PREVIEW / futures_30min / 2010-10-17
file: by_date/futures_30min/2010/2010-10-17.parquet size: 20 KB rows: 492
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-17 18:00:00 | ES | Futures | 1157.71 | 1158.2 | 1156.48 | 1157.46 | 4311.0 |
| 2010-10-17 18:30:00 | ES | Futures | 1157.22 | 1157.96 | 1156.97 | 1157.22 | 2347.0 |
| 2010-10-17 19:00:00 | ES | Futures | 1157.22 | 1157.46 | 1156.48 | 1156.48 | 1655.0 |
| 2010-10-17 19:30:00 | ES | Futures | 1156.73 | 1156.73 | 1155.49 | 1155.99 | 3362.0 |
| 2010-10-17 20:00:00 | ES | Futures | 1155.99 | 1156.23 | 1155.25 | 1155.49 | 5328.0 |
| 2010-10-17 20:30:00 | ES | Futures | 1155.49 | 1155.49 | 1154.51 | 1155.0 | 4422.0 |
| 2010-10-17 21:00:00 | ES | Futures | 1155.0 | 1155.49 | 1154.01 | 1154.26 | 4715.0 |
| 2010-10-17 21:30:00 | ES | Futures | 1154.26 | 1155.0 | 1154.01 | 1154.51 | 2947.0 |
| 2010-10-17 22:00:00 | ES | Futures | 1154.26 | 1154.51 | 1151.55 | 1151.8 | 10048.0 |
| 2010-10-17 22:30:00 | ES | Futures | 1151.8 | 1152.54 | 1150.56 | 1152.29 | 5145.0 |
| 2010-10-17 23:00:00 | ES | Futures | 1152.04 | 1152.78 | 1152.04 | 1152.54 | 1955.0 |
| 2010-10-17 23:30:00 | ES | Futures | 1152.29 | 1152.78 | 1152.04 | 1152.04 | 1487.0 |
| 2010-10-17 18:00:00 | NQ | Futures | 2404.24 | 2405.68 | 2402.23 | 2403.67 | 600.0 |
| 2010-10-17 18:30:00 | NQ | Futures | 2404.24 | 2406.25 | 2403.38 | 2403.96 | 264.0 |
| 2010-10-17 19:00:00 | NQ | Futures | 2403.67 | 2404.24 | 2402.23 | 2402.23 | 121.0 |
| 2010-10-17 19:30:00 | NQ | Futures | 2402.23 | 2402.52 | 2400.51 | 2400.8 | 326.0 |
| 2010-10-17 20:00:00 | NQ | Futures | 2401.09 | 2401.37 | 2399.37 | 2400.23 | 458.0 |
| 2010-10-17 20:30:00 | NQ | Futures | 2399.94 | 2399.94 | 2398.5 | 2399.37 | 402.0 |
| 2010-10-17 21:00:00 | NQ | Futures | 2399.08 | 2399.94 | 2397.07 | 2397.64 | 285.0 |
| 2010-10-17 21:30:00 | NQ | Futures | 2397.64 | 2399.94 | 2397.64 | 2397.93 | 194.0 |
| 2010-10-17 22:00:00 | NQ | Futures | 2397.93 | 2398.22 | 2393.34 | 2394.2 | 479.0 |
| 2010-10-17 22:30:00 | NQ | Futures | 2394.2 | 2394.78 | 2390.76 | 2393.63 | 745.0 |
| 2010-10-17 23:00:00 | NQ | Futures | 2393.63 | 2395.35 | 2393.05 | 2393.63 | 309.0 |
| 2010-10-17 23:30:00 | NQ | Futures | 2394.49 | 2395.06 | 2393.63 | 2394.2 | 176.0 |
| 2010-10-17 18:00:00 | YM | Futures | 10488.7 | 10494.4 | 10484.9 | 10491.5 | 60.0 |
| 2010-10-17 18:30:00 | YM | Futures | 10489.6 | 10496.3 | 10486.8 | 10489.6 | 64.0 |
| 2010-10-17 19:00:00 | YM | Futures | 10487.7 | 10491.5 | 10483.0 | 10483.9 | 41.0 |
| 2010-10-17 19:30:00 | YM | Futures | 10483.0 | 10483.9 | 10474.4 | 10478.2 | 78.0 |
| 2010-10-17 20:00:00 | YM | Futures | 10479.2 | 10481.1 | 10473.4 | 10476.3 | 172.0 |
| 2010-10-17 20:30:00 | YM | Futures | 10474.4 | 10476.3 | 10470.6 | 10473.4 | 232.0 |
| 2010-10-17 21:00:00 | YM | Futures | 10474.4 | 10477.3 | 10467.7 | 10467.7 | 197.0 |
| 2010-10-17 21:30:00 | YM | Futures | 10468.7 | 10472.5 | 10467.7 | 10468.7 | 71.0 |
| 2010-10-17 22:00:00 | YM | Futures | 10469.6 | 10469.6 | 10443.9 | 10448.7 | 287.0 |
| 2010-10-17 22:30:00 | YM | Futures | 10448.7 | 10452.5 | 10439.2 | 10449.6 | 218.0 |
| 2010-10-17 23:00:00 | YM | Futures | 10449.6 | 10454.4 | 10448.7 | 10453.4 | 60.0 |
| 2010-10-17 23:30:00 | YM | Futures | 10454.4 | 10456.3 | 10450.6 | 10451.5 | 42.0 |
| 2010-10-17 18:00:00 | CL | Futures | 154.29 | 154.35 | 153.86 | 154.03 | 168.0 |
| 2010-10-17 18:30:00 | CL | Futures | 154.05 | 154.08 | 153.76 | 153.76 | 299.0 |
| 2010-10-17 19:00:00 | CL | Futures | 153.76 | 153.82 | 153.45 | 153.75 | 309.0 |
| 2010-10-17 19:30:00 | CL | Futures | 153.73 | 153.75 | 153.45 | 153.45 | 242.0 |
| 2010-10-17 20:00:00 | CL | Futures | 153.56 | 153.61 | 152.77 | 152.79 | 625.0 |
| 2010-10-17 20:30:00 | CL | Futures | 152.79 | 153.05 | 152.75 | 152.98 | 314.0 |
| 2010-10-17 21:00:00 | CL | Futures | 153.01 | 153.24 | 152.98 | 153.0 | 287.0 |
| 2010-10-17 21:30:00 | CL | Futures | 153.01 | 153.39 | 152.96 | 153.3 | 320.0 |
| 2010-10-17 22:00:00 | CL | Futures | 153.33 | 153.46 | 152.71 | 152.71 | 592.0 |
| 2010-10-17 22:30:00 | CL | Futures | 152.71 | 152.79 | 152.38 | 152.68 | 577.0 |
| 2010-10-17 23:00:00 | CL | Futures | 152.69 | 152.94 | 152.69 | 152.94 | 228.0 |
| 2010-10-17 23:30:00 | CL | Futures | 152.96 | 153.03 | 152.69 | 152.79 | 247.0 |
| 2010-10-17 18:00:00 | GC | Futures | 1918.1 | 1918.8 | 1912.6 | 1915.3 | 802.0 |
| 2010-10-17 18:30:00 | GC | Futures | 1915.3 | 1916.4 | 1913.2 | 1914.3 | 155.0 |
> showing 50 of 492 rows — these rows as CSV