PREVIEW / futures_30min / 2009-11-30
file: by_date/futures_30min/2009/2009-11-30.parquet size: 70 KB rows: 2,498
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-11-30 00:00:00 | ES | Futures | 1062.63 | 1063.35 | 1058.51 | 1059.72 | 8257.0 |
| 2009-11-30 00:30:00 | ES | Futures | 1059.72 | 1060.93 | 1058.99 | 1059.96 | 3811.0 |
| 2009-11-30 01:00:00 | ES | Futures | 1059.72 | 1060.2 | 1058.99 | 1059.24 | 2261.0 |
| 2009-11-30 01:30:00 | ES | Futures | 1058.99 | 1060.69 | 1058.99 | 1060.2 | 3160.0 |
| 2009-11-30 02:00:00 | ES | Futures | 1059.96 | 1063.11 | 1059.72 | 1062.38 | 7178.0 |
| 2009-11-30 02:30:00 | ES | Futures | 1062.38 | 1062.63 | 1061.17 | 1061.9 | 3621.0 |
| 2009-11-30 03:00:00 | ES | Futures | 1061.9 | 1062.14 | 1056.57 | 1057.3 | 23238.0 |
| 2009-11-30 03:30:00 | ES | Futures | 1057.3 | 1058.75 | 1054.39 | 1057.3 | 22033.0 |
| 2009-11-30 04:00:00 | ES | Futures | 1057.3 | 1058.51 | 1056.09 | 1057.06 | 14014.0 |
| 2009-11-30 04:30:00 | ES | Futures | 1057.3 | 1057.3 | 1052.94 | 1053.66 | 18391.0 |
| 2009-11-30 05:00:00 | ES | Futures | 1053.91 | 1055.12 | 1052.45 | 1053.66 | 15458.0 |
| 2009-11-30 05:30:00 | ES | Futures | 1053.66 | 1056.57 | 1052.94 | 1055.12 | 11415.0 |
| 2009-11-30 06:00:00 | ES | Futures | 1054.88 | 1056.57 | 1050.76 | 1053.42 | 24653.0 |
| 2009-11-30 06:30:00 | ES | Futures | 1053.42 | 1055.12 | 1052.21 | 1053.91 | 11439.0 |
| 2009-11-30 07:00:00 | ES | Futures | 1053.91 | 1055.12 | 1052.45 | 1052.7 | 13817.0 |
| 2009-11-30 07:30:00 | ES | Futures | 1052.45 | 1056.09 | 1052.21 | 1056.09 | 24593.0 |
| 2009-11-30 08:00:00 | ES | Futures | 1055.84 | 1058.75 | 1054.63 | 1058.27 | 23521.0 |
| 2009-11-30 08:30:00 | ES | Futures | 1058.27 | 1059.24 | 1056.33 | 1056.81 | 21160.0 |
| 2009-11-30 09:00:00 | ES | Futures | 1056.57 | 1057.06 | 1054.88 | 1055.84 | 28062.0 |
| 2009-11-30 09:30:00 | ES | Futures | 1056.09 | 1058.99 | 1052.94 | 1057.3 | 267525.0 |
| 2009-11-30 10:00:00 | ES | Futures | 1057.06 | 1061.42 | 1057.06 | 1060.93 | 129977.0 |
| 2009-11-30 10:30:00 | ES | Futures | 1061.17 | 1062.38 | 1057.54 | 1058.27 | 117464.0 |
| 2009-11-30 11:00:00 | ES | Futures | 1058.51 | 1058.51 | 1053.18 | 1053.91 | 128766.0 |
| 2009-11-30 11:30:00 | ES | Futures | 1053.66 | 1054.15 | 1051.24 | 1052.7 | 119059.0 |
| 2009-11-30 12:00:00 | ES | Futures | 1052.45 | 1055.36 | 1052.21 | 1054.63 | 70232.0 |
| 2009-11-30 12:30:00 | ES | Futures | 1054.63 | 1054.88 | 1051.97 | 1052.45 | 73560.0 |
| 2009-11-30 13:00:00 | ES | Futures | 1052.45 | 1054.88 | 1052.21 | 1054.88 | 43843.0 |
| 2009-11-30 13:30:00 | ES | Futures | 1054.88 | 1056.81 | 1053.18 | 1055.84 | 91590.0 |
| 2009-11-30 14:00:00 | ES | Futures | 1055.84 | 1056.33 | 1054.63 | 1055.6 | 53600.0 |
| 2009-11-30 14:30:00 | ES | Futures | 1055.6 | 1056.09 | 1053.91 | 1054.63 | 50287.0 |
| 2009-11-30 15:00:00 | ES | Futures | 1054.63 | 1059.24 | 1054.39 | 1058.75 | 110022.0 |
| 2009-11-30 15:30:00 | ES | Futures | 1058.75 | 1062.38 | 1058.51 | 1060.69 | 262236.0 |
| 2009-11-30 16:00:00 | ES | Futures | 1060.69 | 1061.17 | 1058.02 | 1058.99 | 149629.0 |
| 2009-11-30 16:30:00 | ES | Futures | 1058.75 | 1059.72 | 1058.51 | 1059.72 | 3831.0 |
| 2009-11-30 17:00:00 | ES | Futures | 1059.48 | 1059.72 | 1058.27 | 1058.75 | 2349.0 |
| 2009-11-30 18:00:00 | ES | Futures | 1058.99 | 1058.99 | 1058.51 | 1058.51 | 1829.0 |
| 2009-11-30 18:30:00 | ES | Futures | 1058.51 | 1059.72 | 1058.51 | 1058.75 | 4074.0 |
| 2009-11-30 19:00:00 | ES | Futures | 1058.99 | 1060.45 | 1058.51 | 1060.2 | 5886.0 |
| 2009-11-30 19:30:00 | ES | Futures | 1060.45 | 1061.42 | 1059.24 | 1059.24 | 5761.0 |
| 2009-11-30 20:00:00 | ES | Futures | 1059.48 | 1060.93 | 1059.24 | 1060.2 | 2759.0 |
| 2009-11-30 20:30:00 | ES | Futures | 1060.45 | 1060.69 | 1059.48 | 1059.96 | 2407.0 |
| 2009-11-30 21:00:00 | ES | Futures | 1059.96 | 1062.14 | 1059.96 | 1061.42 | 4619.0 |
| 2009-11-30 21:30:00 | ES | Futures | 1061.42 | 1062.14 | 1060.69 | 1060.69 | 2101.0 |
| 2009-11-30 22:00:00 | ES | Futures | 1060.93 | 1062.14 | 1060.45 | 1061.9 | 1939.0 |
| 2009-11-30 22:30:00 | ES | Futures | 1062.14 | 1062.14 | 1061.17 | 1061.42 | 3217.0 |
| 2009-11-30 23:00:00 | ES | Futures | 1061.66 | 1062.38 | 1061.66 | 1062.38 | 4604.0 |
| 2009-11-30 23:30:00 | ES | Futures | 1062.38 | 1062.38 | 1061.42 | 1061.66 | 1971.0 |
| 2009-11-30 00:00:00 | NQ | Futures | 2023.17 | 2024.31 | 2014.9 | 2017.46 | 572.0 |
| 2009-11-30 00:30:00 | NQ | Futures | 2017.18 | 2018.89 | 2015.75 | 2017.18 | 234.0 |
| 2009-11-30 01:00:00 | NQ | Futures | 2016.61 | 2018.32 | 2015.75 | 2015.75 | 144.0 |
> showing 50 of 2,498 rows — these rows as CSV