PREVIEW / futures_1hour / 2020-08-30
file: by_date/futures_1hour/2020/2020-08-30.parquet size: 17 KB rows: 361
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 |
|---|---|---|---|---|---|---|---|
| 2020-08-30 18:00:00 | ES | Futures | 3918.9 | 3925.88 | 3918.9 | 3923.37 | 9397.0 |
| 2020-08-30 19:00:00 | ES | Futures | 3923.65 | 3930.63 | 3923.37 | 3930.35 | 5854.0 |
| 2020-08-30 20:00:00 | ES | Futures | 3930.35 | 3936.5 | 3930.07 | 3934.82 | 15330.0 |
| 2020-08-30 21:00:00 | ES | Futures | 3934.54 | 3935.94 | 3932.03 | 3934.26 | 8696.0 |
| 2020-08-30 22:00:00 | ES | Futures | 3934.26 | 3936.78 | 3933.42 | 3935.66 | 6532.0 |
| 2020-08-30 23:00:00 | ES | Futures | 3935.66 | 3935.94 | 3933.42 | 3935.66 | 4867.0 |
| 2020-08-30 18:00:00 | NQ | Futures | 13883.75 | 13920.48 | 13878.26 | 13910.93 | 3941.0 |
| 2020-08-30 19:00:00 | NQ | Futures | 13910.93 | 13937.25 | 13908.91 | 13936.09 | 2720.0 |
| 2020-08-30 20:00:00 | NQ | Futures | 13936.67 | 13986.7 | 13933.49 | 13971.08 | 8414.0 |
| 2020-08-30 21:00:00 | NQ | Futures | 13970.79 | 13980.63 | 13964.43 | 13976.58 | 4644.0 |
| 2020-08-30 22:00:00 | NQ | Futures | 13976.58 | 13986.7 | 13971.37 | 13980.63 | 4577.0 |
| 2020-08-30 23:00:00 | NQ | Futures | 13980.91 | 13986.7 | 13975.42 | 13982.36 | 2654.0 |
| 2020-08-30 18:00:00 | YM | Futures | 31579.6 | 31626.9 | 31553.2 | 31584.0 | 1743.0 |
| 2020-08-30 19:00:00 | YM | Futures | 31585.1 | 31656.7 | 31584.0 | 31654.5 | 1410.0 |
| 2020-08-30 20:00:00 | YM | Futures | 31654.5 | 31694.1 | 31649.0 | 31680.9 | 2786.0 |
| 2020-08-30 21:00:00 | YM | Futures | 31679.8 | 31690.8 | 31644.6 | 31668.8 | 2076.0 |
| 2020-08-30 22:00:00 | YM | Futures | 31668.8 | 31688.6 | 31658.9 | 31677.6 | 1251.0 |
| 2020-08-30 23:00:00 | YM | Futures | 31678.7 | 31683.1 | 31658.9 | 31679.8 | 1365.0 |
| 2020-08-30 18:00:00 | CL | Futures | 29.74 | 29.83 | 29.74 | 29.82 | 1145.0 |
| 2020-08-30 19:00:00 | CL | Futures | 29.82 | 29.85 | 29.81 | 29.83 | 640.0 |
| 2020-08-30 20:00:00 | CL | Futures | 29.83 | 29.92 | 29.83 | 29.9 | 2208.0 |
| 2020-08-30 21:00:00 | CL | Futures | 29.9 | 29.9 | 29.85 | 29.9 | 1538.0 |
| 2020-08-30 22:00:00 | CL | Futures | 29.9 | 29.91 | 29.87 | 29.9 | 1038.0 |
| 2020-08-30 23:00:00 | CL | Futures | 29.9 | 29.94 | 29.9 | 29.9 | 1441.0 |
| 2020-08-30 18:00:00 | GC | Futures | 2400.6 | 2413.6 | 2400.0 | 2410.6 | 7099.0 |
| 2020-08-30 19:00:00 | GC | Futures | 2410.6 | 2415.1 | 2407.2 | 2410.4 | 4162.0 |
| 2020-08-30 20:00:00 | GC | Futures | 2410.6 | 2414.7 | 2406.7 | 2409.8 | 5367.0 |
| 2020-08-30 21:00:00 | GC | Futures | 2410.0 | 2410.3 | 2402.2 | 2407.9 | 8443.0 |
| 2020-08-30 22:00:00 | GC | Futures | 2407.9 | 2408.0 | 2404.4 | 2406.5 | 3318.0 |
| 2020-08-30 23:00:00 | GC | Futures | 2406.7 | 2407.0 | 2405.0 | 2406.3 | 1621.0 |
| 2020-08-30 18:00:00 | ZN | Futures | 138.929596 | 138.960764 | 138.898429 | 138.960764 | 427.0 |
| 2020-08-30 19:00:00 | ZN | Futures | 138.960764 | 138.960764 | 138.898429 | 138.898429 | 1457.0 |
| 2020-08-30 20:00:00 | ZN | Futures | 138.898429 | 138.898429 | 138.82051 | 138.82051 | 484.0 |
| 2020-08-30 21:00:00 | ZN | Futures | 138.82051 | 138.836093 | 138.789342 | 138.804926 | 839.0 |
| 2020-08-30 22:00:00 | ZN | Futures | 138.789342 | 138.82051 | 138.789342 | 138.82051 | 140.0 |
| 2020-08-30 23:00:00 | ZN | Futures | 138.82051 | 138.851677 | 138.82051 | 138.851677 | 300.0 |
> showing 36 of 361 rows — these rows as CSV