PREVIEW / futures_1hour / 2010-02-19
file: by_date/futures_1hour/2010/2010-02-19.parquet size: 39 KB rows: 1,117
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.53 | 1064.26 | 3951.0 |
| 2010-02-19 01:00:00 | ES | Futures | 1064.01 | 1064.5 | 1063.53 | 1063.77 | 2431.0 |
| 2010-02-19 02:00:00 | ES | Futures | 1064.01 | 1064.99 | 1063.04 | 1063.53 | 19737.0 |
| 2010-02-19 03:00:00 | ES | Futures | 1063.53 | 1068.39 | 1063.28 | 1068.15 | 42904.0 |
| 2010-02-19 04:00:00 | ES | Futures | 1068.39 | 1069.12 | 1066.93 | 1067.91 | 19595.0 |
| 2010-02-19 05:00:00 | ES | Futures | 1067.91 | 1068.15 | 1066.2 | 1067.18 | 22725.0 |
| 2010-02-19 06:00:00 | ES | Futures | 1067.42 | 1068.39 | 1066.93 | 1067.66 | 19935.0 |
| 2010-02-19 07:00:00 | ES | Futures | 1067.42 | 1070.1 | 1067.42 | 1069.85 | 40487.0 |
| 2010-02-19 08:00:00 | ES | Futures | 1069.61 | 1073.99 | 1068.64 | 1073.01 | 101691.0 |
| 2010-02-19 09:00:00 | ES | Futures | 1073.01 | 1074.47 | 1069.85 | 1069.85 | 252742.0 |
| 2010-02-19 10:00:00 | ES | Futures | 1069.85 | 1075.69 | 1069.12 | 1073.99 | 266031.0 |
| 2010-02-19 11:00:00 | ES | Futures | 1073.99 | 1079.83 | 1073.74 | 1079.58 | 325510.0 |
| 2010-02-19 12:00:00 | ES | Futures | 1079.58 | 1081.04 | 1079.1 | 1080.56 | 164637.0 |
| 2010-02-19 13:00:00 | ES | Futures | 1080.31 | 1080.56 | 1077.15 | 1077.64 | 124261.0 |
| 2010-02-19 14:00:00 | ES | Futures | 1077.88 | 1078.85 | 1076.66 | 1077.88 | 120960.0 |
| 2010-02-19 15:00:00 | ES | Futures | 1077.88 | 1079.58 | 1075.2 | 1077.39 | 281451.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 | 2061.1 | 369.0 |
| 2010-02-19 01:00:00 | NQ | Futures | 2060.81 | 2061.1 | 2058.53 | 2059.39 | 394.0 |
| 2010-02-19 02:00:00 | NQ | Futures | 2059.67 | 2061.67 | 2058.81 | 2059.96 | 1044.0 |
| 2010-02-19 03:00:00 | NQ | Futures | 2059.96 | 2069.67 | 2059.39 | 2069.38 | 3829.0 |
| 2010-02-19 04:00:00 | NQ | Futures | 2069.38 | 2069.67 | 2066.24 | 2068.24 | 1663.0 |
| 2010-02-19 05:00:00 | NQ | Futures | 2068.24 | 2069.1 | 2065.96 | 2068.24 | 2181.0 |
| 2010-02-19 06:00:00 | NQ | Futures | 2068.53 | 2069.95 | 2067.67 | 2069.38 | 1233.0 |
| 2010-02-19 07:00:00 | NQ | Futures | 2069.38 | 2074.52 | 2069.1 | 2073.38 | 2883.0 |
| 2010-02-19 08:00:00 | NQ | Futures | 2073.67 | 2079.09 | 2071.1 | 2077.67 | 10456.0 |
| 2010-02-19 09:00:00 | NQ | Futures | 2077.95 | 2079.95 | 2071.67 | 2071.95 | 34005.0 |
| 2010-02-19 10:00:00 | NQ | Futures | 2071.95 | 2080.24 | 2070.24 | 2078.24 | 37870.0 |
| 2010-02-19 11:00:00 | NQ | Futures | 2078.24 | 2088.81 | 2077.67 | 2087.95 | 41147.0 |
| 2010-02-19 12:00:00 | NQ | Futures | 2088.23 | 2090.52 | 2085.38 | 2089.38 | 29548.0 |
| 2010-02-19 13:00:00 | NQ | Futures | 2089.09 | 2090.81 | 2082.81 | 2084.81 | 24816.0 |
| 2010-02-19 14:00:00 | NQ | Futures | 2084.52 | 2085.66 | 2081.09 | 2082.24 | 19419.0 |
| 2010-02-19 15:00:00 | NQ | Futures | 2082.24 | 2083.09 | 2077.38 | 2080.52 | 48288.0 |
| 2010-02-19 16:00:00 | NQ | Futures | 2080.52 | 2083.38 | 2077.38 | 2077.38 | 9717.0 |
| 2010-02-19 00:00:00 | YM | Futures | 9637.9 | 9637.9 | 9622.0 | 9624.8 | 404.0 |
| 2010-02-19 01:00:00 | YM | Futures | 9624.8 | 9625.8 | 9621.1 | 9621.1 | 575.0 |
| 2010-02-19 02:00:00 | YM | Futures | 9622.0 | 9630.4 | 9617.3 | 9623.0 | 1877.0 |
| 2010-02-19 03:00:00 | YM | Futures | 9622.0 | 9665.1 | 9619.2 | 9662.3 | 2443.0 |
| 2010-02-19 04:00:00 | YM | Futures | 9662.3 | 9666.0 | 9650.1 | 9656.6 | 853.0 |
| 2010-02-19 05:00:00 | YM | Futures | 9655.7 | 9660.4 | 9646.3 | 9653.8 | 895.0 |
| 2010-02-19 06:00:00 | YM | Futures | 9654.8 | 9662.3 | 9652.9 | 9655.7 | 868.0 |
| 2010-02-19 07:00:00 | YM | Futures | 9656.6 | 9675.4 | 9654.8 | 9674.4 | 1065.0 |
| 2010-02-19 08:00:00 | YM | Futures | 9673.5 | 9705.3 | 9666.0 | 9698.8 | 4261.0 |
| 2010-02-19 09:00:00 | YM | Futures | 9698.8 | 9707.2 | 9666.0 | 9666.0 | 15336.0 |
| 2010-02-19 10:00:00 | YM | Futures | 9666.9 | 9710.9 | 9659.4 | 9700.6 | 16890.0 |
| 2010-02-19 11:00:00 | YM | Futures | 9699.7 | 9740.9 | 9696.9 | 9737.1 | 19781.0 |
| 2010-02-19 12:00:00 | YM | Futures | 9738.1 | 9752.1 | 9733.4 | 9745.5 | 11517.0 |
| 2010-02-19 13:00:00 | YM | Futures | 9744.6 | 9746.5 | 9714.7 | 9718.4 | 8884.0 |
| 2010-02-19 14:00:00 | YM | Futures | 9718.4 | 9730.6 | 9707.2 | 9722.1 | 8710.0 |
| 2010-02-19 15:00:00 | YM | Futures | 9721.2 | 9737.1 | 9697.8 | 9715.6 | 16657.0 |
> showing 50 of 1,117 rows — these rows as CSV