PREVIEW / futures_1hour / 2009-08-03
file: by_date/futures_1hour/2009/2009-08-03.parquet size: 44 KB rows: 1,279
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-08-03 00:00:00 | ES | Futures | 951.88 | 952.61 | 950.68 | 950.92 | 3508.0 |
| 2009-08-03 01:00:00 | ES | Futures | 950.68 | 952.12 | 949.95 | 952.12 | 2313.0 |
| 2009-08-03 02:00:00 | ES | Futures | 951.88 | 952.61 | 949.23 | 949.23 | 7956.0 |
| 2009-08-03 03:00:00 | ES | Futures | 949.47 | 953.81 | 948.51 | 953.57 | 16534.0 |
| 2009-08-03 04:00:00 | ES | Futures | 953.33 | 958.15 | 952.85 | 957.91 | 21530.0 |
| 2009-08-03 05:00:00 | ES | Futures | 958.15 | 961.53 | 957.19 | 960.56 | 17471.0 |
| 2009-08-03 06:00:00 | ES | Futures | 960.56 | 961.53 | 958.63 | 959.36 | 16028.0 |
| 2009-08-03 07:00:00 | ES | Futures | 959.6 | 960.08 | 958.15 | 959.12 | 15305.0 |
| 2009-08-03 08:00:00 | ES | Futures | 959.12 | 959.84 | 957.91 | 958.63 | 34114.0 |
| 2009-08-03 09:00:00 | ES | Futures | 958.63 | 960.56 | 953.81 | 956.95 | 281108.0 |
| 2009-08-03 10:00:00 | ES | Futures | 956.7 | 963.94 | 956.7 | 958.88 | 375215.0 |
| 2009-08-03 11:00:00 | ES | Futures | 959.12 | 961.29 | 957.19 | 961.05 | 164882.0 |
| 2009-08-03 12:00:00 | ES | Futures | 961.05 | 961.77 | 958.15 | 961.29 | 99024.0 |
| 2009-08-03 13:00:00 | ES | Futures | 961.29 | 963.46 | 961.05 | 962.73 | 103495.0 |
| 2009-08-03 14:00:00 | ES | Futures | 962.73 | 965.63 | 962.25 | 962.49 | 187976.0 |
| 2009-08-03 15:00:00 | ES | Futures | 962.25 | 965.15 | 960.8 | 964.42 | 281715.0 |
| 2009-08-03 16:00:00 | ES | Futures | 964.42 | 966.35 | 963.94 | 965.63 | 103371.0 |
| 2009-08-03 17:00:00 | ES | Futures | 965.63 | 965.87 | 965.15 | 965.39 | 678.0 |
| 2009-08-03 18:00:00 | ES | Futures | 965.39 | 965.87 | 965.15 | 965.15 | 1717.0 |
| 2009-08-03 19:00:00 | ES | Futures | 965.39 | 965.39 | 964.66 | 965.39 | 1377.0 |
| 2009-08-03 20:00:00 | ES | Futures | 965.39 | 965.87 | 964.66 | 964.9 | 3183.0 |
| 2009-08-03 21:00:00 | ES | Futures | 964.9 | 965.15 | 963.94 | 964.18 | 3329.0 |
| 2009-08-03 22:00:00 | ES | Futures | 964.18 | 965.63 | 963.94 | 964.42 | 2947.0 |
| 2009-08-03 23:00:00 | ES | Futures | 964.18 | 964.42 | 962.98 | 963.22 | 3526.0 |
| 2009-08-03 00:00:00 | NQ | Futures | 1832.47 | 1833.04 | 1830.19 | 1830.19 | 192.0 |
| 2009-08-03 01:00:00 | NQ | Futures | 1829.62 | 1833.04 | 1829.05 | 1833.04 | 138.0 |
| 2009-08-03 02:00:00 | NQ | Futures | 1832.47 | 1833.04 | 1828.77 | 1829.34 | 837.0 |
| 2009-08-03 03:00:00 | NQ | Futures | 1829.34 | 1836.46 | 1827.63 | 1834.46 | 1861.0 |
| 2009-08-03 04:00:00 | NQ | Futures | 1834.46 | 1844.15 | 1833.04 | 1843.29 | 2422.0 |
| 2009-08-03 05:00:00 | NQ | Futures | 1843.29 | 1852.69 | 1842.44 | 1851.27 | 3766.0 |
| 2009-08-03 06:00:00 | NQ | Futures | 1850.98 | 1852.12 | 1847.57 | 1848.99 | 1388.0 |
| 2009-08-03 07:00:00 | NQ | Futures | 1849.27 | 1849.84 | 1844.43 | 1846.14 | 2869.0 |
| 2009-08-03 08:00:00 | NQ | Futures | 1845.86 | 1847.0 | 1840.73 | 1843.01 | 5871.0 |
| 2009-08-03 09:00:00 | NQ | Futures | 1843.01 | 1849.56 | 1834.18 | 1840.44 | 45827.0 |
| 2009-08-03 10:00:00 | NQ | Futures | 1840.44 | 1849.56 | 1838.17 | 1839.31 | 54743.0 |
| 2009-08-03 11:00:00 | NQ | Futures | 1839.31 | 1846.14 | 1835.03 | 1845.29 | 32306.0 |
| 2009-08-03 12:00:00 | NQ | Futures | 1845.29 | 1848.42 | 1842.15 | 1846.14 | 23041.0 |
| 2009-08-03 13:00:00 | NQ | Futures | 1846.43 | 1850.98 | 1846.43 | 1848.99 | 20007.0 |
| 2009-08-03 14:00:00 | NQ | Futures | 1848.99 | 1854.12 | 1848.13 | 1848.42 | 25183.0 |
| 2009-08-03 15:00:00 | NQ | Futures | 1848.13 | 1853.83 | 1843.58 | 1852.69 | 42221.0 |
| 2009-08-03 16:00:00 | NQ | Futures | 1852.98 | 1854.97 | 1850.41 | 1853.55 | 13246.0 |
| 2009-08-03 17:00:00 | NQ | Futures | 1853.55 | 1854.12 | 1853.26 | 1853.55 | 89.0 |
| 2009-08-03 18:00:00 | NQ | Futures | 1853.83 | 1854.4 | 1852.69 | 1853.26 | 93.0 |
| 2009-08-03 19:00:00 | NQ | Futures | 1853.26 | 1853.55 | 1852.41 | 1853.26 | 152.0 |
| 2009-08-03 20:00:00 | NQ | Futures | 1852.98 | 1854.4 | 1852.69 | 1852.69 | 257.0 |
| 2009-08-03 21:00:00 | NQ | Futures | 1852.41 | 1852.98 | 1850.98 | 1850.98 | 259.0 |
| 2009-08-03 22:00:00 | NQ | Futures | 1850.98 | 1852.98 | 1850.7 | 1850.98 | 221.0 |
| 2009-08-03 23:00:00 | NQ | Futures | 1851.27 | 1851.27 | 1848.7 | 1848.7 | 244.0 |
| 2009-08-03 00:00:00 | YM | Futures | 8455.8 | 8459.5 | 8446.6 | 8447.5 | 151.0 |
| 2009-08-03 01:00:00 | YM | Futures | 8445.6 | 8457.7 | 8441.0 | 8455.8 | 92.0 |
> showing 50 of 1,279 rows — these rows as CSV