PREVIEW / futures_30min / 2010-12-06
file: by_date/futures_30min/2010/2010-12-06.parquet size: 71 KB rows: 2,595
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-12-06 00:00:00 | ES | Futures | 1205.77 | 1206.02 | 1204.3 | 1204.54 | 1365.0 |
| 2010-12-06 00:30:00 | ES | Futures | 1204.54 | 1205.04 | 1204.05 | 1204.3 | 1077.0 |
| 2010-12-06 01:00:00 | ES | Futures | 1204.54 | 1205.28 | 1204.05 | 1204.79 | 881.0 |
| 2010-12-06 01:30:00 | ES | Futures | 1205.04 | 1205.77 | 1204.54 | 1205.28 | 3133.0 |
| 2010-12-06 02:00:00 | ES | Futures | 1205.28 | 1206.51 | 1204.54 | 1206.27 | 5470.0 |
| 2010-12-06 02:30:00 | ES | Futures | 1206.27 | 1207.01 | 1204.79 | 1204.79 | 4957.0 |
| 2010-12-06 03:00:00 | ES | Futures | 1204.79 | 1206.02 | 1203.31 | 1203.56 | 13714.0 |
| 2010-12-06 03:30:00 | ES | Futures | 1203.56 | 1204.05 | 1201.09 | 1201.34 | 16010.0 |
| 2010-12-06 04:00:00 | ES | Futures | 1201.09 | 1203.06 | 1200.85 | 1202.82 | 12442.0 |
| 2010-12-06 04:30:00 | ES | Futures | 1202.57 | 1202.82 | 1201.09 | 1202.32 | 7981.0 |
| 2010-12-06 05:00:00 | ES | Futures | 1202.08 | 1203.8 | 1202.08 | 1202.57 | 8255.0 |
| 2010-12-06 05:30:00 | ES | Futures | 1202.57 | 1203.31 | 1199.12 | 1199.37 | 15215.0 |
| 2010-12-06 06:00:00 | ES | Futures | 1199.61 | 1201.58 | 1199.37 | 1200.85 | 7814.0 |
| 2010-12-06 06:30:00 | ES | Futures | 1200.85 | 1202.57 | 1200.11 | 1201.58 | 16246.0 |
| 2010-12-06 07:00:00 | ES | Futures | 1201.58 | 1204.05 | 1201.58 | 1203.8 | 13603.0 |
| 2010-12-06 07:30:00 | ES | Futures | 1203.8 | 1203.8 | 1202.08 | 1203.31 | 7632.0 |
| 2010-12-06 08:00:00 | ES | Futures | 1203.06 | 1203.31 | 1201.58 | 1202.08 | 13109.0 |
| 2010-12-06 08:30:00 | ES | Futures | 1201.83 | 1203.31 | 1200.35 | 1202.82 | 24763.0 |
| 2010-12-06 09:00:00 | ES | Futures | 1202.57 | 1204.54 | 1202.08 | 1204.05 | 24966.0 |
| 2010-12-06 09:30:00 | ES | Futures | 1204.05 | 1205.53 | 1202.82 | 1203.56 | 133906.0 |
| 2010-12-06 10:00:00 | ES | Futures | 1203.56 | 1206.51 | 1203.56 | 1206.51 | 122899.0 |
| 2010-12-06 10:30:00 | ES | Futures | 1206.51 | 1207.01 | 1203.56 | 1204.54 | 100705.0 |
| 2010-12-06 11:00:00 | ES | Futures | 1204.54 | 1206.02 | 1203.06 | 1204.3 | 88552.0 |
| 2010-12-06 11:30:00 | ES | Futures | 1204.3 | 1204.79 | 1202.82 | 1204.05 | 84669.0 |
| 2010-12-06 12:00:00 | ES | Futures | 1204.3 | 1205.04 | 1203.06 | 1203.56 | 64560.0 |
| 2010-12-06 12:30:00 | ES | Futures | 1203.56 | 1205.04 | 1203.56 | 1204.79 | 45909.0 |
| 2010-12-06 13:00:00 | ES | Futures | 1205.04 | 1205.77 | 1204.3 | 1205.53 | 38392.0 |
| 2010-12-06 13:30:00 | ES | Futures | 1205.53 | 1206.76 | 1205.28 | 1206.02 | 50448.0 |
| 2010-12-06 14:00:00 | ES | Futures | 1206.27 | 1206.76 | 1205.28 | 1205.77 | 36133.0 |
| 2010-12-06 14:30:00 | ES | Futures | 1205.77 | 1207.5 | 1205.28 | 1206.76 | 52081.0 |
| 2010-12-06 15:00:00 | ES | Futures | 1207.01 | 1207.75 | 1206.51 | 1206.51 | 50055.0 |
| 2010-12-06 15:30:00 | ES | Futures | 1206.76 | 1208.24 | 1205.04 | 1205.04 | 125297.0 |
| 2010-12-06 16:00:00 | ES | Futures | 1205.04 | 1205.77 | 1204.79 | 1205.28 | 48371.0 |
| 2010-12-06 16:30:00 | ES | Futures | 1205.53 | 1205.53 | 1204.05 | 1204.05 | 6100.0 |
| 2010-12-06 17:00:00 | ES | Futures | 1204.3 | 1204.3 | 1202.57 | 1202.82 | 6460.0 |
| 2010-12-06 18:00:00 | ES | Futures | 1203.8 | 1205.53 | 1202.57 | 1203.06 | 11758.0 |
| 2010-12-06 18:30:00 | ES | Futures | 1203.06 | 1205.77 | 1203.06 | 1205.04 | 5479.0 |
| 2010-12-06 19:00:00 | ES | Futures | 1205.04 | 1206.27 | 1204.79 | 1205.28 | 5394.0 |
| 2010-12-06 19:30:00 | ES | Futures | 1205.28 | 1206.27 | 1205.28 | 1206.02 | 2799.0 |
| 2010-12-06 20:00:00 | ES | Futures | 1206.02 | 1206.27 | 1204.3 | 1204.3 | 3362.0 |
| 2010-12-06 20:30:00 | ES | Futures | 1204.3 | 1204.54 | 1201.83 | 1202.32 | 5665.0 |
| 2010-12-06 21:00:00 | ES | Futures | 1202.57 | 1204.79 | 1202.32 | 1204.79 | 3577.0 |
| 2010-12-06 21:30:00 | ES | Futures | 1204.79 | 1206.76 | 1204.79 | 1206.02 | 5662.0 |
| 2010-12-06 22:00:00 | ES | Futures | 1206.02 | 1206.76 | 1205.77 | 1206.27 | 2488.0 |
| 2010-12-06 22:30:00 | ES | Futures | 1206.27 | 1207.5 | 1205.53 | 1207.5 | 3496.0 |
| 2010-12-06 23:00:00 | ES | Futures | 1207.25 | 1207.75 | 1207.01 | 1207.5 | 1519.0 |
| 2010-12-06 23:30:00 | ES | Futures | 1207.75 | 1207.99 | 1207.25 | 1207.5 | 2080.0 |
| 2010-12-06 00:00:00 | NQ | Futures | 2510.97 | 2511.54 | 2507.81 | 2507.81 | 83.0 |
| 2010-12-06 00:30:00 | NQ | Futures | 2507.81 | 2508.39 | 2507.53 | 2508.1 | 44.0 |
| 2010-12-06 01:00:00 | NQ | Futures | 2508.1 | 2509.25 | 2507.53 | 2509.25 | 146.0 |
> showing 50 of 2,595 rows — these rows as CSV