PREVIEW / futures_30min / 2010-11-05
file: by_date/futures_30min/2010/2010-11-05.parquet size: 63 KB rows: 2,142
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 |
|---|---|---|---|---|---|---|---|
| 2010-11-05 00:00:00 | ES | Futures | 1199.61 | 1199.86 | 1199.37 | 1199.61 | 908.0 |
| 2010-11-05 00:30:00 | ES | Futures | 1199.86 | 1200.11 | 1199.12 | 1199.86 | 1520.0 |
| 2010-11-05 01:00:00 | ES | Futures | 1199.86 | 1200.11 | 1199.61 | 1199.86 | 1373.0 |
| 2010-11-05 01:30:00 | ES | Futures | 1199.86 | 1199.86 | 1199.12 | 1199.37 | 1467.0 |
| 2010-11-05 02:00:00 | ES | Futures | 1199.61 | 1200.11 | 1199.37 | 1199.86 | 1479.0 |
| 2010-11-05 02:30:00 | ES | Futures | 1199.86 | 1200.6 | 1199.61 | 1199.86 | 2311.0 |
| 2010-11-05 03:00:00 | ES | Futures | 1199.86 | 1200.85 | 1199.61 | 1200.85 | 4294.0 |
| 2010-11-05 03:30:00 | ES | Futures | 1200.85 | 1201.34 | 1200.35 | 1200.35 | 6251.0 |
| 2010-11-05 04:00:00 | ES | Futures | 1200.6 | 1201.58 | 1199.86 | 1200.35 | 15905.0 |
| 2010-11-05 04:30:00 | ES | Futures | 1200.35 | 1200.6 | 1198.13 | 1199.12 | 21510.0 |
| 2010-11-05 05:00:00 | ES | Futures | 1199.12 | 1199.61 | 1198.38 | 1199.37 | 16261.0 |
| 2010-11-05 05:30:00 | ES | Futures | 1199.12 | 1199.61 | 1197.89 | 1198.38 | 14329.0 |
| 2010-11-05 06:00:00 | ES | Futures | 1198.38 | 1198.87 | 1197.15 | 1198.13 | 18466.0 |
| 2010-11-05 06:30:00 | ES | Futures | 1198.13 | 1198.63 | 1195.42 | 1195.67 | 34193.0 |
| 2010-11-05 07:00:00 | ES | Futures | 1195.92 | 1197.89 | 1195.42 | 1197.89 | 28930.0 |
| 2010-11-05 07:30:00 | ES | Futures | 1197.89 | 1198.87 | 1197.15 | 1197.89 | 19777.0 |
| 2010-11-05 08:00:00 | ES | Futures | 1198.13 | 1198.63 | 1197.15 | 1197.89 | 22093.0 |
| 2010-11-05 08:30:00 | ES | Futures | 1197.89 | 1205.04 | 1197.89 | 1202.08 | 161515.0 |
| 2010-11-05 09:00:00 | ES | Futures | 1201.83 | 1203.06 | 1200.85 | 1201.34 | 38471.0 |
| 2010-11-05 09:30:00 | ES | Futures | 1201.34 | 1204.05 | 1199.86 | 1202.82 | 222671.0 |
| 2010-11-05 10:00:00 | ES | Futures | 1202.57 | 1205.28 | 1201.34 | 1205.28 | 188979.0 |
| 2010-11-05 10:30:00 | ES | Futures | 1205.04 | 1207.25 | 1204.79 | 1205.77 | 178043.0 |
| 2010-11-05 11:00:00 | ES | Futures | 1206.02 | 1206.51 | 1204.79 | 1205.28 | 116287.0 |
| 2010-11-05 11:30:00 | ES | Futures | 1205.28 | 1205.77 | 1200.6 | 1201.09 | 161295.0 |
| 2010-11-05 12:00:00 | ES | Futures | 1201.09 | 1202.82 | 1200.11 | 1201.09 | 122080.0 |
| 2010-11-05 12:30:00 | ES | Futures | 1201.09 | 1203.8 | 1200.6 | 1202.82 | 79635.0 |
| 2010-11-05 13:00:00 | ES | Futures | 1203.06 | 1204.54 | 1202.82 | 1203.8 | 43558.0 |
| 2010-11-05 13:30:00 | ES | Futures | 1204.05 | 1204.05 | 1203.06 | 1203.8 | 25541.0 |
| 2010-11-05 14:00:00 | ES | Futures | 1203.8 | 1204.05 | 1200.11 | 1201.09 | 76670.0 |
| 2010-11-05 14:30:00 | ES | Futures | 1201.09 | 1202.57 | 1200.85 | 1201.58 | 54960.0 |
| 2010-11-05 15:00:00 | ES | Futures | 1201.58 | 1202.57 | 1200.35 | 1202.32 | 60133.0 |
| 2010-11-05 15:30:00 | ES | Futures | 1202.08 | 1206.27 | 1200.85 | 1205.28 | 209853.0 |
| 2010-11-05 16:00:00 | ES | Futures | 1205.28 | 1206.27 | 1204.05 | 1205.04 | 113870.0 |
| 2010-11-05 00:00:00 | NQ | Futures | 2501.79 | 2502.94 | 2501.79 | 2502.65 | 119.0 |
| 2010-11-05 00:30:00 | NQ | Futures | 2502.65 | 2503.51 | 2502.36 | 2502.94 | 73.0 |
| 2010-11-05 01:00:00 | NQ | Futures | 2503.22 | 2503.51 | 2502.65 | 2502.94 | 71.0 |
| 2010-11-05 01:30:00 | NQ | Futures | 2503.22 | 2503.22 | 2502.65 | 2503.22 | 38.0 |
| 2010-11-05 02:00:00 | NQ | Futures | 2503.22 | 2503.51 | 2502.65 | 2503.51 | 62.0 |
| 2010-11-05 02:30:00 | NQ | Futures | 2503.8 | 2503.8 | 2502.08 | 2502.94 | 211.0 |
| 2010-11-05 03:00:00 | NQ | Futures | 2502.08 | 2504.66 | 2502.08 | 2504.66 | 206.0 |
| 2010-11-05 03:30:00 | NQ | Futures | 2504.95 | 2506.38 | 2504.09 | 2504.95 | 499.0 |
| 2010-11-05 04:00:00 | NQ | Futures | 2504.66 | 2506.38 | 2503.51 | 2504.95 | 747.0 |
| 2010-11-05 04:30:00 | NQ | Futures | 2504.66 | 2505.23 | 2500.36 | 2502.08 | 647.0 |
| 2010-11-05 05:00:00 | NQ | Futures | 2502.36 | 2504.09 | 2501.79 | 2503.22 | 597.0 |
| 2010-11-05 05:30:00 | NQ | Futures | 2503.22 | 2503.51 | 2501.22 | 2502.36 | 441.0 |
| 2010-11-05 06:00:00 | NQ | Futures | 2502.08 | 2503.22 | 2500.07 | 2502.08 | 729.0 |
| 2010-11-05 06:30:00 | NQ | Futures | 2502.36 | 2502.65 | 2498.06 | 2498.35 | 1408.0 |
| 2010-11-05 07:00:00 | NQ | Futures | 2498.06 | 2502.94 | 2498.06 | 2502.94 | 999.0 |
| 2010-11-05 07:30:00 | NQ | Futures | 2502.65 | 2504.09 | 2501.79 | 2503.22 | 663.0 |
| 2010-11-05 08:00:00 | NQ | Futures | 2503.22 | 2505.52 | 2498.92 | 2499.49 | 3117.0 |
> showing 50 of 2,142 rows — these rows as CSV