PREVIEW / futures_30min / 2010-06-04
file: by_date/futures_30min/2010/2010-06-04.parquet size: 65 KB rows: 2,054
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-04 00:00:00 | ES | Futures | 1077.43 | 1077.43 | 1076.45 | 1077.43 | 1596.0 |
| 2010-06-04 00:30:00 | ES | Futures | 1077.43 | 1077.92 | 1077.19 | 1077.92 | 982.0 |
| 2010-06-04 01:00:00 | ES | Futures | 1077.92 | 1078.41 | 1076.7 | 1077.19 | 1692.0 |
| 2010-06-04 01:30:00 | ES | Futures | 1076.94 | 1077.43 | 1076.21 | 1076.94 | 1518.0 |
| 2010-06-04 02:00:00 | ES | Futures | 1076.94 | 1078.41 | 1076.45 | 1078.16 | 3245.0 |
| 2010-06-04 02:30:00 | ES | Futures | 1077.92 | 1078.41 | 1077.43 | 1078.16 | 2155.0 |
| 2010-06-04 03:00:00 | ES | Futures | 1078.16 | 1080.12 | 1077.92 | 1079.14 | 15007.0 |
| 2010-06-04 03:30:00 | ES | Futures | 1079.14 | 1079.88 | 1078.65 | 1079.63 | 9305.0 |
| 2010-06-04 04:00:00 | ES | Futures | 1079.63 | 1080.85 | 1079.14 | 1080.61 | 11917.0 |
| 2010-06-04 04:30:00 | ES | Futures | 1080.36 | 1082.08 | 1080.12 | 1081.1 | 11437.0 |
| 2010-06-04 05:00:00 | ES | Futures | 1080.85 | 1082.08 | 1080.85 | 1081.83 | 10040.0 |
| 2010-06-04 05:30:00 | ES | Futures | 1082.08 | 1083.05 | 1080.61 | 1081.1 | 9092.0 |
| 2010-06-04 06:00:00 | ES | Futures | 1081.1 | 1081.1 | 1078.41 | 1078.65 | 16603.0 |
| 2010-06-04 06:30:00 | ES | Futures | 1078.65 | 1079.14 | 1075.72 | 1076.45 | 24492.0 |
| 2010-06-04 07:00:00 | ES | Futures | 1076.45 | 1076.7 | 1068.88 | 1072.3 | 68229.0 |
| 2010-06-04 07:30:00 | ES | Futures | 1072.05 | 1072.3 | 1067.17 | 1068.39 | 51080.0 |
| 2010-06-04 08:00:00 | ES | Futures | 1068.39 | 1072.05 | 1068.39 | 1072.05 | 42079.0 |
| 2010-06-04 08:30:00 | ES | Futures | 1071.56 | 1071.56 | 1052.5 | 1057.14 | 287886.0 |
| 2010-06-04 09:00:00 | ES | Futures | 1057.14 | 1057.63 | 1053.72 | 1056.9 | 84196.0 |
| 2010-06-04 09:30:00 | ES | Futures | 1056.9 | 1062.03 | 1055.68 | 1060.32 | 312841.0 |
| 2010-06-04 10:00:00 | ES | Futures | 1060.32 | 1063.74 | 1057.39 | 1062.28 | 226898.0 |
| 2010-06-04 10:30:00 | ES | Futures | 1062.52 | 1063.5 | 1058.61 | 1059.1 | 157671.0 |
| 2010-06-04 11:00:00 | ES | Futures | 1058.85 | 1060.81 | 1053.48 | 1054.21 | 160958.0 |
| 2010-06-04 11:30:00 | ES | Futures | 1054.21 | 1057.39 | 1053.23 | 1055.19 | 125337.0 |
| 2010-06-04 12:00:00 | ES | Futures | 1055.19 | 1055.19 | 1049.81 | 1052.99 | 157322.0 |
| 2010-06-04 12:30:00 | ES | Futures | 1052.99 | 1054.94 | 1051.03 | 1054.7 | 80825.0 |
| 2010-06-04 13:00:00 | ES | Futures | 1054.7 | 1055.19 | 1048.83 | 1051.03 | 90763.0 |
| 2010-06-04 13:30:00 | ES | Futures | 1051.03 | 1051.52 | 1047.37 | 1048.34 | 102031.0 |
| 2010-06-04 14:00:00 | ES | Futures | 1048.34 | 1050.3 | 1045.17 | 1046.39 | 138583.0 |
| 2010-06-04 14:30:00 | ES | Futures | 1046.39 | 1048.1 | 1039.3 | 1040.28 | 220388.0 |
| 2010-06-04 15:00:00 | ES | Futures | 1040.28 | 1044.92 | 1039.54 | 1040.28 | 197333.0 |
| 2010-06-04 15:30:00 | ES | Futures | 1040.03 | 1042.23 | 1035.63 | 1041.01 | 364713.0 |
| 2010-06-04 16:00:00 | ES | Futures | 1041.01 | 1043.7 | 1039.79 | 1042.23 | 144201.0 |
| 2010-06-04 00:00:00 | NQ | Futures | 2168.99 | 2169.85 | 2167.27 | 2169.27 | 177.0 |
| 2010-06-04 00:30:00 | NQ | Futures | 2169.56 | 2170.7 | 2168.99 | 2170.7 | 127.0 |
| 2010-06-04 01:00:00 | NQ | Futures | 2170.99 | 2171.56 | 2167.84 | 2168.99 | 161.0 |
| 2010-06-04 01:30:00 | NQ | Futures | 2168.41 | 2169.85 | 2167.27 | 2168.99 | 162.0 |
| 2010-06-04 02:00:00 | NQ | Futures | 2168.99 | 2170.99 | 2168.41 | 2170.99 | 334.0 |
| 2010-06-04 02:30:00 | NQ | Futures | 2170.7 | 2170.99 | 2169.27 | 2170.13 | 172.0 |
| 2010-06-04 03:00:00 | NQ | Futures | 2170.42 | 2173.85 | 2169.56 | 2172.42 | 1290.0 |
| 2010-06-04 03:30:00 | NQ | Futures | 2172.71 | 2175.0 | 2172.71 | 2174.71 | 1442.0 |
| 2010-06-04 04:00:00 | NQ | Futures | 2174.71 | 2177.86 | 2174.14 | 2176.43 | 957.0 |
| 2010-06-04 04:30:00 | NQ | Futures | 2177.0 | 2179.3 | 2176.72 | 2177.58 | 945.0 |
| 2010-06-04 05:00:00 | NQ | Futures | 2177.29 | 2179.87 | 2177.0 | 2179.58 | 718.0 |
| 2010-06-04 05:30:00 | NQ | Futures | 2180.15 | 2181.59 | 2177.86 | 2178.44 | 510.0 |
| 2010-06-04 06:00:00 | NQ | Futures | 2178.44 | 2178.44 | 2173.0 | 2173.0 | 577.0 |
| 2010-06-04 06:30:00 | NQ | Futures | 2173.0 | 2173.57 | 2167.84 | 2168.41 | 1076.0 |
| 2010-06-04 07:00:00 | NQ | Futures | 2168.41 | 2169.27 | 2154.67 | 2157.24 | 7814.0 |
| 2010-06-04 07:30:00 | NQ | Futures | 2156.96 | 2158.1 | 2147.22 | 2150.66 | 6219.0 |
| 2010-06-04 08:00:00 | NQ | Futures | 2150.94 | 2158.96 | 2150.94 | 2157.82 | 4022.0 |
> showing 50 of 2,054 rows — these rows as CSV