PREVIEW / futures_1hour / 2019-03-03
file: by_date/futures_1hour/2019/2019-03-03.parquet size: 16 KB rows: 340
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 |
|---|---|---|---|---|---|---|---|
| 2019-03-03 18:00:00 | ES | Futures | 3056.96 | 3063.2 | 3054.51 | 3060.76 | 22815.0 |
| 2019-03-03 19:00:00 | ES | Futures | 3060.76 | 3060.76 | 3058.04 | 3059.67 | 7189.0 |
| 2019-03-03 20:00:00 | ES | Futures | 3059.67 | 3059.67 | 3057.23 | 3059.13 | 8051.0 |
| 2019-03-03 21:00:00 | ES | Futures | 3059.4 | 3060.49 | 3058.31 | 3060.21 | 5378.0 |
| 2019-03-03 22:00:00 | ES | Futures | 3060.49 | 3061.84 | 3059.94 | 3061.3 | 5179.0 |
| 2019-03-03 23:00:00 | ES | Futures | 3061.3 | 3061.3 | 3060.21 | 3060.49 | 2112.0 |
| 2019-03-03 18:00:00 | NQ | Futures | 8388.17 | 8422.36 | 8384.96 | 8417.68 | 8644.0 |
| 2019-03-03 19:00:00 | NQ | Futures | 8417.97 | 8418.27 | 8410.67 | 8413.88 | 2997.0 |
| 2019-03-03 20:00:00 | NQ | Futures | 8413.88 | 8414.47 | 8403.66 | 8413.01 | 3914.0 |
| 2019-03-03 21:00:00 | NQ | Futures | 8413.01 | 8415.93 | 8410.09 | 8414.18 | 1887.0 |
| 2019-03-03 22:00:00 | NQ | Futures | 8414.76 | 8422.07 | 8413.3 | 8421.19 | 2286.0 |
| 2019-03-03 23:00:00 | NQ | Futures | 8420.9 | 8421.19 | 8416.81 | 8417.97 | 683.0 |
| 2019-03-03 18:00:00 | YM | Futures | 28344.5 | 28414.0 | 28329.3 | 28391.2 | 3564.0 |
| 2019-03-03 19:00:00 | YM | Futures | 28390.1 | 28390.1 | 28359.7 | 28377.1 | 1819.0 |
| 2019-03-03 20:00:00 | YM | Futures | 28377.1 | 28380.4 | 28353.2 | 28376.0 | 2035.0 |
| 2019-03-03 21:00:00 | YM | Futures | 28377.1 | 28391.2 | 28368.4 | 28385.8 | 1284.0 |
| 2019-03-03 22:00:00 | YM | Futures | 28386.9 | 28408.6 | 28382.5 | 28405.3 | 1516.0 |
| 2019-03-03 23:00:00 | YM | Futures | 28405.3 | 28407.5 | 28394.5 | 28396.7 | 643.0 |
| 2019-03-03 18:00:00 | CL | Futures | 50.3 | 50.73 | 50.3 | 50.47 | 9071.0 |
| 2019-03-03 19:00:00 | CL | Futures | 50.47 | 50.52 | 50.39 | 50.5 | 4877.0 |
| 2019-03-03 20:00:00 | CL | Futures | 50.51 | 50.6 | 50.46 | 50.51 | 6972.0 |
| 2019-03-03 21:00:00 | CL | Futures | 50.52 | 50.58 | 50.49 | 50.5 | 3712.0 |
| 2019-03-03 22:00:00 | CL | Futures | 50.5 | 50.54 | 50.46 | 50.51 | 3788.0 |
| 2019-03-03 23:00:00 | CL | Futures | 50.52 | 50.55 | 50.5 | 50.53 | 1571.0 |
| 2019-03-03 18:00:00 | GC | Futures | 1669.1 | 1673.0 | 1669.1 | 1671.6 | 4400.0 |
| 2019-03-03 19:00:00 | GC | Futures | 1671.6 | 1671.7 | 1669.4 | 1670.9 | 3899.0 |
| 2019-03-03 20:00:00 | GC | Futures | 1670.8 | 1673.8 | 1670.7 | 1673.0 | 6652.0 |
| 2019-03-03 21:00:00 | GC | Futures | 1673.0 | 1673.9 | 1672.6 | 1673.6 | 3557.0 |
| 2019-03-03 22:00:00 | GC | Futures | 1673.5 | 1673.6 | 1672.4 | 1673.4 | 2933.0 |
| 2019-03-03 23:00:00 | GC | Futures | 1673.5 | 1673.6 | 1672.5 | 1672.6 | 1503.0 |
| 2019-03-03 18:00:00 | ZN | Futures | 122.258023 | 122.273763 | 122.2108 | 122.242282 | 279.0 |
| 2019-03-03 19:00:00 | ZN | Futures | 122.258023 | 122.305245 | 122.242282 | 122.305245 | 1590.0 |
| 2019-03-03 20:00:00 | ZN | Futures | 122.289504 | 122.320985 | 122.273763 | 122.289504 | 444.0 |
| 2019-03-03 21:00:00 | ZN | Futures | 122.289504 | 122.289504 | 122.273763 | 122.273763 | 164.0 |
| 2019-03-03 22:00:00 | ZN | Futures | 122.258023 | 122.289504 | 122.258023 | 122.258023 | 1037.0 |
| 2019-03-03 23:00:00 | ZN | Futures | 122.258023 | 122.258023 | 122.242282 | 122.242282 | 43.0 |
> showing 36 of 340 rows — these rows as CSV