PREVIEW / futures_30min / 2010-08-31
file: by_date/futures_30min/2010/2010-08-31.parquet size: 70 KB rows: 2,478
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-08-31 00:00:00 | ES | Futures | 1025.44 | 1025.44 | 1023.97 | 1024.21 | 2923.0 |
| 2010-08-31 00:30:00 | ES | Futures | 1024.46 | 1025.2 | 1023.97 | 1024.95 | 1581.0 |
| 2010-08-31 01:00:00 | ES | Futures | 1024.7 | 1025.69 | 1024.46 | 1024.95 | 1818.0 |
| 2010-08-31 01:30:00 | ES | Futures | 1024.95 | 1025.2 | 1022.74 | 1023.48 | 6672.0 |
| 2010-08-31 02:00:00 | ES | Futures | 1023.48 | 1023.72 | 1019.55 | 1020.53 | 18239.0 |
| 2010-08-31 02:30:00 | ES | Futures | 1020.53 | 1021.27 | 1018.32 | 1020.29 | 14297.0 |
| 2010-08-31 03:00:00 | ES | Futures | 1020.04 | 1022.74 | 1019.31 | 1020.78 | 24169.0 |
| 2010-08-31 03:30:00 | ES | Futures | 1020.78 | 1021.51 | 1019.55 | 1021.27 | 16143.0 |
| 2010-08-31 04:00:00 | ES | Futures | 1021.27 | 1022.99 | 1020.53 | 1022.74 | 10902.0 |
| 2010-08-31 04:30:00 | ES | Futures | 1022.74 | 1023.97 | 1022.25 | 1022.74 | 8181.0 |
| 2010-08-31 05:00:00 | ES | Futures | 1022.5 | 1023.23 | 1021.02 | 1022.74 | 10919.0 |
| 2010-08-31 05:30:00 | ES | Futures | 1022.74 | 1023.97 | 1022.25 | 1023.72 | 8193.0 |
| 2010-08-31 06:00:00 | ES | Futures | 1023.72 | 1024.21 | 1022.74 | 1023.23 | 4765.0 |
| 2010-08-31 06:30:00 | ES | Futures | 1023.23 | 1023.48 | 1021.51 | 1021.76 | 5660.0 |
| 2010-08-31 07:00:00 | ES | Futures | 1021.76 | 1022.25 | 1019.8 | 1020.29 | 10510.0 |
| 2010-08-31 07:30:00 | ES | Futures | 1020.53 | 1022.99 | 1020.04 | 1022.5 | 11483.0 |
| 2010-08-31 08:00:00 | ES | Futures | 1022.74 | 1022.74 | 1020.53 | 1021.51 | 16691.0 |
| 2010-08-31 08:30:00 | ES | Futures | 1021.27 | 1021.76 | 1019.8 | 1021.51 | 27964.0 |
| 2010-08-31 09:00:00 | ES | Futures | 1021.27 | 1025.93 | 1021.27 | 1024.21 | 64984.0 |
| 2010-08-31 09:30:00 | ES | Futures | 1024.21 | 1028.14 | 1020.04 | 1026.91 | 308793.0 |
| 2010-08-31 10:00:00 | ES | Futures | 1026.91 | 1033.29 | 1026.91 | 1031.82 | 249683.0 |
| 2010-08-31 10:30:00 | ES | Futures | 1031.58 | 1032.8 | 1027.4 | 1031.82 | 185042.0 |
| 2010-08-31 11:00:00 | ES | Futures | 1031.82 | 1033.05 | 1028.39 | 1031.33 | 160996.0 |
| 2010-08-31 11:30:00 | ES | Futures | 1031.33 | 1034.77 | 1030.59 | 1032.8 | 118295.0 |
| 2010-08-31 12:00:00 | ES | Futures | 1033.05 | 1034.03 | 1030.59 | 1031.33 | 51949.0 |
| 2010-08-31 12:30:00 | ES | Futures | 1031.33 | 1032.31 | 1028.88 | 1028.88 | 53409.0 |
| 2010-08-31 13:00:00 | ES | Futures | 1028.88 | 1032.31 | 1028.63 | 1031.82 | 39956.0 |
| 2010-08-31 13:30:00 | ES | Futures | 1031.82 | 1033.05 | 1030.84 | 1031.58 | 38932.0 |
| 2010-08-31 14:00:00 | ES | Futures | 1031.33 | 1033.54 | 1027.16 | 1028.39 | 148413.0 |
| 2010-08-31 14:30:00 | ES | Futures | 1028.63 | 1028.63 | 1023.23 | 1024.7 | 154477.0 |
| 2010-08-31 15:00:00 | ES | Futures | 1024.7 | 1026.91 | 1023.72 | 1025.69 | 124048.0 |
| 2010-08-31 15:30:00 | ES | Futures | 1025.44 | 1031.08 | 1023.97 | 1029.12 | 389219.0 |
| 2010-08-31 16:00:00 | ES | Futures | 1028.88 | 1033.54 | 1028.88 | 1033.05 | 180697.0 |
| 2010-08-31 16:30:00 | ES | Futures | 1032.31 | 1033.54 | 1031.82 | 1033.29 | 8758.0 |
| 2010-08-31 17:00:00 | ES | Futures | 1033.54 | 1033.78 | 1032.56 | 1033.05 | 2272.0 |
| 2010-08-31 17:30:00 | ES | Futures | 1032.8 | 1032.8 | 1032.8 | 1032.8 | 1.0 |
| 2010-08-31 18:00:00 | ES | Futures | 1032.56 | 1033.05 | 1032.31 | 1032.8 | 1223.0 |
| 2010-08-31 18:30:00 | ES | Futures | 1032.8 | 1033.54 | 1032.56 | 1033.54 | 1464.0 |
| 2010-08-31 19:00:00 | ES | Futures | 1033.54 | 1033.54 | 1032.31 | 1032.56 | 802.0 |
| 2010-08-31 19:30:00 | ES | Futures | 1032.56 | 1032.8 | 1031.82 | 1032.56 | 2008.0 |
| 2010-08-31 20:00:00 | ES | Futures | 1032.56 | 1033.29 | 1031.33 | 1031.82 | 3318.0 |
| 2010-08-31 20:30:00 | ES | Futures | 1031.82 | 1033.54 | 1031.58 | 1032.8 | 2782.0 |
| 2010-08-31 21:00:00 | ES | Futures | 1032.8 | 1037.96 | 1032.8 | 1036.48 | 12559.0 |
| 2010-08-31 21:30:00 | ES | Futures | 1036.48 | 1037.71 | 1035.99 | 1036.24 | 5719.0 |
| 2010-08-31 22:00:00 | ES | Futures | 1035.99 | 1037.22 | 1035.99 | 1037.22 | 1959.0 |
| 2010-08-31 22:30:00 | ES | Futures | 1036.97 | 1039.18 | 1036.97 | 1038.2 | 6027.0 |
| 2010-08-31 23:00:00 | ES | Futures | 1037.96 | 1038.2 | 1036.97 | 1037.46 | 3680.0 |
| 2010-08-31 23:30:00 | ES | Futures | 1037.46 | 1038.94 | 1037.22 | 1037.96 | 3023.0 |
| 2010-08-31 00:00:00 | NQ | Futures | 2026.88 | 2026.88 | 2024.59 | 2024.88 | 208.0 |
| 2010-08-31 00:30:00 | NQ | Futures | 2025.45 | 2027.45 | 2025.45 | 2026.88 | 66.0 |
> showing 50 of 2,478 rows — these rows as CSV