PREVIEW / futures_30min / 2008-07-20
file: by_date/futures_30min/2008/2008-07-20.parquet size: 17 KB rows: 385
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-20 18:00:00 | ES | Futures | 1170.68 | 1172.3 | 1170.68 | 1172.07 | 6423.0 |
| 2008-07-20 18:30:00 | ES | Futures | 1172.07 | 1172.54 | 1171.61 | 1172.3 | 1475.0 |
| 2008-07-20 19:00:00 | ES | Futures | 1172.3 | 1172.54 | 1171.37 | 1171.61 | 2224.0 |
| 2008-07-20 19:30:00 | ES | Futures | 1171.61 | 1172.07 | 1171.37 | 1171.37 | 4600.0 |
| 2008-07-20 20:00:00 | ES | Futures | 1171.37 | 1171.61 | 1171.37 | 1171.37 | 767.0 |
| 2008-07-20 20:30:00 | ES | Futures | 1171.37 | 1171.61 | 1170.21 | 1170.21 | 1994.0 |
| 2008-07-20 21:00:00 | ES | Futures | 1170.21 | 1170.44 | 1169.75 | 1170.44 | 878.0 |
| 2008-07-20 21:30:00 | ES | Futures | 1170.21 | 1171.37 | 1169.51 | 1170.68 | 1437.0 |
| 2008-07-20 22:00:00 | ES | Futures | 1170.68 | 1171.84 | 1170.44 | 1171.84 | 955.0 |
| 2008-07-20 22:30:00 | ES | Futures | 1171.84 | 1173.23 | 1171.61 | 1173.0 | 1095.0 |
| 2008-07-20 23:00:00 | ES | Futures | 1172.77 | 1173.7 | 1172.07 | 1173.7 | 758.0 |
| 2008-07-20 23:30:00 | ES | Futures | 1173.47 | 1173.93 | 1173.0 | 1173.0 | 596.0 |
| 2008-07-20 18:00:00 | NQ | Futures | 2056.5 | 2059.32 | 2056.5 | 2059.32 | 116.0 |
| 2008-07-20 18:30:00 | NQ | Futures | 2059.32 | 2059.88 | 2058.19 | 2059.6 | 66.0 |
| 2008-07-20 19:00:00 | NQ | Futures | 2059.32 | 2059.32 | 2056.78 | 2056.78 | 58.0 |
| 2008-07-20 19:30:00 | NQ | Futures | 2057.06 | 2057.91 | 2057.06 | 2057.91 | 24.0 |
| 2008-07-20 20:00:00 | NQ | Futures | 2057.91 | 2058.75 | 2057.91 | 2058.19 | 13.0 |
| 2008-07-20 20:30:00 | NQ | Futures | 2057.91 | 2057.91 | 2056.22 | 2056.22 | 72.0 |
| 2008-07-20 21:00:00 | NQ | Futures | 2055.94 | 2055.94 | 2054.25 | 2055.66 | 175.0 |
| 2008-07-20 21:30:00 | NQ | Futures | 2054.81 | 2056.5 | 2053.13 | 2056.5 | 47.0 |
| 2008-07-20 22:00:00 | NQ | Futures | 2054.81 | 2056.78 | 2054.81 | 2056.22 | 49.0 |
| 2008-07-20 22:30:00 | NQ | Futures | 2056.5 | 2058.47 | 2056.5 | 2057.35 | 173.0 |
| 2008-07-20 23:00:00 | NQ | Futures | 2056.78 | 2058.47 | 2056.5 | 2058.47 | 23.0 |
| 2008-07-20 23:30:00 | NQ | Futures | 2058.47 | 2058.75 | 2057.35 | 2058.75 | 22.0 |
| 2008-07-20 18:00:00 | YM | Futures | 10439.3 | 10453.0 | 10439.3 | 10450.2 | 165.0 |
| 2008-07-20 18:30:00 | YM | Futures | 10453.0 | 10461.1 | 10451.1 | 10453.9 | 147.0 |
| 2008-07-20 19:00:00 | YM | Futures | 10453.9 | 10456.6 | 10447.5 | 10449.3 | 84.0 |
| 2008-07-20 19:30:00 | YM | Futures | 10450.2 | 10453.9 | 10447.5 | 10447.5 | 45.0 |
| 2008-07-20 20:00:00 | YM | Futures | 10447.5 | 10450.2 | 10447.5 | 10448.4 | 37.0 |
| 2008-07-20 20:30:00 | YM | Futures | 10446.6 | 10450.2 | 10440.2 | 10443.0 | 102.0 |
| 2008-07-20 21:00:00 | YM | Futures | 10440.2 | 10443.9 | 10437.5 | 10442.1 | 70.0 |
| 2008-07-20 21:30:00 | YM | Futures | 10439.3 | 10451.1 | 10437.5 | 10447.5 | 82.0 |
| 2008-07-20 22:00:00 | YM | Futures | 10444.8 | 10453.9 | 10444.8 | 10452.1 | 128.0 |
| 2008-07-20 22:30:00 | YM | Futures | 10453.0 | 10463.0 | 10453.0 | 10460.2 | 103.0 |
| 2008-07-20 23:00:00 | YM | Futures | 10460.2 | 10465.7 | 10455.7 | 10465.7 | 95.0 |
| 2008-07-20 23:30:00 | YM | Futures | 10465.7 | 10470.2 | 10463.0 | 10467.5 | 91.0 |
| 2008-07-20 18:00:00 | CL | Futures | 489.63 | 494.09 | 489.29 | 493.57 | 436.0 |
| 2008-07-20 18:30:00 | CL | Futures | 493.64 | 494.43 | 493.49 | 493.6 | 357.0 |
| 2008-07-20 19:00:00 | CL | Futures | 493.79 | 493.79 | 492.39 | 492.47 | 175.0 |
| 2008-07-20 19:30:00 | CL | Futures | 492.58 | 493.15 | 492.47 | 493.0 | 78.0 |
| 2008-07-20 20:00:00 | CL | Futures | 493.0 | 493.0 | 492.39 | 492.7 | 46.0 |
| 2008-07-20 20:30:00 | CL | Futures | 492.85 | 492.88 | 492.24 | 492.51 | 69.0 |
| 2008-07-20 21:00:00 | CL | Futures | 492.39 | 492.73 | 492.28 | 492.32 | 77.0 |
| 2008-07-20 21:30:00 | CL | Futures | 492.2 | 492.54 | 491.49 | 491.94 | 270.0 |
| 2008-07-20 22:00:00 | CL | Futures | 492.01 | 493.04 | 492.01 | 492.51 | 65.0 |
| 2008-07-20 22:30:00 | CL | Futures | 492.24 | 492.58 | 492.13 | 492.13 | 24.0 |
| 2008-07-20 23:00:00 | CL | Futures | 491.83 | 492.43 | 491.64 | 492.28 | 37.0 |
| 2008-07-20 23:30:00 | CL | Futures | 492.24 | 492.81 | 492.24 | 492.81 | 58.0 |
| 2008-07-20 18:00:00 | GC | Futures | 1380.0 | 1383.3 | 1378.1 | 1380.5 | 306.0 |
| 2008-07-20 18:30:00 | GC | Futures | 1380.2 | 1380.2 | 1377.6 | 1378.8 | 107.0 |
> showing 50 of 385 rows — these rows as CSV