PREVIEW / futures_30min / 2010-02-19
file: by_date/futures_30min/2010/2010-02-19.parquet size: 61 KB rows: 2,076
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-02-19 00:00:00 | ES | Futures | 1065.23 | 1065.47 | 1063.77 | 1064.26 | 2232.0 |
| 2010-02-19 00:30:00 | ES | Futures | 1064.01 | 1064.74 | 1063.53 | 1064.26 | 1719.0 |
| 2010-02-19 01:00:00 | ES | Futures | 1064.01 | 1064.26 | 1063.53 | 1064.01 | 1024.0 |
| 2010-02-19 01:30:00 | ES | Futures | 1064.01 | 1064.5 | 1063.77 | 1063.77 | 1407.0 |
| 2010-02-19 02:00:00 | ES | Futures | 1064.01 | 1064.99 | 1063.28 | 1063.77 | 8418.0 |
| 2010-02-19 02:30:00 | ES | Futures | 1063.53 | 1064.74 | 1063.04 | 1063.53 | 11319.0 |
| 2010-02-19 03:00:00 | ES | Futures | 1063.53 | 1066.2 | 1063.28 | 1065.47 | 22040.0 |
| 2010-02-19 03:30:00 | ES | Futures | 1065.47 | 1068.39 | 1065.47 | 1068.15 | 20864.0 |
| 2010-02-19 04:00:00 | ES | Futures | 1068.39 | 1069.12 | 1066.93 | 1067.42 | 13879.0 |
| 2010-02-19 04:30:00 | ES | Futures | 1067.42 | 1068.39 | 1066.93 | 1067.91 | 5716.0 |
| 2010-02-19 05:00:00 | ES | Futures | 1067.91 | 1068.15 | 1066.69 | 1066.93 | 8668.0 |
| 2010-02-19 05:30:00 | ES | Futures | 1067.18 | 1068.15 | 1066.2 | 1067.18 | 14057.0 |
| 2010-02-19 06:00:00 | ES | Futures | 1067.42 | 1068.39 | 1066.93 | 1067.42 | 10228.0 |
| 2010-02-19 06:30:00 | ES | Futures | 1067.66 | 1068.39 | 1067.18 | 1067.66 | 9707.0 |
| 2010-02-19 07:00:00 | ES | Futures | 1067.42 | 1069.37 | 1067.42 | 1068.88 | 22339.0 |
| 2010-02-19 07:30:00 | ES | Futures | 1069.12 | 1070.1 | 1068.88 | 1069.85 | 18148.0 |
| 2010-02-19 08:00:00 | ES | Futures | 1069.61 | 1069.85 | 1068.64 | 1069.37 | 20015.0 |
| 2010-02-19 08:30:00 | ES | Futures | 1069.37 | 1073.99 | 1069.12 | 1073.01 | 81676.0 |
| 2010-02-19 09:00:00 | ES | Futures | 1073.01 | 1073.5 | 1071.31 | 1071.8 | 40616.0 |
| 2010-02-19 09:30:00 | ES | Futures | 1071.55 | 1074.47 | 1069.85 | 1069.85 | 212126.0 |
| 2010-02-19 10:00:00 | ES | Futures | 1069.85 | 1074.96 | 1069.12 | 1073.99 | 164944.0 |
| 2010-02-19 10:30:00 | ES | Futures | 1073.99 | 1075.69 | 1072.77 | 1073.99 | 101087.0 |
| 2010-02-19 11:00:00 | ES | Futures | 1073.99 | 1079.34 | 1073.74 | 1078.85 | 205884.0 |
| 2010-02-19 11:30:00 | ES | Futures | 1079.1 | 1079.83 | 1077.39 | 1079.58 | 119626.0 |
| 2010-02-19 12:00:00 | ES | Futures | 1079.58 | 1081.04 | 1079.1 | 1080.07 | 115690.0 |
| 2010-02-19 12:30:00 | ES | Futures | 1080.31 | 1080.56 | 1079.1 | 1080.56 | 48947.0 |
| 2010-02-19 13:00:00 | ES | Futures | 1080.31 | 1080.56 | 1078.12 | 1078.61 | 56717.0 |
| 2010-02-19 13:30:00 | ES | Futures | 1078.61 | 1079.58 | 1077.15 | 1077.64 | 67544.0 |
| 2010-02-19 14:00:00 | ES | Futures | 1077.88 | 1078.37 | 1076.66 | 1078.12 | 62908.0 |
| 2010-02-19 14:30:00 | ES | Futures | 1077.88 | 1078.85 | 1077.64 | 1077.88 | 58052.0 |
| 2010-02-19 15:00:00 | ES | Futures | 1077.88 | 1078.12 | 1075.2 | 1075.69 | 97631.0 |
| 2010-02-19 15:30:00 | ES | Futures | 1075.93 | 1079.58 | 1075.69 | 1077.39 | 183820.0 |
| 2010-02-19 16:00:00 | ES | Futures | 1077.39 | 1077.39 | 1075.45 | 1076.18 | 102664.0 |
| 2010-02-19 00:00:00 | NQ | Futures | 2062.24 | 2062.81 | 2059.96 | 2060.81 | 253.0 |
| 2010-02-19 00:30:00 | NQ | Futures | 2060.53 | 2061.67 | 2059.96 | 2061.1 | 116.0 |
| 2010-02-19 01:00:00 | NQ | Futures | 2060.81 | 2061.1 | 2059.67 | 2059.96 | 164.0 |
| 2010-02-19 01:30:00 | NQ | Futures | 2059.67 | 2059.96 | 2058.53 | 2059.39 | 230.0 |
| 2010-02-19 02:00:00 | NQ | Futures | 2059.67 | 2061.67 | 2059.39 | 2060.24 | 592.0 |
| 2010-02-19 02:30:00 | NQ | Futures | 2060.24 | 2061.39 | 2058.81 | 2059.96 | 452.0 |
| 2010-02-19 03:00:00 | NQ | Futures | 2059.96 | 2064.81 | 2059.39 | 2063.38 | 1316.0 |
| 2010-02-19 03:30:00 | NQ | Futures | 2063.38 | 2069.67 | 2063.1 | 2069.38 | 2513.0 |
| 2010-02-19 04:00:00 | NQ | Futures | 2069.38 | 2069.67 | 2066.24 | 2066.81 | 1135.0 |
| 2010-02-19 04:30:00 | NQ | Futures | 2066.81 | 2069.1 | 2066.24 | 2068.24 | 528.0 |
| 2010-02-19 05:00:00 | NQ | Futures | 2068.24 | 2069.1 | 2065.96 | 2066.81 | 858.0 |
| 2010-02-19 05:30:00 | NQ | Futures | 2067.1 | 2069.1 | 2066.53 | 2068.24 | 1323.0 |
| 2010-02-19 06:00:00 | NQ | Futures | 2068.53 | 2069.95 | 2067.67 | 2069.1 | 726.0 |
| 2010-02-19 06:30:00 | NQ | Futures | 2069.38 | 2069.95 | 2069.1 | 2069.38 | 507.0 |
| 2010-02-19 07:00:00 | NQ | Futures | 2069.38 | 2072.53 | 2069.1 | 2072.24 | 1579.0 |
| 2010-02-19 07:30:00 | NQ | Futures | 2072.24 | 2074.52 | 2072.24 | 2073.38 | 1304.0 |
| 2010-02-19 08:00:00 | NQ | Futures | 2073.67 | 2073.67 | 2071.1 | 2072.24 | 2248.0 |
> showing 50 of 2,076 rows — these rows as CSV