PREVIEW / futures_30min / 2008-07-15
file: by_date/futures_30min/2008/2008-07-15.parquet size: 68 KB rows: 2,273
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-15 00:00:00 | ES | Futures | 1136.98 | 1137.44 | 1136.05 | 1136.98 | 1090.0 |
| 2008-07-15 00:30:00 | ES | Futures | 1136.98 | 1136.98 | 1135.35 | 1135.81 | 674.0 |
| 2008-07-15 01:00:00 | ES | Futures | 1135.81 | 1136.05 | 1134.42 | 1134.88 | 1158.0 |
| 2008-07-15 01:30:00 | ES | Futures | 1135.12 | 1136.28 | 1134.88 | 1136.28 | 1473.0 |
| 2008-07-15 02:00:00 | ES | Futures | 1136.51 | 1137.21 | 1135.12 | 1137.21 | 2357.0 |
| 2008-07-15 02:30:00 | ES | Futures | 1137.21 | 1137.91 | 1134.65 | 1136.51 | 3311.0 |
| 2008-07-15 03:00:00 | ES | Futures | 1136.51 | 1137.67 | 1132.56 | 1133.49 | 16483.0 |
| 2008-07-15 03:30:00 | ES | Futures | 1133.49 | 1135.58 | 1133.02 | 1133.26 | 8749.0 |
| 2008-07-15 04:00:00 | ES | Futures | 1133.02 | 1134.65 | 1131.17 | 1132.79 | 12396.0 |
| 2008-07-15 04:30:00 | ES | Futures | 1132.79 | 1134.88 | 1131.63 | 1133.95 | 8166.0 |
| 2008-07-15 05:00:00 | ES | Futures | 1133.72 | 1135.58 | 1132.33 | 1133.72 | 10657.0 |
| 2008-07-15 05:30:00 | ES | Futures | 1133.72 | 1133.95 | 1130.7 | 1131.17 | 8125.0 |
| 2008-07-15 06:00:00 | ES | Futures | 1131.17 | 1131.86 | 1130.0 | 1130.93 | 10974.0 |
| 2008-07-15 06:30:00 | ES | Futures | 1131.17 | 1131.17 | 1125.12 | 1127.21 | 37778.0 |
| 2008-07-15 07:00:00 | ES | Futures | 1126.98 | 1128.61 | 1126.75 | 1128.38 | 16699.0 |
| 2008-07-15 07:30:00 | ES | Futures | 1128.14 | 1130.0 | 1126.98 | 1129.31 | 19770.0 |
| 2008-07-15 08:00:00 | ES | Futures | 1129.31 | 1130.24 | 1127.68 | 1128.61 | 20566.0 |
| 2008-07-15 08:30:00 | ES | Futures | 1128.61 | 1131.86 | 1126.05 | 1131.63 | 45864.0 |
| 2008-07-15 09:00:00 | ES | Futures | 1131.86 | 1134.65 | 1130.24 | 1132.79 | 50487.0 |
| 2008-07-15 09:30:00 | ES | Futures | 1133.02 | 1133.02 | 1125.12 | 1126.28 | 302335.0 |
| 2008-07-15 10:00:00 | ES | Futures | 1126.28 | 1126.98 | 1116.29 | 1121.87 | 429566.0 |
| 2008-07-15 10:30:00 | ES | Futures | 1121.87 | 1128.14 | 1119.31 | 1126.28 | 254931.0 |
| 2008-07-15 11:00:00 | ES | Futures | 1126.28 | 1138.37 | 1126.05 | 1130.47 | 380284.0 |
| 2008-07-15 11:30:00 | ES | Futures | 1130.47 | 1136.98 | 1126.28 | 1136.05 | 243287.0 |
| 2008-07-15 12:00:00 | ES | Futures | 1136.05 | 1139.53 | 1133.02 | 1137.91 | 219512.0 |
| 2008-07-15 12:30:00 | ES | Futures | 1137.67 | 1143.25 | 1137.21 | 1141.39 | 239112.0 |
| 2008-07-15 13:00:00 | ES | Futures | 1141.62 | 1146.74 | 1136.05 | 1137.67 | 216612.0 |
| 2008-07-15 13:30:00 | ES | Futures | 1137.91 | 1142.32 | 1135.35 | 1140.23 | 127714.0 |
| 2008-07-15 14:00:00 | ES | Futures | 1140.46 | 1142.09 | 1135.81 | 1140.46 | 141487.0 |
| 2008-07-15 14:30:00 | ES | Futures | 1140.69 | 1144.88 | 1139.53 | 1143.95 | 143010.0 |
| 2008-07-15 15:00:00 | ES | Futures | 1143.72 | 1148.83 | 1138.84 | 1139.07 | 215246.0 |
| 2008-07-15 15:30:00 | ES | Futures | 1139.07 | 1141.16 | 1129.31 | 1129.77 | 298259.0 |
| 2008-07-15 16:00:00 | ES | Futures | 1129.77 | 1129.77 | 1125.36 | 1125.82 | 125558.0 |
| 2008-07-15 16:30:00 | ES | Futures | 1127.45 | 1129.31 | 1126.52 | 1128.38 | 14495.0 |
| 2008-07-15 17:00:00 | ES | Futures | 1128.14 | 1128.61 | 1126.98 | 1127.21 | 3790.0 |
| 2008-07-15 18:00:00 | ES | Futures | 1126.75 | 1126.98 | 1125.12 | 1126.28 | 3587.0 |
| 2008-07-15 18:30:00 | ES | Futures | 1126.28 | 1127.45 | 1125.82 | 1127.21 | 1187.0 |
| 2008-07-15 19:00:00 | ES | Futures | 1127.21 | 1128.84 | 1127.21 | 1128.61 | 1066.0 |
| 2008-07-15 19:30:00 | ES | Futures | 1128.38 | 1129.31 | 1128.14 | 1129.07 | 1278.0 |
| 2008-07-15 20:00:00 | ES | Futures | 1129.07 | 1130.0 | 1128.84 | 1129.54 | 1918.0 |
| 2008-07-15 20:30:00 | ES | Futures | 1129.31 | 1129.54 | 1128.84 | 1129.54 | 866.0 |
| 2008-07-15 21:00:00 | ES | Futures | 1129.54 | 1129.54 | 1128.38 | 1129.07 | 801.0 |
| 2008-07-15 21:30:00 | ES | Futures | 1128.84 | 1130.0 | 1127.45 | 1128.38 | 3076.0 |
| 2008-07-15 22:00:00 | ES | Futures | 1127.91 | 1129.07 | 1127.91 | 1129.07 | 2374.0 |
| 2008-07-15 22:30:00 | ES | Futures | 1128.84 | 1129.77 | 1128.61 | 1128.84 | 3791.0 |
| 2008-07-15 23:00:00 | ES | Futures | 1128.84 | 1130.0 | 1128.61 | 1129.54 | 2007.0 |
| 2008-07-15 23:30:00 | ES | Futures | 1129.54 | 1130.24 | 1129.54 | 1130.24 | 4643.0 |
| 2008-07-15 00:00:00 | NQ | Futures | 2020.22 | 2021.06 | 2019.09 | 2020.22 | 82.0 |
| 2008-07-15 00:30:00 | NQ | Futures | 2019.09 | 2019.09 | 2017.4 | 2018.53 | 66.0 |
| 2008-07-15 01:00:00 | NQ | Futures | 2019.09 | 2019.09 | 2016.28 | 2016.84 | 188.0 |
> showing 50 of 2,273 rows — these rows as CSV