PREVIEW / futures_1hour / 2010-02-15
file: by_date/futures_1hour/2010/2010-02-15.parquet size: 29 KB rows: 864
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-15 00:00:00 | ES | Futures | 1046.5 | 1047.47 | 1046.01 | 1046.26 | 1213.0 |
| 2010-02-15 01:00:00 | ES | Futures | 1046.26 | 1047.23 | 1046.01 | 1047.23 | 1229.0 |
| 2010-02-15 02:00:00 | ES | Futures | 1047.23 | 1047.47 | 1044.55 | 1047.23 | 10878.0 |
| 2010-02-15 03:00:00 | ES | Futures | 1047.47 | 1049.66 | 1046.74 | 1047.72 | 18660.0 |
| 2010-02-15 04:00:00 | ES | Futures | 1047.96 | 1049.18 | 1046.99 | 1047.47 | 10121.0 |
| 2010-02-15 05:00:00 | ES | Futures | 1047.47 | 1049.42 | 1047.47 | 1049.18 | 9139.0 |
| 2010-02-15 06:00:00 | ES | Futures | 1049.18 | 1049.42 | 1048.2 | 1048.93 | 6100.0 |
| 2010-02-15 07:00:00 | ES | Futures | 1049.18 | 1049.9 | 1048.69 | 1048.93 | 4759.0 |
| 2010-02-15 08:00:00 | ES | Futures | 1048.93 | 1049.42 | 1047.72 | 1047.96 | 4898.0 |
| 2010-02-15 09:00:00 | ES | Futures | 1047.96 | 1049.18 | 1047.72 | 1048.45 | 6686.0 |
| 2010-02-15 10:00:00 | ES | Futures | 1048.45 | 1048.69 | 1046.01 | 1046.5 | 13733.0 |
| 2010-02-15 11:00:00 | ES | Futures | 1046.5 | 1047.72 | 1046.01 | 1046.5 | 9916.0 |
| 2010-02-15 18:00:00 | ES | Futures | 1047.47 | 1048.2 | 1046.5 | 1046.74 | 4401.0 |
| 2010-02-15 19:00:00 | ES | Futures | 1046.74 | 1048.2 | 1046.26 | 1048.2 | 2717.0 |
| 2010-02-15 20:00:00 | ES | Futures | 1048.2 | 1049.18 | 1047.96 | 1048.2 | 3441.0 |
| 2010-02-15 21:00:00 | ES | Futures | 1048.2 | 1048.45 | 1047.72 | 1048.45 | 1196.0 |
| 2010-02-15 22:00:00 | ES | Futures | 1048.69 | 1048.93 | 1047.72 | 1047.96 | 2054.0 |
| 2010-02-15 23:00:00 | ES | Futures | 1047.96 | 1049.66 | 1047.96 | 1049.18 | 3618.0 |
| 2010-02-15 00:00:00 | NQ | Futures | 2031.68 | 2033.11 | 2030.82 | 2030.82 | 48.0 |
| 2010-02-15 01:00:00 | NQ | Futures | 2030.54 | 2032.25 | 2029.97 | 2032.25 | 83.0 |
| 2010-02-15 02:00:00 | NQ | Futures | 2032.82 | 2034.54 | 2028.25 | 2034.25 | 951.0 |
| 2010-02-15 03:00:00 | NQ | Futures | 2034.54 | 2038.82 | 2033.97 | 2034.25 | 2487.0 |
| 2010-02-15 04:00:00 | NQ | Futures | 2034.54 | 2037.11 | 2033.97 | 2033.97 | 1017.0 |
| 2010-02-15 05:00:00 | NQ | Futures | 2033.68 | 2037.39 | 2033.68 | 2036.54 | 805.0 |
| 2010-02-15 06:00:00 | NQ | Futures | 2036.54 | 2037.11 | 2034.25 | 2035.96 | 580.0 |
| 2010-02-15 07:00:00 | NQ | Futures | 2035.68 | 2037.39 | 2035.11 | 2035.39 | 310.0 |
| 2010-02-15 08:00:00 | NQ | Futures | 2035.39 | 2036.54 | 2033.68 | 2033.97 | 353.0 |
| 2010-02-15 09:00:00 | NQ | Futures | 2033.39 | 2037.11 | 2033.39 | 2035.96 | 1601.0 |
| 2010-02-15 10:00:00 | NQ | Futures | 2036.25 | 2036.25 | 2029.4 | 2030.54 | 1759.0 |
| 2010-02-15 11:00:00 | NQ | Futures | 2030.54 | 2033.68 | 2029.11 | 2030.54 | 1051.0 |
| 2010-02-15 18:00:00 | NQ | Futures | 2032.54 | 2034.82 | 2031.97 | 2032.25 | 178.0 |
| 2010-02-15 19:00:00 | NQ | Futures | 2031.68 | 2034.82 | 2031.39 | 2034.82 | 215.0 |
| 2010-02-15 20:00:00 | NQ | Futures | 2034.54 | 2037.11 | 2034.25 | 2035.39 | 312.0 |
| 2010-02-15 21:00:00 | NQ | Futures | 2035.11 | 2035.96 | 2034.82 | 2035.96 | 42.0 |
| 2010-02-15 22:00:00 | NQ | Futures | 2036.54 | 2036.82 | 2034.25 | 2034.25 | 73.0 |
| 2010-02-15 23:00:00 | NQ | Futures | 2034.54 | 2036.54 | 2034.54 | 2036.54 | 164.0 |
| 2010-02-15 00:00:00 | YM | Futures | 9440.5 | 9444.2 | 9434.9 | 9435.8 | 43.0 |
| 2010-02-15 01:00:00 | YM | Futures | 9435.8 | 9440.5 | 9431.1 | 9440.5 | 202.0 |
| 2010-02-15 02:00:00 | YM | Futures | 9442.3 | 9448.9 | 9420.8 | 9448.0 | 771.0 |
| 2010-02-15 03:00:00 | YM | Futures | 9448.9 | 9462.9 | 9448.0 | 9451.7 | 1365.0 |
| 2010-02-15 04:00:00 | YM | Futures | 9448.9 | 9458.2 | 9442.3 | 9444.2 | 399.0 |
| 2010-02-15 05:00:00 | YM | Futures | 9447.0 | 9461.1 | 9446.1 | 9459.2 | 266.0 |
| 2010-02-15 06:00:00 | YM | Futures | 9456.4 | 9460.1 | 9449.8 | 9457.3 | 210.0 |
| 2010-02-15 07:00:00 | YM | Futures | 9456.4 | 9461.1 | 9453.6 | 9455.4 | 251.0 |
| 2010-02-15 08:00:00 | YM | Futures | 9454.5 | 9459.2 | 9447.0 | 9450.8 | 144.0 |
| 2010-02-15 09:00:00 | YM | Futures | 9448.9 | 9459.2 | 9447.0 | 9452.6 | 333.0 |
| 2010-02-15 10:00:00 | YM | Futures | 9451.7 | 9451.7 | 9432.0 | 9435.8 | 618.0 |
| 2010-02-15 11:00:00 | YM | Futures | 9433.9 | 9445.1 | 9432.0 | 9437.7 | 529.0 |
| 2010-02-15 18:00:00 | YM | Futures | 9442.3 | 9450.8 | 9439.5 | 9439.5 | 131.0 |
| 2010-02-15 19:00:00 | YM | Futures | 9438.6 | 9448.0 | 9434.9 | 9448.0 | 150.0 |
> showing 50 of 864 rows — these rows as CSV