PREVIEW / futures_1hour / 2009-07-10
file: by_date/futures_1hour/2009/2009-07-10.parquet size: 36 KB rows: 1,027
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-07-10 00:00:00 | ES | Futures | 845.77 | 846.25 | 845.05 | 845.53 | 1269.0 |
| 2009-07-10 01:00:00 | ES | Futures | 845.77 | 846.01 | 845.29 | 845.77 | 1025.0 |
| 2009-07-10 02:00:00 | ES | Futures | 845.77 | 846.01 | 844.56 | 845.53 | 7017.0 |
| 2009-07-10 03:00:00 | ES | Futures | 845.53 | 846.01 | 843.84 | 844.8 | 14329.0 |
| 2009-07-10 04:00:00 | ES | Futures | 844.56 | 846.97 | 844.32 | 845.77 | 8924.0 |
| 2009-07-10 05:00:00 | ES | Futures | 845.53 | 845.77 | 842.87 | 843.36 | 12802.0 |
| 2009-07-10 06:00:00 | ES | Futures | 843.12 | 843.36 | 840.95 | 841.43 | 16182.0 |
| 2009-07-10 07:00:00 | ES | Futures | 841.43 | 842.39 | 839.98 | 840.46 | 20163.0 |
| 2009-07-10 08:00:00 | ES | Futures | 840.7 | 842.63 | 839.74 | 841.67 | 29937.0 |
| 2009-07-10 09:00:00 | ES | Futures | 841.67 | 849.14 | 840.7 | 844.32 | 325132.0 |
| 2009-07-10 10:00:00 | ES | Futures | 844.32 | 847.94 | 841.67 | 844.56 | 344327.0 |
| 2009-07-10 11:00:00 | ES | Futures | 844.56 | 844.8 | 838.05 | 839.98 | 271540.0 |
| 2009-07-10 12:00:00 | ES | Futures | 839.98 | 844.8 | 839.5 | 843.36 | 146740.0 |
| 2009-07-10 13:00:00 | ES | Futures | 843.12 | 845.77 | 842.63 | 844.8 | 120858.0 |
| 2009-07-10 14:00:00 | ES | Futures | 844.8 | 845.05 | 841.19 | 842.15 | 146586.0 |
| 2009-07-10 15:00:00 | ES | Futures | 842.15 | 846.73 | 841.43 | 843.84 | 261496.0 |
| 2009-07-10 16:00:00 | ES | Futures | 843.84 | 844.8 | 842.39 | 843.36 | 78327.0 |
| 2009-07-10 00:00:00 | NQ | Futures | 1605.76 | 1607.19 | 1605.48 | 1606.05 | 119.0 |
| 2009-07-10 01:00:00 | NQ | Futures | 1605.48 | 1605.76 | 1605.19 | 1605.48 | 78.0 |
| 2009-07-10 02:00:00 | NQ | Futures | 1605.19 | 1605.48 | 1603.77 | 1604.91 | 252.0 |
| 2009-07-10 03:00:00 | NQ | Futures | 1604.91 | 1605.19 | 1602.34 | 1604.05 | 622.0 |
| 2009-07-10 04:00:00 | NQ | Futures | 1604.05 | 1606.62 | 1603.2 | 1605.19 | 669.0 |
| 2009-07-10 05:00:00 | NQ | Futures | 1605.19 | 1605.48 | 1600.63 | 1601.2 | 886.0 |
| 2009-07-10 06:00:00 | NQ | Futures | 1601.2 | 1602.06 | 1598.93 | 1600.63 | 1758.0 |
| 2009-07-10 07:00:00 | NQ | Futures | 1600.35 | 1603.77 | 1599.78 | 1600.06 | 2389.0 |
| 2009-07-10 08:00:00 | NQ | Futures | 1600.35 | 1603.48 | 1599.78 | 1602.34 | 3434.0 |
| 2009-07-10 09:00:00 | NQ | Futures | 1602.34 | 1625.13 | 1600.92 | 1618.86 | 56592.0 |
| 2009-07-10 10:00:00 | NQ | Futures | 1618.86 | 1623.42 | 1612.88 | 1616.3 | 45975.0 |
| 2009-07-10 11:00:00 | NQ | Futures | 1616.3 | 1616.3 | 1598.07 | 1606.62 | 43570.0 |
| 2009-07-10 12:00:00 | NQ | Futures | 1606.33 | 1614.31 | 1605.48 | 1611.46 | 16344.0 |
| 2009-07-10 13:00:00 | NQ | Futures | 1611.46 | 1618.01 | 1610.03 | 1615.44 | 15540.0 |
| 2009-07-10 14:00:00 | NQ | Futures | 1615.44 | 1615.73 | 1608.61 | 1611.17 | 17143.0 |
| 2009-07-10 15:00:00 | NQ | Futures | 1610.89 | 1617.72 | 1610.32 | 1614.88 | 35498.0 |
| 2009-07-10 16:00:00 | NQ | Futures | 1614.59 | 1615.73 | 1611.17 | 1612.88 | 8349.0 |
| 2009-07-10 00:00:00 | YM | Futures | 7504.4 | 7507.1 | 7499.7 | 7503.4 | 101.0 |
| 2009-07-10 01:00:00 | YM | Futures | 7504.4 | 7505.3 | 7498.8 | 7500.7 | 129.0 |
| 2009-07-10 02:00:00 | YM | Futures | 7500.7 | 7501.6 | 7491.4 | 7500.7 | 332.0 |
| 2009-07-10 03:00:00 | YM | Futures | 7499.7 | 7501.6 | 7485.9 | 7491.4 | 1018.0 |
| 2009-07-10 04:00:00 | YM | Futures | 7489.6 | 7508.1 | 7489.6 | 7499.7 | 620.0 |
| 2009-07-10 05:00:00 | YM | Futures | 7499.7 | 7501.6 | 7473.9 | 7477.6 | 720.0 |
| 2009-07-10 06:00:00 | YM | Futures | 7477.6 | 7480.3 | 7459.1 | 7461.8 | 942.0 |
| 2009-07-10 07:00:00 | YM | Futures | 7462.8 | 7468.3 | 7449.8 | 7455.4 | 1016.0 |
| 2009-07-10 08:00:00 | YM | Futures | 7456.3 | 7474.8 | 7451.7 | 7469.2 | 2209.0 |
| 2009-07-10 09:00:00 | YM | Futures | 7469.2 | 7521.0 | 7460.0 | 7484.9 | 21358.0 |
| 2009-07-10 10:00:00 | YM | Futures | 7484.9 | 7513.6 | 7464.6 | 7474.8 | 23947.0 |
| 2009-07-10 11:00:00 | YM | Futures | 7473.9 | 7474.8 | 7435.0 | 7449.8 | 15565.0 |
| 2009-07-10 12:00:00 | YM | Futures | 7448.9 | 7483.1 | 7446.1 | 7470.2 | 7962.0 |
| 2009-07-10 13:00:00 | YM | Futures | 7470.2 | 7487.7 | 7460.0 | 7478.5 | 6842.0 |
| 2009-07-10 14:00:00 | YM | Futures | 7477.6 | 7477.6 | 7449.8 | 7455.4 | 8794.0 |
| 2009-07-10 15:00:00 | YM | Futures | 7454.4 | 7501.6 | 7450.7 | 7477.6 | 17370.0 |
> showing 50 of 1,027 rows — these rows as CSV