PREVIEW / futures_1hour / 2018-11-25
file: by_date/futures_1hour/2018/2018-11-25.parquet size: 15 KB rows: 313
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 |
|---|---|---|---|---|---|---|---|
| 2018-11-25 18:00:00 | ES | Futures | 2865.23 | 2871.76 | 2863.05 | 2870.13 | 13868.0 |
| 2018-11-25 19:00:00 | ES | Futures | 2870.13 | 2875.02 | 2867.68 | 2868.77 | 10702.0 |
| 2018-11-25 20:00:00 | ES | Futures | 2868.77 | 2873.93 | 2867.95 | 2870.94 | 9598.0 |
| 2018-11-25 21:00:00 | ES | Futures | 2870.94 | 2874.48 | 2869.31 | 2872.57 | 7487.0 |
| 2018-11-25 22:00:00 | ES | Futures | 2872.3 | 2877.2 | 2872.03 | 2875.57 | 8206.0 |
| 2018-11-25 23:00:00 | ES | Futures | 2875.57 | 2876.93 | 2874.48 | 2876.93 | 3641.0 |
| 2018-11-25 18:00:00 | NQ | Futures | 7670.16 | 7693.34 | 7661.95 | 7689.23 | 7794.0 |
| 2018-11-25 19:00:00 | NQ | Futures | 7689.23 | 7703.02 | 7684.83 | 7688.64 | 5239.0 |
| 2018-11-25 20:00:00 | NQ | Futures | 7688.06 | 7702.14 | 7686.3 | 7695.39 | 4738.0 |
| 2018-11-25 21:00:00 | NQ | Futures | 7695.68 | 7707.71 | 7689.82 | 7698.62 | 3705.0 |
| 2018-11-25 22:00:00 | NQ | Futures | 7698.62 | 7712.7 | 7697.44 | 7707.71 | 3382.0 |
| 2018-11-25 23:00:00 | NQ | Futures | 7707.12 | 7716.22 | 7702.43 | 7713.87 | 3116.0 |
| 2018-11-25 18:00:00 | YM | Futures | 26375.1 | 26457.7 | 26369.7 | 26438.1 | 2452.0 |
| 2018-11-25 19:00:00 | YM | Futures | 26438.1 | 26482.7 | 26409.9 | 26421.8 | 2469.0 |
| 2018-11-25 20:00:00 | YM | Futures | 26422.9 | 26475.0 | 26413.1 | 26445.7 | 2611.0 |
| 2018-11-25 21:00:00 | YM | Futures | 26445.7 | 26472.9 | 26432.7 | 26452.2 | 1707.0 |
| 2018-11-25 22:00:00 | YM | Futures | 26450.1 | 26497.9 | 26447.9 | 26482.7 | 1793.0 |
| 2018-11-25 23:00:00 | YM | Futures | 26482.7 | 26496.8 | 26470.7 | 26495.7 | 911.0 |
| 2018-11-25 18:00:00 | CL | Futures | 46.41 | 46.83 | 45.93 | 46.38 | 17907.0 |
| 2018-11-25 19:00:00 | CL | Futures | 46.38 | 46.71 | 46.32 | 46.55 | 12167.0 |
| 2018-11-25 20:00:00 | CL | Futures | 46.54 | 46.7 | 46.33 | 46.43 | 9309.0 |
| 2018-11-25 21:00:00 | CL | Futures | 46.43 | 46.62 | 46.17 | 46.5 | 12071.0 |
| 2018-11-25 22:00:00 | CL | Futures | 46.51 | 46.64 | 46.47 | 46.5 | 5194.0 |
| 2018-11-25 23:00:00 | CL | Futures | 46.5 | 46.71 | 46.47 | 46.7 | 6507.0 |
| 2018-11-25 18:00:00 | GC | Futures | 1593.9 | 1594.3 | 1592.7 | 1594.2 | 580.0 |
| 2018-11-25 19:00:00 | GC | Futures | 1594.3 | 1594.4 | 1592.5 | 1592.5 | 448.0 |
| 2018-11-25 20:00:00 | GC | Futures | 1592.4 | 1593.1 | 1591.3 | 1592.9 | 629.0 |
| 2018-11-25 21:00:00 | GC | Futures | 1593.0 | 1594.7 | 1592.1 | 1592.4 | 739.0 |
| 2018-11-25 22:00:00 | GC | Futures | 1592.2 | 1593.7 | 1592.1 | 1593.5 | 384.0 |
| 2018-11-25 23:00:00 | GC | Futures | 1593.7 | 1594.6 | 1593.0 | 1594.6 | 332.0 |
| 2018-11-25 18:00:00 | ZN | Futures | 120.196188 | 120.227665 | 120.148972 | 120.196188 | 31897.0 |
| 2018-11-25 19:00:00 | ZN | Futures | 120.196188 | 120.211927 | 120.133233 | 120.196188 | 31013.0 |
| 2018-11-25 20:00:00 | ZN | Futures | 120.196188 | 120.196188 | 120.148972 | 120.164711 | 20081.0 |
| 2018-11-25 21:00:00 | ZN | Futures | 120.180449 | 120.196188 | 120.164711 | 120.196188 | 18144.0 |
| 2018-11-25 22:00:00 | ZN | Futures | 120.196188 | 120.196188 | 120.164711 | 120.196188 | 29228.0 |
| 2018-11-25 23:00:00 | ZN | Futures | 120.196188 | 120.196188 | 120.180449 | 120.196188 | 7061.0 |
> showing 36 of 313 rows — these rows as CSV