PREVIEW / futures_1hour / 2024-07-28
file: by_date/futures_1hour/2024/2024-07-28.parquet size: 19 KB rows: 430
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 |
|---|---|---|---|---|---|---|---|
| 2024-07-28 18:00:00 | ES | Futures | 5763.94 | 5779.93 | 5763.67 | 5778.88 | 11029.0 |
| 2024-07-28 19:00:00 | ES | Futures | 5778.62 | 5783.07 | 5777.57 | 5780.98 | 5476.0 |
| 2024-07-28 20:00:00 | ES | Futures | 5780.98 | 5799.07 | 5779.4 | 5793.56 | 13152.0 |
| 2024-07-28 21:00:00 | ES | Futures | 5793.56 | 5796.18 | 5789.63 | 5790.94 | 10043.0 |
| 2024-07-28 22:00:00 | ES | Futures | 5791.2 | 5794.61 | 5789.63 | 5790.15 | 5337.0 |
| 2024-07-28 23:00:00 | ES | Futures | 5790.15 | 5794.09 | 5789.89 | 5791.99 | 3322.0 |
| 2024-07-28 18:00:00 | NQ | Futures | 20244.03 | 20318.47 | 20239.8 | 20308.44 | 6566.0 |
| 2024-07-28 19:00:00 | NQ | Futures | 20307.65 | 20330.61 | 20300.52 | 20317.15 | 3037.0 |
| 2024-07-28 20:00:00 | NQ | Futures | 20318.73 | 20411.13 | 20314.51 | 20379.45 | 10339.0 |
| 2024-07-28 21:00:00 | NQ | Futures | 20379.19 | 20398.19 | 20358.33 | 20372.59 | 11199.0 |
| 2024-07-28 22:00:00 | NQ | Futures | 20374.43 | 20395.82 | 20363.61 | 20365.46 | 4044.0 |
| 2024-07-28 23:00:00 | NQ | Futures | 20367.04 | 20392.65 | 20364.93 | 20382.35 | 1762.0 |
| 2024-07-28 18:00:00 | YM | Futures | 42929.6 | 42995.8 | 42926.4 | 42990.5 | 1191.0 |
| 2024-07-28 19:00:00 | YM | Futures | 42988.4 | 43015.7 | 42987.4 | 42998.9 | 586.0 |
| 2024-07-28 20:00:00 | YM | Futures | 43000.0 | 43110.3 | 42989.5 | 43081.9 | 1647.0 |
| 2024-07-28 21:00:00 | YM | Futures | 43081.9 | 43094.6 | 43054.6 | 43067.2 | 1041.0 |
| 2024-07-28 22:00:00 | YM | Futures | 43069.3 | 43078.8 | 43055.7 | 43062.0 | 572.0 |
| 2024-07-28 23:00:00 | YM | Futures | 43062.0 | 43072.5 | 43048.3 | 43059.9 | 496.0 |
| 2024-07-28 18:00:00 | CL | Futures | 67.11 | 67.29 | 66.99 | 67.13 | 4001.0 |
| 2024-07-28 19:00:00 | CL | Futures | 67.13 | 67.16 | 67.06 | 67.07 | 987.0 |
| 2024-07-28 20:00:00 | CL | Futures | 67.07 | 67.23 | 66.96 | 67.17 | 2319.0 |
| 2024-07-28 21:00:00 | CL | Futures | 67.17 | 67.21 | 66.85 | 67.05 | 2850.0 |
| 2024-07-28 22:00:00 | CL | Futures | 67.04 | 67.06 | 66.91 | 66.99 | 1128.0 |
| 2024-07-28 23:00:00 | CL | Futures | 66.98 | 67.17 | 66.95 | 67.16 | 1149.0 |
| 2024-07-28 18:00:00 | GC | Futures | 2562.5 | 2579.0 | 2562.1 | 2571.0 | 3953.0 |
| 2024-07-28 19:00:00 | GC | Futures | 2571.1 | 2574.4 | 2569.8 | 2572.5 | 1449.0 |
| 2024-07-28 20:00:00 | GC | Futures | 2572.5 | 2577.4 | 2572.5 | 2575.6 | 2549.0 |
| 2024-07-28 21:00:00 | GC | Futures | 2575.8 | 2578.2 | 2563.7 | 2568.1 | 4462.0 |
| 2024-07-28 22:00:00 | GC | Futures | 2567.9 | 2570.0 | 2566.1 | 2568.1 | 1556.0 |
| 2024-07-28 23:00:00 | GC | Futures | 2568.1 | 2570.6 | 2566.9 | 2569.7 | 1357.0 |
| 2024-07-28 18:00:00 | ZN | Futures | 111.847462 | 111.894595 | 111.81604 | 111.847462 | 12185.0 |
| 2024-07-28 19:00:00 | ZN | Futures | 111.831751 | 111.878884 | 111.831751 | 111.863173 | 7335.0 |
| 2024-07-28 20:00:00 | ZN | Futures | 111.863173 | 111.973151 | 111.863173 | 111.95744 | 35564.0 |
| 2024-07-28 21:00:00 | ZN | Futures | 111.95744 | 112.020284 | 111.941729 | 111.988862 | 29053.0 |
| 2024-07-28 22:00:00 | ZN | Futures | 111.988862 | 112.020284 | 111.973151 | 111.988862 | 11052.0 |
| 2024-07-28 23:00:00 | ZN | Futures | 111.973151 | 111.988862 | 111.941729 | 111.95744 | 11879.0 |
> showing 36 of 430 rows — these rows as CSV