PREVIEW / futures_1hour / 2017-06-11
file: by_date/futures_1hour/2017/2017-06-11.parquet size: 13 KB rows: 262
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 |
|---|---|---|---|---|---|---|---|
| 2017-06-11 18:00:00 | ES | Futures | 2654.95 | 2656.04 | 2652.76 | 2653.31 | 3186.0 |
| 2017-06-11 19:00:00 | ES | Futures | 2653.58 | 2653.86 | 2651.13 | 2652.49 | 2082.0 |
| 2017-06-11 20:00:00 | ES | Futures | 2652.49 | 2654.95 | 2652.22 | 2653.31 | 2615.0 |
| 2017-06-11 21:00:00 | ES | Futures | 2653.31 | 2654.68 | 2652.76 | 2654.68 | 2125.0 |
| 2017-06-11 22:00:00 | ES | Futures | 2654.68 | 2655.22 | 2652.49 | 2652.76 | 2857.0 |
| 2017-06-11 23:00:00 | ES | Futures | 2652.76 | 2652.76 | 2650.85 | 2652.22 | 2320.0 |
| 2017-06-11 18:00:00 | NQ | Futures | 6845.9 | 6853.05 | 6832.48 | 6836.35 | 1225.0 |
| 2017-06-11 19:00:00 | NQ | Futures | 6836.35 | 6837.85 | 6830.99 | 6837.85 | 801.0 |
| 2017-06-11 20:00:00 | NQ | Futures | 6837.85 | 6842.02 | 6834.86 | 6835.16 | 767.0 |
| 2017-06-11 21:00:00 | NQ | Futures | 6835.46 | 6839.34 | 6833.08 | 6838.44 | 651.0 |
| 2017-06-11 22:00:00 | NQ | Futures | 6838.44 | 6843.81 | 6833.37 | 6834.27 | 461.0 |
| 2017-06-11 23:00:00 | NQ | Futures | 6833.37 | 6833.97 | 6827.41 | 6830.09 | 670.0 |
| 2017-06-11 18:00:00 | YM | Futures | 23088.9 | 23088.9 | 23059.5 | 23064.9 | 1990.0 |
| 2017-06-11 19:00:00 | YM | Futures | 23066.0 | 23070.4 | 23050.8 | 23064.9 | 989.0 |
| 2017-06-11 20:00:00 | YM | Futures | 23064.9 | 23080.2 | 23061.7 | 23064.9 | 1237.0 |
| 2017-06-11 21:00:00 | YM | Futures | 23062.8 | 23074.7 | 23058.4 | 23074.7 | 777.0 |
| 2017-06-11 22:00:00 | YM | Futures | 23072.6 | 23081.3 | 23057.3 | 23058.4 | 1379.0 |
| 2017-06-11 23:00:00 | YM | Futures | 23059.5 | 23060.6 | 23046.4 | 23058.4 | 968.0 |
| 2017-06-11 18:00:00 | CL | Futures | 41.9 | 42.11 | 41.83 | 42.05 | 3989.0 |
| 2017-06-11 19:00:00 | CL | Futures | 42.05 | 42.16 | 42.02 | 42.15 | 2307.0 |
| 2017-06-11 20:00:00 | CL | Futures | 42.14 | 42.19 | 42.09 | 42.18 | 3301.0 |
| 2017-06-11 21:00:00 | CL | Futures | 42.19 | 42.19 | 42.1 | 42.14 | 2965.0 |
| 2017-06-11 22:00:00 | CL | Futures | 42.14 | 42.16 | 42.09 | 42.09 | 2166.0 |
| 2017-06-11 23:00:00 | CL | Futures | 42.09 | 42.22 | 42.07 | 42.17 | 4607.0 |
| 2017-06-11 18:00:00 | GC | Futures | 1699.8 | 1700.5 | 1698.2 | 1699.0 | 2229.0 |
| 2017-06-11 19:00:00 | GC | Futures | 1699.0 | 1700.4 | 1699.0 | 1700.2 | 1764.0 |
| 2017-06-11 20:00:00 | GC | Futures | 1700.1 | 1702.8 | 1699.8 | 1702.6 | 4819.0 |
| 2017-06-11 21:00:00 | GC | Futures | 1702.6 | 1703.3 | 1698.4 | 1698.8 | 6558.0 |
| 2017-06-11 22:00:00 | GC | Futures | 1698.8 | 1700.0 | 1698.8 | 1699.6 | 3141.0 |
| 2017-06-11 23:00:00 | GC | Futures | 1699.6 | 1699.7 | 1698.2 | 1698.8 | 3414.0 |
| 2017-06-11 18:00:00 | ZN | Futures | 125.639617 | 125.639617 | 125.530905 | 125.561966 | 6802.0 |
| 2017-06-11 19:00:00 | ZN | Futures | 125.561966 | 125.561966 | 125.530905 | 125.561966 | 3276.0 |
| 2017-06-11 20:00:00 | ZN | Futures | 125.546436 | 125.577496 | 125.530905 | 125.561966 | 9008.0 |
| 2017-06-11 21:00:00 | ZN | Futures | 125.561966 | 125.561966 | 125.468784 | 125.468784 | 17044.0 |
| 2017-06-11 22:00:00 | ZN | Futures | 125.484315 | 125.499845 | 125.468784 | 125.484315 | 7858.0 |
| 2017-06-11 23:00:00 | ZN | Futures | 125.484315 | 125.484315 | 125.468784 | 125.468784 | 4554.0 |
> showing 36 of 262 rows — these rows as CSV