PREVIEW / futures_30min / 2010-07-30
file: by_date/futures_30min/2010/2010-07-30.parquet size: 62 KB rows: 2,057
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-07-30 00:00:00 | ES | Futures | 1071.82 | 1072.31 | 1070.84 | 1071.82 | 2422.0 |
| 2010-07-30 00:30:00 | ES | Futures | 1071.82 | 1072.55 | 1070.84 | 1072.55 | 2229.0 |
| 2010-07-30 01:00:00 | ES | Futures | 1072.55 | 1073.78 | 1072.06 | 1073.04 | 2473.0 |
| 2010-07-30 01:30:00 | ES | Futures | 1073.04 | 1073.78 | 1072.8 | 1073.78 | 1020.0 |
| 2010-07-30 02:00:00 | ES | Futures | 1073.78 | 1075.01 | 1072.8 | 1074.52 | 4737.0 |
| 2010-07-30 02:30:00 | ES | Futures | 1074.52 | 1075.5 | 1074.27 | 1074.76 | 2568.0 |
| 2010-07-30 03:00:00 | ES | Futures | 1074.52 | 1077.71 | 1074.27 | 1074.52 | 16009.0 |
| 2010-07-30 03:30:00 | ES | Futures | 1074.52 | 1075.25 | 1072.8 | 1074.76 | 12201.0 |
| 2010-07-30 04:00:00 | ES | Futures | 1074.76 | 1075.01 | 1072.55 | 1073.54 | 8242.0 |
| 2010-07-30 04:30:00 | ES | Futures | 1073.29 | 1074.03 | 1071.82 | 1072.8 | 9335.0 |
| 2010-07-30 05:00:00 | ES | Futures | 1072.8 | 1073.78 | 1071.08 | 1071.57 | 12147.0 |
| 2010-07-30 05:30:00 | ES | Futures | 1071.57 | 1072.31 | 1070.1 | 1070.35 | 7841.0 |
| 2010-07-30 06:00:00 | ES | Futures | 1070.59 | 1072.06 | 1070.1 | 1071.57 | 7495.0 |
| 2010-07-30 06:30:00 | ES | Futures | 1071.57 | 1073.54 | 1071.33 | 1073.29 | 5965.0 |
| 2010-07-30 07:00:00 | ES | Futures | 1073.29 | 1073.54 | 1071.57 | 1072.06 | 7280.0 |
| 2010-07-30 07:30:00 | ES | Futures | 1072.06 | 1073.04 | 1071.08 | 1072.06 | 5026.0 |
| 2010-07-30 08:00:00 | ES | Futures | 1072.06 | 1072.31 | 1070.59 | 1070.59 | 15342.0 |
| 2010-07-30 08:30:00 | ES | Futures | 1070.59 | 1070.84 | 1063.47 | 1065.68 | 111573.0 |
| 2010-07-30 09:00:00 | ES | Futures | 1065.68 | 1067.16 | 1064.95 | 1066.42 | 48170.0 |
| 2010-07-30 09:30:00 | ES | Futures | 1066.42 | 1073.04 | 1064.46 | 1071.33 | 328098.0 |
| 2010-07-30 10:00:00 | ES | Futures | 1071.33 | 1076.23 | 1070.84 | 1074.76 | 185627.0 |
| 2010-07-30 10:30:00 | ES | Futures | 1074.76 | 1080.9 | 1074.27 | 1078.2 | 198466.0 |
| 2010-07-30 11:00:00 | ES | Futures | 1078.44 | 1079.67 | 1074.76 | 1075.5 | 105514.0 |
| 2010-07-30 11:30:00 | ES | Futures | 1075.5 | 1077.46 | 1074.27 | 1077.22 | 87900.0 |
| 2010-07-30 12:00:00 | ES | Futures | 1077.22 | 1077.95 | 1074.76 | 1076.48 | 64846.0 |
| 2010-07-30 12:30:00 | ES | Futures | 1076.48 | 1077.71 | 1074.76 | 1076.97 | 37392.0 |
| 2010-07-30 13:00:00 | ES | Futures | 1076.97 | 1077.71 | 1073.29 | 1074.76 | 63060.0 |
| 2010-07-30 13:30:00 | ES | Futures | 1074.52 | 1074.76 | 1070.1 | 1070.84 | 83058.0 |
| 2010-07-30 14:00:00 | ES | Futures | 1070.59 | 1076.97 | 1070.35 | 1075.74 | 104168.0 |
| 2010-07-30 14:30:00 | ES | Futures | 1075.99 | 1077.46 | 1074.27 | 1075.01 | 76517.0 |
| 2010-07-30 15:00:00 | ES | Futures | 1074.76 | 1082.86 | 1074.03 | 1081.88 | 144423.0 |
| 2010-07-30 15:30:00 | ES | Futures | 1081.88 | 1083.11 | 1077.22 | 1077.71 | 228355.0 |
| 2010-07-30 16:00:00 | ES | Futures | 1077.46 | 1080.16 | 1076.73 | 1079.92 | 101481.0 |
| 2010-07-30 00:00:00 | NQ | Futures | 2119.16 | 2120.59 | 2118.3 | 2119.73 | 105.0 |
| 2010-07-30 00:30:00 | NQ | Futures | 2120.02 | 2120.59 | 2118.58 | 2120.59 | 142.0 |
| 2010-07-30 01:00:00 | NQ | Futures | 2120.59 | 2123.17 | 2120.3 | 2122.31 | 148.0 |
| 2010-07-30 01:30:00 | NQ | Futures | 2122.88 | 2124.31 | 2122.88 | 2123.45 | 82.0 |
| 2010-07-30 02:00:00 | NQ | Futures | 2123.74 | 2126.03 | 2122.59 | 2125.46 | 278.0 |
| 2010-07-30 02:30:00 | NQ | Futures | 2125.17 | 2127.75 | 2125.17 | 2126.32 | 302.0 |
| 2010-07-30 03:00:00 | NQ | Futures | 2126.03 | 2130.9 | 2123.45 | 2123.74 | 1216.0 |
| 2010-07-30 03:30:00 | NQ | Futures | 2124.03 | 2125.17 | 2120.3 | 2124.6 | 1341.0 |
| 2010-07-30 04:00:00 | NQ | Futures | 2124.6 | 2124.6 | 2120.02 | 2121.16 | 713.0 |
| 2010-07-30 04:30:00 | NQ | Futures | 2120.59 | 2123.17 | 2118.58 | 2120.3 | 592.0 |
| 2010-07-30 05:00:00 | NQ | Futures | 2120.02 | 2122.31 | 2118.01 | 2119.16 | 701.0 |
| 2010-07-30 05:30:00 | NQ | Futures | 2119.16 | 2120.59 | 2117.44 | 2117.72 | 844.0 |
| 2010-07-30 06:00:00 | NQ | Futures | 2118.01 | 2120.59 | 2117.15 | 2119.44 | 806.0 |
| 2010-07-30 06:30:00 | NQ | Futures | 2119.44 | 2123.74 | 2119.44 | 2123.45 | 716.0 |
| 2010-07-30 07:00:00 | NQ | Futures | 2123.74 | 2123.74 | 2119.73 | 2121.16 | 690.0 |
| 2010-07-30 07:30:00 | NQ | Futures | 2120.88 | 2122.59 | 2119.44 | 2121.16 | 553.0 |
| 2010-07-30 08:00:00 | NQ | Futures | 2121.16 | 2121.16 | 2113.14 | 2119.73 | 1908.0 |
> showing 50 of 2,057 rows — these rows as CSV