PREVIEW / futures_30min / 2009-12-28
file: by_date/futures_30min/2009/2009-12-28.parquet size: 57 KB rows: 2,219
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-28 00:00:00 | ES | Futures | 1092.23 | 1094.66 | 1092.23 | 1093.69 | 2312.0 |
| 2009-12-28 00:30:00 | ES | Futures | 1093.69 | 1093.69 | 1092.96 | 1093.45 | 346.0 |
| 2009-12-28 01:00:00 | ES | Futures | 1093.45 | 1094.18 | 1093.45 | 1094.18 | 553.0 |
| 2009-12-28 01:30:00 | ES | Futures | 1094.18 | 1094.18 | 1092.72 | 1092.96 | 737.0 |
| 2009-12-28 02:00:00 | ES | Futures | 1093.2 | 1093.69 | 1092.23 | 1093.45 | 2136.0 |
| 2009-12-28 02:30:00 | ES | Futures | 1093.69 | 1093.93 | 1092.96 | 1092.96 | 1191.0 |
| 2009-12-28 03:00:00 | ES | Futures | 1092.72 | 1093.69 | 1092.23 | 1092.23 | 3802.0 |
| 2009-12-28 03:30:00 | ES | Futures | 1092.23 | 1093.69 | 1092.23 | 1092.96 | 1620.0 |
| 2009-12-28 04:00:00 | ES | Futures | 1092.96 | 1092.96 | 1092.23 | 1092.72 | 971.0 |
| 2009-12-28 04:30:00 | ES | Futures | 1092.72 | 1093.93 | 1092.72 | 1093.45 | 1893.0 |
| 2009-12-28 05:00:00 | ES | Futures | 1093.69 | 1093.93 | 1092.72 | 1093.2 | 1477.0 |
| 2009-12-28 05:30:00 | ES | Futures | 1093.45 | 1093.45 | 1092.96 | 1093.45 | 639.0 |
| 2009-12-28 06:00:00 | ES | Futures | 1093.45 | 1094.18 | 1092.72 | 1093.2 | 1598.0 |
| 2009-12-28 06:30:00 | ES | Futures | 1093.2 | 1093.69 | 1092.96 | 1093.69 | 711.0 |
| 2009-12-28 07:00:00 | ES | Futures | 1093.93 | 1093.93 | 1091.75 | 1092.72 | 2623.0 |
| 2009-12-28 07:30:00 | ES | Futures | 1092.72 | 1093.69 | 1092.48 | 1093.45 | 1528.0 |
| 2009-12-28 08:00:00 | ES | Futures | 1093.45 | 1093.93 | 1092.96 | 1093.45 | 3719.0 |
| 2009-12-28 08:30:00 | ES | Futures | 1093.45 | 1094.42 | 1092.72 | 1094.42 | 4978.0 |
| 2009-12-28 09:00:00 | ES | Futures | 1094.18 | 1095.15 | 1093.69 | 1094.66 | 8007.0 |
| 2009-12-28 09:30:00 | ES | Futures | 1094.66 | 1095.88 | 1093.69 | 1094.18 | 62371.0 |
| 2009-12-28 10:00:00 | ES | Futures | 1094.18 | 1094.66 | 1092.23 | 1092.96 | 40998.0 |
| 2009-12-28 10:30:00 | ES | Futures | 1092.96 | 1093.2 | 1091.75 | 1092.23 | 33493.0 |
| 2009-12-28 11:00:00 | ES | Futures | 1092.23 | 1093.2 | 1092.23 | 1092.72 | 23168.0 |
| 2009-12-28 11:30:00 | ES | Futures | 1092.96 | 1093.45 | 1091.99 | 1092.96 | 20196.0 |
| 2009-12-28 12:00:00 | ES | Futures | 1092.72 | 1092.96 | 1091.99 | 1092.23 | 13501.0 |
| 2009-12-28 12:30:00 | ES | Futures | 1092.23 | 1092.96 | 1091.99 | 1092.72 | 11957.0 |
| 2009-12-28 13:00:00 | ES | Futures | 1092.96 | 1093.2 | 1092.48 | 1092.72 | 14717.0 |
| 2009-12-28 13:30:00 | ES | Futures | 1092.96 | 1092.96 | 1091.75 | 1092.23 | 15376.0 |
| 2009-12-28 14:00:00 | ES | Futures | 1092.23 | 1092.48 | 1089.31 | 1089.56 | 42731.0 |
| 2009-12-28 14:30:00 | ES | Futures | 1089.56 | 1090.77 | 1089.31 | 1090.29 | 16815.0 |
| 2009-12-28 15:00:00 | ES | Futures | 1090.53 | 1091.02 | 1089.8 | 1090.04 | 16906.0 |
| 2009-12-28 15:30:00 | ES | Futures | 1090.29 | 1093.69 | 1090.04 | 1093.2 | 67347.0 |
| 2009-12-28 16:00:00 | ES | Futures | 1093.2 | 1093.69 | 1092.23 | 1092.72 | 35309.0 |
| 2009-12-28 16:30:00 | ES | Futures | 1092.48 | 1092.96 | 1092.23 | 1092.72 | 1492.0 |
| 2009-12-28 17:00:00 | ES | Futures | 1092.48 | 1092.72 | 1092.23 | 1092.48 | 532.0 |
| 2009-12-28 18:00:00 | ES | Futures | 1092.48 | 1092.96 | 1092.23 | 1092.96 | 1427.0 |
| 2009-12-28 18:30:00 | ES | Futures | 1092.72 | 1093.2 | 1092.72 | 1093.2 | 848.0 |
| 2009-12-28 19:00:00 | ES | Futures | 1093.2 | 1094.18 | 1092.96 | 1092.96 | 1671.0 |
| 2009-12-28 19:30:00 | ES | Futures | 1092.96 | 1093.45 | 1092.72 | 1093.2 | 452.0 |
| 2009-12-28 20:00:00 | ES | Futures | 1092.96 | 1093.45 | 1092.96 | 1093.2 | 144.0 |
| 2009-12-28 20:30:00 | ES | Futures | 1093.2 | 1093.69 | 1092.72 | 1093.69 | 759.0 |
| 2009-12-28 21:00:00 | ES | Futures | 1093.69 | 1093.69 | 1092.96 | 1093.45 | 216.0 |
| 2009-12-28 21:30:00 | ES | Futures | 1093.2 | 1093.2 | 1092.96 | 1093.2 | 154.0 |
| 2009-12-28 22:00:00 | ES | Futures | 1093.2 | 1093.2 | 1092.48 | 1092.48 | 454.0 |
| 2009-12-28 22:30:00 | ES | Futures | 1092.48 | 1092.72 | 1092.23 | 1092.48 | 273.0 |
| 2009-12-28 23:00:00 | ES | Futures | 1092.72 | 1093.2 | 1092.23 | 1093.2 | 422.0 |
| 2009-12-28 23:30:00 | ES | Futures | 1092.96 | 1093.2 | 1092.96 | 1093.2 | 161.0 |
| 2009-12-28 00:00:00 | NQ | Futures | 2137.36 | 2140.79 | 2137.08 | 2139.36 | 289.0 |
| 2009-12-28 00:30:00 | NQ | Futures | 2139.65 | 2139.93 | 2139.36 | 2139.65 | 33.0 |
| 2009-12-28 01:00:00 | NQ | Futures | 2139.93 | 2140.79 | 2139.36 | 2140.22 | 30.0 |
> showing 50 of 2,219 rows — these rows as CSV