PREVIEW / futures_30min / 2013-01-06
file: by_date/futures_30min/2013/2013-01-06.parquet size: 21 KB rows: 526
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-01-06 18:00:00 | ES | Futures | 1498.75 | 1499.26 | 1496.7 | 1497.47 | 6453.0 |
| 2013-01-06 18:30:00 | ES | Futures | 1497.47 | 1497.72 | 1497.21 | 1497.47 | 704.0 |
| 2013-01-06 19:00:00 | ES | Futures | 1497.47 | 1497.47 | 1496.18 | 1496.7 | 3091.0 |
| 2013-01-06 19:30:00 | ES | Futures | 1496.95 | 1497.47 | 1496.18 | 1496.95 | 2545.0 |
| 2013-01-06 20:00:00 | ES | Futures | 1496.7 | 1497.72 | 1496.18 | 1496.18 | 2920.0 |
| 2013-01-06 20:30:00 | ES | Futures | 1496.44 | 1496.95 | 1496.18 | 1496.44 | 1853.0 |
| 2013-01-06 21:00:00 | ES | Futures | 1496.44 | 1497.21 | 1496.44 | 1496.44 | 896.0 |
| 2013-01-06 21:30:00 | ES | Futures | 1496.44 | 1496.95 | 1495.67 | 1495.93 | 2170.0 |
| 2013-01-06 22:00:00 | ES | Futures | 1495.67 | 1496.44 | 1495.16 | 1495.16 | 3055.0 |
| 2013-01-06 22:30:00 | ES | Futures | 1495.16 | 1495.67 | 1494.39 | 1494.64 | 2677.0 |
| 2013-01-06 23:00:00 | ES | Futures | 1494.39 | 1495.41 | 1494.13 | 1494.39 | 2322.0 |
| 2013-01-06 23:30:00 | ES | Futures | 1494.64 | 1495.16 | 1494.13 | 1494.39 | 1624.0 |
| 2013-01-06 18:00:00 | NQ | Futures | 3162.47 | 3163.92 | 3160.14 | 3161.3 | 462.0 |
| 2013-01-06 18:30:00 | NQ | Futures | 3161.59 | 3162.47 | 3161.3 | 3162.47 | 42.0 |
| 2013-01-06 19:00:00 | NQ | Futures | 3162.17 | 3162.17 | 3160.14 | 3160.43 | 286.0 |
| 2013-01-06 19:30:00 | NQ | Futures | 3160.43 | 3161.88 | 3159.55 | 3161.01 | 303.0 |
| 2013-01-06 20:00:00 | NQ | Futures | 3160.72 | 3162.76 | 3158.68 | 3158.68 | 281.0 |
| 2013-01-06 20:30:00 | NQ | Futures | 3158.97 | 3160.43 | 3158.97 | 3159.85 | 175.0 |
| 2013-01-06 21:00:00 | NQ | Futures | 3159.85 | 3161.59 | 3159.55 | 3160.43 | 86.0 |
| 2013-01-06 21:30:00 | NQ | Futures | 3160.14 | 3160.72 | 3158.68 | 3158.97 | 122.0 |
| 2013-01-06 22:00:00 | NQ | Futures | 3158.97 | 3159.85 | 3158.68 | 3158.68 | 271.0 |
| 2013-01-06 22:30:00 | NQ | Futures | 3158.68 | 3159.55 | 3156.64 | 3156.94 | 343.0 |
| 2013-01-06 23:00:00 | NQ | Futures | 3156.94 | 3158.97 | 3156.64 | 3156.64 | 173.0 |
| 2013-01-06 23:30:00 | NQ | Futures | 3156.35 | 3157.81 | 3155.19 | 3155.77 | 182.0 |
| 2013-01-06 18:00:00 | YM | Futures | 13441.5 | 13446.5 | 13429.4 | 13436.5 | 384.0 |
| 2013-01-06 18:30:00 | YM | Futures | 13437.5 | 13437.5 | 13433.5 | 13434.5 | 98.0 |
| 2013-01-06 19:00:00 | YM | Futures | 13434.5 | 13434.5 | 13426.4 | 13429.4 | 429.0 |
| 2013-01-06 19:30:00 | YM | Futures | 13429.4 | 13432.4 | 13425.4 | 13430.4 | 311.0 |
| 2013-01-06 20:00:00 | YM | Futures | 13430.4 | 13436.5 | 13423.4 | 13424.4 | 287.0 |
| 2013-01-06 20:30:00 | YM | Futures | 13425.4 | 13429.4 | 13424.4 | 13427.4 | 174.0 |
| 2013-01-06 21:00:00 | YM | Futures | 13425.4 | 13433.5 | 13424.4 | 13428.4 | 101.0 |
| 2013-01-06 21:30:00 | YM | Futures | 13426.4 | 13431.4 | 13422.4 | 13422.4 | 173.0 |
| 2013-01-06 22:00:00 | YM | Futures | 13422.4 | 13426.4 | 13417.4 | 13418.4 | 295.0 |
| 2013-01-06 22:30:00 | YM | Futures | 13418.4 | 13420.4 | 13409.3 | 13410.3 | 301.0 |
| 2013-01-06 23:00:00 | YM | Futures | 13410.3 | 13417.4 | 13408.3 | 13408.3 | 361.0 |
| 2013-01-06 23:30:00 | YM | Futures | 13408.3 | 13414.3 | 13407.3 | 13408.3 | 103.0 |
| 2013-01-06 18:00:00 | CL | Futures | 149.64 | 149.71 | 149.26 | 149.37 | 814.0 |
| 2013-01-06 18:30:00 | CL | Futures | 149.4 | 149.51 | 149.34 | 149.39 | 161.0 |
| 2013-01-06 19:00:00 | CL | Futures | 149.42 | 149.42 | 149.15 | 149.21 | 396.0 |
| 2013-01-06 19:30:00 | CL | Futures | 149.19 | 149.29 | 149.11 | 149.23 | 385.0 |
| 2013-01-06 20:00:00 | CL | Futures | 149.21 | 149.47 | 149.19 | 149.34 | 516.0 |
| 2013-01-06 20:30:00 | CL | Futures | 149.32 | 149.42 | 149.24 | 149.24 | 274.0 |
| 2013-01-06 21:00:00 | CL | Futures | 149.27 | 149.47 | 149.26 | 149.4 | 302.0 |
| 2013-01-06 21:30:00 | CL | Futures | 149.39 | 149.5 | 149.37 | 149.37 | 347.0 |
| 2013-01-06 22:00:00 | CL | Futures | 149.37 | 149.43 | 149.32 | 149.32 | 180.0 |
| 2013-01-06 22:30:00 | CL | Futures | 149.34 | 149.37 | 149.18 | 149.19 | 426.0 |
| 2013-01-06 23:00:00 | CL | Futures | 149.19 | 149.26 | 149.16 | 149.16 | 215.0 |
| 2013-01-06 23:30:00 | CL | Futures | 149.16 | 149.16 | 149.03 | 149.06 | 546.0 |
| 2013-01-06 18:00:00 | GC | Futures | 2281.1 | 2285.3 | 2280.9 | 2284.7 | 1901.0 |
| 2013-01-06 18:30:00 | GC | Futures | 2284.3 | 2285.6 | 2280.6 | 2282.1 | 695.0 |
> showing 50 of 526 rows — these rows as CSV