PREVIEW / futures_1hour / 2009-08-26
file: by_date/futures_1hour/2009/2009-08-26.parquet size: 41 KB rows: 1,210
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-26 00:00:00 | ES | Futures | 992.4 | 992.64 | 991.43 | 992.16 | 1624.0 |
| 2009-08-26 01:00:00 | ES | Futures | 991.92 | 993.36 | 991.67 | 992.88 | 2734.0 |
| 2009-08-26 02:00:00 | ES | Futures | 992.64 | 993.12 | 990.47 | 990.47 | 7236.0 |
| 2009-08-26 03:00:00 | ES | Futures | 990.47 | 993.6 | 989.74 | 993.12 | 23904.0 |
| 2009-08-26 04:00:00 | ES | Futures | 993.12 | 993.6 | 989.26 | 990.47 | 16150.0 |
| 2009-08-26 05:00:00 | ES | Futures | 990.47 | 990.71 | 988.78 | 989.99 | 10693.0 |
| 2009-08-26 06:00:00 | ES | Futures | 990.23 | 991.43 | 987.09 | 988.06 | 11495.0 |
| 2009-08-26 07:00:00 | ES | Futures | 988.3 | 989.26 | 986.37 | 988.3 | 20192.0 |
| 2009-08-26 08:00:00 | ES | Futures | 988.3 | 992.4 | 986.85 | 988.78 | 71902.0 |
| 2009-08-26 09:00:00 | ES | Futures | 988.54 | 989.26 | 984.2 | 987.33 | 237553.0 |
| 2009-08-26 10:00:00 | ES | Futures | 987.33 | 995.53 | 987.09 | 992.4 | 482386.0 |
| 2009-08-26 11:00:00 | ES | Futures | 992.64 | 992.88 | 986.85 | 989.02 | 200733.0 |
| 2009-08-26 12:00:00 | ES | Futures | 989.02 | 990.95 | 988.06 | 989.26 | 114113.0 |
| 2009-08-26 13:00:00 | ES | Futures | 989.02 | 991.67 | 986.13 | 991.67 | 128113.0 |
| 2009-08-26 14:00:00 | ES | Futures | 991.67 | 992.4 | 988.3 | 988.54 | 144269.0 |
| 2009-08-26 15:00:00 | ES | Futures | 988.54 | 991.92 | 988.06 | 990.95 | 303823.0 |
| 2009-08-26 16:00:00 | ES | Futures | 990.95 | 991.67 | 989.74 | 990.23 | 75555.0 |
| 2009-08-26 17:00:00 | ES | Futures | 990.23 | 990.95 | 989.99 | 990.71 | 1029.0 |
| 2009-08-26 18:00:00 | ES | Futures | 990.47 | 991.43 | 989.99 | 990.71 | 1957.0 |
| 2009-08-26 19:00:00 | ES | Futures | 990.71 | 990.95 | 989.5 | 989.5 | 1403.0 |
| 2009-08-26 20:00:00 | ES | Futures | 989.74 | 989.99 | 986.85 | 987.09 | 4595.0 |
| 2009-08-26 21:00:00 | ES | Futures | 987.33 | 987.57 | 986.13 | 986.61 | 5668.0 |
| 2009-08-26 22:00:00 | ES | Futures | 986.61 | 988.78 | 986.37 | 988.3 | 3213.0 |
| 2009-08-26 23:00:00 | ES | Futures | 988.3 | 988.54 | 984.44 | 985.16 | 5755.0 |
| 2009-08-26 00:00:00 | NQ | Futures | 1870.92 | 1871.77 | 1870.07 | 1870.92 | 355.0 |
| 2009-08-26 01:00:00 | NQ | Futures | 1871.49 | 1873.77 | 1870.63 | 1872.63 | 355.0 |
| 2009-08-26 02:00:00 | NQ | Futures | 1872.63 | 1873.2 | 1868.93 | 1869.21 | 484.0 |
| 2009-08-26 03:00:00 | NQ | Futures | 1868.93 | 1873.48 | 1867.79 | 1872.91 | 1671.0 |
| 2009-08-26 04:00:00 | NQ | Futures | 1872.91 | 1873.48 | 1867.22 | 1869.21 | 1068.0 |
| 2009-08-26 05:00:00 | NQ | Futures | 1868.93 | 1869.21 | 1864.65 | 1867.79 | 899.0 |
| 2009-08-26 06:00:00 | NQ | Futures | 1867.79 | 1869.21 | 1862.66 | 1864.08 | 902.0 |
| 2009-08-26 07:00:00 | NQ | Futures | 1864.37 | 1866.65 | 1861.24 | 1864.37 | 1267.0 |
| 2009-08-26 08:00:00 | NQ | Futures | 1864.08 | 1871.49 | 1861.81 | 1865.79 | 6068.0 |
| 2009-08-26 09:00:00 | NQ | Futures | 1865.51 | 1868.36 | 1859.81 | 1868.07 | 31592.0 |
| 2009-08-26 10:00:00 | NQ | Futures | 1867.5 | 1878.89 | 1866.08 | 1870.07 | 53229.0 |
| 2009-08-26 11:00:00 | NQ | Futures | 1870.07 | 1870.63 | 1854.69 | 1857.53 | 46914.0 |
| 2009-08-26 12:00:00 | NQ | Futures | 1857.53 | 1862.38 | 1855.26 | 1858.39 | 26383.0 |
| 2009-08-26 13:00:00 | NQ | Futures | 1858.39 | 1866.93 | 1854.12 | 1866.93 | 20023.0 |
| 2009-08-26 14:00:00 | NQ | Futures | 1866.93 | 1869.21 | 1861.81 | 1862.38 | 21230.0 |
| 2009-08-26 15:00:00 | NQ | Futures | 1862.66 | 1866.93 | 1860.38 | 1865.22 | 36987.0 |
| 2009-08-26 16:00:00 | NQ | Futures | 1865.22 | 1866.65 | 1860.38 | 1864.37 | 7015.0 |
| 2009-08-26 17:00:00 | NQ | Futures | 1864.37 | 1865.79 | 1864.37 | 1865.51 | 93.0 |
| 2009-08-26 18:00:00 | NQ | Futures | 1865.22 | 1865.51 | 1863.51 | 1864.08 | 139.0 |
| 2009-08-26 19:00:00 | NQ | Futures | 1864.65 | 1864.65 | 1862.66 | 1862.66 | 133.0 |
| 2009-08-26 20:00:00 | NQ | Futures | 1862.66 | 1863.51 | 1857.25 | 1857.82 | 360.0 |
| 2009-08-26 21:00:00 | NQ | Futures | 1858.1 | 1858.96 | 1856.11 | 1857.25 | 383.0 |
| 2009-08-26 22:00:00 | NQ | Futures | 1857.25 | 1860.95 | 1857.25 | 1860.1 | 413.0 |
| 2009-08-26 23:00:00 | NQ | Futures | 1860.1 | 1860.1 | 1854.4 | 1855.26 | 531.0 |
| 2009-08-26 00:00:00 | YM | Futures | 8827.5 | 8828.4 | 8819.2 | 8822.9 | 185.0 |
| 2009-08-26 01:00:00 | YM | Futures | 8825.7 | 8834.0 | 8821.1 | 8829.4 | 326.0 |
> showing 50 of 1,210 rows — these rows as CSV