PREVIEW / futures_30min / 2010-06-24
file: by_date/futures_30min/2010/2010-06-24.parquet size: 70 KB rows: 2,485
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-24 00:00:00 | ES | Futures | 1069.61 | 1069.85 | 1069.12 | 1069.61 | 1592.0 |
| 2010-06-24 00:30:00 | ES | Futures | 1069.61 | 1069.61 | 1068.38 | 1069.36 | 1411.0 |
| 2010-06-24 01:00:00 | ES | Futures | 1069.12 | 1070.35 | 1068.14 | 1069.61 | 4409.0 |
| 2010-06-24 01:30:00 | ES | Futures | 1069.85 | 1070.1 | 1067.4 | 1067.4 | 3865.0 |
| 2010-06-24 02:00:00 | ES | Futures | 1067.89 | 1070.84 | 1067.65 | 1070.35 | 3546.0 |
| 2010-06-24 02:30:00 | ES | Futures | 1070.35 | 1070.59 | 1067.89 | 1068.38 | 4578.0 |
| 2010-06-24 03:00:00 | ES | Futures | 1068.14 | 1068.63 | 1064.95 | 1065.19 | 15196.0 |
| 2010-06-24 03:30:00 | ES | Futures | 1064.95 | 1065.44 | 1060.78 | 1061.76 | 34405.0 |
| 2010-06-24 04:00:00 | ES | Futures | 1061.76 | 1062.49 | 1059.06 | 1059.55 | 24934.0 |
| 2010-06-24 04:30:00 | ES | Futures | 1059.55 | 1059.79 | 1057.09 | 1059.06 | 28499.0 |
| 2010-06-24 05:00:00 | ES | Futures | 1058.81 | 1060.78 | 1058.08 | 1060.53 | 10418.0 |
| 2010-06-24 05:30:00 | ES | Futures | 1060.53 | 1061.02 | 1059.79 | 1060.04 | 6909.0 |
| 2010-06-24 06:00:00 | ES | Futures | 1059.79 | 1062.0 | 1059.79 | 1061.27 | 5533.0 |
| 2010-06-24 06:30:00 | ES | Futures | 1061.27 | 1061.51 | 1060.28 | 1060.53 | 5274.0 |
| 2010-06-24 07:00:00 | ES | Futures | 1060.78 | 1062.25 | 1059.79 | 1059.79 | 11440.0 |
| 2010-06-24 07:30:00 | ES | Futures | 1059.79 | 1060.78 | 1058.08 | 1059.3 | 25095.0 |
| 2010-06-24 08:00:00 | ES | Futures | 1059.3 | 1059.79 | 1057.34 | 1058.57 | 23592.0 |
| 2010-06-24 08:30:00 | ES | Futures | 1058.57 | 1063.97 | 1057.34 | 1061.51 | 86092.0 |
| 2010-06-24 09:00:00 | ES | Futures | 1061.51 | 1063.47 | 1060.78 | 1062.49 | 37063.0 |
| 2010-06-24 09:30:00 | ES | Futures | 1062.49 | 1063.72 | 1054.15 | 1055.62 | 257424.0 |
| 2010-06-24 10:00:00 | ES | Futures | 1055.38 | 1061.27 | 1055.38 | 1060.04 | 194148.0 |
| 2010-06-24 10:30:00 | ES | Futures | 1059.79 | 1060.04 | 1052.68 | 1055.38 | 198405.0 |
| 2010-06-24 11:00:00 | ES | Futures | 1055.38 | 1055.62 | 1049.73 | 1052.68 | 196675.0 |
| 2010-06-24 11:30:00 | ES | Futures | 1052.68 | 1055.62 | 1051.94 | 1054.89 | 140482.0 |
| 2010-06-24 12:00:00 | ES | Futures | 1054.89 | 1058.08 | 1054.15 | 1054.64 | 98950.0 |
| 2010-06-24 12:30:00 | ES | Futures | 1054.4 | 1056.36 | 1052.19 | 1055.62 | 68508.0 |
| 2010-06-24 13:00:00 | ES | Futures | 1055.62 | 1058.57 | 1053.91 | 1056.36 | 80610.0 |
| 2010-06-24 13:30:00 | ES | Futures | 1056.11 | 1061.76 | 1055.87 | 1061.02 | 106174.0 |
| 2010-06-24 14:00:00 | ES | Futures | 1061.02 | 1061.27 | 1057.34 | 1058.08 | 65612.0 |
| 2010-06-24 14:30:00 | ES | Futures | 1058.08 | 1058.32 | 1051.21 | 1052.43 | 148810.0 |
| 2010-06-24 15:00:00 | ES | Futures | 1052.68 | 1054.4 | 1046.79 | 1050.96 | 242752.0 |
| 2010-06-24 15:30:00 | ES | Futures | 1050.96 | 1051.94 | 1047.03 | 1049.98 | 284510.0 |
| 2010-06-24 16:00:00 | ES | Futures | 1049.73 | 1051.7 | 1049.49 | 1050.47 | 100789.0 |
| 2010-06-24 16:30:00 | ES | Futures | 1050.47 | 1053.66 | 1049.98 | 1053.41 | 12383.0 |
| 2010-06-24 17:00:00 | ES | Futures | 1053.17 | 1053.66 | 1052.68 | 1052.92 | 1594.0 |
| 2010-06-24 18:00:00 | ES | Futures | 1053.17 | 1053.66 | 1052.92 | 1053.41 | 2874.0 |
| 2010-06-24 18:30:00 | ES | Futures | 1053.41 | 1053.41 | 1051.94 | 1052.43 | 1341.0 |
| 2010-06-24 19:00:00 | ES | Futures | 1052.19 | 1053.17 | 1051.94 | 1052.19 | 1884.0 |
| 2010-06-24 19:30:00 | ES | Futures | 1051.94 | 1053.17 | 1051.94 | 1053.17 | 1773.0 |
| 2010-06-24 20:00:00 | ES | Futures | 1053.17 | 1053.66 | 1051.7 | 1051.94 | 4569.0 |
| 2010-06-24 20:30:00 | ES | Futures | 1051.94 | 1052.68 | 1050.96 | 1050.96 | 3645.0 |
| 2010-06-24 21:00:00 | ES | Futures | 1051.21 | 1052.92 | 1050.72 | 1052.92 | 4006.0 |
| 2010-06-24 21:30:00 | ES | Futures | 1052.92 | 1054.89 | 1052.68 | 1054.64 | 4062.0 |
| 2010-06-24 22:00:00 | ES | Futures | 1054.4 | 1055.13 | 1053.41 | 1054.4 | 3762.0 |
| 2010-06-24 22:30:00 | ES | Futures | 1054.64 | 1055.13 | 1053.41 | 1053.66 | 2403.0 |
| 2010-06-24 23:00:00 | ES | Futures | 1053.66 | 1053.91 | 1052.92 | 1053.41 | 831.0 |
| 2010-06-24 23:30:00 | ES | Futures | 1053.41 | 1053.91 | 1051.45 | 1052.19 | 1828.0 |
| 2010-06-24 00:00:00 | NQ | Futures | 2147.24 | 2148.67 | 2146.95 | 2148.1 | 165.0 |
| 2010-06-24 00:30:00 | NQ | Futures | 2148.1 | 2148.67 | 2146.67 | 2146.95 | 192.0 |
| 2010-06-24 01:00:00 | NQ | Futures | 2146.95 | 2148.67 | 2145.23 | 2148.1 | 218.0 |
> showing 50 of 2,485 rows — these rows as CSV