PREVIEW / futures_30min / 2010-06-10
file: by_date/futures_30min/2010/2010-06-10.parquet size: 70 KB rows: 2,421
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-06-10 00:00:00 | ES | Futures | 1034.9 | 1038.81 | 1034.41 | 1038.08 | 11020.0 |
| 2010-06-10 00:30:00 | ES | Futures | 1037.83 | 1038.32 | 1036.37 | 1038.08 | 3169.0 |
| 2010-06-10 01:00:00 | ES | Futures | 1038.08 | 1038.32 | 1035.63 | 1036.37 | 1907.0 |
| 2010-06-10 01:30:00 | ES | Futures | 1036.37 | 1038.81 | 1036.37 | 1038.57 | 3724.0 |
| 2010-06-10 02:00:00 | ES | Futures | 1038.32 | 1038.81 | 1037.35 | 1038.08 | 6802.0 |
| 2010-06-10 02:30:00 | ES | Futures | 1038.32 | 1038.81 | 1037.35 | 1038.32 | 7172.0 |
| 2010-06-10 03:00:00 | ES | Futures | 1038.57 | 1040.77 | 1036.37 | 1037.1 | 24837.0 |
| 2010-06-10 03:30:00 | ES | Futures | 1037.35 | 1040.77 | 1036.86 | 1037.35 | 20634.0 |
| 2010-06-10 04:00:00 | ES | Futures | 1037.1 | 1040.28 | 1036.37 | 1039.54 | 17034.0 |
| 2010-06-10 04:30:00 | ES | Futures | 1039.54 | 1044.92 | 1039.3 | 1042.72 | 33397.0 |
| 2010-06-10 05:00:00 | ES | Futures | 1042.97 | 1045.66 | 1041.99 | 1045.17 | 23521.0 |
| 2010-06-10 05:30:00 | ES | Futures | 1045.41 | 1045.41 | 1043.46 | 1043.7 | 10904.0 |
| 2010-06-10 06:00:00 | ES | Futures | 1043.7 | 1043.94 | 1041.74 | 1043.21 | 11245.0 |
| 2010-06-10 06:30:00 | ES | Futures | 1042.97 | 1043.94 | 1042.48 | 1043.46 | 9981.0 |
| 2010-06-10 07:00:00 | ES | Futures | 1043.7 | 1044.43 | 1041.74 | 1041.74 | 16440.0 |
| 2010-06-10 07:30:00 | ES | Futures | 1041.99 | 1042.97 | 1040.77 | 1041.01 | 20691.0 |
| 2010-06-10 08:00:00 | ES | Futures | 1040.77 | 1043.21 | 1040.28 | 1042.48 | 25043.0 |
| 2010-06-10 08:30:00 | ES | Futures | 1042.23 | 1044.19 | 1038.81 | 1042.97 | 64576.0 |
| 2010-06-10 09:00:00 | ES | Futures | 1042.97 | 1050.06 | 1041.99 | 1049.32 | 106812.0 |
| 2010-06-10 09:30:00 | ES | Futures | 1049.32 | 1056.9 | 1048.1 | 1056.65 | 257896.0 |
| 2010-06-10 10:00:00 | ES | Futures | 1056.65 | 1059.1 | 1050.79 | 1052.74 | 181398.0 |
| 2010-06-10 10:30:00 | ES | Futures | 1052.74 | 1054.94 | 1052.5 | 1053.72 | 73348.0 |
| 2010-06-10 11:00:00 | ES | Futures | 1053.72 | 1056.9 | 1053.48 | 1055.43 | 73136.0 |
| 2010-06-10 11:30:00 | ES | Futures | 1055.43 | 1055.92 | 1051.52 | 1053.48 | 83751.0 |
| 2010-06-10 12:00:00 | ES | Futures | 1053.72 | 1054.21 | 1048.83 | 1052.74 | 97563.0 |
| 2010-06-10 12:30:00 | ES | Futures | 1052.74 | 1054.21 | 1047.86 | 1051.03 | 72967.0 |
| 2010-06-10 13:00:00 | ES | Futures | 1051.28 | 1052.99 | 1048.34 | 1052.26 | 53845.0 |
| 2010-06-10 13:30:00 | ES | Futures | 1052.01 | 1055.68 | 1052.01 | 1053.97 | 50709.0 |
| 2010-06-10 14:00:00 | ES | Futures | 1054.21 | 1055.43 | 1051.03 | 1054.7 | 44425.0 |
| 2010-06-10 14:30:00 | ES | Futures | 1054.7 | 1059.59 | 1054.45 | 1057.39 | 65593.0 |
| 2010-06-10 15:00:00 | ES | Futures | 1057.63 | 1062.52 | 1056.41 | 1060.32 | 86409.0 |
| 2010-06-10 15:30:00 | ES | Futures | 1060.32 | 1063.5 | 1058.37 | 1062.52 | 126378.0 |
| 2010-06-10 16:00:00 | ES | Futures | 1062.52 | 1062.77 | 1059.34 | 1059.83 | 76805.0 |
| 2010-06-10 16:30:00 | ES | Futures | 1059.83 | 1061.54 | 1058.85 | 1060.81 | 4449.0 |
| 2010-06-10 17:00:00 | ES | Futures | 1061.05 | 1061.3 | 1060.57 | 1061.3 | 731.0 |
| 2010-06-10 18:00:00 | ES | Futures | 1061.3 | 1061.54 | 1060.57 | 1060.81 | 1076.0 |
| 2010-06-10 18:30:00 | ES | Futures | 1060.81 | 1060.81 | 1059.83 | 1060.08 | 698.0 |
| 2010-06-10 19:00:00 | ES | Futures | 1060.57 | 1060.81 | 1060.08 | 1060.57 | 563.0 |
| 2010-06-10 19:30:00 | ES | Futures | 1060.32 | 1060.81 | 1059.59 | 1060.32 | 1121.0 |
| 2010-06-10 20:00:00 | ES | Futures | 1060.57 | 1060.57 | 1057.88 | 1058.12 | 2460.0 |
| 2010-06-10 20:30:00 | ES | Futures | 1058.12 | 1059.34 | 1057.88 | 1058.85 | 2083.0 |
| 2010-06-10 21:00:00 | ES | Futures | 1058.85 | 1059.34 | 1058.37 | 1058.85 | 741.0 |
| 2010-06-10 21:30:00 | ES | Futures | 1059.1 | 1060.32 | 1058.37 | 1058.61 | 1338.0 |
| 2010-06-10 22:00:00 | ES | Futures | 1058.61 | 1058.61 | 1057.63 | 1057.88 | 1092.0 |
| 2010-06-10 22:30:00 | ES | Futures | 1057.88 | 1058.61 | 1057.39 | 1057.39 | 967.0 |
| 2010-06-10 23:00:00 | ES | Futures | 1057.39 | 1057.88 | 1057.39 | 1057.39 | 419.0 |
| 2010-06-10 23:30:00 | ES | Futures | 1057.39 | 1059.1 | 1057.39 | 1058.37 | 956.0 |
| 2010-06-10 00:00:00 | NQ | Futures | 2046.42 | 2051.86 | 2045.85 | 2051.86 | 466.0 |
| 2010-06-10 00:30:00 | NQ | Futures | 2050.71 | 2052.15 | 2048.42 | 2052.15 | 200.0 |
| 2010-06-10 01:00:00 | NQ | Futures | 2052.15 | 2052.15 | 2046.42 | 2048.71 | 92.0 |
> showing 50 of 2,421 rows — these rows as CSV