PREVIEW / futures_30min / 2010-05-21
file: by_date/futures_30min/2010/2010-05-21.parquet size: 64 KB rows: 2,072
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-21 00:00:00 | ES | Futures | 1050.79 | 1054.45 | 1049.81 | 1052.99 | 6741.0 |
| 2010-05-21 00:30:00 | ES | Futures | 1053.23 | 1053.72 | 1050.3 | 1050.79 | 3612.0 |
| 2010-05-21 01:00:00 | ES | Futures | 1050.54 | 1051.52 | 1047.61 | 1051.52 | 4338.0 |
| 2010-05-21 01:30:00 | ES | Futures | 1051.52 | 1054.21 | 1051.52 | 1052.99 | 6024.0 |
| 2010-05-21 02:00:00 | ES | Futures | 1052.99 | 1054.21 | 1050.3 | 1052.99 | 14059.0 |
| 2010-05-21 02:30:00 | ES | Futures | 1053.23 | 1055.68 | 1052.74 | 1053.48 | 15225.0 |
| 2010-05-21 03:00:00 | ES | Futures | 1053.48 | 1056.41 | 1048.1 | 1050.54 | 40999.0 |
| 2010-05-21 03:30:00 | ES | Futures | 1050.54 | 1052.5 | 1046.39 | 1050.3 | 26264.0 |
| 2010-05-21 04:00:00 | ES | Futures | 1050.06 | 1052.99 | 1049.08 | 1049.81 | 19441.0 |
| 2010-05-21 04:30:00 | ES | Futures | 1050.06 | 1053.72 | 1048.83 | 1050.06 | 18564.0 |
| 2010-05-21 05:00:00 | ES | Futures | 1050.06 | 1053.97 | 1049.81 | 1051.77 | 20034.0 |
| 2010-05-21 05:30:00 | ES | Futures | 1051.77 | 1052.5 | 1047.12 | 1048.83 | 18805.0 |
| 2010-05-21 06:00:00 | ES | Futures | 1048.83 | 1050.79 | 1046.39 | 1046.63 | 24991.0 |
| 2010-05-21 06:30:00 | ES | Futures | 1046.88 | 1047.37 | 1040.28 | 1042.48 | 43906.0 |
| 2010-05-21 07:00:00 | ES | Futures | 1042.72 | 1044.68 | 1035.88 | 1035.88 | 56299.0 |
| 2010-05-21 07:30:00 | ES | Futures | 1036.12 | 1040.28 | 1033.92 | 1039.79 | 71215.0 |
| 2010-05-21 08:00:00 | ES | Futures | 1039.54 | 1041.26 | 1034.9 | 1035.39 | 59401.0 |
| 2010-05-21 08:30:00 | ES | Futures | 1035.39 | 1040.03 | 1034.41 | 1038.57 | 84987.0 |
| 2010-05-21 09:00:00 | ES | Futures | 1038.57 | 1038.57 | 1028.55 | 1030.26 | 163950.0 |
| 2010-05-21 09:30:00 | ES | Futures | 1030.5 | 1051.77 | 1027.81 | 1048.34 | 618283.0 |
| 2010-05-21 10:00:00 | ES | Futures | 1048.1 | 1055.43 | 1042.97 | 1044.19 | 381810.0 |
| 2010-05-21 10:30:00 | ES | Futures | 1044.19 | 1051.28 | 1042.48 | 1048.34 | 234826.0 |
| 2010-05-21 11:00:00 | ES | Futures | 1048.1 | 1058.85 | 1047.61 | 1056.9 | 230877.0 |
| 2010-05-21 11:30:00 | ES | Futures | 1056.9 | 1064.48 | 1054.94 | 1061.05 | 252233.0 |
| 2010-05-21 12:00:00 | ES | Futures | 1061.3 | 1063.01 | 1057.39 | 1061.05 | 141613.0 |
| 2010-05-21 12:30:00 | ES | Futures | 1061.05 | 1062.03 | 1055.68 | 1056.41 | 147665.0 |
| 2010-05-21 13:00:00 | ES | Futures | 1056.41 | 1059.34 | 1052.74 | 1054.21 | 135087.0 |
| 2010-05-21 13:30:00 | ES | Futures | 1054.21 | 1059.1 | 1053.48 | 1058.12 | 87670.0 |
| 2010-05-21 14:00:00 | ES | Futures | 1058.37 | 1059.83 | 1051.28 | 1053.97 | 132675.0 |
| 2010-05-21 14:30:00 | ES | Futures | 1053.97 | 1055.92 | 1047.12 | 1051.28 | 139439.0 |
| 2010-05-21 15:00:00 | ES | Futures | 1051.03 | 1052.99 | 1044.19 | 1049.32 | 180037.0 |
| 2010-05-21 15:30:00 | ES | Futures | 1049.08 | 1062.52 | 1045.41 | 1061.54 | 365898.0 |
| 2010-05-21 16:00:00 | ES | Futures | 1061.54 | 1061.79 | 1058.61 | 1060.32 | 150366.0 |
| 2010-05-21 00:00:00 | NQ | Futures | 2073.91 | 2080.5 | 2072.19 | 2078.21 | 684.0 |
| 2010-05-21 00:30:00 | NQ | Futures | 2077.92 | 2079.35 | 2072.76 | 2073.05 | 300.0 |
| 2010-05-21 01:00:00 | NQ | Futures | 2073.34 | 2073.62 | 2067.9 | 2073.62 | 450.0 |
| 2010-05-21 01:30:00 | NQ | Futures | 2073.91 | 2076.77 | 2073.62 | 2074.77 | 441.0 |
| 2010-05-21 02:00:00 | NQ | Futures | 2074.77 | 2077.06 | 2071.05 | 2074.77 | 1567.0 |
| 2010-05-21 02:30:00 | NQ | Futures | 2075.06 | 2080.5 | 2074.77 | 2076.49 | 1020.0 |
| 2010-05-21 03:00:00 | NQ | Futures | 2076.77 | 2081.93 | 2065.89 | 2071.05 | 3281.0 |
| 2010-05-21 03:30:00 | NQ | Futures | 2070.76 | 2073.62 | 2062.46 | 2069.33 | 2756.0 |
| 2010-05-21 04:00:00 | NQ | Futures | 2069.61 | 2075.34 | 2067.32 | 2069.04 | 1734.0 |
| 2010-05-21 04:30:00 | NQ | Futures | 2069.61 | 2076.2 | 2067.04 | 2068.76 | 1060.0 |
| 2010-05-21 05:00:00 | NQ | Futures | 2068.76 | 2075.91 | 2068.76 | 2072.76 | 1109.0 |
| 2010-05-21 05:30:00 | NQ | Futures | 2072.19 | 2073.34 | 2063.31 | 2067.04 | 1020.0 |
| 2010-05-21 06:00:00 | NQ | Futures | 2066.75 | 2070.76 | 2061.6 | 2062.74 | 1289.0 |
| 2010-05-21 06:30:00 | NQ | Futures | 2062.46 | 2063.6 | 2051.86 | 2056.16 | 2686.0 |
| 2010-05-21 07:00:00 | NQ | Futures | 2056.44 | 2060.16 | 2041.55 | 2041.84 | 5203.0 |
| 2010-05-21 07:30:00 | NQ | Futures | 2041.84 | 2050.14 | 2035.54 | 2048.71 | 6234.0 |
| 2010-05-21 08:00:00 | NQ | Futures | 2049.0 | 2051.0 | 2039.55 | 2040.69 | 5099.0 |
> showing 50 of 2,072 rows — these rows as CSV