PREVIEW / futures_1hour / 2022-05-29
file: by_date/futures_1hour/2022/2022-05-29.parquet size: 17 KB rows: 366
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-05-29 18:00:00 | ES | Futures | 4721.55 | 4723.81 | 4713.61 | 4720.7 | 7174.0 |
| 2022-05-29 19:00:00 | ES | Futures | 4720.98 | 4731.47 | 4719.56 | 4724.95 | 5946.0 |
| 2022-05-29 20:00:00 | ES | Futures | 4724.95 | 4728.63 | 4719.28 | 4726.65 | 8671.0 |
| 2022-05-29 21:00:00 | ES | Futures | 4726.37 | 4732.32 | 4722.96 | 4728.07 | 5286.0 |
| 2022-05-29 22:00:00 | ES | Futures | 4728.07 | 4737.7 | 4726.08 | 4734.3 | 6404.0 |
| 2022-05-29 23:00:00 | ES | Futures | 4734.02 | 4735.72 | 4729.48 | 4732.03 | 4255.0 |
| 2022-05-29 18:00:00 | NQ | Futures | 14736.82 | 14755.09 | 14699.13 | 14738.56 | 4126.0 |
| 2022-05-29 19:00:00 | NQ | Futures | 14738.27 | 14796.85 | 14733.34 | 14774.52 | 4393.0 |
| 2022-05-29 20:00:00 | NQ | Futures | 14773.36 | 14793.08 | 14754.22 | 14786.99 | 4255.0 |
| 2022-05-29 21:00:00 | NQ | Futures | 14786.41 | 14810.77 | 14774.81 | 14790.47 | 3834.0 |
| 2022-05-29 22:00:00 | NQ | Futures | 14790.47 | 14840.92 | 14782.64 | 14827.0 | 4815.0 |
| 2022-05-29 23:00:00 | NQ | Futures | 14826.71 | 14836.57 | 14810.77 | 14831.64 | 2689.0 |
| 2022-05-29 18:00:00 | YM | Futures | 37428.5 | 37451.1 | 37391.3 | 37430.8 | 1129.0 |
| 2022-05-29 19:00:00 | YM | Futures | 37435.3 | 37488.3 | 37426.3 | 37440.9 | 1190.0 |
| 2022-05-29 20:00:00 | YM | Futures | 37437.5 | 37455.6 | 37393.6 | 37442.0 | 1331.0 |
| 2022-05-29 21:00:00 | YM | Futures | 37439.8 | 37478.1 | 37412.7 | 37452.2 | 729.0 |
| 2022-05-29 22:00:00 | YM | Futures | 37452.2 | 37501.8 | 37440.9 | 37474.7 | 859.0 |
| 2022-05-29 23:00:00 | YM | Futures | 37470.2 | 37484.9 | 37439.8 | 37446.5 | 665.0 |
| 2022-05-29 18:00:00 | CL | Futures | 87.09 | 87.45 | 87.01 | 87.33 | 1452.0 |
| 2022-05-29 19:00:00 | CL | Futures | 87.31 | 87.73 | 87.31 | 87.57 | 1217.0 |
| 2022-05-29 20:00:00 | CL | Futures | 87.57 | 87.73 | 87.44 | 87.65 | 1890.0 |
| 2022-05-29 21:00:00 | CL | Futures | 87.64 | 87.95 | 87.49 | 87.85 | 4939.0 |
| 2022-05-29 22:00:00 | CL | Futures | 87.83 | 88.17 | 87.77 | 88.05 | 3338.0 |
| 2022-05-29 23:00:00 | CL | Futures | 88.04 | 88.16 | 87.8 | 87.87 | 2644.0 |
| 2022-05-29 18:00:00 | GC | Futures | 2215.7 | 2216.4 | 2213.1 | 2213.1 | 725.0 |
| 2022-05-29 19:00:00 | GC | Futures | 2213.1 | 2213.3 | 2207.5 | 2211.9 | 1436.0 |
| 2022-05-29 20:00:00 | GC | Futures | 2212.0 | 2214.6 | 2211.4 | 2212.8 | 1260.0 |
| 2022-05-29 21:00:00 | GC | Futures | 2212.6 | 2221.1 | 2210.6 | 2220.2 | 2897.0 |
| 2022-05-29 22:00:00 | GC | Futures | 2220.5 | 2224.4 | 2220.4 | 2223.0 | 2945.0 |
| 2022-05-29 23:00:00 | GC | Futures | 2223.0 | 2225.5 | 2221.7 | 2225.1 | 1612.0 |
| 2022-05-29 18:00:00 | ZN | Futures | 123.727835 | 123.792001 | 123.67971 | 123.775959 | 450.0 |
| 2022-05-29 19:00:00 | ZN | Futures | 123.775959 | 123.792001 | 123.711793 | 123.759918 | 1257.0 |
| 2022-05-29 20:00:00 | ZN | Futures | 123.775959 | 123.775959 | 123.711793 | 123.775959 | 750.0 |
| 2022-05-29 21:00:00 | ZN | Futures | 123.759918 | 123.775959 | 123.743876 | 123.743876 | 543.0 |
| 2022-05-29 22:00:00 | ZN | Futures | 123.743876 | 123.743876 | 123.711793 | 123.727835 | 1160.0 |
| 2022-05-29 23:00:00 | ZN | Futures | 123.711793 | 123.759918 | 123.711793 | 123.743876 | 368.0 |
> showing 36 of 366 rows — these rows as CSV