PREVIEW / futures_30min / 2013-06-30
file: by_date/futures_30min/2013/2013-06-30.parquet size: 20 KB rows: 481
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 |
|---|---|---|---|---|---|---|---|
| 2013-06-30 18:00:00 | ES | Futures | 1654.63 | 1655.92 | 1654.37 | 1654.37 | 8038.0 |
| 2013-06-30 18:30:00 | ES | Futures | 1654.37 | 1654.88 | 1652.82 | 1652.82 | 3751.0 |
| 2013-06-30 19:00:00 | ES | Futures | 1653.07 | 1653.85 | 1651.26 | 1652.82 | 2890.0 |
| 2013-06-30 19:30:00 | ES | Futures | 1652.56 | 1653.59 | 1652.56 | 1653.33 | 1202.0 |
| 2013-06-30 20:00:00 | ES | Futures | 1653.07 | 1653.07 | 1649.71 | 1649.97 | 4217.0 |
| 2013-06-30 20:30:00 | ES | Futures | 1649.97 | 1650.49 | 1647.39 | 1648.16 | 7241.0 |
| 2013-06-30 21:00:00 | ES | Futures | 1648.42 | 1650.75 | 1648.16 | 1649.46 | 2572.0 |
| 2013-06-30 21:30:00 | ES | Futures | 1649.46 | 1649.71 | 1647.65 | 1648.68 | 4410.0 |
| 2013-06-30 22:00:00 | ES | Futures | 1648.94 | 1650.49 | 1647.9 | 1649.97 | 2589.0 |
| 2013-06-30 22:30:00 | ES | Futures | 1650.23 | 1651.01 | 1649.2 | 1650.49 | 1546.0 |
| 2013-06-30 23:00:00 | ES | Futures | 1650.75 | 1651.01 | 1648.16 | 1648.42 | 1664.0 |
| 2013-06-30 23:30:00 | ES | Futures | 1648.68 | 1650.23 | 1648.42 | 1649.97 | 1308.0 |
| 2013-06-30 18:00:00 | NQ | Futures | 3393.15 | 3399.0 | 3393.15 | 3395.49 | 345.0 |
| 2013-06-30 18:30:00 | NQ | Futures | 3395.2 | 3396.07 | 3393.15 | 3393.74 | 119.0 |
| 2013-06-30 19:00:00 | NQ | Futures | 3393.44 | 3394.32 | 3390.81 | 3393.15 | 357.0 |
| 2013-06-30 19:30:00 | NQ | Futures | 3393.15 | 3394.9 | 3393.15 | 3394.03 | 119.0 |
| 2013-06-30 20:00:00 | NQ | Futures | 3394.03 | 3394.03 | 3387.6 | 3388.18 | 572.0 |
| 2013-06-30 20:30:00 | NQ | Futures | 3388.77 | 3389.06 | 3383.21 | 3384.68 | 766.0 |
| 2013-06-30 21:00:00 | NQ | Futures | 3384.68 | 3388.77 | 3384.38 | 3387.6 | 375.0 |
| 2013-06-30 21:30:00 | NQ | Futures | 3387.31 | 3387.31 | 3383.8 | 3385.26 | 789.0 |
| 2013-06-30 22:00:00 | NQ | Futures | 3385.26 | 3389.06 | 3383.21 | 3388.18 | 298.0 |
| 2013-06-30 22:30:00 | NQ | Futures | 3388.47 | 3389.64 | 3387.01 | 3389.35 | 153.0 |
| 2013-06-30 23:00:00 | NQ | Futures | 3389.64 | 3389.94 | 3385.55 | 3385.84 | 379.0 |
| 2013-06-30 23:30:00 | NQ | Futures | 3386.14 | 3388.47 | 3385.55 | 3387.6 | 175.0 |
| 2013-06-30 18:00:00 | YM | Futures | 15065.6 | 15086.9 | 15065.6 | 15071.7 | 398.0 |
| 2013-06-30 18:30:00 | YM | Futures | 15070.7 | 15073.7 | 15062.6 | 15062.6 | 190.0 |
| 2013-06-30 19:00:00 | YM | Futures | 15062.6 | 15065.6 | 15048.3 | 15057.5 | 271.0 |
| 2013-06-30 19:30:00 | YM | Futures | 15057.5 | 15065.6 | 15056.5 | 15062.6 | 193.0 |
| 2013-06-30 20:00:00 | YM | Futures | 15061.5 | 15061.5 | 15038.2 | 15041.2 | 679.0 |
| 2013-06-30 20:30:00 | YM | Futures | 15041.2 | 15046.3 | 15022.9 | 15028.0 | 1302.0 |
| 2013-06-30 21:00:00 | YM | Futures | 15029.0 | 15046.3 | 15029.0 | 15042.2 | 514.0 |
| 2013-06-30 21:30:00 | YM | Futures | 15042.2 | 15043.3 | 15029.0 | 15034.1 | 1084.0 |
| 2013-06-30 22:00:00 | YM | Futures | 15035.1 | 15048.3 | 15028.0 | 15044.3 | 480.0 |
| 2013-06-30 22:30:00 | YM | Futures | 15045.3 | 15050.4 | 15040.2 | 15049.3 | 339.0 |
| 2013-06-30 23:00:00 | YM | Futures | 15050.4 | 15051.4 | 15032.1 | 15034.1 | 265.0 |
| 2013-06-30 23:30:00 | YM | Futures | 15035.1 | 15046.3 | 15031.1 | 15042.2 | 289.0 |
| 2013-06-30 18:00:00 | CL | Futures | 150.98 | 151.0 | 150.78 | 150.86 | 443.0 |
| 2013-06-30 18:30:00 | CL | Futures | 150.86 | 150.95 | 150.48 | 150.69 | 824.0 |
| 2013-06-30 19:00:00 | CL | Futures | 150.69 | 150.7 | 150.44 | 150.5 | 336.0 |
| 2013-06-30 19:30:00 | CL | Futures | 150.48 | 150.75 | 150.47 | 150.69 | 250.0 |
| 2013-06-30 20:00:00 | CL | Futures | 150.72 | 150.73 | 150.34 | 150.41 | 606.0 |
| 2013-06-30 20:30:00 | CL | Futures | 150.42 | 150.42 | 150.27 | 150.28 | 417.0 |
| 2013-06-30 21:00:00 | CL | Futures | 150.28 | 150.38 | 150.19 | 150.22 | 968.0 |
| 2013-06-30 21:30:00 | CL | Futures | 150.19 | 150.41 | 150.19 | 150.36 | 475.0 |
| 2013-06-30 22:00:00 | CL | Futures | 150.38 | 150.47 | 150.3 | 150.34 | 392.0 |
| 2013-06-30 22:30:00 | CL | Futures | 150.33 | 150.36 | 150.23 | 150.31 | 210.0 |
| 2013-06-30 23:00:00 | CL | Futures | 150.34 | 150.61 | 150.22 | 150.58 | 538.0 |
| 2013-06-30 23:30:00 | CL | Futures | 150.58 | 150.66 | 150.58 | 150.63 | 185.0 |
| 2013-06-30 18:00:00 | GC | Futures | 1690.9 | 1697.3 | 1690.6 | 1692.7 | 1983.0 |
| 2013-06-30 18:30:00 | GC | Futures | 1692.7 | 1698.4 | 1692.7 | 1698.0 | 666.0 |
> showing 50 of 481 rows — these rows as CSV