# Cannot convert String to series data for plotting

**URL:** <https://discourse.julialang.org/t/cannot-convert-string-to-series-data-for-plotting/58763>\
**Category:** New to Julia\
**Tags:** juliadb\
**Created:** [April 7, 2021, 3:12pm UTC](https://discourse.julialang.org/t/cannot-convert-string-to-series-data-for-plotting/58763 "2021-04-07T15:12:38Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![quantiota](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/quantiota/32/46039_2.png) [@quantiota](https://discourse.julialang.org/u/quantiota)\
**Post date:** [April 7, 2021, 3:12pm UTC](https://discourse.julialang.org/t/cannot-convert-string-to-series-data-for-plotting/58763/1 "2021-04-07T15:12:38Z")

</div>

hey  
trying to work with JuliaDB by example from

> **[GitHub - JuliaComputing/TrueFX: JuliaDB demonstration using TrueFX data](https://github.com/JuliaComputing/TrueFX)**
>
> JuliaDB demonstration using TrueFX data. Contribute to JuliaComputing/TrueFX development by creating an account on GitHub.

just added a first column for the curency market.

```julia
month = 1
window = Dates.Hour(1)

# 1) subset data (lazy)
date_range = DateTime(2019, 1):Dates.Millisecond(1):DateTime(2019,12)+Dates.Month(1)-Dates.Millisecond(1)
@time subdata = data[["dukascopy"], ["AUDUSD", "EURUSD", "GBPUSD"], date_range]

# 2) group data
@time compute(groupreduce((bid=:bid=>min, ask=:ask=>max), 
                subdata, 
                (:market, :pair, :timestamp => dt -> floor(dt, window))))

```

```julia
using Plots
gr()

```

```julia
function plot_rates(month, window, currency_markets= ["dukascopy"], currency_pairs= ["AUDUSD", "EURUSD", "GBPUSD"])
    date_range = DateTime(2019, month):Dates.Millisecond(1):DateTime(2019,month)+Dates.Month(1)-Dates.Millisecond(1)
    p = Plots.Plot()
    for market in currency_markets
    for pair in currency_pairs
        subdata = data[market, pair, date_range]
        result = collect(groupreduce((bid=:bid=>min, ask=:ask=>max), 
            subdata, :timestamp => dt -> floor(dt, window)))
    
        plot!(p, keys(result, :timestamp), 
                values(result, :bid), fillrange=values(result, :ask), 
                label=pair, market, legend=:bottomleft)
    end
    end

    p
end

```

` plot_rates(1,Dates.Minute(5)) # January, 5-minute intervals ,`

Output cell : Cannot convert String to series data for plotting