PREVIEW / futures_1hour / 2022-07-03
file: by_date/futures_1hour/2022/2022-07-03.parquet size: 18 KB rows: 370
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 |
|---|---|---|---|---|---|---|---|
| 2022-07-03 18:00:00 | ES | Futures | 4338.02 | 4338.02 | 4327.26 | 4330.94 | 5324.0 |
| 2022-07-03 19:00:00 | ES | Futures | 4330.94 | 4334.34 | 4316.49 | 4319.04 | 6688.0 |
| 2022-07-03 20:00:00 | ES | Futures | 4318.76 | 4321.87 | 4307.99 | 4309.98 | 10702.0 |
| 2022-07-03 21:00:00 | ES | Futures | 4309.69 | 4312.24 | 4297.8 | 4309.98 | 11442.0 |
| 2022-07-03 22:00:00 | ES | Futures | 4309.98 | 4315.07 | 4300.91 | 4306.86 | 7886.0 |
| 2022-07-03 23:00:00 | ES | Futures | 4306.86 | 4312.53 | 4306.29 | 4311.11 | 4423.0 |
| 2022-07-03 18:00:00 | NQ | Futures | 13427.63 | 13442.38 | 13404.78 | 13419.82 | 2437.0 |
| 2022-07-03 19:00:00 | NQ | Futures | 13420.11 | 13436.02 | 13374.99 | 13387.14 | 3598.0 |
| 2022-07-03 20:00:00 | NQ | Futures | 13386.27 | 13396.68 | 13335.08 | 13345.2 | 6436.0 |
| 2022-07-03 21:00:00 | NQ | Futures | 13342.89 | 13357.93 | 13305.0 | 13345.78 | 6191.0 |
| 2022-07-03 22:00:00 | NQ | Futures | 13346.07 | 13362.84 | 13314.25 | 13339.7 | 4049.0 |
| 2022-07-03 23:00:00 | NQ | Futures | 13338.84 | 13352.43 | 13330.45 | 13345.49 | 2209.0 |
| 2022-07-03 18:00:00 | YM | Futures | 35036.2 | 35040.7 | 34965.1 | 34993.3 | 842.0 |
| 2022-07-03 19:00:00 | YM | Futures | 34992.2 | 35011.4 | 34881.6 | 34897.4 | 1254.0 |
| 2022-07-03 20:00:00 | YM | Futures | 34894.0 | 34929.0 | 34836.5 | 34852.3 | 2036.0 |
| 2022-07-03 21:00:00 | YM | Futures | 34846.6 | 34869.2 | 34762.0 | 34856.8 | 1565.0 |
| 2022-07-03 22:00:00 | YM | Futures | 34857.9 | 34890.6 | 34786.8 | 34829.7 | 1040.0 |
| 2022-07-03 23:00:00 | YM | Futures | 34830.8 | 34871.5 | 34827.5 | 34865.8 | 658.0 |
| 2022-07-03 18:00:00 | CL | Futures | 84.23 | 84.31 | 83.75 | 83.96 | 1331.0 |
| 2022-07-03 19:00:00 | CL | Futures | 83.94 | 84.06 | 83.71 | 83.75 | 876.0 |
| 2022-07-03 20:00:00 | CL | Futures | 83.75 | 83.88 | 83.37 | 83.45 | 2056.0 |
| 2022-07-03 21:00:00 | CL | Futures | 83.45 | 83.74 | 83.03 | 83.69 | 5190.0 |
| 2022-07-03 22:00:00 | CL | Futures | 83.69 | 83.89 | 83.57 | 83.66 | 2934.0 |
| 2022-07-03 23:00:00 | CL | Futures | 83.66 | 83.93 | 83.66 | 83.77 | 1779.0 |
| 2022-07-03 18:00:00 | GC | Futures | 2165.5 | 2165.5 | 2160.4 | 2161.3 | 1618.0 |
| 2022-07-03 19:00:00 | GC | Futures | 2161.4 | 2161.9 | 2158.9 | 2159.0 | 955.0 |
| 2022-07-03 20:00:00 | GC | Futures | 2159.1 | 2163.1 | 2158.7 | 2159.4 | 2016.0 |
| 2022-07-03 21:00:00 | GC | Futures | 2159.3 | 2159.6 | 2156.2 | 2159.0 | 2434.0 |
| 2022-07-03 22:00:00 | GC | Futures | 2159.0 | 2166.4 | 2158.9 | 2160.8 | 3253.0 |
| 2022-07-03 23:00:00 | GC | Futures | 2160.8 | 2165.3 | 2160.3 | 2162.8 | 1409.0 |
| 2022-07-03 18:00:00 | ZN | Futures | 123.236507 | 123.268743 | 123.123683 | 123.155919 | 4364.0 |
| 2022-07-03 19:00:00 | ZN | Futures | 123.155919 | 123.22039 | 123.07533 | 123.139801 | 4759.0 |
| 2022-07-03 20:00:00 | ZN | Futures | 123.155919 | 123.413803 | 123.139801 | 123.381567 | 9805.0 |
| 2022-07-03 21:00:00 | ZN | Futures | 123.381567 | 123.381567 | 123.236507 | 123.268743 | 7213.0 |
| 2022-07-03 22:00:00 | ZN | Futures | 123.252625 | 123.300979 | 123.22039 | 123.268743 | 5520.0 |
| 2022-07-03 23:00:00 | ZN | Futures | 123.268743 | 123.284861 | 123.22039 | 123.252625 | 2522.0 |
> showing 36 of 370 rows — these rows as CSV