PREVIEW / futures_30min / 2010-08-24
file: by_date/futures_30min/2010/2010-08-24.parquet size: 71 KB rows: 2,507
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-24 00:00:00 | ES | Futures | 1044.09 | 1044.83 | 1041.88 | 1041.88 | 3009.0 |
| 2010-08-24 00:30:00 | ES | Futures | 1042.13 | 1042.37 | 1041.64 | 1042.13 | 1911.0 |
| 2010-08-24 01:00:00 | ES | Futures | 1042.37 | 1043.35 | 1042.13 | 1042.86 | 1946.0 |
| 2010-08-24 01:30:00 | ES | Futures | 1042.86 | 1043.6 | 1041.88 | 1043.35 | 1435.0 |
| 2010-08-24 02:00:00 | ES | Futures | 1043.35 | 1043.6 | 1041.88 | 1043.35 | 5221.0 |
| 2010-08-24 02:30:00 | ES | Futures | 1043.11 | 1043.11 | 1040.65 | 1041.15 | 10812.0 |
| 2010-08-24 03:00:00 | ES | Futures | 1041.15 | 1042.13 | 1038.45 | 1038.69 | 27988.0 |
| 2010-08-24 03:30:00 | ES | Futures | 1038.45 | 1039.18 | 1036.48 | 1036.97 | 28273.0 |
| 2010-08-24 04:00:00 | ES | Futures | 1036.73 | 1037.96 | 1035.5 | 1036.97 | 21290.0 |
| 2010-08-24 04:30:00 | ES | Futures | 1036.97 | 1038.45 | 1036.24 | 1037.71 | 11705.0 |
| 2010-08-24 05:00:00 | ES | Futures | 1037.71 | 1038.45 | 1036.97 | 1038.2 | 8278.0 |
| 2010-08-24 05:30:00 | ES | Futures | 1038.2 | 1038.45 | 1036.48 | 1036.97 | 9394.0 |
| 2010-08-24 06:00:00 | ES | Futures | 1036.73 | 1039.18 | 1036.73 | 1037.71 | 11038.0 |
| 2010-08-24 06:30:00 | ES | Futures | 1037.96 | 1038.94 | 1037.22 | 1037.96 | 5985.0 |
| 2010-08-24 07:00:00 | ES | Futures | 1037.96 | 1039.43 | 1037.71 | 1038.2 | 7092.0 |
| 2010-08-24 07:30:00 | ES | Futures | 1038.2 | 1038.45 | 1034.52 | 1034.77 | 24535.0 |
| 2010-08-24 08:00:00 | ES | Futures | 1034.77 | 1035.99 | 1032.31 | 1032.56 | 56050.0 |
| 2010-08-24 08:30:00 | ES | Futures | 1032.31 | 1034.77 | 1032.07 | 1033.05 | 36292.0 |
| 2010-08-24 09:00:00 | ES | Futures | 1032.8 | 1034.52 | 1031.08 | 1034.52 | 50804.0 |
| 2010-08-24 09:30:00 | ES | Futures | 1034.27 | 1035.5 | 1029.37 | 1032.07 | 248666.0 |
| 2010-08-24 10:00:00 | ES | Futures | 1032.07 | 1034.27 | 1024.7 | 1031.82 | 381100.0 |
| 2010-08-24 10:30:00 | ES | Futures | 1031.58 | 1034.03 | 1029.37 | 1033.78 | 161770.0 |
| 2010-08-24 11:00:00 | ES | Futures | 1033.78 | 1036.97 | 1032.31 | 1035.5 | 173908.0 |
| 2010-08-24 11:30:00 | ES | Futures | 1035.5 | 1038.69 | 1034.27 | 1035.75 | 136403.0 |
| 2010-08-24 12:00:00 | ES | Futures | 1035.75 | 1037.96 | 1033.05 | 1033.78 | 86677.0 |
| 2010-08-24 12:30:00 | ES | Futures | 1033.78 | 1035.26 | 1033.05 | 1033.78 | 54351.0 |
| 2010-08-24 13:00:00 | ES | Futures | 1033.78 | 1036.73 | 1032.31 | 1036.48 | 71059.0 |
| 2010-08-24 13:30:00 | ES | Futures | 1036.48 | 1036.73 | 1030.35 | 1031.08 | 105464.0 |
| 2010-08-24 14:00:00 | ES | Futures | 1031.33 | 1034.27 | 1030.35 | 1032.07 | 111016.0 |
| 2010-08-24 14:30:00 | ES | Futures | 1032.31 | 1035.01 | 1031.08 | 1034.27 | 92818.0 |
| 2010-08-24 15:00:00 | ES | Futures | 1034.52 | 1037.71 | 1033.54 | 1035.99 | 113600.0 |
| 2010-08-24 15:30:00 | ES | Futures | 1035.99 | 1036.48 | 1029.61 | 1030.84 | 261928.0 |
| 2010-08-24 16:00:00 | ES | Futures | 1030.84 | 1031.08 | 1030.1 | 1030.35 | 96009.0 |
| 2010-08-24 16:30:00 | ES | Futures | 1030.59 | 1030.84 | 1028.63 | 1028.63 | 8168.0 |
| 2010-08-24 17:00:00 | ES | Futures | 1028.88 | 1029.61 | 1027.89 | 1029.12 | 2470.0 |
| 2010-08-24 18:00:00 | ES | Futures | 1029.12 | 1030.59 | 1028.88 | 1029.86 | 1663.0 |
| 2010-08-24 18:30:00 | ES | Futures | 1030.1 | 1030.1 | 1029.61 | 1029.86 | 566.0 |
| 2010-08-24 19:00:00 | ES | Futures | 1029.86 | 1030.1 | 1028.88 | 1029.37 | 824.0 |
| 2010-08-24 19:30:00 | ES | Futures | 1029.61 | 1032.8 | 1029.12 | 1032.56 | 4901.0 |
| 2010-08-24 20:00:00 | ES | Futures | 1032.56 | 1034.03 | 1032.07 | 1033.05 | 5649.0 |
| 2010-08-24 20:30:00 | ES | Futures | 1033.05 | 1033.78 | 1032.8 | 1033.54 | 2967.0 |
| 2010-08-24 21:00:00 | ES | Futures | 1033.78 | 1034.77 | 1033.54 | 1034.52 | 4797.0 |
| 2010-08-24 21:30:00 | ES | Futures | 1034.77 | 1034.77 | 1033.29 | 1033.29 | 1705.0 |
| 2010-08-24 22:00:00 | ES | Futures | 1033.54 | 1034.52 | 1032.8 | 1033.05 | 1530.0 |
| 2010-08-24 22:30:00 | ES | Futures | 1033.29 | 1033.54 | 1032.31 | 1033.29 | 2503.0 |
| 2010-08-24 23:00:00 | ES | Futures | 1033.54 | 1034.52 | 1033.05 | 1033.78 | 1142.0 |
| 2010-08-24 23:30:00 | ES | Futures | 1034.03 | 1034.52 | 1032.8 | 1033.54 | 1440.0 |
| 2010-08-24 00:00:00 | NQ | Futures | 2071.3 | 2072.45 | 2066.43 | 2066.43 | 382.0 |
| 2010-08-24 00:30:00 | NQ | Futures | 2066.43 | 2067.0 | 2064.42 | 2065.85 | 480.0 |
| 2010-08-24 01:00:00 | NQ | Futures | 2066.14 | 2068.15 | 2066.14 | 2067.29 | 116.0 |
> showing 50 of 2,507 rows — these rows as CSV