PREVIEW / futures_30min / 2008-02-24
file: by_date/futures_30min/2008/2008-02-24.parquet size: 16 KB rows: 365
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 |
|---|---|---|---|---|---|---|---|
| 2008-02-24 18:00:00 | ES | Futures | 1263.24 | 1266.97 | 1262.77 | 1264.87 | 4521.0 |
| 2008-02-24 18:30:00 | ES | Futures | 1264.87 | 1266.97 | 1264.87 | 1266.27 | 2070.0 |
| 2008-02-24 19:00:00 | ES | Futures | 1266.5 | 1269.3 | 1266.5 | 1268.6 | 2973.0 |
| 2008-02-24 19:30:00 | ES | Futures | 1268.84 | 1272.1 | 1268.6 | 1270.93 | 5646.0 |
| 2008-02-24 20:00:00 | ES | Futures | 1271.17 | 1271.63 | 1270.47 | 1270.7 | 2692.0 |
| 2008-02-24 20:30:00 | ES | Futures | 1270.93 | 1271.4 | 1269.54 | 1269.77 | 1557.0 |
| 2008-02-24 21:00:00 | ES | Futures | 1270.0 | 1270.0 | 1267.67 | 1268.37 | 2928.0 |
| 2008-02-24 21:30:00 | ES | Futures | 1268.6 | 1269.54 | 1267.67 | 1268.84 | 1345.0 |
| 2008-02-24 22:00:00 | ES | Futures | 1268.84 | 1270.0 | 1268.37 | 1269.3 | 1091.0 |
| 2008-02-24 22:30:00 | ES | Futures | 1269.3 | 1269.77 | 1268.84 | 1269.07 | 532.0 |
| 2008-02-24 23:00:00 | ES | Futures | 1269.07 | 1269.77 | 1268.84 | 1269.3 | 421.0 |
| 2008-02-24 23:30:00 | ES | Futures | 1269.3 | 1271.17 | 1269.07 | 1270.93 | 843.0 |
| 2008-02-24 18:00:00 | NQ | Futures | 2016.43 | 2023.81 | 2015.57 | 2022.1 | 359.0 |
| 2008-02-24 18:30:00 | NQ | Futures | 2022.1 | 2026.64 | 2021.53 | 2022.67 | 117.0 |
| 2008-02-24 19:00:00 | NQ | Futures | 2023.24 | 2028.35 | 2023.24 | 2028.35 | 121.0 |
| 2008-02-24 19:30:00 | NQ | Futures | 2028.35 | 2032.32 | 2028.35 | 2030.33 | 204.0 |
| 2008-02-24 20:00:00 | NQ | Futures | 2030.05 | 2031.75 | 2030.05 | 2031.19 | 82.0 |
| 2008-02-24 20:30:00 | NQ | Futures | 2031.19 | 2033.17 | 2030.33 | 2030.33 | 155.0 |
| 2008-02-24 21:00:00 | NQ | Futures | 2031.19 | 2031.19 | 2027.21 | 2027.78 | 177.0 |
| 2008-02-24 21:30:00 | NQ | Futures | 2027.78 | 2029.2 | 2026.93 | 2028.63 | 35.0 |
| 2008-02-24 22:00:00 | NQ | Futures | 2027.5 | 2029.77 | 2027.21 | 2029.48 | 26.0 |
| 2008-02-24 22:30:00 | NQ | Futures | 2028.63 | 2029.48 | 2028.06 | 2028.63 | 60.0 |
| 2008-02-24 23:00:00 | NQ | Futures | 2028.63 | 2029.77 | 2028.63 | 2028.63 | 62.0 |
| 2008-02-24 23:30:00 | NQ | Futures | 2028.91 | 2032.6 | 2028.35 | 2032.04 | 108.0 |
| 2008-02-24 18:00:00 | YM | Futures | 11259.9 | 11275.4 | 11249.0 | 11269.9 | 309.0 |
| 2008-02-24 18:30:00 | YM | Futures | 11267.2 | 11285.4 | 11266.3 | 11274.5 | 141.0 |
| 2008-02-24 19:00:00 | YM | Futures | 11276.3 | 11294.4 | 11276.3 | 11294.4 | 127.0 |
| 2008-02-24 19:30:00 | YM | Futures | 11294.4 | 11315.3 | 11294.4 | 11308.1 | 655.0 |
| 2008-02-24 20:00:00 | YM | Futures | 11308.1 | 11315.3 | 11305.4 | 11307.2 | 245.0 |
| 2008-02-24 20:30:00 | YM | Futures | 11307.2 | 11310.8 | 11299.0 | 11299.9 | 166.0 |
| 2008-02-24 21:00:00 | YM | Futures | 11299.0 | 11300.8 | 11281.7 | 11285.4 | 179.0 |
| 2008-02-24 21:30:00 | YM | Futures | 11285.4 | 11298.1 | 11282.6 | 11293.5 | 97.0 |
| 2008-02-24 22:00:00 | YM | Futures | 11294.4 | 11309.0 | 11292.6 | 11297.2 | 62.0 |
| 2008-02-24 22:30:00 | YM | Futures | 11296.3 | 11302.6 | 11295.4 | 11298.1 | 75.0 |
| 2008-02-24 23:00:00 | YM | Futures | 11300.8 | 11302.6 | 11298.1 | 11298.1 | 22.0 |
| 2008-02-24 23:30:00 | YM | Futures | 11296.3 | 11314.4 | 11294.4 | 11314.4 | 76.0 |
| 2008-02-24 18:00:00 | CL | Futures | 369.62 | 371.34 | 369.29 | 371.04 | 486.0 |
| 2008-02-24 18:30:00 | CL | Futures | 370.97 | 372.24 | 370.37 | 371.49 | 547.0 |
| 2008-02-24 19:00:00 | CL | Futures | 371.53 | 372.27 | 371.26 | 371.82 | 371.0 |
| 2008-02-24 19:30:00 | CL | Futures | 371.75 | 372.05 | 371.53 | 371.53 | 228.0 |
| 2008-02-24 20:00:00 | CL | Futures | 371.53 | 372.01 | 371.49 | 371.49 | 169.0 |
| 2008-02-24 20:30:00 | CL | Futures | 371.53 | 371.6 | 371.3 | 371.45 | 110.0 |
| 2008-02-24 21:00:00 | CL | Futures | 371.41 | 371.64 | 371.23 | 371.64 | 107.0 |
| 2008-02-24 21:30:00 | CL | Futures | 371.64 | 371.82 | 371.49 | 371.82 | 84.0 |
| 2008-02-24 22:00:00 | CL | Futures | 371.79 | 371.79 | 371.45 | 371.6 | 95.0 |
| 2008-02-24 22:30:00 | CL | Futures | 371.6 | 371.82 | 371.6 | 371.71 | 21.0 |
| 2008-02-24 23:00:00 | CL | Futures | 371.75 | 372.27 | 371.71 | 371.94 | 167.0 |
| 2008-02-24 23:30:00 | CL | Futures | 371.9 | 371.97 | 371.53 | 371.53 | 78.0 |
| 2008-02-24 18:00:00 | GC | Futures | 1380.0 | 1382.8 | 1379.6 | 1381.8 | 846.0 |
| 2008-02-24 18:30:00 | GC | Futures | 1381.6 | 1384.4 | 1380.2 | 1384.0 | 481.0 |
> showing 50 of 365 rows — these rows as CSV