PREVIEW / futures_1hour / 2010-03-07
file: by_date/futures_1hour/2010/2010-03-07.parquet size: 13 KB rows: 236
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-03-07 18:00:00 | ES | Futures | 1105.61 | 1106.83 | 1105.12 | 1106.58 | 7127.0 |
| 2010-03-07 19:00:00 | ES | Futures | 1106.34 | 1107.07 | 1105.37 | 1105.61 | 5408.0 |
| 2010-03-07 20:00:00 | ES | Futures | 1105.61 | 1106.83 | 1105.37 | 1106.34 | 3663.0 |
| 2010-03-07 21:00:00 | ES | Futures | 1106.1 | 1107.8 | 1106.1 | 1106.83 | 3974.0 |
| 2010-03-07 22:00:00 | ES | Futures | 1106.58 | 1107.56 | 1106.58 | 1106.83 | 2477.0 |
| 2010-03-07 23:00:00 | ES | Futures | 1106.83 | 1107.8 | 1106.83 | 1107.56 | 2223.0 |
| 2010-03-07 18:00:00 | NQ | Futures | 2152.5 | 2157.36 | 2152.5 | 2157.07 | 642.0 |
| 2010-03-07 19:00:00 | NQ | Futures | 2157.07 | 2158.21 | 2155.07 | 2155.36 | 419.0 |
| 2010-03-07 20:00:00 | NQ | Futures | 2155.07 | 2156.79 | 2154.79 | 2156.21 | 198.0 |
| 2010-03-07 21:00:00 | NQ | Futures | 2155.93 | 2157.93 | 2155.93 | 2156.5 | 166.0 |
| 2010-03-07 22:00:00 | NQ | Futures | 2156.79 | 2157.64 | 2154.79 | 2155.64 | 365.0 |
| 2010-03-07 23:00:00 | NQ | Futures | 2155.64 | 2156.5 | 2154.21 | 2155.64 | 653.0 |
| 2010-03-07 18:00:00 | YM | Futures | 9867.2 | 9871.9 | 9859.7 | 9870.9 | 275.0 |
| 2010-03-07 19:00:00 | YM | Futures | 9870.9 | 9876.6 | 9863.5 | 9866.3 | 372.0 |
| 2010-03-07 20:00:00 | YM | Futures | 9866.3 | 9872.8 | 9865.3 | 9870.9 | 163.0 |
| 2010-03-07 21:00:00 | YM | Futures | 9870.0 | 9882.2 | 9870.0 | 9872.8 | 393.0 |
| 2010-03-07 22:00:00 | YM | Futures | 9873.7 | 9876.6 | 9871.9 | 9871.9 | 203.0 |
| 2010-03-07 23:00:00 | YM | Futures | 9871.9 | 9880.3 | 9871.9 | 9877.5 | 198.0 |
| 2010-03-07 18:00:00 | CL | Futures | 174.03 | 174.31 | 173.84 | 174.12 | 1146.0 |
| 2010-03-07 19:00:00 | CL | Futures | 174.08 | 174.27 | 174.03 | 174.12 | 391.0 |
| 2010-03-07 20:00:00 | CL | Futures | 174.12 | 174.29 | 173.97 | 174.22 | 712.0 |
| 2010-03-07 21:00:00 | CL | Futures | 174.22 | 174.56 | 174.22 | 174.42 | 763.0 |
| 2010-03-07 22:00:00 | CL | Futures | 174.44 | 174.5 | 174.33 | 174.42 | 319.0 |
| 2010-03-07 23:00:00 | CL | Futures | 174.39 | 174.52 | 174.31 | 174.35 | 296.0 |
| 2010-03-07 18:00:00 | GC | Futures | 1599.3 | 1602.0 | 1597.9 | 1598.2 | 2058.0 |
| 2010-03-07 19:00:00 | GC | Futures | 1597.9 | 1599.6 | 1596.0 | 1597.2 | 1819.0 |
| 2010-03-07 20:00:00 | GC | Futures | 1597.4 | 1598.9 | 1594.5 | 1598.1 | 2591.0 |
| 2010-03-07 21:00:00 | GC | Futures | 1598.1 | 1598.9 | 1597.5 | 1598.3 | 791.0 |
| 2010-03-07 22:00:00 | GC | Futures | 1598.3 | 1598.8 | 1596.4 | 1596.8 | 1351.0 |
| 2010-03-07 23:00:00 | GC | Futures | 1596.8 | 1598.6 | 1596.0 | 1598.1 | 1090.0 |
| 2010-03-07 18:00:00 | ZN | Futures | 96.253367 | 96.253367 | 96.253367 | 96.253367 | 1.0 |
| 2010-03-07 19:00:00 | ZN | Futures | 96.177218 | 96.202601 | 96.177218 | 96.202601 | 12.0 |
| 2010-03-07 20:00:00 | ZN | Futures | 96.177218 | 96.177218 | 96.177218 | 96.177218 | 56.0 |
| 2010-03-07 21:00:00 | ZN | Futures | 96.164526 | 96.164526 | 96.126451 | 96.151834 | 122.0 |
| 2010-03-07 22:00:00 | ZN | Futures | 96.151834 | 96.151834 | 96.151834 | 96.151834 | 5.0 |
| 2010-03-07 23:00:00 | ZN | Futures | 96.151834 | 96.151834 | 96.139143 | 96.139143 | 76.0 |
> showing 36 of 236 rows — these rows as CSV