PREVIEW / futures_30min / 2010-11-07
file: by_date/futures_30min/2010/2010-11-07.parquet size: 20 KB rows: 520
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-07 18:00:00 | ES | Futures | 1203.31 | 1204.05 | 1202.32 | 1203.56 | 6819.0 |
| 2010-11-07 18:30:00 | ES | Futures | 1203.56 | 1204.54 | 1202.82 | 1204.3 | 3474.0 |
| 2010-11-07 19:00:00 | ES | Futures | 1204.05 | 1204.79 | 1203.8 | 1204.3 | 3505.0 |
| 2010-11-07 19:30:00 | ES | Futures | 1204.3 | 1205.04 | 1203.56 | 1204.3 | 2982.0 |
| 2010-11-07 20:00:00 | ES | Futures | 1204.3 | 1204.54 | 1202.32 | 1202.82 | 2493.0 |
| 2010-11-07 20:30:00 | ES | Futures | 1202.82 | 1202.82 | 1200.35 | 1201.09 | 6940.0 |
| 2010-11-07 21:00:00 | ES | Futures | 1201.34 | 1201.34 | 1199.86 | 1200.35 | 5118.0 |
| 2010-11-07 21:30:00 | ES | Futures | 1200.6 | 1201.83 | 1199.61 | 1201.83 | 5288.0 |
| 2010-11-07 22:00:00 | ES | Futures | 1201.58 | 1202.32 | 1201.34 | 1201.83 | 3876.0 |
| 2010-11-07 22:30:00 | ES | Futures | 1201.83 | 1201.83 | 1200.6 | 1200.85 | 4214.0 |
| 2010-11-07 23:00:00 | ES | Futures | 1200.85 | 1201.09 | 1200.11 | 1200.6 | 2008.0 |
| 2010-11-07 23:30:00 | ES | Futures | 1200.6 | 1201.83 | 1200.35 | 1200.85 | 1250.0 |
| 2010-11-07 18:00:00 | NQ | Futures | 2502.36 | 2503.51 | 2499.49 | 2502.94 | 874.0 |
| 2010-11-07 18:30:00 | NQ | Futures | 2502.65 | 2505.81 | 2502.08 | 2505.52 | 164.0 |
| 2010-11-07 19:00:00 | NQ | Futures | 2505.52 | 2506.09 | 2504.37 | 2505.23 | 139.0 |
| 2010-11-07 19:30:00 | NQ | Futures | 2505.23 | 2506.38 | 2503.51 | 2505.52 | 131.0 |
| 2010-11-07 20:00:00 | NQ | Futures | 2505.52 | 2505.52 | 2501.5 | 2502.36 | 168.0 |
| 2010-11-07 20:30:00 | NQ | Futures | 2502.36 | 2502.36 | 2498.63 | 2500.07 | 319.0 |
| 2010-11-07 21:00:00 | NQ | Futures | 2500.07 | 2500.36 | 2496.34 | 2498.06 | 572.0 |
| 2010-11-07 21:30:00 | NQ | Futures | 2498.35 | 2500.93 | 2497.49 | 2500.93 | 235.0 |
| 2010-11-07 22:00:00 | NQ | Futures | 2500.64 | 2503.8 | 2500.64 | 2500.93 | 361.0 |
| 2010-11-07 22:30:00 | NQ | Futures | 2501.22 | 2501.22 | 2498.92 | 2499.21 | 179.0 |
| 2010-11-07 23:00:00 | NQ | Futures | 2498.92 | 2499.78 | 2498.63 | 2499.21 | 77.0 |
| 2010-11-07 23:30:00 | NQ | Futures | 2498.92 | 2500.36 | 2498.92 | 2499.21 | 52.0 |
| 2010-11-07 18:00:00 | YM | Futures | 10830.7 | 10834.5 | 10821.1 | 10832.6 | 328.0 |
| 2010-11-07 18:30:00 | YM | Futures | 10830.7 | 10839.2 | 10826.8 | 10838.3 | 91.0 |
| 2010-11-07 19:00:00 | YM | Futures | 10839.2 | 10840.2 | 10833.5 | 10840.2 | 100.0 |
| 2010-11-07 19:30:00 | YM | Futures | 10839.2 | 10845.9 | 10832.6 | 10840.2 | 123.0 |
| 2010-11-07 20:00:00 | YM | Futures | 10838.3 | 10838.3 | 10823.0 | 10824.0 | 103.0 |
| 2010-11-07 20:30:00 | YM | Futures | 10824.9 | 10824.9 | 10809.7 | 10813.5 | 201.0 |
| 2010-11-07 21:00:00 | YM | Futures | 10813.5 | 10814.5 | 10803.0 | 10808.8 | 277.0 |
| 2010-11-07 21:30:00 | YM | Futures | 10807.8 | 10818.3 | 10802.1 | 10818.3 | 149.0 |
| 2010-11-07 22:00:00 | YM | Futures | 10818.3 | 10824.9 | 10816.4 | 10819.2 | 236.0 |
| 2010-11-07 22:30:00 | YM | Futures | 10820.2 | 10820.2 | 10809.7 | 10811.6 | 159.0 |
| 2010-11-07 23:00:00 | YM | Futures | 10811.6 | 10813.5 | 10804.9 | 10809.7 | 84.0 |
| 2010-11-07 23:30:00 | YM | Futures | 10808.8 | 10820.2 | 10808.8 | 10813.5 | 208.0 |
| 2010-11-07 18:00:00 | CL | Futures | 164.03 | 164.03 | 163.49 | 163.69 | 1242.0 |
| 2010-11-07 18:30:00 | CL | Futures | 163.68 | 164.16 | 163.62 | 164.13 | 564.0 |
| 2010-11-07 19:00:00 | CL | Futures | 164.13 | 164.22 | 163.98 | 163.99 | 595.0 |
| 2010-11-07 19:30:00 | CL | Futures | 163.99 | 164.03 | 163.77 | 163.79 | 389.0 |
| 2010-11-07 20:00:00 | CL | Futures | 163.79 | 163.96 | 163.71 | 163.81 | 493.0 |
| 2010-11-07 20:30:00 | CL | Futures | 163.83 | 163.88 | 163.51 | 163.6 | 663.0 |
| 2010-11-07 21:00:00 | CL | Futures | 163.6 | 163.68 | 162.98 | 163.09 | 1477.0 |
| 2010-11-07 21:30:00 | CL | Futures | 163.07 | 163.21 | 162.92 | 163.17 | 877.0 |
| 2010-11-07 22:00:00 | CL | Futures | 163.21 | 163.49 | 163.19 | 163.39 | 391.0 |
| 2010-11-07 22:30:00 | CL | Futures | 163.39 | 163.39 | 163.04 | 163.13 | 216.0 |
| 2010-11-07 23:00:00 | CL | Futures | 163.13 | 163.3 | 163.09 | 163.11 | 174.0 |
| 2010-11-07 23:30:00 | CL | Futures | 163.13 | 163.19 | 163.04 | 163.13 | 277.0 |
| 2010-11-07 18:00:00 | GC | Futures | 1954.5 | 1954.9 | 1949.1 | 1950.0 | 1122.0 |
| 2010-11-07 18:30:00 | GC | Futures | 1950.1 | 1952.5 | 1949.6 | 1952.4 | 834.0 |
> showing 50 of 520 rows — these rows as CSV