PREVIEW / futures_30min / 2010-05-23
file: by_date/futures_30min/2010/2010-05-23.parquet size: 18 KB rows: 428
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-05-23 18:00:00 | ES | Futures | 1061.3 | 1062.52 | 1057.63 | 1057.88 | 13806.0 |
| 2010-05-23 18:30:00 | ES | Futures | 1057.63 | 1060.57 | 1057.63 | 1059.83 | 3716.0 |
| 2010-05-23 19:00:00 | ES | Futures | 1059.59 | 1061.05 | 1058.61 | 1059.59 | 2810.0 |
| 2010-05-23 19:30:00 | ES | Futures | 1059.59 | 1060.32 | 1056.9 | 1057.63 | 5479.0 |
| 2010-05-23 20:00:00 | ES | Futures | 1057.63 | 1058.61 | 1054.21 | 1054.21 | 7299.0 |
| 2010-05-23 20:30:00 | ES | Futures | 1054.45 | 1055.43 | 1052.5 | 1052.99 | 11003.0 |
| 2010-05-23 21:00:00 | ES | Futures | 1052.99 | 1053.48 | 1050.79 | 1051.52 | 12364.0 |
| 2010-05-23 21:30:00 | ES | Futures | 1051.52 | 1056.9 | 1051.52 | 1055.43 | 10385.0 |
| 2010-05-23 22:00:00 | ES | Futures | 1055.43 | 1056.9 | 1054.94 | 1055.68 | 5856.0 |
| 2010-05-23 22:30:00 | ES | Futures | 1055.43 | 1060.57 | 1053.48 | 1059.34 | 10600.0 |
| 2010-05-23 23:00:00 | ES | Futures | 1059.34 | 1060.32 | 1054.94 | 1054.94 | 4071.0 |
| 2010-05-23 23:30:00 | ES | Futures | 1055.19 | 1056.17 | 1054.21 | 1055.19 | 3049.0 |
| 2010-05-23 18:00:00 | NQ | Futures | 2086.22 | 2087.08 | 2076.49 | 2077.35 | 956.0 |
| 2010-05-23 18:30:00 | NQ | Futures | 2077.35 | 2082.5 | 2077.35 | 2080.78 | 399.0 |
| 2010-05-23 19:00:00 | NQ | Futures | 2080.78 | 2083.07 | 2078.49 | 2079.64 | 270.0 |
| 2010-05-23 19:30:00 | NQ | Futures | 2080.21 | 2081.07 | 2076.2 | 2076.77 | 218.0 |
| 2010-05-23 20:00:00 | NQ | Futures | 2077.06 | 2079.35 | 2067.9 | 2069.33 | 613.0 |
| 2010-05-23 20:30:00 | NQ | Futures | 2069.61 | 2071.62 | 2066.18 | 2067.32 | 637.0 |
| 2010-05-23 21:00:00 | NQ | Futures | 2067.61 | 2068.47 | 2063.31 | 2065.03 | 795.0 |
| 2010-05-23 21:30:00 | NQ | Futures | 2065.32 | 2075.06 | 2065.32 | 2072.76 | 620.0 |
| 2010-05-23 22:00:00 | NQ | Futures | 2072.48 | 2074.77 | 2070.76 | 2072.48 | 336.0 |
| 2010-05-23 22:30:00 | NQ | Futures | 2072.19 | 2082.5 | 2068.76 | 2081.36 | 1351.0 |
| 2010-05-23 23:00:00 | NQ | Futures | 2081.07 | 2082.22 | 2073.34 | 2073.62 | 495.0 |
| 2010-05-23 23:30:00 | NQ | Futures | 2073.62 | 2076.49 | 2072.48 | 2075.34 | 248.0 |
| 2010-05-23 18:00:00 | YM | Futures | 9567.9 | 9573.5 | 9539.7 | 9539.7 | 216.0 |
| 2010-05-23 18:30:00 | YM | Futures | 9539.7 | 9565.1 | 9539.7 | 9559.4 | 136.0 |
| 2010-05-23 19:00:00 | YM | Futures | 9554.7 | 9563.2 | 9550.9 | 9550.9 | 123.0 |
| 2010-05-23 19:30:00 | YM | Futures | 9553.8 | 9556.6 | 9534.9 | 9536.8 | 141.0 |
| 2010-05-23 20:00:00 | YM | Futures | 9537.8 | 9547.2 | 9513.3 | 9514.2 | 304.0 |
| 2010-05-23 20:30:00 | YM | Futures | 9515.2 | 9525.5 | 9503.9 | 9506.7 | 536.0 |
| 2010-05-23 21:00:00 | YM | Futures | 9505.8 | 9512.4 | 9487.9 | 9494.5 | 614.0 |
| 2010-05-23 21:30:00 | YM | Futures | 9496.4 | 9539.7 | 9496.4 | 9530.2 | 662.0 |
| 2010-05-23 22:00:00 | YM | Futures | 9530.2 | 9539.7 | 9524.6 | 9534.9 | 456.0 |
| 2010-05-23 22:30:00 | YM | Futures | 9532.1 | 9570.7 | 9516.1 | 9561.3 | 1478.0 |
| 2010-05-23 23:00:00 | YM | Futures | 9561.3 | 9566.0 | 9528.4 | 9528.4 | 397.0 |
| 2010-05-23 23:30:00 | YM | Futures | 9529.3 | 9536.8 | 9521.8 | 9527.4 | 355.0 |
| 2010-05-23 18:00:00 | CL | Futures | 138.89 | 138.94 | 137.39 | 137.49 | 1241.0 |
| 2010-05-23 18:30:00 | CL | Futures | 137.51 | 138.14 | 137.51 | 138.1 | 320.0 |
| 2010-05-23 19:00:00 | CL | Futures | 138.06 | 138.39 | 137.98 | 138.28 | 216.0 |
| 2010-05-23 19:30:00 | CL | Futures | 138.28 | 138.37 | 138.02 | 138.12 | 487.0 |
| 2010-05-23 20:00:00 | CL | Futures | 138.12 | 138.61 | 137.47 | 137.47 | 653.0 |
| 2010-05-23 20:30:00 | CL | Futures | 137.47 | 137.86 | 137.37 | 137.49 | 1049.0 |
| 2010-05-23 21:00:00 | CL | Futures | 137.47 | 137.47 | 136.9 | 137.08 | 1399.0 |
| 2010-05-23 21:30:00 | CL | Futures | 137.12 | 138.16 | 137.1 | 137.9 | 648.0 |
| 2010-05-23 22:00:00 | CL | Futures | 137.94 | 138.37 | 137.86 | 138.26 | 609.0 |
| 2010-05-23 22:30:00 | CL | Futures | 138.24 | 138.75 | 138.0 | 138.69 | 742.0 |
| 2010-05-23 23:00:00 | CL | Futures | 138.67 | 138.73 | 138.06 | 138.12 | 531.0 |
| 2010-05-23 23:30:00 | CL | Futures | 138.14 | 138.69 | 138.04 | 138.59 | 388.0 |
| 2010-05-23 18:00:00 | GC | Futures | 1656.5 | 1658.9 | 1654.7 | 1658.7 | 406.0 |
| 2010-05-23 18:30:00 | GC | Futures | 1658.9 | 1662.4 | 1657.5 | 1661.0 | 426.0 |
> showing 50 of 428 rows — these rows as CSV