PREVIEW / futures_1hour / 2021-10-17
file: by_date/futures_1hour/2021/2021-10-17.parquet size: 19 KB rows: 402
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 |
|---|---|---|---|---|---|---|---|
| 2021-10-17 18:00:00 | ES | Futures | 5040.88 | 5045.39 | 5029.31 | 5033.26 | 11765.0 |
| 2021-10-17 19:00:00 | ES | Futures | 5033.26 | 5034.67 | 5025.92 | 5026.2 | 9432.0 |
| 2021-10-17 20:00:00 | ES | Futures | 5026.2 | 5039.75 | 5024.23 | 5034.67 | 16475.0 |
| 2021-10-17 21:00:00 | ES | Futures | 5034.39 | 5036.93 | 5030.15 | 5035.23 | 13563.0 |
| 2021-10-17 22:00:00 | ES | Futures | 5035.23 | 5037.49 | 5033.54 | 5036.08 | 7045.0 |
| 2021-10-17 23:00:00 | ES | Futures | 5036.36 | 5036.64 | 5033.54 | 5034.39 | 4142.0 |
| 2021-10-17 18:00:00 | NQ | Futures | 17557.12 | 17578.57 | 17510.17 | 17519.45 | 6857.0 |
| 2021-10-17 19:00:00 | NQ | Futures | 17519.74 | 17529.01 | 17477.71 | 17483.8 | 7071.0 |
| 2021-10-17 20:00:00 | NQ | Futures | 17484.09 | 17532.78 | 17481.77 | 17513.36 | 6795.0 |
| 2021-10-17 21:00:00 | NQ | Futures | 17513.07 | 17524.37 | 17491.91 | 17509.59 | 5481.0 |
| 2021-10-17 22:00:00 | NQ | Futures | 17509.88 | 17518.58 | 17500.32 | 17508.43 | 3319.0 |
| 2021-10-17 23:00:00 | NQ | Futures | 17509.3 | 17510.75 | 17491.91 | 17495.68 | 2809.0 |
| 2021-10-17 18:00:00 | YM | Futures | 39467.1 | 39486.2 | 39385.3 | 39408.9 | 2763.0 |
| 2021-10-17 19:00:00 | YM | Futures | 39408.9 | 39429.0 | 39375.2 | 39377.5 | 1776.0 |
| 2021-10-17 20:00:00 | YM | Futures | 39380.8 | 39479.5 | 39357.3 | 39436.9 | 2580.0 |
| 2021-10-17 21:00:00 | YM | Futures | 39434.6 | 39452.6 | 39398.8 | 39440.2 | 1528.0 |
| 2021-10-17 22:00:00 | YM | Futures | 39440.2 | 39458.2 | 39430.2 | 39450.3 | 838.0 |
| 2021-10-17 23:00:00 | YM | Futures | 39452.6 | 39463.8 | 39432.4 | 39439.1 | 961.0 |
| 2021-10-17 18:00:00 | CL | Futures | 57.31 | 57.69 | 57.25 | 57.51 | 5829.0 |
| 2021-10-17 19:00:00 | CL | Futures | 57.51 | 57.66 | 57.46 | 57.58 | 1886.0 |
| 2021-10-17 20:00:00 | CL | Futures | 57.59 | 57.69 | 57.48 | 57.57 | 2993.0 |
| 2021-10-17 21:00:00 | CL | Futures | 57.58 | 57.91 | 57.51 | 57.83 | 9517.0 |
| 2021-10-17 22:00:00 | CL | Futures | 57.84 | 58.0 | 57.76 | 57.95 | 6002.0 |
| 2021-10-17 23:00:00 | CL | Futures | 57.95 | 58.08 | 57.88 | 57.93 | 4704.0 |
| 2021-10-17 18:00:00 | GC | Futures | 2127.7 | 2129.6 | 2124.4 | 2129.5 | 3013.0 |
| 2021-10-17 19:00:00 | GC | Futures | 2129.4 | 2133.7 | 2128.8 | 2132.3 | 2665.0 |
| 2021-10-17 20:00:00 | GC | Futures | 2132.3 | 2132.8 | 2129.1 | 2132.6 | 1939.0 |
| 2021-10-17 21:00:00 | GC | Futures | 2132.6 | 2133.7 | 2130.3 | 2131.7 | 4865.0 |
| 2021-10-17 22:00:00 | GC | Futures | 2131.7 | 2133.2 | 2131.4 | 2132.0 | 2369.0 |
| 2021-10-17 23:00:00 | GC | Futures | 2132.0 | 2132.0 | 2127.6 | 2128.2 | 3001.0 |
| 2021-10-17 18:00:00 | ZN | Futures | 133.739304 | 133.77123 | 133.547746 | 133.595635 | 42511.0 |
| 2021-10-17 19:00:00 | ZN | Futures | 133.595635 | 133.659488 | 133.563709 | 133.611599 | 21371.0 |
| 2021-10-17 20:00:00 | ZN | Futures | 133.611599 | 133.675451 | 133.579672 | 133.643525 | 29045.0 |
| 2021-10-17 21:00:00 | ZN | Futures | 133.627562 | 133.739304 | 133.627562 | 133.659488 | 34251.0 |
| 2021-10-17 22:00:00 | ZN | Futures | 133.659488 | 133.691414 | 133.627562 | 133.627562 | 13099.0 |
| 2021-10-17 23:00:00 | ZN | Futures | 133.627562 | 133.643525 | 133.46793 | 133.483893 | 40252.0 |
> showing 36 of 402 rows — these rows as CSV