PREVIEW / futures_1hour / 2013-03-10
file: by_date/futures_1hour/2013/2013-03-10.parquet size: 14 KB rows: 266
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2013-03-10 18:00:00 | ES | Futures | 1588.04 | 1589.84 | 1587.27 | 1588.56 | 4204.0 |
| 2013-03-10 19:00:00 | ES | Futures | 1588.56 | 1589.58 | 1588.3 | 1589.07 | 826.0 |
| 2013-03-10 20:00:00 | ES | Futures | 1588.81 | 1589.07 | 1588.04 | 1588.56 | 1832.0 |
| 2013-03-10 21:00:00 | ES | Futures | 1588.81 | 1590.35 | 1588.3 | 1589.84 | 2062.0 |
| 2013-03-10 22:00:00 | ES | Futures | 1589.58 | 1590.86 | 1589.58 | 1590.61 | 1526.0 |
| 2013-03-10 23:00:00 | ES | Futures | 1590.86 | 1591.12 | 1590.09 | 1590.61 | 1081.0 |
| 2013-03-10 18:00:00 | NQ | Futures | 3261.72 | 3261.72 | 3254.73 | 3257.65 | 297.0 |
| 2013-03-10 19:00:00 | NQ | Futures | 3256.77 | 3258.52 | 3256.48 | 3257.35 | 36.0 |
| 2013-03-10 20:00:00 | NQ | Futures | 3257.35 | 3257.65 | 3255.32 | 3256.77 | 182.0 |
| 2013-03-10 21:00:00 | NQ | Futures | 3257.06 | 3259.97 | 3256.77 | 3259.39 | 287.0 |
| 2013-03-10 22:00:00 | NQ | Futures | 3259.68 | 3263.18 | 3259.68 | 3262.3 | 65.0 |
| 2013-03-10 23:00:00 | NQ | Futures | 3262.01 | 3263.47 | 3261.72 | 3262.88 | 27.0 |
| 2013-03-10 18:00:00 | YM | Futures | 14469.7 | 14469.7 | 14449.4 | 14456.5 | 461.0 |
| 2013-03-10 19:00:00 | YM | Futures | 14457.5 | 14465.6 | 14456.5 | 14462.6 | 190.0 |
| 2013-03-10 20:00:00 | YM | Futures | 14460.6 | 14460.6 | 14453.5 | 14458.5 | 354.0 |
| 2013-03-10 21:00:00 | YM | Futures | 14459.5 | 14475.7 | 14457.5 | 14471.7 | 413.0 |
| 2013-03-10 22:00:00 | YM | Futures | 14472.7 | 14483.8 | 14471.7 | 14481.8 | 389.0 |
| 2013-03-10 23:00:00 | YM | Futures | 14480.8 | 14484.8 | 14478.8 | 14480.8 | 387.0 |
| 2013-03-10 18:00:00 | CL | Futures | 145.9 | 146.05 | 145.65 | 145.7 | 565.0 |
| 2013-03-10 19:00:00 | CL | Futures | 145.68 | 145.7 | 145.54 | 145.66 | 374.0 |
| 2013-03-10 20:00:00 | CL | Futures | 145.66 | 145.95 | 145.59 | 145.7 | 994.0 |
| 2013-03-10 21:00:00 | CL | Futures | 145.71 | 145.82 | 145.65 | 145.68 | 509.0 |
| 2013-03-10 22:00:00 | CL | Futures | 145.7 | 145.76 | 145.63 | 145.73 | 527.0 |
| 2013-03-10 23:00:00 | CL | Futures | 145.73 | 145.9 | 145.73 | 145.86 | 479.0 |
| 2013-03-10 18:00:00 | GC | Futures | 2170.4 | 2171.0 | 2168.2 | 2169.2 | 605.0 |
| 2013-03-10 19:00:00 | GC | Futures | 2169.2 | 2170.3 | 2168.1 | 2169.5 | 678.0 |
| 2013-03-10 20:00:00 | GC | Futures | 2169.5 | 2170.2 | 2165.2 | 2168.4 | 3143.0 |
| 2013-03-10 21:00:00 | GC | Futures | 2168.2 | 2173.6 | 2168.2 | 2173.2 | 4565.0 |
| 2013-03-10 22:00:00 | GC | Futures | 2173.3 | 2174.0 | 2171.8 | 2172.8 | 2095.0 |
| 2013-03-10 23:00:00 | GC | Futures | 2172.6 | 2173.3 | 2172.1 | 2172.5 | 1233.0 |
| 2013-03-10 18:00:00 | ZN | Futures | 117.125452 | 117.139495 | 117.069284 | 117.083326 | 7917.0 |
| 2013-03-10 19:00:00 | ZN | Futures | 117.083326 | 117.097368 | 117.0412 | 117.069284 | 3315.0 |
| 2013-03-10 20:00:00 | ZN | Futures | 117.083326 | 117.097368 | 117.069284 | 117.083326 | 9160.0 |
| 2013-03-10 21:00:00 | ZN | Futures | 117.069284 | 117.083326 | 117.027158 | 117.0412 | 8364.0 |
| 2013-03-10 22:00:00 | ZN | Futures | 117.0412 | 117.0412 | 116.985031 | 116.999073 | 10163.0 |
| 2013-03-10 23:00:00 | ZN | Futures | 116.985031 | 116.999073 | 116.900778 | 116.985031 | 13195.0 |
> showing 36 of 266 rows — these rows as CSV