PREVIEW / futures_1hour / 2009-08-21
file: by_date/futures_1hour/2009/2009-08-21.parquet size: 36 KB rows: 987
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-21 00:00:00 | ES | Futures | 961.77 | 963.46 | 961.29 | 961.77 | 6042.0 |
| 2009-08-21 01:00:00 | ES | Futures | 962.01 | 965.87 | 961.53 | 964.42 | 5825.0 |
| 2009-08-21 02:00:00 | ES | Futures | 964.42 | 965.87 | 963.94 | 964.66 | 7644.0 |
| 2009-08-21 03:00:00 | ES | Futures | 964.66 | 970.21 | 964.18 | 968.76 | 18171.0 |
| 2009-08-21 04:00:00 | ES | Futures | 968.76 | 970.45 | 967.32 | 970.21 | 12640.0 |
| 2009-08-21 05:00:00 | ES | Futures | 970.45 | 972.86 | 969.73 | 972.62 | 33895.0 |
| 2009-08-21 06:00:00 | ES | Futures | 972.62 | 975.76 | 971.9 | 974.31 | 30298.0 |
| 2009-08-21 07:00:00 | ES | Futures | 974.55 | 976.0 | 973.59 | 974.55 | 23080.0 |
| 2009-08-21 08:00:00 | ES | Futures | 974.31 | 976.24 | 973.35 | 976.0 | 32482.0 |
| 2009-08-21 09:00:00 | ES | Futures | 976.0 | 979.62 | 976.0 | 979.37 | 312810.0 |
| 2009-08-21 10:00:00 | ES | Futures | 979.62 | 989.02 | 979.62 | 985.89 | 495156.0 |
| 2009-08-21 11:00:00 | ES | Futures | 985.64 | 988.06 | 985.4 | 987.09 | 150176.0 |
| 2009-08-21 12:00:00 | ES | Futures | 987.33 | 987.33 | 985.89 | 986.37 | 86732.0 |
| 2009-08-21 13:00:00 | ES | Futures | 986.61 | 987.33 | 984.92 | 984.92 | 152036.0 |
| 2009-08-21 14:00:00 | ES | Futures | 984.92 | 986.85 | 984.44 | 986.85 | 100068.0 |
| 2009-08-21 15:00:00 | ES | Futures | 986.85 | 990.71 | 986.37 | 988.3 | 321297.0 |
| 2009-08-21 16:00:00 | ES | Futures | 988.54 | 989.74 | 988.3 | 989.26 | 103958.0 |
| 2009-08-21 00:00:00 | NQ | Futures | 1825.07 | 1827.34 | 1822.79 | 1824.5 | 482.0 |
| 2009-08-21 01:00:00 | NQ | Futures | 1824.5 | 1830.19 | 1823.93 | 1829.05 | 665.0 |
| 2009-08-21 02:00:00 | NQ | Futures | 1829.05 | 1830.48 | 1827.63 | 1828.77 | 593.0 |
| 2009-08-21 03:00:00 | NQ | Futures | 1829.05 | 1836.74 | 1827.91 | 1834.18 | 1572.0 |
| 2009-08-21 04:00:00 | NQ | Futures | 1834.46 | 1837.03 | 1831.9 | 1836.74 | 1011.0 |
| 2009-08-21 05:00:00 | NQ | Futures | 1836.46 | 1841.3 | 1836.17 | 1841.3 | 1550.0 |
| 2009-08-21 06:00:00 | NQ | Futures | 1841.3 | 1847.85 | 1840.44 | 1845.29 | 2525.0 |
| 2009-08-21 07:00:00 | NQ | Futures | 1845.29 | 1848.13 | 1843.58 | 1845.29 | 1800.0 |
| 2009-08-21 08:00:00 | NQ | Futures | 1845.29 | 1847.85 | 1843.58 | 1847.57 | 2555.0 |
| 2009-08-21 09:00:00 | NQ | Futures | 1847.85 | 1853.55 | 1839.02 | 1846.14 | 50000.0 |
| 2009-08-21 10:00:00 | NQ | Futures | 1846.14 | 1868.07 | 1846.14 | 1861.81 | 75354.0 |
| 2009-08-21 11:00:00 | NQ | Futures | 1861.81 | 1863.8 | 1859.81 | 1861.24 | 24550.0 |
| 2009-08-21 12:00:00 | NQ | Futures | 1861.24 | 1862.09 | 1858.96 | 1859.24 | 14177.0 |
| 2009-08-21 13:00:00 | NQ | Futures | 1859.53 | 1860.67 | 1853.55 | 1855.26 | 23795.0 |
| 2009-08-21 14:00:00 | NQ | Futures | 1855.26 | 1861.24 | 1854.69 | 1861.24 | 20403.0 |
| 2009-08-21 15:00:00 | NQ | Futures | 1860.95 | 1867.79 | 1860.38 | 1864.08 | 52056.0 |
| 2009-08-21 16:00:00 | NQ | Futures | 1864.37 | 1865.79 | 1861.24 | 1863.51 | 13400.0 |
| 2009-08-21 00:00:00 | YM | Futures | 8561.2 | 8570.5 | 8552.0 | 8556.6 | 419.0 |
| 2009-08-21 01:00:00 | YM | Futures | 8558.5 | 8589.0 | 8554.8 | 8579.7 | 492.0 |
| 2009-08-21 02:00:00 | YM | Futures | 8580.6 | 8590.8 | 8575.1 | 8578.8 | 957.0 |
| 2009-08-21 03:00:00 | YM | Futures | 8582.5 | 8626.0 | 8577.9 | 8614.9 | 1657.0 |
| 2009-08-21 04:00:00 | YM | Futures | 8614.9 | 8628.7 | 8603.8 | 8623.2 | 1126.0 |
| 2009-08-21 05:00:00 | YM | Futures | 8623.2 | 8641.7 | 8620.4 | 8638.9 | 1325.0 |
| 2009-08-21 06:00:00 | YM | Futures | 8639.8 | 8663.9 | 8634.3 | 8652.8 | 1597.0 |
| 2009-08-21 07:00:00 | YM | Futures | 8654.6 | 8667.6 | 8650.0 | 8654.6 | 1277.0 |
| 2009-08-21 08:00:00 | YM | Futures | 8654.6 | 8665.7 | 8646.3 | 8663.9 | 2262.0 |
| 2009-08-21 09:00:00 | YM | Futures | 8664.8 | 8711.9 | 8663.9 | 8698.1 | 22911.0 |
| 2009-08-21 10:00:00 | YM | Futures | 8698.1 | 8779.4 | 8698.1 | 8757.3 | 35494.0 |
| 2009-08-21 11:00:00 | YM | Futures | 8757.3 | 8773.9 | 8754.5 | 8766.5 | 11804.0 |
| 2009-08-21 12:00:00 | YM | Futures | 8766.5 | 8768.3 | 8756.3 | 8761.9 | 6503.0 |
| 2009-08-21 13:00:00 | YM | Futures | 8761.9 | 8769.3 | 8749.9 | 8752.6 | 7722.0 |
| 2009-08-21 14:00:00 | YM | Futures | 8751.7 | 8763.7 | 8747.1 | 8762.8 | 6421.0 |
| 2009-08-21 15:00:00 | YM | Futures | 8762.8 | 8791.5 | 8760.0 | 8773.0 | 20688.0 |
> showing 50 of 987 rows — these rows as CSV