PREVIEW / futures_30min / 2009-10-08
file: by_date/futures_30min/2009/2009-10-08.parquet size: 67 KB rows: 2,433
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-10-08 00:00:00 | ES | Futures | 1029.93 | 1029.93 | 1028.96 | 1029.44 | 2540.0 |
| 2009-10-08 00:30:00 | ES | Futures | 1029.44 | 1029.93 | 1029.2 | 1029.68 | 1681.0 |
| 2009-10-08 01:00:00 | ES | Futures | 1029.93 | 1029.93 | 1029.44 | 1029.68 | 1148.0 |
| 2009-10-08 01:30:00 | ES | Futures | 1029.68 | 1029.93 | 1029.44 | 1029.93 | 854.0 |
| 2009-10-08 02:00:00 | ES | Futures | 1029.68 | 1031.38 | 1029.68 | 1031.14 | 7935.0 |
| 2009-10-08 02:30:00 | ES | Futures | 1030.9 | 1031.86 | 1030.41 | 1031.62 | 4803.0 |
| 2009-10-08 03:00:00 | ES | Futures | 1031.62 | 1031.86 | 1030.41 | 1031.62 | 16823.0 |
| 2009-10-08 03:30:00 | ES | Futures | 1031.38 | 1031.86 | 1030.17 | 1031.62 | 11971.0 |
| 2009-10-08 04:00:00 | ES | Futures | 1031.62 | 1032.59 | 1030.41 | 1030.41 | 12973.0 |
| 2009-10-08 04:30:00 | ES | Futures | 1030.41 | 1031.38 | 1029.68 | 1029.68 | 6412.0 |
| 2009-10-08 05:00:00 | ES | Futures | 1029.68 | 1030.41 | 1028.96 | 1030.41 | 4895.0 |
| 2009-10-08 05:30:00 | ES | Futures | 1030.17 | 1031.14 | 1030.17 | 1030.65 | 4046.0 |
| 2009-10-08 06:00:00 | ES | Futures | 1030.65 | 1030.9 | 1029.68 | 1030.65 | 5327.0 |
| 2009-10-08 06:30:00 | ES | Futures | 1030.41 | 1030.9 | 1029.44 | 1030.17 | 5635.0 |
| 2009-10-08 07:00:00 | ES | Futures | 1029.93 | 1030.65 | 1029.44 | 1029.68 | 9631.0 |
| 2009-10-08 07:30:00 | ES | Futures | 1029.68 | 1030.17 | 1028.72 | 1029.2 | 9986.0 |
| 2009-10-08 08:00:00 | ES | Futures | 1029.2 | 1030.41 | 1028.23 | 1029.44 | 12671.0 |
| 2009-10-08 08:30:00 | ES | Futures | 1029.68 | 1032.59 | 1029.44 | 1030.41 | 38252.0 |
| 2009-10-08 09:00:00 | ES | Futures | 1030.17 | 1030.65 | 1027.5 | 1027.99 | 38947.0 |
| 2009-10-08 09:30:00 | ES | Futures | 1028.23 | 1030.41 | 1025.57 | 1027.26 | 215275.0 |
| 2009-10-08 10:00:00 | ES | Futures | 1027.26 | 1028.72 | 1023.87 | 1028.23 | 172011.0 |
| 2009-10-08 10:30:00 | ES | Futures | 1027.99 | 1029.93 | 1027.5 | 1029.2 | 95077.0 |
| 2009-10-08 11:00:00 | ES | Futures | 1028.96 | 1033.32 | 1027.75 | 1031.62 | 176061.0 |
| 2009-10-08 11:30:00 | ES | Futures | 1031.86 | 1033.56 | 1031.62 | 1032.59 | 110456.0 |
| 2009-10-08 12:00:00 | ES | Futures | 1032.59 | 1034.04 | 1030.9 | 1033.32 | 74304.0 |
| 2009-10-08 12:30:00 | ES | Futures | 1033.32 | 1034.04 | 1032.35 | 1032.83 | 66901.0 |
| 2009-10-08 13:00:00 | ES | Futures | 1032.59 | 1033.08 | 1029.68 | 1030.65 | 84057.0 |
| 2009-10-08 13:30:00 | ES | Futures | 1030.9 | 1031.38 | 1027.99 | 1030.65 | 103803.0 |
| 2009-10-08 14:00:00 | ES | Futures | 1030.65 | 1031.14 | 1027.26 | 1028.96 | 71505.0 |
| 2009-10-08 14:30:00 | ES | Futures | 1028.96 | 1030.65 | 1027.99 | 1029.68 | 52397.0 |
| 2009-10-08 15:00:00 | ES | Futures | 1029.68 | 1032.11 | 1029.2 | 1030.17 | 71541.0 |
| 2009-10-08 15:30:00 | ES | Futures | 1029.93 | 1030.17 | 1027.5 | 1028.47 | 201217.0 |
| 2009-10-08 16:00:00 | ES | Futures | 1028.23 | 1030.9 | 1028.23 | 1030.9 | 79830.0 |
| 2009-10-08 16:30:00 | ES | Futures | 1030.17 | 1031.86 | 1029.93 | 1031.14 | 6871.0 |
| 2009-10-08 17:00:00 | ES | Futures | 1030.9 | 1031.62 | 1030.65 | 1030.65 | 1885.0 |
| 2009-10-08 18:00:00 | ES | Futures | 1030.65 | 1031.14 | 1030.41 | 1030.9 | 1516.0 |
| 2009-10-08 18:30:00 | ES | Futures | 1030.9 | 1031.62 | 1030.65 | 1031.14 | 863.0 |
| 2009-10-08 19:00:00 | ES | Futures | 1031.38 | 1031.38 | 1030.17 | 1030.9 | 1994.0 |
| 2009-10-08 19:30:00 | ES | Futures | 1031.14 | 1031.62 | 1030.9 | 1031.14 | 767.0 |
| 2009-10-08 20:00:00 | ES | Futures | 1031.14 | 1031.38 | 1030.17 | 1030.41 | 1822.0 |
| 2009-10-08 20:30:00 | ES | Futures | 1030.41 | 1031.14 | 1030.17 | 1030.9 | 859.0 |
| 2009-10-08 21:00:00 | ES | Futures | 1030.65 | 1032.35 | 1030.41 | 1031.86 | 2017.0 |
| 2009-10-08 21:30:00 | ES | Futures | 1031.62 | 1031.86 | 1029.68 | 1029.93 | 4371.0 |
| 2009-10-08 22:00:00 | ES | Futures | 1029.93 | 1030.17 | 1029.68 | 1029.93 | 805.0 |
| 2009-10-08 22:30:00 | ES | Futures | 1029.93 | 1030.41 | 1029.2 | 1029.44 | 1146.0 |
| 2009-10-08 23:00:00 | ES | Futures | 1029.2 | 1030.17 | 1028.96 | 1029.68 | 1945.0 |
| 2009-10-08 23:30:00 | ES | Futures | 1029.68 | 1030.41 | 1029.68 | 1030.41 | 696.0 |
| 2009-10-08 00:00:00 | NQ | Futures | 1963.28 | 1963.28 | 1962.42 | 1962.71 | 212.0 |
| 2009-10-08 00:30:00 | NQ | Futures | 1962.71 | 1963.56 | 1962.42 | 1963.56 | 179.0 |
| 2009-10-08 01:00:00 | NQ | Futures | 1963.28 | 1963.56 | 1962.71 | 1962.99 | 109.0 |
> showing 50 of 2,433 rows — these rows as CSV