PREVIEW / futures_30min / 2010-10-31
file: by_date/futures_30min/2010/2010-10-31.parquet size: 20 KB rows: 504
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-10-31 18:00:00 | ES | Futures | 1163.87 | 1170.28 | 1163.63 | 1169.3 | 11242.0 |
| 2010-10-31 18:30:00 | ES | Futures | 1169.3 | 1169.54 | 1168.56 | 1168.56 | 1838.0 |
| 2010-10-31 19:00:00 | ES | Futures | 1168.8 | 1169.79 | 1168.56 | 1169.79 | 1164.0 |
| 2010-10-31 19:30:00 | ES | Futures | 1169.54 | 1170.77 | 1168.56 | 1169.54 | 11269.0 |
| 2010-10-31 20:00:00 | ES | Futures | 1169.54 | 1170.77 | 1168.31 | 1169.3 | 8702.0 |
| 2010-10-31 20:30:00 | ES | Futures | 1169.3 | 1170.28 | 1168.56 | 1170.04 | 3837.0 |
| 2010-10-31 21:00:00 | ES | Futures | 1169.79 | 1172.01 | 1169.79 | 1171.51 | 7991.0 |
| 2010-10-31 21:30:00 | ES | Futures | 1171.51 | 1172.25 | 1171.02 | 1171.76 | 6701.0 |
| 2010-10-31 22:00:00 | ES | Futures | 1172.01 | 1172.01 | 1171.27 | 1171.27 | 3278.0 |
| 2010-10-31 22:30:00 | ES | Futures | 1171.51 | 1172.01 | 1171.27 | 1171.51 | 2297.0 |
| 2010-10-31 23:00:00 | ES | Futures | 1171.51 | 1172.01 | 1171.51 | 1171.76 | 978.0 |
| 2010-10-31 23:30:00 | ES | Futures | 1171.76 | 1172.25 | 1171.51 | 1171.76 | 1991.0 |
| 2010-10-31 18:00:00 | NQ | Futures | 2438.67 | 2447.57 | 2438.67 | 2446.7 | 874.0 |
| 2010-10-31 18:30:00 | NQ | Futures | 2446.7 | 2446.99 | 2445.56 | 2445.56 | 379.0 |
| 2010-10-31 19:00:00 | NQ | Futures | 2445.84 | 2447.85 | 2445.84 | 2447.28 | 125.0 |
| 2010-10-31 19:30:00 | NQ | Futures | 2447.57 | 2449.86 | 2446.13 | 2447.85 | 352.0 |
| 2010-10-31 20:00:00 | NQ | Futures | 2448.43 | 2450.43 | 2445.56 | 2447.85 | 521.0 |
| 2010-10-31 20:30:00 | NQ | Futures | 2448.14 | 2449.0 | 2446.13 | 2448.14 | 385.0 |
| 2010-10-31 21:00:00 | NQ | Futures | 2448.43 | 2451.01 | 2447.85 | 2450.15 | 499.0 |
| 2010-10-31 21:30:00 | NQ | Futures | 2450.43 | 2451.01 | 2449.0 | 2450.15 | 670.0 |
| 2010-10-31 22:00:00 | NQ | Futures | 2450.15 | 2450.72 | 2449.57 | 2449.86 | 203.0 |
| 2010-10-31 22:30:00 | NQ | Futures | 2449.86 | 2450.72 | 2449.57 | 2450.15 | 199.0 |
| 2010-10-31 23:00:00 | NQ | Futures | 2449.86 | 2450.15 | 2449.57 | 2449.86 | 86.0 |
| 2010-10-31 23:30:00 | NQ | Futures | 2450.15 | 2451.01 | 2449.86 | 2450.43 | 171.0 |
| 2010-10-31 18:00:00 | YM | Futures | 10543.0 | 10603.0 | 10543.0 | 10597.3 | 493.0 |
| 2010-10-31 18:30:00 | YM | Futures | 10597.3 | 10597.3 | 10589.7 | 10591.6 | 73.0 |
| 2010-10-31 19:00:00 | YM | Futures | 10589.7 | 10597.3 | 10589.7 | 10597.3 | 142.0 |
| 2010-10-31 19:30:00 | YM | Futures | 10596.3 | 10603.9 | 10589.7 | 10596.3 | 188.0 |
| 2010-10-31 20:00:00 | YM | Futures | 10597.3 | 10604.9 | 10587.8 | 10594.4 | 382.0 |
| 2010-10-31 20:30:00 | YM | Futures | 10596.3 | 10602.0 | 10591.6 | 10598.2 | 166.0 |
| 2010-10-31 21:00:00 | YM | Futures | 10598.2 | 10614.4 | 10598.2 | 10609.7 | 392.0 |
| 2010-10-31 21:30:00 | YM | Futures | 10610.6 | 10613.5 | 10604.9 | 10611.6 | 297.0 |
| 2010-10-31 22:00:00 | YM | Futures | 10611.6 | 10614.4 | 10608.7 | 10609.7 | 121.0 |
| 2010-10-31 22:30:00 | YM | Futures | 10609.7 | 10612.5 | 10606.8 | 10609.7 | 103.0 |
| 2010-10-31 23:00:00 | YM | Futures | 10609.7 | 10611.6 | 10606.8 | 10611.6 | 68.0 |
| 2010-10-31 23:30:00 | YM | Futures | 10612.5 | 10613.5 | 10609.7 | 10611.6 | 108.0 |
| 2010-10-31 18:00:00 | CL | Futures | 152.88 | 153.6 | 152.64 | 153.46 | 975.0 |
| 2010-10-31 18:30:00 | CL | Futures | 153.46 | 153.73 | 153.43 | 153.48 | 563.0 |
| 2010-10-31 19:00:00 | CL | Futures | 153.46 | 153.54 | 153.37 | 153.43 | 183.0 |
| 2010-10-31 19:30:00 | CL | Futures | 153.41 | 153.65 | 153.41 | 153.58 | 176.0 |
| 2010-10-31 20:00:00 | CL | Futures | 153.58 | 153.6 | 153.13 | 153.45 | 722.0 |
| 2010-10-31 20:30:00 | CL | Futures | 153.45 | 153.6 | 153.3 | 153.54 | 305.0 |
| 2010-10-31 21:00:00 | CL | Futures | 153.56 | 153.78 | 153.37 | 153.71 | 706.0 |
| 2010-10-31 21:30:00 | CL | Futures | 153.73 | 153.82 | 153.6 | 153.8 | 627.0 |
| 2010-10-31 22:00:00 | CL | Futures | 153.8 | 153.84 | 153.39 | 153.45 | 559.0 |
| 2010-10-31 22:30:00 | CL | Futures | 153.48 | 153.69 | 153.46 | 153.69 | 267.0 |
| 2010-10-31 23:00:00 | CL | Futures | 153.63 | 153.63 | 153.54 | 153.56 | 196.0 |
| 2010-10-31 23:30:00 | CL | Futures | 153.58 | 153.71 | 153.56 | 153.58 | 206.0 |
| 2010-10-31 18:00:00 | GC | Futures | 1902.3 | 1911.6 | 1901.9 | 1909.0 | 2384.0 |
| 2010-10-31 18:30:00 | GC | Futures | 1909.0 | 1909.4 | 1908.1 | 1908.4 | 314.0 |
> showing 50 of 504 rows — these rows as CSV