PREVIEW / futures_30min / 2008-08-10
file: by_date/futures_30min/2008/2008-08-10.parquet size: 18 KB rows: 424
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-08-10 18:00:00 | ES | Futures | 1200.66 | 1201.12 | 1199.26 | 1200.43 | 3465.0 |
| 2008-08-10 18:30:00 | ES | Futures | 1200.43 | 1200.89 | 1200.19 | 1200.43 | 542.0 |
| 2008-08-10 19:00:00 | ES | Futures | 1200.66 | 1201.12 | 1199.73 | 1200.43 | 882.0 |
| 2008-08-10 19:30:00 | ES | Futures | 1200.19 | 1200.89 | 1199.96 | 1200.66 | 628.0 |
| 2008-08-10 20:00:00 | ES | Futures | 1200.66 | 1202.05 | 1200.66 | 1201.82 | 1885.0 |
| 2008-08-10 20:30:00 | ES | Futures | 1201.82 | 1201.82 | 1199.5 | 1200.43 | 1066.0 |
| 2008-08-10 21:00:00 | ES | Futures | 1200.43 | 1200.66 | 1198.8 | 1199.03 | 1369.0 |
| 2008-08-10 21:30:00 | ES | Futures | 1199.26 | 1199.26 | 1198.8 | 1198.8 | 1002.0 |
| 2008-08-10 22:00:00 | ES | Futures | 1199.03 | 1199.26 | 1198.33 | 1199.03 | 627.0 |
| 2008-08-10 22:30:00 | ES | Futures | 1199.03 | 1199.26 | 1198.57 | 1198.8 | 188.0 |
| 2008-08-10 23:00:00 | ES | Futures | 1199.03 | 1199.26 | 1198.8 | 1199.03 | 203.0 |
| 2008-08-10 23:30:00 | ES | Futures | 1199.03 | 1200.19 | 1199.03 | 1200.19 | 541.0 |
| 2008-08-10 18:00:00 | NQ | Futures | 2161.42 | 2162.55 | 2159.74 | 2162.55 | 480.0 |
| 2008-08-10 18:30:00 | NQ | Futures | 2162.55 | 2163.39 | 2161.42 | 2163.39 | 31.0 |
| 2008-08-10 19:00:00 | NQ | Futures | 2162.27 | 2162.55 | 2161.42 | 2161.42 | 118.0 |
| 2008-08-10 19:30:00 | NQ | Futures | 2162.55 | 2162.55 | 2161.42 | 2162.27 | 15.0 |
| 2008-08-10 20:00:00 | NQ | Futures | 2161.99 | 2164.8 | 2161.99 | 2164.52 | 69.0 |
| 2008-08-10 20:30:00 | NQ | Futures | 2164.8 | 2164.8 | 2161.42 | 2162.55 | 113.0 |
| 2008-08-10 21:00:00 | NQ | Futures | 2162.55 | 2163.39 | 2161.42 | 2161.42 | 179.0 |
| 2008-08-10 21:30:00 | NQ | Futures | 2161.14 | 2161.42 | 2160.02 | 2160.02 | 18.0 |
| 2008-08-10 22:00:00 | NQ | Futures | 2160.02 | 2160.02 | 2158.89 | 2160.02 | 44.0 |
| 2008-08-10 22:30:00 | NQ | Futures | 2161.42 | 2161.42 | 2160.02 | 2160.02 | 15.0 |
| 2008-08-10 23:00:00 | NQ | Futures | 2160.3 | 2161.14 | 2158.89 | 2160.86 | 71.0 |
| 2008-08-10 23:30:00 | NQ | Futures | 2159.74 | 2161.42 | 2159.74 | 2161.42 | 29.0 |
| 2008-08-10 18:00:00 | YM | Futures | 10621.1 | 10631.1 | 10608.4 | 10609.3 | 91.0 |
| 2008-08-10 18:30:00 | YM | Futures | 10611.1 | 10614.7 | 10610.2 | 10613.8 | 45.0 |
| 2008-08-10 19:00:00 | YM | Futures | 10611.1 | 10618.4 | 10610.2 | 10611.1 | 18.0 |
| 2008-08-10 19:30:00 | YM | Futures | 10613.8 | 10615.7 | 10611.1 | 10615.7 | 21.0 |
| 2008-08-10 20:00:00 | YM | Futures | 10614.7 | 10623.8 | 10614.7 | 10623.8 | 69.0 |
| 2008-08-10 20:30:00 | YM | Futures | 10624.7 | 10625.6 | 10608.4 | 10612.9 | 54.0 |
| 2008-08-10 21:00:00 | YM | Futures | 10612.9 | 10617.5 | 10603.8 | 10604.7 | 106.0 |
| 2008-08-10 21:30:00 | YM | Futures | 10603.8 | 10605.7 | 10601.1 | 10602.9 | 60.0 |
| 2008-08-10 22:00:00 | YM | Futures | 10603.8 | 10603.8 | 10599.3 | 10602.9 | 34.0 |
| 2008-08-10 22:30:00 | YM | Futures | 10602.0 | 10602.0 | 10599.3 | 10602.0 | 18.0 |
| 2008-08-10 23:00:00 | YM | Futures | 10602.0 | 10605.7 | 10598.4 | 10602.9 | 22.0 |
| 2008-08-10 23:30:00 | YM | Futures | 10605.7 | 10609.3 | 10602.9 | 10607.5 | 31.0 |
| 2008-08-10 18:00:00 | CL | Futures | 435.57 | 440.06 | 435.57 | 439.16 | 1319.0 |
| 2008-08-10 18:30:00 | CL | Futures | 439.04 | 439.16 | 437.95 | 438.06 | 302.0 |
| 2008-08-10 19:00:00 | CL | Futures | 438.21 | 440.18 | 438.21 | 439.95 | 555.0 |
| 2008-08-10 19:30:00 | CL | Futures | 440.06 | 440.48 | 438.55 | 438.55 | 367.0 |
| 2008-08-10 20:00:00 | CL | Futures | 438.63 | 438.78 | 436.89 | 437.15 | 443.0 |
| 2008-08-10 20:30:00 | CL | Futures | 437.19 | 440.03 | 437.19 | 439.65 | 353.0 |
| 2008-08-10 21:00:00 | CL | Futures | 439.35 | 440.48 | 439.27 | 439.65 | 176.0 |
| 2008-08-10 21:30:00 | CL | Futures | 439.57 | 440.06 | 439.38 | 439.95 | 197.0 |
| 2008-08-10 22:00:00 | CL | Futures | 439.91 | 440.18 | 439.08 | 439.16 | 177.0 |
| 2008-08-10 22:30:00 | CL | Futures | 439.31 | 440.48 | 438.97 | 440.48 | 446.0 |
| 2008-08-10 23:00:00 | CL | Futures | 440.44 | 441.12 | 440.22 | 440.86 | 249.0 |
| 2008-08-10 23:30:00 | CL | Futures | 440.97 | 441.39 | 440.48 | 441.09 | 339.0 |
| 2008-08-10 18:00:00 | GC | Futures | 1232.3 | 1239.1 | 1230.8 | 1238.8 | 871.0 |
| 2008-08-10 18:30:00 | GC | Futures | 1239.0 | 1240.5 | 1237.0 | 1239.1 | 427.0 |
> showing 50 of 424 rows — these rows as CSV