PREVIEW / futures_1hour / 2009-06-29
file: by_date/futures_1hour/2009/2009-06-29.parquet size: 42 KB rows: 1,255
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-06-29 00:00:00 | ES | Futures | 879.29 | 879.53 | 877.12 | 877.36 | 4913.0 |
| 2009-06-29 01:00:00 | ES | Futures | 877.36 | 877.6 | 875.19 | 875.43 | 4167.0 |
| 2009-06-29 02:00:00 | ES | Futures | 875.43 | 877.84 | 875.19 | 877.6 | 5101.0 |
| 2009-06-29 03:00:00 | ES | Futures | 877.6 | 881.7 | 877.6 | 880.98 | 15632.0 |
| 2009-06-29 04:00:00 | ES | Futures | 880.98 | 882.43 | 880.01 | 880.26 | 11895.0 |
| 2009-06-29 05:00:00 | ES | Futures | 880.5 | 882.18 | 879.53 | 881.46 | 4984.0 |
| 2009-06-29 06:00:00 | ES | Futures | 881.46 | 885.32 | 881.46 | 884.84 | 19405.0 |
| 2009-06-29 07:00:00 | ES | Futures | 884.84 | 885.8 | 883.63 | 885.32 | 17034.0 |
| 2009-06-29 08:00:00 | ES | Futures | 885.56 | 886.28 | 883.63 | 884.11 | 27970.0 |
| 2009-06-29 09:00:00 | ES | Futures | 884.11 | 885.32 | 879.29 | 880.5 | 191810.0 |
| 2009-06-29 10:00:00 | ES | Futures | 880.74 | 890.63 | 880.01 | 889.18 | 341009.0 |
| 2009-06-29 11:00:00 | ES | Futures | 889.18 | 890.87 | 888.7 | 890.38 | 135985.0 |
| 2009-06-29 12:00:00 | ES | Futures | 890.63 | 891.35 | 888.94 | 888.94 | 90026.0 |
| 2009-06-29 13:00:00 | ES | Futures | 889.18 | 890.87 | 888.7 | 889.66 | 66765.0 |
| 2009-06-29 14:00:00 | ES | Futures | 889.9 | 889.9 | 887.73 | 889.66 | 95558.0 |
| 2009-06-29 15:00:00 | ES | Futures | 889.66 | 891.35 | 887.25 | 890.38 | 224015.0 |
| 2009-06-29 16:00:00 | ES | Futures | 890.38 | 890.87 | 888.45 | 888.94 | 79124.0 |
| 2009-06-29 17:00:00 | ES | Futures | 888.94 | 889.18 | 888.7 | 888.94 | 799.0 |
| 2009-06-29 18:00:00 | ES | Futures | 888.7 | 889.18 | 888.21 | 888.7 | 1893.0 |
| 2009-06-29 19:00:00 | ES | Futures | 888.94 | 889.42 | 888.21 | 888.7 | 1226.0 |
| 2009-06-29 20:00:00 | ES | Futures | 888.7 | 890.14 | 888.45 | 889.66 | 3338.0 |
| 2009-06-29 21:00:00 | ES | Futures | 889.66 | 890.38 | 889.42 | 889.9 | 2377.0 |
| 2009-06-29 22:00:00 | ES | Futures | 889.9 | 890.38 | 889.42 | 889.9 | 1510.0 |
| 2009-06-29 23:00:00 | ES | Futures | 889.9 | 890.14 | 888.45 | 888.7 | 2182.0 |
| 2009-06-29 00:00:00 | NQ | Futures | 1678.39 | 1678.67 | 1675.25 | 1675.54 | 291.0 |
| 2009-06-29 01:00:00 | NQ | Futures | 1675.54 | 1675.54 | 1672.41 | 1673.55 | 208.0 |
| 2009-06-29 02:00:00 | NQ | Futures | 1674.12 | 1676.68 | 1671.84 | 1676.39 | 388.0 |
| 2009-06-29 03:00:00 | NQ | Futures | 1676.68 | 1682.66 | 1676.11 | 1681.81 | 1191.0 |
| 2009-06-29 04:00:00 | NQ | Futures | 1681.81 | 1683.8 | 1679.81 | 1679.81 | 762.0 |
| 2009-06-29 05:00:00 | NQ | Futures | 1680.1 | 1682.94 | 1678.39 | 1681.81 | 465.0 |
| 2009-06-29 06:00:00 | NQ | Futures | 1682.09 | 1689.21 | 1682.09 | 1687.79 | 1741.0 |
| 2009-06-29 07:00:00 | NQ | Futures | 1688.07 | 1691.2 | 1686.36 | 1688.64 | 1711.0 |
| 2009-06-29 08:00:00 | NQ | Futures | 1688.93 | 1690.63 | 1684.94 | 1686.36 | 2564.0 |
| 2009-06-29 09:00:00 | NQ | Futures | 1686.65 | 1689.78 | 1673.55 | 1677.82 | 31744.0 |
| 2009-06-29 10:00:00 | NQ | Futures | 1677.25 | 1689.21 | 1670.98 | 1686.65 | 46364.0 |
| 2009-06-29 11:00:00 | NQ | Futures | 1686.65 | 1697.47 | 1684.94 | 1697.19 | 31007.0 |
| 2009-06-29 12:00:00 | NQ | Futures | 1697.19 | 1700.32 | 1692.91 | 1693.2 | 18981.0 |
| 2009-06-29 13:00:00 | NQ | Futures | 1692.91 | 1695.48 | 1687.22 | 1689.78 | 15417.0 |
| 2009-06-29 14:00:00 | NQ | Futures | 1689.78 | 1691.2 | 1685.51 | 1690.63 | 18493.0 |
| 2009-06-29 15:00:00 | NQ | Futures | 1690.35 | 1692.91 | 1683.23 | 1686.08 | 30914.0 |
| 2009-06-29 16:00:00 | NQ | Futures | 1686.65 | 1689.78 | 1685.22 | 1687.79 | 8137.0 |
| 2009-06-29 17:00:00 | NQ | Futures | 1687.79 | 1688.64 | 1687.5 | 1687.79 | 136.0 |
| 2009-06-29 18:00:00 | NQ | Futures | 1687.79 | 1688.36 | 1686.36 | 1688.07 | 281.0 |
| 2009-06-29 19:00:00 | NQ | Futures | 1688.07 | 1689.21 | 1686.93 | 1687.22 | 121.0 |
| 2009-06-29 20:00:00 | NQ | Futures | 1687.5 | 1690.07 | 1687.22 | 1689.5 | 212.0 |
| 2009-06-29 21:00:00 | NQ | Futures | 1688.64 | 1690.63 | 1688.64 | 1689.78 | 242.0 |
| 2009-06-29 22:00:00 | NQ | Futures | 1689.21 | 1690.35 | 1689.21 | 1689.78 | 86.0 |
| 2009-06-29 23:00:00 | NQ | Futures | 1689.5 | 1689.78 | 1687.5 | 1687.5 | 50.0 |
| 2009-06-29 00:00:00 | YM | Futures | 7727.2 | 7729.1 | 7705.9 | 7707.8 | 277.0 |
| 2009-06-29 01:00:00 | YM | Futures | 7705.9 | 7707.8 | 7693.0 | 7694.8 | 286.0 |
> showing 50 of 1,255 rows — these rows as CSV