PREVIEW / futures_1hour / 2010-02-18
file: by_date/futures_1hour/2010/2010-02-18.parquet size: 47 KB rows: 1,385
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-18 00:00:00 | ES | Futures | 1067.66 | 1068.15 | 1067.18 | 1067.91 | 1464.0 |
| 2010-02-18 01:00:00 | ES | Futures | 1068.15 | 1068.88 | 1067.42 | 1068.15 | 2219.0 |
| 2010-02-18 02:00:00 | ES | Futures | 1068.15 | 1068.15 | 1065.23 | 1065.47 | 13397.0 |
| 2010-02-18 03:00:00 | ES | Futures | 1065.72 | 1066.69 | 1064.74 | 1065.72 | 20642.0 |
| 2010-02-18 04:00:00 | ES | Futures | 1065.72 | 1067.91 | 1064.5 | 1067.18 | 18472.0 |
| 2010-02-18 05:00:00 | ES | Futures | 1066.93 | 1069.85 | 1066.93 | 1068.64 | 15518.0 |
| 2010-02-18 06:00:00 | ES | Futures | 1068.64 | 1069.12 | 1067.42 | 1068.39 | 13260.0 |
| 2010-02-18 07:00:00 | ES | Futures | 1068.15 | 1068.64 | 1066.93 | 1068.15 | 22166.0 |
| 2010-02-18 08:00:00 | ES | Futures | 1067.91 | 1069.12 | 1063.53 | 1064.99 | 92139.0 |
| 2010-02-18 09:00:00 | ES | Futures | 1064.99 | 1071.31 | 1064.5 | 1070.1 | 256387.0 |
| 2010-02-18 10:00:00 | ES | Futures | 1070.1 | 1072.28 | 1066.69 | 1070.1 | 298358.0 |
| 2010-02-18 11:00:00 | ES | Futures | 1070.1 | 1070.83 | 1068.15 | 1069.37 | 186639.0 |
| 2010-02-18 12:00:00 | ES | Futures | 1069.37 | 1070.34 | 1068.39 | 1068.88 | 88259.0 |
| 2010-02-18 13:00:00 | ES | Futures | 1069.12 | 1071.8 | 1068.64 | 1071.07 | 125546.0 |
| 2010-02-18 14:00:00 | ES | Futures | 1071.07 | 1075.93 | 1070.34 | 1075.69 | 252496.0 |
| 2010-02-18 15:00:00 | ES | Futures | 1075.45 | 1076.91 | 1074.23 | 1075.2 | 295724.0 |
| 2010-02-18 16:00:00 | ES | Futures | 1075.2 | 1076.18 | 1064.99 | 1066.93 | 200859.0 |
| 2010-02-18 17:00:00 | ES | Futures | 1066.93 | 1068.88 | 1066.2 | 1068.39 | 13276.0 |
| 2010-02-18 18:00:00 | ES | Futures | 1067.66 | 1068.39 | 1064.74 | 1065.47 | 20013.0 |
| 2010-02-18 19:00:00 | ES | Futures | 1065.47 | 1067.42 | 1064.5 | 1067.18 | 10469.0 |
| 2010-02-18 20:00:00 | ES | Futures | 1067.42 | 1067.42 | 1064.74 | 1064.99 | 6859.0 |
| 2010-02-18 21:00:00 | ES | Futures | 1064.99 | 1065.96 | 1063.28 | 1063.77 | 16148.0 |
| 2010-02-18 22:00:00 | ES | Futures | 1063.77 | 1064.74 | 1063.28 | 1063.77 | 7896.0 |
| 2010-02-18 23:00:00 | ES | Futures | 1063.77 | 1065.96 | 1063.53 | 1065.23 | 6639.0 |
| 2010-02-18 00:00:00 | NQ | Futures | 2067.38 | 2068.24 | 2066.53 | 2067.67 | 89.0 |
| 2010-02-18 01:00:00 | NQ | Futures | 2067.67 | 2069.38 | 2066.81 | 2068.53 | 196.0 |
| 2010-02-18 02:00:00 | NQ | Futures | 2068.24 | 2068.24 | 2063.1 | 2063.1 | 700.0 |
| 2010-02-18 03:00:00 | NQ | Futures | 2063.38 | 2065.67 | 2061.96 | 2064.53 | 1572.0 |
| 2010-02-18 04:00:00 | NQ | Futures | 2064.24 | 2069.38 | 2062.53 | 2068.53 | 1637.0 |
| 2010-02-18 05:00:00 | NQ | Futures | 2068.53 | 2073.67 | 2068.24 | 2071.38 | 1853.0 |
| 2010-02-18 06:00:00 | NQ | Futures | 2071.38 | 2072.81 | 2070.81 | 2072.53 | 1363.0 |
| 2010-02-18 07:00:00 | NQ | Futures | 2072.24 | 2073.1 | 2069.67 | 2071.38 | 2900.0 |
| 2010-02-18 08:00:00 | NQ | Futures | 2071.67 | 2073.1 | 2061.96 | 2064.24 | 9081.0 |
| 2010-02-18 09:00:00 | NQ | Futures | 2064.24 | 2069.67 | 2063.1 | 2068.81 | 38732.0 |
| 2010-02-18 10:00:00 | NQ | Futures | 2068.81 | 2075.95 | 2064.81 | 2073.95 | 48564.0 |
| 2010-02-18 11:00:00 | NQ | Futures | 2073.95 | 2075.95 | 2070.81 | 2073.67 | 35781.0 |
| 2010-02-18 12:00:00 | NQ | Futures | 2073.38 | 2074.81 | 2069.38 | 2070.81 | 17069.0 |
| 2010-02-18 13:00:00 | NQ | Futures | 2070.81 | 2075.67 | 2070.24 | 2073.95 | 21107.0 |
| 2010-02-18 14:00:00 | NQ | Futures | 2074.24 | 2084.52 | 2072.81 | 2083.95 | 34781.0 |
| 2010-02-18 15:00:00 | NQ | Futures | 2083.66 | 2084.81 | 2080.81 | 2081.38 | 40774.0 |
| 2010-02-18 16:00:00 | NQ | Futures | 2081.38 | 2081.95 | 2063.38 | 2066.53 | 17180.0 |
| 2010-02-18 17:00:00 | NQ | Futures | 2066.53 | 2068.53 | 2063.96 | 2066.81 | 887.0 |
| 2010-02-18 18:00:00 | NQ | Futures | 2065.96 | 2067.1 | 2062.81 | 2063.1 | 1064.0 |
| 2010-02-18 19:00:00 | NQ | Futures | 2063.1 | 2067.38 | 2062.24 | 2066.81 | 798.0 |
| 2010-02-18 20:00:00 | NQ | Futures | 2066.53 | 2066.81 | 2062.81 | 2063.1 | 322.0 |
| 2010-02-18 21:00:00 | NQ | Futures | 2063.1 | 2064.81 | 2058.24 | 2058.81 | 1375.0 |
| 2010-02-18 22:00:00 | NQ | Futures | 2058.81 | 2061.96 | 2057.67 | 2059.96 | 879.0 |
| 2010-02-18 23:00:00 | NQ | Futures | 2060.24 | 2063.38 | 2059.67 | 2061.96 | 543.0 |
| 2010-02-18 00:00:00 | YM | Futures | 9620.1 | 9621.1 | 9615.5 | 9621.1 | 96.0 |
| 2010-02-18 01:00:00 | YM | Futures | 9619.2 | 9627.6 | 9618.3 | 9625.8 | 228.0 |
> showing 50 of 1,385 rows — these rows as CSV