PREVIEW / futures_30min / 2010-05-24
file: by_date/futures_30min/2010/2010-05-24.parquet size: 72 KB rows: 2,492
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-24 00:00:00 | ES | Futures | 1055.19 | 1058.12 | 1054.7 | 1057.14 | 3377.0 |
| 2010-05-24 00:30:00 | ES | Futures | 1056.9 | 1059.34 | 1055.92 | 1056.41 | 3648.0 |
| 2010-05-24 01:00:00 | ES | Futures | 1056.65 | 1058.12 | 1055.68 | 1056.9 | 3120.0 |
| 2010-05-24 01:30:00 | ES | Futures | 1057.14 | 1058.37 | 1055.19 | 1055.92 | 3252.0 |
| 2010-05-24 02:00:00 | ES | Futures | 1055.68 | 1059.59 | 1055.43 | 1058.85 | 7358.0 |
| 2010-05-24 02:30:00 | ES | Futures | 1058.85 | 1059.83 | 1058.37 | 1059.59 | 7289.0 |
| 2010-05-24 03:00:00 | ES | Futures | 1059.59 | 1062.52 | 1059.1 | 1061.54 | 22458.0 |
| 2010-05-24 03:30:00 | ES | Futures | 1061.3 | 1062.52 | 1057.63 | 1057.88 | 17867.0 |
| 2010-05-24 04:00:00 | ES | Futures | 1057.63 | 1058.37 | 1052.74 | 1053.23 | 20026.0 |
| 2010-05-24 04:30:00 | ES | Futures | 1053.23 | 1055.92 | 1052.99 | 1054.45 | 16951.0 |
| 2010-05-24 05:00:00 | ES | Futures | 1054.45 | 1056.65 | 1053.72 | 1054.7 | 13087.0 |
| 2010-05-24 05:30:00 | ES | Futures | 1054.7 | 1056.17 | 1051.03 | 1052.26 | 13971.0 |
| 2010-05-24 06:00:00 | ES | Futures | 1052.26 | 1052.26 | 1046.63 | 1046.88 | 20225.0 |
| 2010-05-24 06:30:00 | ES | Futures | 1046.88 | 1049.81 | 1046.14 | 1048.59 | 16230.0 |
| 2010-05-24 07:00:00 | ES | Futures | 1048.59 | 1050.54 | 1047.61 | 1049.81 | 16392.0 |
| 2010-05-24 07:30:00 | ES | Futures | 1049.81 | 1052.5 | 1047.86 | 1050.54 | 29360.0 |
| 2010-05-24 08:00:00 | ES | Futures | 1050.54 | 1052.01 | 1049.81 | 1051.03 | 16969.0 |
| 2010-05-24 08:30:00 | ES | Futures | 1051.03 | 1055.68 | 1050.54 | 1055.68 | 39160.0 |
| 2010-05-24 09:00:00 | ES | Futures | 1055.43 | 1059.1 | 1055.19 | 1055.92 | 67481.0 |
| 2010-05-24 09:30:00 | ES | Futures | 1055.92 | 1060.81 | 1052.74 | 1054.45 | 264985.0 |
| 2010-05-24 10:00:00 | ES | Futures | 1054.45 | 1060.32 | 1051.77 | 1059.59 | 184760.0 |
| 2010-05-24 10:30:00 | ES | Futures | 1059.59 | 1062.77 | 1057.63 | 1059.34 | 167435.0 |
| 2010-05-24 11:00:00 | ES | Futures | 1059.34 | 1061.54 | 1056.17 | 1057.39 | 111392.0 |
| 2010-05-24 11:30:00 | ES | Futures | 1057.39 | 1062.28 | 1056.41 | 1061.3 | 101282.0 |
| 2010-05-24 12:00:00 | ES | Futures | 1061.3 | 1064.48 | 1060.32 | 1062.03 | 86331.0 |
| 2010-05-24 12:30:00 | ES | Futures | 1062.03 | 1064.23 | 1059.83 | 1063.25 | 82353.0 |
| 2010-05-24 13:00:00 | ES | Futures | 1063.25 | 1064.23 | 1059.83 | 1061.3 | 87455.0 |
| 2010-05-24 13:30:00 | ES | Futures | 1061.54 | 1062.52 | 1056.41 | 1058.85 | 104029.0 |
| 2010-05-24 14:00:00 | ES | Futures | 1058.61 | 1060.57 | 1056.65 | 1059.1 | 64133.0 |
| 2010-05-24 14:30:00 | ES | Futures | 1059.1 | 1060.57 | 1055.19 | 1056.41 | 80161.0 |
| 2010-05-24 15:00:00 | ES | Futures | 1056.17 | 1057.14 | 1052.26 | 1054.7 | 119552.0 |
| 2010-05-24 15:30:00 | ES | Futures | 1054.7 | 1057.88 | 1047.12 | 1048.1 | 240095.0 |
| 2010-05-24 16:00:00 | ES | Futures | 1048.1 | 1048.59 | 1046.14 | 1046.63 | 99133.0 |
| 2010-05-24 16:30:00 | ES | Futures | 1045.66 | 1045.66 | 1042.72 | 1044.43 | 11057.0 |
| 2010-05-24 17:00:00 | ES | Futures | 1044.68 | 1045.17 | 1042.23 | 1042.48 | 4267.0 |
| 2010-05-24 18:00:00 | ES | Futures | 1042.72 | 1043.21 | 1040.52 | 1041.01 | 6078.0 |
| 2010-05-24 18:30:00 | ES | Futures | 1041.01 | 1042.72 | 1040.28 | 1042.48 | 2709.0 |
| 2010-05-24 19:00:00 | ES | Futures | 1042.48 | 1042.72 | 1041.5 | 1041.74 | 1958.0 |
| 2010-05-24 19:30:00 | ES | Futures | 1041.74 | 1041.74 | 1039.3 | 1040.52 | 4385.0 |
| 2010-05-24 20:00:00 | ES | Futures | 1040.52 | 1041.5 | 1034.41 | 1035.63 | 13198.0 |
| 2010-05-24 20:30:00 | ES | Futures | 1035.63 | 1036.86 | 1033.68 | 1035.88 | 12575.0 |
| 2010-05-24 21:00:00 | ES | Futures | 1035.88 | 1037.35 | 1034.41 | 1035.39 | 8435.0 |
| 2010-05-24 21:30:00 | ES | Futures | 1035.39 | 1036.37 | 1034.41 | 1034.9 | 6336.0 |
| 2010-05-24 22:00:00 | ES | Futures | 1035.15 | 1035.15 | 1031.72 | 1033.92 | 8096.0 |
| 2010-05-24 22:30:00 | ES | Futures | 1034.17 | 1035.39 | 1032.7 | 1033.68 | 4766.0 |
| 2010-05-24 23:00:00 | ES | Futures | 1033.68 | 1035.39 | 1031.97 | 1032.46 | 3865.0 |
| 2010-05-24 23:30:00 | ES | Futures | 1032.46 | 1032.95 | 1028.79 | 1029.52 | 9418.0 |
| 2010-05-24 00:00:00 | NQ | Futures | 2074.48 | 2079.92 | 2074.48 | 2078.49 | 283.0 |
| 2010-05-24 00:30:00 | NQ | Futures | 2077.63 | 2081.64 | 2075.34 | 2076.77 | 229.0 |
| 2010-05-24 01:00:00 | NQ | Futures | 2076.77 | 2079.07 | 2074.2 | 2076.77 | 245.0 |
> showing 50 of 2,492 rows — these rows as CSV