PREVIEW / futures_1hour / 2009-05-22
file: by_date/futures_1hour/2009/2009-05-22.parquet size: 35 KB rows: 980
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-05-22 00:00:00 | ES | Futures | 854.29 | 854.29 | 851.18 | 853.1 | 3810.0 |
| 2009-05-22 01:00:00 | ES | Futures | 853.1 | 853.1 | 851.42 | 852.14 | 2267.0 |
| 2009-05-22 02:00:00 | ES | Futures | 852.14 | 853.82 | 849.74 | 853.58 | 9405.0 |
| 2009-05-22 03:00:00 | ES | Futures | 853.34 | 854.53 | 850.22 | 853.34 | 20818.0 |
| 2009-05-22 04:00:00 | ES | Futures | 853.1 | 858.85 | 852.38 | 856.93 | 21416.0 |
| 2009-05-22 05:00:00 | ES | Futures | 856.93 | 858.13 | 856.45 | 857.89 | 9405.0 |
| 2009-05-22 06:00:00 | ES | Futures | 858.13 | 858.37 | 856.21 | 857.65 | 12687.0 |
| 2009-05-22 07:00:00 | ES | Futures | 857.65 | 858.13 | 854.29 | 855.01 | 14651.0 |
| 2009-05-22 08:00:00 | ES | Futures | 855.25 | 857.89 | 854.29 | 855.49 | 32631.0 |
| 2009-05-22 09:00:00 | ES | Futures | 855.49 | 855.73 | 845.43 | 848.3 | 296150.0 |
| 2009-05-22 10:00:00 | ES | Futures | 848.3 | 856.69 | 847.11 | 855.49 | 370728.0 |
| 2009-05-22 11:00:00 | ES | Futures | 855.25 | 857.41 | 853.1 | 854.05 | 170129.0 |
| 2009-05-22 12:00:00 | ES | Futures | 854.29 | 856.45 | 852.14 | 855.49 | 128521.0 |
| 2009-05-22 13:00:00 | ES | Futures | 855.49 | 856.69 | 852.14 | 854.53 | 114660.0 |
| 2009-05-22 14:00:00 | ES | Futures | 854.53 | 857.17 | 853.34 | 856.93 | 102876.0 |
| 2009-05-22 15:00:00 | ES | Futures | 856.93 | 858.37 | 848.54 | 849.26 | 245489.0 |
| 2009-05-22 16:00:00 | ES | Futures | 849.26 | 849.26 | 846.63 | 848.3 | 62121.0 |
| 2009-05-22 00:00:00 | NQ | Futures | 1560.21 | 1560.21 | 1554.81 | 1558.22 | 211.0 |
| 2009-05-22 01:00:00 | NQ | Futures | 1558.51 | 1559.36 | 1557.09 | 1557.65 | 266.0 |
| 2009-05-22 02:00:00 | NQ | Futures | 1557.09 | 1560.5 | 1553.39 | 1560.21 | 389.0 |
| 2009-05-22 03:00:00 | NQ | Futures | 1560.21 | 1561.06 | 1553.96 | 1558.51 | 875.0 |
| 2009-05-22 04:00:00 | NQ | Futures | 1558.22 | 1567.32 | 1557.09 | 1564.76 | 1671.0 |
| 2009-05-22 05:00:00 | NQ | Futures | 1564.76 | 1567.6 | 1564.19 | 1566.75 | 487.0 |
| 2009-05-22 06:00:00 | NQ | Futures | 1566.75 | 1567.6 | 1563.62 | 1565.89 | 529.0 |
| 2009-05-22 07:00:00 | NQ | Futures | 1566.18 | 1567.6 | 1560.5 | 1561.35 | 1109.0 |
| 2009-05-22 08:00:00 | NQ | Futures | 1561.06 | 1565.04 | 1559.93 | 1560.78 | 2591.0 |
| 2009-05-22 09:00:00 | NQ | Futures | 1560.78 | 1561.06 | 1536.91 | 1545.72 | 41157.0 |
| 2009-05-22 10:00:00 | NQ | Futures | 1545.72 | 1559.08 | 1542.6 | 1556.52 | 40032.0 |
| 2009-05-22 11:00:00 | NQ | Futures | 1556.52 | 1562.48 | 1553.96 | 1556.52 | 23506.0 |
| 2009-05-22 12:00:00 | NQ | Futures | 1556.23 | 1561.92 | 1552.26 | 1561.06 | 15721.0 |
| 2009-05-22 13:00:00 | NQ | Futures | 1561.06 | 1562.77 | 1553.96 | 1558.79 | 16733.0 |
| 2009-05-22 14:00:00 | NQ | Futures | 1558.79 | 1565.33 | 1556.8 | 1564.47 | 17026.0 |
| 2009-05-22 15:00:00 | NQ | Futures | 1564.47 | 1567.32 | 1547.71 | 1548.56 | 38906.0 |
| 2009-05-22 16:00:00 | NQ | Futures | 1548.28 | 1548.28 | 1541.46 | 1545.72 | 8248.0 |
| 2009-05-22 00:00:00 | YM | Futures | 7640.1 | 7640.1 | 7616.3 | 7629.1 | 481.0 |
| 2009-05-22 01:00:00 | YM | Futures | 7629.1 | 7632.8 | 7619.9 | 7622.7 | 177.0 |
| 2009-05-22 02:00:00 | YM | Futures | 7622.7 | 7637.4 | 7605.2 | 7636.5 | 579.0 |
| 2009-05-22 03:00:00 | YM | Futures | 7635.5 | 7642.9 | 7608.0 | 7639.2 | 1614.0 |
| 2009-05-22 04:00:00 | YM | Futures | 7636.5 | 7676.9 | 7628.2 | 7659.4 | 1711.0 |
| 2009-05-22 05:00:00 | YM | Futures | 7658.5 | 7672.3 | 7657.6 | 7669.6 | 552.0 |
| 2009-05-22 06:00:00 | YM | Futures | 7668.6 | 7676.0 | 7657.6 | 7671.4 | 1005.0 |
| 2009-05-22 07:00:00 | YM | Futures | 7672.3 | 7676.0 | 7646.6 | 7654.8 | 1094.0 |
| 2009-05-22 08:00:00 | YM | Futures | 7653.0 | 7676.0 | 7648.4 | 7654.8 | 2850.0 |
| 2009-05-22 09:00:00 | YM | Futures | 7654.8 | 7658.5 | 7574.0 | 7595.1 | 19511.0 |
| 2009-05-22 10:00:00 | YM | Futures | 7595.1 | 7666.8 | 7585.9 | 7657.6 | 25571.0 |
| 2009-05-22 11:00:00 | YM | Futures | 7657.6 | 7672.3 | 7642.0 | 7648.4 | 11096.0 |
| 2009-05-22 12:00:00 | YM | Futures | 7648.4 | 7664.0 | 7635.5 | 7659.4 | 9599.0 |
| 2009-05-22 13:00:00 | YM | Futures | 7659.4 | 7669.6 | 7631.9 | 7652.1 | 9541.0 |
| 2009-05-22 14:00:00 | YM | Futures | 7652.1 | 7666.8 | 7644.7 | 7665.9 | 8353.0 |
| 2009-05-22 15:00:00 | YM | Futures | 7665.0 | 7676.9 | 7587.8 | 7593.3 | 15276.0 |
> showing 50 of 980 rows — these rows as CSV