PREVIEW / futures_1hour / 2009-12-11
file: by_date/futures_1hour/2009/2009-12-11.parquet size: 37 KB rows: 1,078
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-11 00:00:00 | ES | Futures | 1070.86 | 1071.59 | 1070.86 | 1071.1 | 1990.0 |
| 2009-12-11 01:00:00 | ES | Futures | 1071.35 | 1071.59 | 1070.62 | 1070.86 | 1221.0 |
| 2009-12-11 02:00:00 | ES | Futures | 1071.1 | 1071.59 | 1070.62 | 1071.59 | 3980.0 |
| 2009-12-11 03:00:00 | ES | Futures | 1071.35 | 1074.74 | 1071.35 | 1073.28 | 18832.0 |
| 2009-12-11 04:00:00 | ES | Futures | 1073.53 | 1075.46 | 1073.04 | 1074.74 | 8990.0 |
| 2009-12-11 05:00:00 | ES | Futures | 1074.74 | 1074.98 | 1073.77 | 1074.25 | 3929.0 |
| 2009-12-11 06:00:00 | ES | Futures | 1074.01 | 1074.74 | 1072.56 | 1072.56 | 5336.0 |
| 2009-12-11 07:00:00 | ES | Futures | 1072.56 | 1074.25 | 1072.07 | 1074.01 | 5828.0 |
| 2009-12-11 08:00:00 | ES | Futures | 1074.01 | 1075.95 | 1071.59 | 1073.04 | 28269.0 |
| 2009-12-11 09:00:00 | ES | Futures | 1072.8 | 1074.25 | 1069.17 | 1073.04 | 86195.0 |
| 2009-12-11 10:00:00 | ES | Futures | 1073.53 | 1074.25 | 1070.14 | 1073.28 | 68761.0 |
| 2009-12-11 11:00:00 | ES | Futures | 1073.28 | 1073.53 | 1066.99 | 1068.68 | 54612.0 |
| 2009-12-11 12:00:00 | ES | Futures | 1068.44 | 1071.59 | 1068.44 | 1071.35 | 24855.0 |
| 2009-12-11 13:00:00 | ES | Futures | 1071.59 | 1072.07 | 1070.38 | 1071.1 | 16524.0 |
| 2009-12-11 14:00:00 | ES | Futures | 1071.1 | 1073.04 | 1070.62 | 1070.86 | 23407.0 |
| 2009-12-11 15:00:00 | ES | Futures | 1071.1 | 1073.77 | 1070.14 | 1072.8 | 32840.0 |
| 2009-12-11 16:00:00 | ES | Futures | 1072.8 | 1074.01 | 1071.83 | 1074.01 | 21828.0 |
| 2009-12-11 00:00:00 | NQ | Futures | 2058.53 | 2059.39 | 2057.96 | 2057.96 | 27.0 |
| 2009-12-11 01:00:00 | NQ | Futures | 2057.96 | 2059.1 | 2057.39 | 2058.25 | 60.0 |
| 2009-12-11 02:00:00 | NQ | Futures | 2058.25 | 2058.82 | 2057.39 | 2058.25 | 94.0 |
| 2009-12-11 03:00:00 | NQ | Futures | 2058.53 | 2065.09 | 2058.53 | 2063.09 | 1030.0 |
| 2009-12-11 04:00:00 | NQ | Futures | 2062.81 | 2067.09 | 2062.24 | 2064.24 | 475.0 |
| 2009-12-11 05:00:00 | NQ | Futures | 2065.38 | 2065.66 | 2063.66 | 2064.24 | 69.0 |
| 2009-12-11 06:00:00 | NQ | Futures | 2064.52 | 2065.09 | 2061.1 | 2061.38 | 160.0 |
| 2009-12-11 07:00:00 | NQ | Futures | 2061.67 | 2064.81 | 2061.38 | 2063.95 | 270.0 |
| 2009-12-11 08:00:00 | NQ | Futures | 2064.24 | 2067.94 | 2060.81 | 2062.24 | 2960.0 |
| 2009-12-11 09:00:00 | NQ | Futures | 2062.24 | 2065.38 | 2053.11 | 2061.38 | 12108.0 |
| 2009-12-11 10:00:00 | NQ | Futures | 2061.95 | 2062.24 | 2051.4 | 2055.39 | 9066.0 |
| 2009-12-11 11:00:00 | NQ | Futures | 2055.39 | 2055.68 | 2035.72 | 2039.14 | 9645.0 |
| 2009-12-11 12:00:00 | NQ | Futures | 2039.14 | 2045.98 | 2038.85 | 2045.7 | 5535.0 |
| 2009-12-11 13:00:00 | NQ | Futures | 2045.98 | 2047.12 | 2042.85 | 2043.99 | 1702.0 |
| 2009-12-11 14:00:00 | NQ | Futures | 2043.99 | 2047.12 | 2041.7 | 2043.42 | 4086.0 |
| 2009-12-11 15:00:00 | NQ | Futures | 2043.42 | 2048.83 | 2040.28 | 2043.99 | 5514.0 |
| 2009-12-11 16:00:00 | NQ | Futures | 2044.27 | 2047.98 | 2043.7 | 2046.84 | 2233.0 |
| 2009-12-11 00:00:00 | YM | Futures | 9705.3 | 9709.0 | 9704.4 | 9704.4 | 94.0 |
| 2009-12-11 01:00:00 | YM | Futures | 9706.2 | 9710.0 | 9702.5 | 9703.4 | 159.0 |
| 2009-12-11 02:00:00 | YM | Futures | 9703.4 | 9707.2 | 9701.6 | 9705.3 | 306.0 |
| 2009-12-11 03:00:00 | YM | Futures | 9705.3 | 9732.4 | 9705.3 | 9720.3 | 1660.0 |
| 2009-12-11 04:00:00 | YM | Futures | 9721.2 | 9738.1 | 9719.3 | 9730.6 | 663.0 |
| 2009-12-11 05:00:00 | YM | Futures | 9730.6 | 9734.3 | 9725.9 | 9730.6 | 213.0 |
| 2009-12-11 06:00:00 | YM | Futures | 9730.6 | 9734.3 | 9710.0 | 9714.7 | 517.0 |
| 2009-12-11 07:00:00 | YM | Futures | 9713.7 | 9726.8 | 9710.9 | 9725.9 | 408.0 |
| 2009-12-11 08:00:00 | YM | Futures | 9725.0 | 9737.1 | 9699.7 | 9714.7 | 2731.0 |
| 2009-12-11 09:00:00 | YM | Futures | 9713.7 | 9740.9 | 9691.3 | 9725.9 | 15718.0 |
| 2009-12-11 10:00:00 | YM | Futures | 9727.8 | 9741.8 | 9706.2 | 9734.3 | 14121.0 |
| 2009-12-11 11:00:00 | YM | Futures | 9734.3 | 9734.3 | 9688.5 | 9703.4 | 12525.0 |
| 2009-12-11 12:00:00 | YM | Futures | 9703.4 | 9731.5 | 9703.4 | 9731.5 | 6874.0 |
| 2009-12-11 13:00:00 | YM | Futures | 9731.5 | 9740.9 | 9725.0 | 9731.5 | 4730.0 |
| 2009-12-11 14:00:00 | YM | Futures | 9732.4 | 9749.3 | 9728.7 | 9733.4 | 7699.0 |
| 2009-12-11 15:00:00 | YM | Futures | 9733.4 | 9754.0 | 9729.6 | 9745.5 | 13055.0 |
> showing 50 of 1,078 rows — these rows as CSV