PREVIEW / futures_30min / 2010-08-30
file: by_date/futures_30min/2010/2010-08-30.parquet size: 66 KB rows: 2,305
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-30 00:00:00 | ES | Futures | 1048.51 | 1050.22 | 1048.02 | 1049.24 | 2659.0 |
| 2010-08-30 00:30:00 | ES | Futures | 1049.49 | 1050.22 | 1048.51 | 1048.75 | 1447.0 |
| 2010-08-30 01:00:00 | ES | Futures | 1048.75 | 1049.0 | 1047.53 | 1049.0 | 2397.0 |
| 2010-08-30 01:30:00 | ES | Futures | 1048.75 | 1049.24 | 1048.26 | 1048.75 | 2042.0 |
| 2010-08-30 02:00:00 | ES | Futures | 1048.75 | 1049.0 | 1047.53 | 1048.26 | 5806.0 |
| 2010-08-30 02:30:00 | ES | Futures | 1048.26 | 1048.75 | 1047.28 | 1047.53 | 4715.0 |
| 2010-08-30 03:00:00 | ES | Futures | 1047.53 | 1047.77 | 1045.56 | 1045.81 | 11095.0 |
| 2010-08-30 03:30:00 | ES | Futures | 1045.56 | 1047.03 | 1045.32 | 1046.79 | 7846.0 |
| 2010-08-30 04:00:00 | ES | Futures | 1047.03 | 1047.53 | 1046.05 | 1046.05 | 7180.0 |
| 2010-08-30 04:30:00 | ES | Futures | 1046.05 | 1046.79 | 1045.56 | 1046.3 | 5691.0 |
| 2010-08-30 05:00:00 | ES | Futures | 1046.05 | 1047.03 | 1045.56 | 1046.05 | 4581.0 |
| 2010-08-30 05:30:00 | ES | Futures | 1046.05 | 1046.3 | 1045.32 | 1046.05 | 3467.0 |
| 2010-08-30 06:00:00 | ES | Futures | 1045.81 | 1045.81 | 1044.34 | 1045.32 | 7112.0 |
| 2010-08-30 06:30:00 | ES | Futures | 1045.32 | 1045.56 | 1043.11 | 1043.35 | 13617.0 |
| 2010-08-30 07:00:00 | ES | Futures | 1043.6 | 1044.58 | 1042.13 | 1043.6 | 15050.0 |
| 2010-08-30 07:30:00 | ES | Futures | 1043.6 | 1044.83 | 1042.86 | 1043.35 | 11584.0 |
| 2010-08-30 08:00:00 | ES | Futures | 1043.35 | 1043.6 | 1042.13 | 1042.62 | 10480.0 |
| 2010-08-30 08:30:00 | ES | Futures | 1042.62 | 1044.58 | 1040.41 | 1041.39 | 37459.0 |
| 2010-08-30 09:00:00 | ES | Futures | 1041.39 | 1042.62 | 1040.41 | 1040.9 | 23193.0 |
| 2010-08-30 09:30:00 | ES | Futures | 1040.65 | 1043.84 | 1039.67 | 1043.6 | 148866.0 |
| 2010-08-30 10:00:00 | ES | Futures | 1043.35 | 1043.84 | 1038.2 | 1039.43 | 128013.0 |
| 2010-08-30 10:30:00 | ES | Futures | 1039.43 | 1041.88 | 1037.71 | 1040.9 | 95042.0 |
| 2010-08-30 11:00:00 | ES | Futures | 1040.9 | 1041.39 | 1037.96 | 1039.43 | 84822.0 |
| 2010-08-30 11:30:00 | ES | Futures | 1039.18 | 1039.43 | 1035.26 | 1036.48 | 96786.0 |
| 2010-08-30 12:00:00 | ES | Futures | 1036.73 | 1037.22 | 1035.75 | 1036.48 | 33435.0 |
| 2010-08-30 12:30:00 | ES | Futures | 1036.73 | 1039.43 | 1036.24 | 1037.71 | 55335.0 |
| 2010-08-30 13:00:00 | ES | Futures | 1037.71 | 1038.69 | 1034.52 | 1035.01 | 63822.0 |
| 2010-08-30 13:30:00 | ES | Futures | 1035.01 | 1036.24 | 1034.27 | 1035.01 | 48995.0 |
| 2010-08-30 14:00:00 | ES | Futures | 1035.01 | 1035.99 | 1032.56 | 1035.26 | 79456.0 |
| 2010-08-30 14:30:00 | ES | Futures | 1035.26 | 1036.73 | 1034.03 | 1034.77 | 49809.0 |
| 2010-08-30 15:00:00 | ES | Futures | 1034.77 | 1035.5 | 1031.33 | 1032.07 | 72041.0 |
| 2010-08-30 15:30:00 | ES | Futures | 1031.82 | 1033.05 | 1027.89 | 1028.39 | 171154.0 |
| 2010-08-30 16:00:00 | ES | Futures | 1028.39 | 1028.63 | 1025.2 | 1025.44 | 118064.0 |
| 2010-08-30 16:30:00 | ES | Futures | 1025.69 | 1026.91 | 1025.2 | 1026.67 | 6419.0 |
| 2010-08-30 17:00:00 | ES | Futures | 1026.67 | 1026.67 | 1025.44 | 1025.93 | 2073.0 |
| 2010-08-30 18:00:00 | ES | Futures | 1025.93 | 1026.91 | 1025.69 | 1026.42 | 1884.0 |
| 2010-08-30 18:30:00 | ES | Futures | 1026.42 | 1026.67 | 1026.18 | 1026.42 | 550.0 |
| 2010-08-30 19:00:00 | ES | Futures | 1026.67 | 1027.4 | 1026.42 | 1027.4 | 1709.0 |
| 2010-08-30 19:30:00 | ES | Futures | 1027.16 | 1028.39 | 1026.91 | 1027.4 | 3768.0 |
| 2010-08-30 20:00:00 | ES | Futures | 1027.4 | 1027.65 | 1024.7 | 1025.44 | 6161.0 |
| 2010-08-30 20:30:00 | ES | Futures | 1025.44 | 1026.18 | 1024.7 | 1025.93 | 3138.0 |
| 2010-08-30 21:00:00 | ES | Futures | 1025.93 | 1026.42 | 1025.69 | 1025.93 | 2222.0 |
| 2010-08-30 21:30:00 | ES | Futures | 1026.18 | 1027.16 | 1025.2 | 1025.44 | 3565.0 |
| 2010-08-30 22:00:00 | ES | Futures | 1025.44 | 1026.18 | 1025.2 | 1025.44 | 2447.0 |
| 2010-08-30 22:30:00 | ES | Futures | 1025.69 | 1026.67 | 1025.44 | 1026.42 | 1484.0 |
| 2010-08-30 23:00:00 | ES | Futures | 1026.67 | 1026.67 | 1025.44 | 1025.44 | 779.0 |
| 2010-08-30 23:30:00 | ES | Futures | 1025.44 | 1026.18 | 1025.2 | 1025.2 | 2346.0 |
| 2010-08-30 00:00:00 | NQ | Futures | 2060.98 | 2062.99 | 2060.12 | 2061.84 | 195.0 |
| 2010-08-30 00:30:00 | NQ | Futures | 2061.84 | 2062.99 | 2060.7 | 2061.56 | 93.0 |
| 2010-08-30 01:00:00 | NQ | Futures | 2060.41 | 2060.98 | 2058.98 | 2060.41 | 134.0 |
> showing 50 of 2,305 rows — these rows as CSV