PREVIEW / futures_30min / 2010-05-26
file: by_date/futures_30min/2010/2010-05-26.parquet size: 73 KB rows: 2,574
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-05-26 00:00:00 | ES | Futures | 1053.97 | 1055.43 | 1053.97 | 1054.7 | 3680.0 |
| 2010-05-26 00:30:00 | ES | Futures | 1054.7 | 1055.19 | 1052.74 | 1054.7 | 2750.0 |
| 2010-05-26 01:00:00 | ES | Futures | 1054.45 | 1054.7 | 1051.03 | 1051.77 | 3527.0 |
| 2010-05-26 01:30:00 | ES | Futures | 1051.77 | 1052.5 | 1048.59 | 1048.83 | 3965.0 |
| 2010-05-26 02:00:00 | ES | Futures | 1048.59 | 1050.54 | 1047.37 | 1049.32 | 9529.0 |
| 2010-05-26 02:30:00 | ES | Futures | 1049.08 | 1052.01 | 1048.34 | 1050.54 | 8384.0 |
| 2010-05-26 03:00:00 | ES | Futures | 1050.54 | 1050.54 | 1046.63 | 1047.37 | 32618.0 |
| 2010-05-26 03:30:00 | ES | Futures | 1047.12 | 1054.94 | 1046.63 | 1054.45 | 24777.0 |
| 2010-05-26 04:00:00 | ES | Futures | 1054.45 | 1055.43 | 1052.26 | 1053.23 | 12865.0 |
| 2010-05-26 04:30:00 | ES | Futures | 1053.23 | 1057.14 | 1052.99 | 1055.43 | 18524.0 |
| 2010-05-26 05:00:00 | ES | Futures | 1055.19 | 1057.88 | 1055.19 | 1056.9 | 16806.0 |
| 2010-05-26 05:30:00 | ES | Futures | 1056.65 | 1057.88 | 1053.97 | 1054.94 | 8983.0 |
| 2010-05-26 06:00:00 | ES | Futures | 1054.7 | 1055.68 | 1053.48 | 1053.48 | 9690.0 |
| 2010-05-26 06:30:00 | ES | Futures | 1053.23 | 1056.41 | 1052.74 | 1055.92 | 9722.0 |
| 2010-05-26 07:00:00 | ES | Futures | 1055.92 | 1059.1 | 1055.68 | 1058.37 | 18993.0 |
| 2010-05-26 07:30:00 | ES | Futures | 1058.37 | 1058.61 | 1057.14 | 1058.37 | 17669.0 |
| 2010-05-26 08:00:00 | ES | Futures | 1058.37 | 1060.81 | 1058.12 | 1059.83 | 31654.0 |
| 2010-05-26 08:30:00 | ES | Futures | 1059.83 | 1061.54 | 1055.92 | 1056.41 | 84769.0 |
| 2010-05-26 09:00:00 | ES | Futures | 1056.41 | 1059.1 | 1054.7 | 1055.92 | 64485.0 |
| 2010-05-26 09:30:00 | ES | Futures | 1055.68 | 1063.25 | 1054.94 | 1062.28 | 296972.0 |
| 2010-05-26 10:00:00 | ES | Futures | 1062.03 | 1064.48 | 1060.08 | 1061.3 | 225624.0 |
| 2010-05-26 10:30:00 | ES | Futures | 1061.54 | 1065.21 | 1059.34 | 1060.81 | 186241.0 |
| 2010-05-26 11:00:00 | ES | Futures | 1060.57 | 1061.79 | 1055.19 | 1055.43 | 201104.0 |
| 2010-05-26 11:30:00 | ES | Futures | 1055.43 | 1057.88 | 1052.5 | 1056.65 | 172956.0 |
| 2010-05-26 12:00:00 | ES | Futures | 1056.65 | 1060.32 | 1056.17 | 1057.39 | 83499.0 |
| 2010-05-26 12:30:00 | ES | Futures | 1057.63 | 1059.59 | 1054.7 | 1059.59 | 85505.0 |
| 2010-05-26 13:00:00 | ES | Futures | 1059.59 | 1060.81 | 1057.63 | 1058.61 | 71892.0 |
| 2010-05-26 13:30:00 | ES | Futures | 1058.61 | 1062.52 | 1058.12 | 1060.32 | 76527.0 |
| 2010-05-26 14:00:00 | ES | Futures | 1060.32 | 1061.3 | 1055.68 | 1057.63 | 84454.0 |
| 2010-05-26 14:30:00 | ES | Futures | 1057.63 | 1058.37 | 1050.06 | 1053.23 | 210870.0 |
| 2010-05-26 15:00:00 | ES | Futures | 1052.99 | 1055.92 | 1040.52 | 1043.46 | 248392.0 |
| 2010-05-26 15:30:00 | ES | Futures | 1043.21 | 1048.83 | 1039.54 | 1042.48 | 341810.0 |
| 2010-05-26 16:00:00 | ES | Futures | 1042.23 | 1042.72 | 1036.86 | 1037.35 | 143020.0 |
| 2010-05-26 16:30:00 | ES | Futures | 1036.37 | 1039.3 | 1035.39 | 1038.57 | 12809.0 |
| 2010-05-26 17:00:00 | ES | Futures | 1038.57 | 1038.57 | 1031.97 | 1032.46 | 9210.0 |
| 2010-05-26 18:00:00 | ES | Futures | 1032.46 | 1036.37 | 1032.46 | 1034.66 | 9071.0 |
| 2010-05-26 18:30:00 | ES | Futures | 1034.66 | 1036.37 | 1034.41 | 1036.37 | 2991.0 |
| 2010-05-26 19:00:00 | ES | Futures | 1036.12 | 1037.59 | 1035.88 | 1037.1 | 3296.0 |
| 2010-05-26 19:30:00 | ES | Futures | 1036.86 | 1039.79 | 1035.39 | 1039.54 | 5006.0 |
| 2010-05-26 20:00:00 | ES | Futures | 1039.3 | 1041.74 | 1039.06 | 1041.01 | 8058.0 |
| 2010-05-26 20:30:00 | ES | Futures | 1040.77 | 1042.97 | 1040.28 | 1042.48 | 6456.0 |
| 2010-05-26 21:00:00 | ES | Futures | 1042.72 | 1044.92 | 1042.23 | 1043.7 | 7642.0 |
| 2010-05-26 21:30:00 | ES | Futures | 1043.94 | 1043.94 | 1039.54 | 1040.03 | 6676.0 |
| 2010-05-26 22:00:00 | ES | Futures | 1040.03 | 1043.7 | 1037.83 | 1043.46 | 7154.0 |
| 2010-05-26 22:30:00 | ES | Futures | 1043.46 | 1044.68 | 1041.74 | 1043.21 | 4476.0 |
| 2010-05-26 23:00:00 | ES | Futures | 1043.21 | 1045.17 | 1042.97 | 1044.19 | 3743.0 |
| 2010-05-26 23:30:00 | ES | Futures | 1044.19 | 1045.17 | 1043.94 | 1044.68 | 1872.0 |
| 2010-05-26 00:00:00 | NQ | Futures | 2090.81 | 2093.38 | 2089.09 | 2090.52 | 266.0 |
| 2010-05-26 00:30:00 | NQ | Futures | 2090.81 | 2092.24 | 2088.23 | 2092.24 | 167.0 |
| 2010-05-26 01:00:00 | NQ | Futures | 2091.67 | 2091.67 | 2085.65 | 2087.08 | 206.0 |
> showing 50 of 2,574 rows — these rows as CSV