PREVIEW / futures_1hour / 2009-08-11
file: by_date/futures_1hour/2009/2009-08-11.parquet size: 42 KB rows: 1,240
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-11 00:00:00 | ES | Futures | 969.97 | 971.42 | 969.97 | 970.93 | 1481.0 |
| 2009-08-11 01:00:00 | ES | Futures | 970.69 | 971.9 | 970.69 | 971.42 | 3135.0 |
| 2009-08-11 02:00:00 | ES | Futures | 971.42 | 973.35 | 971.17 | 971.9 | 7127.0 |
| 2009-08-11 03:00:00 | ES | Futures | 971.66 | 974.79 | 971.66 | 974.79 | 13881.0 |
| 2009-08-11 04:00:00 | ES | Futures | 974.55 | 975.03 | 973.59 | 974.07 | 10175.0 |
| 2009-08-11 05:00:00 | ES | Futures | 974.31 | 974.55 | 971.9 | 972.14 | 11309.0 |
| 2009-08-11 06:00:00 | ES | Futures | 972.14 | 972.14 | 969.25 | 970.69 | 16544.0 |
| 2009-08-11 07:00:00 | ES | Futures | 970.69 | 971.42 | 968.04 | 968.52 | 20692.0 |
| 2009-08-11 08:00:00 | ES | Futures | 968.28 | 972.14 | 967.07 | 967.8 | 32593.0 |
| 2009-08-11 09:00:00 | ES | Futures | 967.56 | 967.8 | 961.05 | 962.73 | 249255.0 |
| 2009-08-11 10:00:00 | ES | Futures | 962.73 | 962.98 | 957.43 | 959.36 | 300939.0 |
| 2009-08-11 11:00:00 | ES | Futures | 959.36 | 959.6 | 955.02 | 957.19 | 205423.0 |
| 2009-08-11 12:00:00 | ES | Futures | 957.43 | 958.88 | 955.26 | 955.74 | 86322.0 |
| 2009-08-11 13:00:00 | ES | Futures | 955.5 | 958.63 | 955.26 | 957.91 | 97301.0 |
| 2009-08-11 14:00:00 | ES | Futures | 957.91 | 960.56 | 957.67 | 960.32 | 188873.0 |
| 2009-08-11 15:00:00 | ES | Futures | 960.32 | 961.53 | 956.7 | 957.19 | 244822.0 |
| 2009-08-11 16:00:00 | ES | Futures | 957.19 | 958.15 | 955.98 | 957.91 | 102101.0 |
| 2009-08-11 17:00:00 | ES | Futures | 958.15 | 958.15 | 957.43 | 957.67 | 1127.0 |
| 2009-08-11 18:00:00 | ES | Futures | 957.91 | 958.15 | 956.95 | 957.67 | 1610.0 |
| 2009-08-11 19:00:00 | ES | Futures | 957.91 | 958.15 | 957.67 | 957.67 | 1270.0 |
| 2009-08-11 20:00:00 | ES | Futures | 957.91 | 959.36 | 957.91 | 958.88 | 5203.0 |
| 2009-08-11 21:00:00 | ES | Futures | 958.88 | 959.84 | 958.63 | 959.6 | 4070.0 |
| 2009-08-11 22:00:00 | ES | Futures | 959.6 | 959.84 | 957.19 | 957.67 | 5867.0 |
| 2009-08-11 23:00:00 | ES | Futures | 957.67 | 958.39 | 957.19 | 957.67 | 3113.0 |
| 2009-08-11 00:00:00 | NQ | Futures | 1833.61 | 1835.6 | 1833.61 | 1835.03 | 92.0 |
| 2009-08-11 01:00:00 | NQ | Futures | 1834.75 | 1837.88 | 1834.75 | 1836.74 | 245.0 |
| 2009-08-11 02:00:00 | NQ | Futures | 1836.74 | 1839.59 | 1836.46 | 1837.03 | 412.0 |
| 2009-08-11 03:00:00 | NQ | Futures | 1836.74 | 1841.3 | 1836.74 | 1841.3 | 987.0 |
| 2009-08-11 04:00:00 | NQ | Futures | 1841.58 | 1843.01 | 1840.16 | 1841.3 | 803.0 |
| 2009-08-11 05:00:00 | NQ | Futures | 1841.87 | 1842.72 | 1837.6 | 1838.17 | 886.0 |
| 2009-08-11 06:00:00 | NQ | Futures | 1838.17 | 1838.45 | 1833.04 | 1836.17 | 951.0 |
| 2009-08-11 07:00:00 | NQ | Futures | 1836.46 | 1838.17 | 1831.9 | 1832.47 | 1899.0 |
| 2009-08-11 08:00:00 | NQ | Futures | 1832.47 | 1840.44 | 1828.2 | 1828.77 | 4057.0 |
| 2009-08-11 09:00:00 | NQ | Futures | 1828.77 | 1828.77 | 1817.09 | 1821.08 | 41526.0 |
| 2009-08-11 10:00:00 | NQ | Futures | 1821.08 | 1821.65 | 1807.69 | 1810.26 | 60813.0 |
| 2009-08-11 11:00:00 | NQ | Futures | 1809.97 | 1812.53 | 1806.55 | 1811.11 | 30257.0 |
| 2009-08-11 12:00:00 | NQ | Futures | 1811.11 | 1813.67 | 1807.69 | 1808.26 | 17350.0 |
| 2009-08-11 13:00:00 | NQ | Futures | 1808.26 | 1813.39 | 1807.41 | 1811.96 | 17949.0 |
| 2009-08-11 14:00:00 | NQ | Futures | 1812.25 | 1820.22 | 1812.25 | 1819.65 | 33790.0 |
| 2009-08-11 15:00:00 | NQ | Futures | 1819.94 | 1823.93 | 1815.1 | 1816.52 | 43712.0 |
| 2009-08-11 16:00:00 | NQ | Futures | 1816.52 | 1819.65 | 1815.1 | 1819.65 | 10332.0 |
| 2009-08-11 17:00:00 | NQ | Futures | 1819.65 | 1819.94 | 1818.23 | 1818.23 | 115.0 |
| 2009-08-11 18:00:00 | NQ | Futures | 1815.1 | 1820.22 | 1815.1 | 1818.51 | 546.0 |
| 2009-08-11 19:00:00 | NQ | Futures | 1818.23 | 1818.8 | 1817.09 | 1818.23 | 247.0 |
| 2009-08-11 20:00:00 | NQ | Futures | 1818.23 | 1821.93 | 1817.66 | 1821.65 | 500.0 |
| 2009-08-11 21:00:00 | NQ | Futures | 1821.36 | 1823.07 | 1820.79 | 1822.79 | 743.0 |
| 2009-08-11 22:00:00 | NQ | Futures | 1822.79 | 1823.07 | 1819.65 | 1820.22 | 823.0 |
| 2009-08-11 23:00:00 | NQ | Futures | 1820.22 | 1821.36 | 1819.37 | 1819.94 | 112.0 |
| 2009-08-11 00:00:00 | YM | Futures | 8606.5 | 8613.9 | 8606.5 | 8613.0 | 64.0 |
| 2009-08-11 01:00:00 | YM | Futures | 8612.1 | 8617.6 | 8610.2 | 8614.9 | 120.0 |
> showing 50 of 1,240 rows — these rows as CSV