PREVIEW / futures_1hour / 2010-04-11
file: by_date/futures_1hour/2010/2010-04-11.parquet size: 13 KB rows: 252
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 |
|---|---|---|---|---|---|---|---|
| 2010-04-11 18:00:00 | ES | Futures | 1168.11 | 1171.78 | 1168.11 | 1170.56 | 20924.0 |
| 2010-04-11 19:00:00 | ES | Futures | 1170.56 | 1171.29 | 1170.31 | 1171.05 | 5294.0 |
| 2010-04-11 20:00:00 | ES | Futures | 1171.05 | 1171.29 | 1170.31 | 1170.8 | 5017.0 |
| 2010-04-11 21:00:00 | ES | Futures | 1170.8 | 1171.05 | 1170.07 | 1170.31 | 4805.0 |
| 2010-04-11 22:00:00 | ES | Futures | 1170.31 | 1170.56 | 1169.82 | 1170.07 | 3245.0 |
| 2010-04-11 23:00:00 | ES | Futures | 1170.07 | 1170.31 | 1169.58 | 1170.07 | 1447.0 |
| 2010-04-11 18:00:00 | NQ | Futures | 2285.25 | 2292.41 | 2284.97 | 2290.12 | 2086.0 |
| 2010-04-11 19:00:00 | NQ | Futures | 2290.12 | 2292.41 | 2290.12 | 2292.13 | 681.0 |
| 2010-04-11 20:00:00 | NQ | Futures | 2292.13 | 2292.99 | 2290.98 | 2292.41 | 598.0 |
| 2010-04-11 21:00:00 | NQ | Futures | 2292.13 | 2292.13 | 2290.41 | 2290.41 | 287.0 |
| 2010-04-11 22:00:00 | NQ | Futures | 2290.69 | 2290.98 | 2289.84 | 2289.84 | 162.0 |
| 2010-04-11 23:00:00 | NQ | Futures | 2290.12 | 2290.12 | 2288.98 | 2289.84 | 132.0 |
| 2010-04-11 18:00:00 | YM | Futures | 10322.5 | 10353.6 | 10322.5 | 10344.2 | 1692.0 |
| 2010-04-11 19:00:00 | YM | Futures | 10342.3 | 10351.7 | 10342.3 | 10348.0 | 414.0 |
| 2010-04-11 20:00:00 | YM | Futures | 10348.0 | 10353.6 | 10345.1 | 10351.7 | 437.0 |
| 2010-04-11 21:00:00 | YM | Futures | 10351.7 | 10351.7 | 10344.2 | 10346.1 | 355.0 |
| 2010-04-11 22:00:00 | YM | Futures | 10345.1 | 10345.1 | 10339.5 | 10341.4 | 182.0 |
| 2010-04-11 23:00:00 | YM | Futures | 10342.3 | 10344.2 | 10336.7 | 10338.5 | 375.0 |
| 2010-04-11 18:00:00 | CL | Futures | 180.27 | 181.28 | 180.27 | 181.07 | 1449.0 |
| 2010-04-11 19:00:00 | CL | Futures | 181.05 | 181.41 | 181.05 | 181.14 | 1048.0 |
| 2010-04-11 20:00:00 | CL | Futures | 181.12 | 181.22 | 180.97 | 181.14 | 846.0 |
| 2010-04-11 21:00:00 | CL | Futures | 181.18 | 181.22 | 180.78 | 180.82 | 873.0 |
| 2010-04-11 22:00:00 | CL | Futures | 180.82 | 180.97 | 180.54 | 180.9 | 807.0 |
| 2010-04-11 23:00:00 | CL | Futures | 180.9 | 181.12 | 180.44 | 180.88 | 819.0 |
| 2010-04-11 18:00:00 | GC | Futures | 1639.9 | 1646.1 | 1638.6 | 1640.9 | 4261.0 |
| 2010-04-11 19:00:00 | GC | Futures | 1641.0 | 1646.1 | 1640.0 | 1640.7 | 3020.0 |
| 2010-04-11 20:00:00 | GC | Futures | 1640.9 | 1641.4 | 1638.8 | 1640.6 | 1574.0 |
| 2010-04-11 21:00:00 | GC | Futures | 1640.5 | 1640.6 | 1638.1 | 1640.2 | 1460.0 |
| 2010-04-11 22:00:00 | GC | Futures | 1640.2 | 1640.7 | 1638.9 | 1640.0 | 990.0 |
| 2010-04-11 23:00:00 | GC | Futures | 1639.9 | 1640.6 | 1639.0 | 1640.2 | 735.0 |
| 2010-04-11 18:00:00 | ZN | Futures | 95.239804 | 95.252652 | 95.124175 | 95.124175 | 7179.0 |
| 2010-04-11 19:00:00 | ZN | Futures | 95.124175 | 95.162718 | 95.09848 | 95.124175 | 4636.0 |
| 2010-04-11 20:00:00 | ZN | Futures | 95.124175 | 95.124175 | 95.085632 | 95.111327 | 5193.0 |
| 2010-04-11 21:00:00 | ZN | Futures | 95.124175 | 95.137023 | 95.085632 | 95.09848 | 2264.0 |
| 2010-04-11 22:00:00 | ZN | Futures | 95.09848 | 95.14987 | 95.09848 | 95.124175 | 2757.0 |
| 2010-04-11 23:00:00 | ZN | Futures | 95.124175 | 95.137023 | 95.111327 | 95.111327 | 855.0 |
> showing 36 of 252 rows — these rows as CSV