PREVIEW / futures_30min / 2010-11-08
file: by_date/futures_30min/2010/2010-11-08.parquet size: 70 KB rows: 2,626
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-08 00:00:00 | ES | Futures | 1201.09 | 1202.32 | 1200.85 | 1202.32 | 1514.0 |
| 2010-11-08 00:30:00 | ES | Futures | 1202.08 | 1202.57 | 1201.83 | 1202.57 | 2311.0 |
| 2010-11-08 01:00:00 | ES | Futures | 1202.32 | 1202.82 | 1201.58 | 1201.58 | 2455.0 |
| 2010-11-08 01:30:00 | ES | Futures | 1201.34 | 1201.58 | 1200.11 | 1200.35 | 2954.0 |
| 2010-11-08 02:00:00 | ES | Futures | 1200.35 | 1201.83 | 1200.11 | 1201.58 | 8353.0 |
| 2010-11-08 02:30:00 | ES | Futures | 1201.58 | 1203.31 | 1201.58 | 1203.06 | 4337.0 |
| 2010-11-08 03:00:00 | ES | Futures | 1203.06 | 1203.31 | 1201.58 | 1202.57 | 16080.0 |
| 2010-11-08 03:30:00 | ES | Futures | 1202.32 | 1203.8 | 1202.32 | 1202.57 | 14921.0 |
| 2010-11-08 04:00:00 | ES | Futures | 1202.57 | 1203.06 | 1200.11 | 1200.85 | 18540.0 |
| 2010-11-08 04:30:00 | ES | Futures | 1200.6 | 1202.32 | 1200.6 | 1202.08 | 8047.0 |
| 2010-11-08 05:00:00 | ES | Futures | 1201.83 | 1202.82 | 1201.34 | 1202.32 | 8472.0 |
| 2010-11-08 05:30:00 | ES | Futures | 1202.32 | 1203.06 | 1199.37 | 1199.61 | 23782.0 |
| 2010-11-08 06:00:00 | ES | Futures | 1199.61 | 1201.34 | 1199.37 | 1200.85 | 9360.0 |
| 2010-11-08 06:30:00 | ES | Futures | 1200.85 | 1201.58 | 1200.35 | 1201.34 | 10302.0 |
| 2010-11-08 07:00:00 | ES | Futures | 1201.58 | 1202.82 | 1200.85 | 1201.58 | 13278.0 |
| 2010-11-08 07:30:00 | ES | Futures | 1201.83 | 1202.32 | 1201.09 | 1201.34 | 10103.0 |
| 2010-11-08 08:00:00 | ES | Futures | 1201.09 | 1202.08 | 1200.85 | 1200.85 | 12443.0 |
| 2010-11-08 08:30:00 | ES | Futures | 1200.85 | 1202.32 | 1200.85 | 1201.09 | 17928.0 |
| 2010-11-08 09:00:00 | ES | Futures | 1201.34 | 1201.58 | 1200.35 | 1201.34 | 18928.0 |
| 2010-11-08 09:30:00 | ES | Futures | 1201.58 | 1202.82 | 1198.38 | 1199.12 | 191983.0 |
| 2010-11-08 10:00:00 | ES | Futures | 1199.12 | 1201.83 | 1198.13 | 1201.34 | 140743.0 |
| 2010-11-08 10:30:00 | ES | Futures | 1201.34 | 1201.83 | 1198.63 | 1198.87 | 115309.0 |
| 2010-11-08 11:00:00 | ES | Futures | 1198.87 | 1200.6 | 1197.64 | 1199.86 | 117610.0 |
| 2010-11-08 11:30:00 | ES | Futures | 1200.11 | 1202.32 | 1199.86 | 1201.83 | 79134.0 |
| 2010-11-08 12:00:00 | ES | Futures | 1201.83 | 1203.56 | 1200.85 | 1202.82 | 74540.0 |
| 2010-11-08 12:30:00 | ES | Futures | 1202.82 | 1203.06 | 1201.58 | 1202.08 | 41507.0 |
| 2010-11-08 13:00:00 | ES | Futures | 1202.08 | 1204.05 | 1201.83 | 1203.06 | 47291.0 |
| 2010-11-08 13:30:00 | ES | Futures | 1203.06 | 1203.06 | 1201.09 | 1202.08 | 42135.0 |
| 2010-11-08 14:00:00 | ES | Futures | 1202.32 | 1204.3 | 1202.08 | 1203.06 | 49315.0 |
| 2010-11-08 14:30:00 | ES | Futures | 1203.06 | 1203.31 | 1201.34 | 1201.58 | 65354.0 |
| 2010-11-08 15:00:00 | ES | Futures | 1201.83 | 1203.8 | 1201.34 | 1203.56 | 60611.0 |
| 2010-11-08 15:30:00 | ES | Futures | 1203.56 | 1204.79 | 1201.34 | 1203.31 | 165653.0 |
| 2010-11-08 16:00:00 | ES | Futures | 1203.56 | 1203.8 | 1202.57 | 1202.82 | 62492.0 |
| 2010-11-08 16:30:00 | ES | Futures | 1202.08 | 1202.32 | 1201.09 | 1201.09 | 6734.0 |
| 2010-11-08 17:00:00 | ES | Futures | 1201.34 | 1201.34 | 1200.35 | 1201.09 | 2139.0 |
| 2010-11-08 18:00:00 | ES | Futures | 1200.85 | 1201.58 | 1200.11 | 1201.09 | 3987.0 |
| 2010-11-08 18:30:00 | ES | Futures | 1201.34 | 1201.58 | 1199.37 | 1199.61 | 3275.0 |
| 2010-11-08 19:00:00 | ES | Futures | 1199.61 | 1199.61 | 1198.13 | 1198.38 | 7968.0 |
| 2010-11-08 19:30:00 | ES | Futures | 1198.13 | 1199.12 | 1198.13 | 1198.63 | 2475.0 |
| 2010-11-08 20:00:00 | ES | Futures | 1198.87 | 1199.86 | 1198.38 | 1199.37 | 3097.0 |
| 2010-11-08 20:30:00 | ES | Futures | 1199.37 | 1200.11 | 1199.12 | 1199.86 | 2661.0 |
| 2010-11-08 21:00:00 | ES | Futures | 1199.86 | 1200.11 | 1199.12 | 1199.61 | 2136.0 |
| 2010-11-08 21:30:00 | ES | Futures | 1199.86 | 1200.11 | 1198.87 | 1199.37 | 5142.0 |
| 2010-11-08 22:00:00 | ES | Futures | 1199.12 | 1200.35 | 1199.12 | 1200.35 | 2240.0 |
| 2010-11-08 22:30:00 | ES | Futures | 1200.11 | 1201.34 | 1200.11 | 1200.6 | 4131.0 |
| 2010-11-08 23:00:00 | ES | Futures | 1200.6 | 1200.85 | 1199.37 | 1199.37 | 2296.0 |
| 2010-11-08 23:30:00 | ES | Futures | 1199.61 | 1199.61 | 1199.12 | 1199.37 | 1060.0 |
| 2010-11-08 00:00:00 | NQ | Futures | 2498.92 | 2500.93 | 2498.92 | 2500.93 | 42.0 |
| 2010-11-08 00:30:00 | NQ | Futures | 2501.22 | 2501.79 | 2500.93 | 2501.79 | 48.0 |
| 2010-11-08 01:00:00 | NQ | Futures | 2502.08 | 2502.08 | 2500.64 | 2501.22 | 28.0 |
> showing 50 of 2,626 rows — these rows as CSV