PREVIEW / futures_1hour / 2010-02-28
file: by_date/futures_1hour/2010/2010-02-28.parquet size: 13 KB rows: 229
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-02-28 18:00:00 | ES | Futures | 1075.69 | 1080.31 | 1075.69 | 1079.1 | 13495.0 |
| 2010-02-28 19:00:00 | ES | Futures | 1078.85 | 1079.58 | 1078.12 | 1078.37 | 4868.0 |
| 2010-02-28 20:00:00 | ES | Futures | 1078.37 | 1078.37 | 1075.45 | 1076.66 | 13030.0 |
| 2010-02-28 21:00:00 | ES | Futures | 1076.66 | 1077.64 | 1075.93 | 1076.91 | 4899.0 |
| 2010-02-28 22:00:00 | ES | Futures | 1076.66 | 1078.37 | 1076.66 | 1077.88 | 3233.0 |
| 2010-02-28 23:00:00 | ES | Futures | 1077.88 | 1078.61 | 1077.64 | 1078.37 | 1877.0 |
| 2010-02-28 18:00:00 | NQ | Futures | 2080.81 | 2090.52 | 2080.81 | 2088.81 | 1204.0 |
| 2010-02-28 19:00:00 | NQ | Futures | 2088.81 | 2089.95 | 2087.38 | 2087.66 | 363.0 |
| 2010-02-28 20:00:00 | NQ | Futures | 2087.38 | 2087.38 | 2084.52 | 2086.52 | 1566.0 |
| 2010-02-28 21:00:00 | NQ | Futures | 2086.52 | 2087.38 | 2084.81 | 2086.81 | 389.0 |
| 2010-02-28 22:00:00 | NQ | Futures | 2087.09 | 2088.52 | 2086.81 | 2088.23 | 277.0 |
| 2010-02-28 23:00:00 | NQ | Futures | 2088.52 | 2089.09 | 2087.66 | 2088.81 | 132.0 |
| 2010-02-28 18:00:00 | YM | Futures | 9661.3 | 9701.6 | 9661.3 | 9688.5 | 659.0 |
| 2010-02-28 19:00:00 | YM | Futures | 9692.2 | 9698.8 | 9687.5 | 9690.3 | 371.0 |
| 2010-02-28 20:00:00 | YM | Futures | 9691.3 | 9691.3 | 9665.1 | 9678.2 | 666.0 |
| 2010-02-28 21:00:00 | YM | Futures | 9679.1 | 9682.8 | 9671.6 | 9681.0 | 312.0 |
| 2010-02-28 22:00:00 | YM | Futures | 9681.0 | 9692.2 | 9681.0 | 9690.3 | 203.0 |
| 2010-02-28 23:00:00 | YM | Futures | 9689.4 | 9694.1 | 9686.6 | 9692.2 | 102.0 |
| 2010-02-28 18:00:00 | CL | Futures | 169.88 | 170.69 | 169.5 | 170.69 | 1965.0 |
| 2010-02-28 19:00:00 | CL | Futures | 170.67 | 171.52 | 170.52 | 171.05 | 2759.0 |
| 2010-02-28 20:00:00 | CL | Futures | 171.05 | 171.22 | 170.42 | 170.46 | 2210.0 |
| 2010-02-28 21:00:00 | CL | Futures | 170.48 | 170.71 | 170.33 | 170.59 | 677.0 |
| 2010-02-28 22:00:00 | CL | Futures | 170.59 | 170.63 | 170.37 | 170.54 | 331.0 |
| 2010-02-28 23:00:00 | CL | Futures | 170.52 | 170.71 | 170.35 | 170.67 | 375.0 |
| 2010-02-28 18:00:00 | GC | Futures | 1575.4 | 1577.8 | 1572.2 | 1573.8 | 2807.0 |
| 2010-02-28 19:00:00 | GC | Futures | 1574.0 | 1577.2 | 1573.6 | 1575.3 | 2279.0 |
| 2010-02-28 20:00:00 | GC | Futures | 1575.1 | 1575.5 | 1570.5 | 1571.0 | 3303.0 |
| 2010-02-28 21:00:00 | GC | Futures | 1571.0 | 1573.0 | 1570.9 | 1572.0 | 1363.0 |
| 2010-02-28 22:00:00 | GC | Futures | 1572.0 | 1574.6 | 1570.8 | 1574.0 | 1110.0 |
| 2010-02-28 23:00:00 | GC | Futures | 1574.0 | 1574.1 | 1572.2 | 1573.0 | 714.0 |
| 2010-02-28 18:00:00 | ZN | Futures | 96.380284 | 96.43105 | 96.367592 | 96.405667 | 1981.0 |
| 2010-02-28 19:00:00 | ZN | Futures | 96.405667 | 96.418359 | 96.392975 | 96.418359 | 322.0 |
| 2010-02-28 20:00:00 | ZN | Futures | 96.418359 | 96.443742 | 96.392975 | 96.443742 | 422.0 |
| 2010-02-28 21:00:00 | ZN | Futures | 96.443742 | 96.456434 | 96.43105 | 96.43105 | 109.0 |
| 2010-02-28 22:00:00 | ZN | Futures | 96.43105 | 96.43105 | 96.43105 | 96.43105 | 36.0 |
| 2010-02-28 23:00:00 | ZN | Futures | 96.418359 | 96.418359 | 96.405667 | 96.405667 | 231.0 |
> showing 36 of 229 rows — these rows as CSV