PREVIEW / futures_30min / 2010-09-03
file: by_date/futures_30min/2010/2010-09-03.parquet size: 60 KB rows: 1,994
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-09-03 00:00:00 | ES | Futures | 1067.16 | 1068.14 | 1066.66 | 1067.65 | 1058.0 |
| 2010-09-03 00:30:00 | ES | Futures | 1067.65 | 1067.89 | 1066.91 | 1067.16 | 684.0 |
| 2010-09-03 01:00:00 | ES | Futures | 1067.16 | 1067.65 | 1066.66 | 1066.66 | 1422.0 |
| 2010-09-03 01:30:00 | ES | Futures | 1066.66 | 1067.65 | 1066.17 | 1067.4 | 2691.0 |
| 2010-09-03 02:00:00 | ES | Futures | 1067.4 | 1068.14 | 1067.16 | 1067.65 | 3578.0 |
| 2010-09-03 02:30:00 | ES | Futures | 1067.4 | 1068.63 | 1066.91 | 1067.89 | 3370.0 |
| 2010-09-03 03:00:00 | ES | Futures | 1068.14 | 1068.63 | 1066.91 | 1068.14 | 14104.0 |
| 2010-09-03 03:30:00 | ES | Futures | 1068.14 | 1069.85 | 1067.65 | 1069.61 | 12036.0 |
| 2010-09-03 04:00:00 | ES | Futures | 1069.61 | 1069.85 | 1067.89 | 1067.89 | 9064.0 |
| 2010-09-03 04:30:00 | ES | Futures | 1068.14 | 1069.12 | 1067.65 | 1069.12 | 6468.0 |
| 2010-09-03 05:00:00 | ES | Futures | 1069.12 | 1070.59 | 1068.87 | 1070.35 | 10231.0 |
| 2010-09-03 05:30:00 | ES | Futures | 1070.35 | 1070.84 | 1070.1 | 1070.35 | 6258.0 |
| 2010-09-03 06:00:00 | ES | Futures | 1070.59 | 1071.82 | 1070.35 | 1071.08 | 7708.0 |
| 2010-09-03 06:30:00 | ES | Futures | 1071.08 | 1071.08 | 1070.1 | 1070.35 | 4272.0 |
| 2010-09-03 07:00:00 | ES | Futures | 1070.59 | 1070.59 | 1068.63 | 1069.36 | 9817.0 |
| 2010-09-03 07:30:00 | ES | Futures | 1069.12 | 1069.61 | 1067.65 | 1067.89 | 20866.0 |
| 2010-09-03 08:00:00 | ES | Futures | 1067.89 | 1072.55 | 1067.4 | 1071.33 | 35774.0 |
| 2010-09-03 08:30:00 | ES | Futures | 1071.57 | 1083.35 | 1071.57 | 1081.14 | 215986.0 |
| 2010-09-03 09:00:00 | ES | Futures | 1081.14 | 1081.88 | 1079.18 | 1079.42 | 83130.0 |
| 2010-09-03 09:30:00 | ES | Futures | 1079.42 | 1084.09 | 1079.18 | 1083.35 | 227659.0 |
| 2010-09-03 10:00:00 | ES | Futures | 1083.11 | 1083.35 | 1075.25 | 1075.99 | 291657.0 |
| 2010-09-03 10:30:00 | ES | Futures | 1075.99 | 1077.22 | 1073.54 | 1075.74 | 153666.0 |
| 2010-09-03 11:00:00 | ES | Futures | 1075.74 | 1077.95 | 1074.52 | 1076.48 | 96435.0 |
| 2010-09-03 11:30:00 | ES | Futures | 1076.48 | 1078.2 | 1075.5 | 1076.97 | 65064.0 |
| 2010-09-03 12:00:00 | ES | Futures | 1077.22 | 1078.2 | 1076.73 | 1077.46 | 26929.0 |
| 2010-09-03 12:30:00 | ES | Futures | 1077.46 | 1080.9 | 1077.22 | 1080.16 | 76638.0 |
| 2010-09-03 13:00:00 | ES | Futures | 1080.16 | 1081.14 | 1079.67 | 1079.92 | 58739.0 |
| 2010-09-03 13:30:00 | ES | Futures | 1079.92 | 1082.61 | 1079.67 | 1081.88 | 59501.0 |
| 2010-09-03 14:00:00 | ES | Futures | 1081.88 | 1082.61 | 1080.9 | 1081.88 | 50777.0 |
| 2010-09-03 14:30:00 | ES | Futures | 1081.88 | 1082.61 | 1078.93 | 1079.42 | 57156.0 |
| 2010-09-03 15:00:00 | ES | Futures | 1079.18 | 1081.39 | 1078.69 | 1081.14 | 50081.0 |
| 2010-09-03 15:30:00 | ES | Futures | 1081.39 | 1083.6 | 1079.67 | 1083.35 | 183449.0 |
| 2010-09-03 16:00:00 | ES | Futures | 1083.35 | 1084.09 | 1082.37 | 1082.86 | 100318.0 |
| 2010-09-03 00:00:00 | NQ | Futures | 2103.11 | 2105.69 | 2102.82 | 2104.54 | 58.0 |
| 2010-09-03 00:30:00 | NQ | Futures | 2105.11 | 2105.97 | 2104.54 | 2104.83 | 124.0 |
| 2010-09-03 01:00:00 | NQ | Futures | 2105.4 | 2106.26 | 2103.11 | 2103.11 | 285.0 |
| 2010-09-03 01:30:00 | NQ | Futures | 2103.68 | 2104.83 | 2102.82 | 2104.25 | 267.0 |
| 2010-09-03 02:00:00 | NQ | Futures | 2104.54 | 2105.4 | 2103.97 | 2104.54 | 131.0 |
| 2010-09-03 02:30:00 | NQ | Futures | 2104.54 | 2106.83 | 2103.39 | 2105.97 | 190.0 |
| 2010-09-03 03:00:00 | NQ | Futures | 2105.97 | 2106.83 | 2104.25 | 2106.55 | 1135.0 |
| 2010-09-03 03:30:00 | NQ | Futures | 2106.83 | 2109.7 | 2105.11 | 2109.7 | 843.0 |
| 2010-09-03 04:00:00 | NQ | Futures | 2109.7 | 2110.56 | 2105.97 | 2105.97 | 753.0 |
| 2010-09-03 04:30:00 | NQ | Futures | 2106.26 | 2109.13 | 2105.97 | 2109.13 | 374.0 |
| 2010-09-03 05:00:00 | NQ | Futures | 2109.41 | 2112.28 | 2108.55 | 2112.28 | 1236.0 |
| 2010-09-03 05:30:00 | NQ | Futures | 2112.28 | 2113.14 | 2109.99 | 2110.85 | 577.0 |
| 2010-09-03 06:00:00 | NQ | Futures | 2110.85 | 2113.42 | 2110.56 | 2112.28 | 563.0 |
| 2010-09-03 06:30:00 | NQ | Futures | 2111.99 | 2111.99 | 2110.27 | 2110.56 | 351.0 |
| 2010-09-03 07:00:00 | NQ | Futures | 2110.85 | 2110.85 | 2107.41 | 2108.55 | 660.0 |
| 2010-09-03 07:30:00 | NQ | Futures | 2108.55 | 2109.13 | 2104.54 | 2105.4 | 1239.0 |
| 2010-09-03 08:00:00 | NQ | Futures | 2105.4 | 2116.58 | 2105.11 | 2111.42 | 4372.0 |
> showing 50 of 1,994 rows — these rows as CSV