PREVIEW / futures_30min / 2010-11-28
file: by_date/futures_30min/2010/2010-11-28.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 |
|---|---|---|---|---|---|---|---|
| 2010-11-28 18:00:00 | ES | Futures | 1171.76 | 1175.7 | 1171.51 | 1172.01 | 25300.0 |
| 2010-11-28 18:30:00 | ES | Futures | 1172.01 | 1172.75 | 1170.28 | 1170.77 | 8653.0 |
| 2010-11-28 19:00:00 | ES | Futures | 1170.77 | 1174.23 | 1170.28 | 1172.99 | 10876.0 |
| 2010-11-28 19:30:00 | ES | Futures | 1172.99 | 1172.99 | 1167.57 | 1168.06 | 14585.0 |
| 2010-11-28 20:00:00 | ES | Futures | 1167.82 | 1169.3 | 1167.32 | 1167.57 | 5422.0 |
| 2010-11-28 20:30:00 | ES | Futures | 1167.82 | 1170.28 | 1167.32 | 1169.79 | 4629.0 |
| 2010-11-28 21:00:00 | ES | Futures | 1170.04 | 1171.51 | 1169.79 | 1171.27 | 3456.0 |
| 2010-11-28 21:30:00 | ES | Futures | 1171.51 | 1172.75 | 1171.27 | 1172.25 | 3715.0 |
| 2010-11-28 22:00:00 | ES | Futures | 1172.01 | 1172.75 | 1172.01 | 1172.25 | 1345.0 |
| 2010-11-28 22:30:00 | ES | Futures | 1172.01 | 1173.73 | 1172.01 | 1172.75 | 3057.0 |
| 2010-11-28 23:00:00 | ES | Futures | 1172.5 | 1173.24 | 1171.27 | 1172.01 | 2107.0 |
| 2010-11-28 23:30:00 | ES | Futures | 1172.01 | 1172.75 | 1171.27 | 1172.75 | 2424.0 |
| 2010-11-28 18:00:00 | NQ | Futures | 2467.36 | 2477.4 | 2459.33 | 2470.23 | 1763.0 |
| 2010-11-28 18:30:00 | NQ | Futures | 2469.94 | 2471.38 | 2467.36 | 2468.51 | 422.0 |
| 2010-11-28 19:00:00 | NQ | Futures | 2468.8 | 2476.26 | 2468.22 | 2473.39 | 685.0 |
| 2010-11-28 19:30:00 | NQ | Futures | 2473.39 | 2473.67 | 2462.48 | 2464.21 | 665.0 |
| 2010-11-28 20:00:00 | NQ | Futures | 2464.49 | 2467.07 | 2463.92 | 2464.49 | 399.0 |
| 2010-11-28 20:30:00 | NQ | Futures | 2464.78 | 2467.94 | 2463.92 | 2467.94 | 254.0 |
| 2010-11-28 21:00:00 | NQ | Futures | 2467.94 | 2470.8 | 2467.65 | 2470.52 | 184.0 |
| 2010-11-28 21:30:00 | NQ | Futures | 2470.8 | 2472.53 | 2470.8 | 2472.24 | 202.0 |
| 2010-11-28 22:00:00 | NQ | Futures | 2472.24 | 2473.1 | 2471.38 | 2471.67 | 167.0 |
| 2010-11-28 22:30:00 | NQ | Futures | 2471.95 | 2474.53 | 2471.95 | 2472.81 | 203.0 |
| 2010-11-28 23:00:00 | NQ | Futures | 2473.1 | 2474.25 | 2469.66 | 2470.23 | 400.0 |
| 2010-11-28 23:30:00 | NQ | Futures | 2470.23 | 2471.09 | 2468.8 | 2471.09 | 180.0 |
| 2010-11-28 18:00:00 | YM | Futures | 10530.6 | 10577.3 | 10530.6 | 10549.7 | 862.0 |
| 2010-11-28 18:30:00 | YM | Futures | 10548.7 | 10554.4 | 10536.3 | 10537.3 | 238.0 |
| 2010-11-28 19:00:00 | YM | Futures | 10539.2 | 10565.8 | 10537.3 | 10556.3 | 388.0 |
| 2010-11-28 19:30:00 | YM | Futures | 10555.4 | 10555.4 | 10511.6 | 10515.4 | 529.0 |
| 2010-11-28 20:00:00 | YM | Futures | 10515.4 | 10528.7 | 10515.4 | 10518.2 | 352.0 |
| 2010-11-28 20:30:00 | YM | Futures | 10517.3 | 10536.3 | 10514.4 | 10536.3 | 294.0 |
| 2010-11-28 21:00:00 | YM | Futures | 10536.3 | 10549.7 | 10536.3 | 10548.7 | 170.0 |
| 2010-11-28 21:30:00 | YM | Futures | 10550.6 | 10558.2 | 10549.7 | 10553.5 | 146.0 |
| 2010-11-28 22:00:00 | YM | Futures | 10553.5 | 10556.3 | 10547.7 | 10548.7 | 197.0 |
| 2010-11-28 22:30:00 | YM | Futures | 10548.7 | 10562.0 | 10548.7 | 10557.3 | 174.0 |
| 2010-11-28 23:00:00 | YM | Futures | 10558.2 | 10571.6 | 10549.7 | 10558.2 | 225.0 |
| 2010-11-28 23:30:00 | YM | Futures | 10555.4 | 10560.1 | 10549.7 | 10555.4 | 305.0 |
| 2010-11-28 18:00:00 | CL | Futures | 156.58 | 157.04 | 156.24 | 156.76 | 1185.0 |
| 2010-11-28 18:30:00 | CL | Futures | 156.74 | 156.8 | 156.61 | 156.71 | 396.0 |
| 2010-11-28 19:00:00 | CL | Futures | 156.74 | 157.14 | 156.58 | 156.91 | 541.0 |
| 2010-11-28 19:30:00 | CL | Futures | 156.91 | 156.91 | 156.31 | 156.35 | 1002.0 |
| 2010-11-28 20:00:00 | CL | Futures | 156.37 | 156.5 | 156.11 | 156.15 | 734.0 |
| 2010-11-28 20:30:00 | CL | Futures | 156.17 | 156.67 | 156.11 | 156.61 | 527.0 |
| 2010-11-28 21:00:00 | CL | Futures | 156.63 | 157.58 | 156.63 | 157.53 | 1510.0 |
| 2010-11-28 21:30:00 | CL | Futures | 157.53 | 157.62 | 157.27 | 157.43 | 1033.0 |
| 2010-11-28 22:00:00 | CL | Futures | 157.45 | 157.51 | 157.27 | 157.36 | 320.0 |
| 2010-11-28 22:30:00 | CL | Futures | 157.38 | 157.51 | 157.25 | 157.3 | 341.0 |
| 2010-11-28 23:00:00 | CL | Futures | 157.32 | 157.45 | 157.23 | 157.25 | 344.0 |
| 2010-11-28 23:30:00 | CL | Futures | 157.27 | 157.32 | 157.04 | 157.17 | 404.0 |
| 2010-11-28 18:00:00 | GC | Futures | 1906.6 | 1907.6 | 1901.3 | 1901.3 | 710.0 |
| 2010-11-28 18:30:00 | GC | Futures | 1901.3 | 1901.7 | 1897.1 | 1898.1 | 846.0 |
> showing 50 of 481 rows — these rows as CSV