PREVIEW / futures_30min / 2008-06-15
file: by_date/futures_30min/2008/2008-06-15.parquet size: 17 KB rows: 389
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 |
|---|---|---|---|---|---|---|---|
| 2008-06-15 18:00:00 | ES | Futures | 1263.41 | 1265.04 | 1261.78 | 1262.95 | 3073.0 |
| 2008-06-15 18:30:00 | ES | Futures | 1262.71 | 1264.8 | 1262.71 | 1264.57 | 651.0 |
| 2008-06-15 19:00:00 | ES | Futures | 1264.57 | 1264.8 | 1263.87 | 1264.11 | 566.0 |
| 2008-06-15 19:30:00 | ES | Futures | 1263.87 | 1264.8 | 1263.64 | 1264.8 | 379.0 |
| 2008-06-15 20:00:00 | ES | Futures | 1264.57 | 1265.27 | 1264.34 | 1265.27 | 850.0 |
| 2008-06-15 20:30:00 | ES | Futures | 1265.27 | 1265.73 | 1263.87 | 1264.11 | 1257.0 |
| 2008-06-15 21:00:00 | ES | Futures | 1263.87 | 1264.34 | 1263.64 | 1263.87 | 887.0 |
| 2008-06-15 21:30:00 | ES | Futures | 1263.64 | 1263.87 | 1262.95 | 1263.18 | 894.0 |
| 2008-06-15 22:00:00 | ES | Futures | 1263.18 | 1263.18 | 1262.02 | 1262.71 | 1401.0 |
| 2008-06-15 22:30:00 | ES | Futures | 1262.95 | 1263.64 | 1262.25 | 1263.41 | 837.0 |
| 2008-06-15 23:00:00 | ES | Futures | 1263.41 | 1263.64 | 1262.71 | 1263.64 | 235.0 |
| 2008-06-15 23:30:00 | ES | Futures | 1263.41 | 1264.34 | 1263.18 | 1264.34 | 843.0 |
| 2008-06-15 18:00:00 | NQ | Futures | 2221.62 | 2223.31 | 2219.65 | 2219.93 | 121.0 |
| 2008-06-15 18:30:00 | NQ | Futures | 2220.49 | 2221.9 | 2220.49 | 2221.34 | 5.0 |
| 2008-06-15 19:00:00 | NQ | Futures | 2223.31 | 2223.31 | 2213.18 | 2216.84 | 324.0 |
| 2008-06-15 19:30:00 | NQ | Futures | 2216.84 | 2221.06 | 2216.84 | 2221.06 | 71.0 |
| 2008-06-15 20:00:00 | NQ | Futures | 2219.93 | 2223.03 | 2219.65 | 2220.49 | 75.0 |
| 2008-06-15 20:30:00 | NQ | Futures | 2221.06 | 2221.62 | 2217.4 | 2217.96 | 533.0 |
| 2008-06-15 21:00:00 | NQ | Futures | 2218.24 | 2218.24 | 2212.62 | 2214.87 | 745.0 |
| 2008-06-15 21:30:00 | NQ | Futures | 2214.59 | 2214.87 | 2209.52 | 2212.34 | 881.0 |
| 2008-06-15 22:00:00 | NQ | Futures | 2212.06 | 2212.9 | 2210.93 | 2212.34 | 91.0 |
| 2008-06-15 22:30:00 | NQ | Futures | 2211.49 | 2214.02 | 2210.93 | 2213.74 | 87.0 |
| 2008-06-15 23:00:00 | NQ | Futures | 2213.46 | 2213.74 | 2212.06 | 2213.18 | 60.0 |
| 2008-06-15 23:30:00 | NQ | Futures | 2213.46 | 2215.71 | 2213.46 | 2215.43 | 63.0 |
| 2008-06-15 18:00:00 | YM | Futures | 11179.2 | 11183.7 | 11155.5 | 11167.3 | 127.0 |
| 2008-06-15 18:30:00 | YM | Futures | 11170.1 | 11184.6 | 11170.1 | 11177.3 | 34.0 |
| 2008-06-15 19:00:00 | YM | Futures | 11180.1 | 11182.8 | 11173.7 | 11177.3 | 31.0 |
| 2008-06-15 19:30:00 | YM | Futures | 11178.2 | 11183.7 | 11172.8 | 11178.2 | 63.0 |
| 2008-06-15 20:00:00 | YM | Futures | 11179.2 | 11187.3 | 11179.2 | 11185.5 | 51.0 |
| 2008-06-15 20:30:00 | YM | Futures | 11186.4 | 11190.1 | 11180.1 | 11180.1 | 60.0 |
| 2008-06-15 21:00:00 | YM | Futures | 11177.3 | 11181.0 | 11174.6 | 11175.5 | 95.0 |
| 2008-06-15 21:30:00 | YM | Futures | 11176.4 | 11176.4 | 11169.2 | 11170.1 | 30.0 |
| 2008-06-15 22:00:00 | YM | Futures | 11170.1 | 11170.1 | 11161.0 | 11169.2 | 63.0 |
| 2008-06-15 22:30:00 | YM | Futures | 11167.3 | 11175.5 | 11167.3 | 11175.5 | 43.0 |
| 2008-06-15 23:00:00 | YM | Futures | 11173.7 | 11177.3 | 11170.1 | 11172.8 | 13.0 |
| 2008-06-15 23:30:00 | YM | Futures | 11172.8 | 11183.7 | 11169.2 | 11180.1 | 99.0 |
| 2008-06-15 18:00:00 | CL | Futures | 512.63 | 513.77 | 512.33 | 512.37 | 540.0 |
| 2008-06-15 18:30:00 | CL | Futures | 512.63 | 512.86 | 511.99 | 511.99 | 42.0 |
| 2008-06-15 19:00:00 | CL | Futures | 511.95 | 512.37 | 511.65 | 511.95 | 52.0 |
| 2008-06-15 19:30:00 | CL | Futures | 511.83 | 512.18 | 511.72 | 511.87 | 13.0 |
| 2008-06-15 20:00:00 | CL | Futures | 511.87 | 512.4 | 511.61 | 512.25 | 56.0 |
| 2008-06-15 20:30:00 | CL | Futures | 512.33 | 512.48 | 511.72 | 511.72 | 22.0 |
| 2008-06-15 21:00:00 | CL | Futures | 511.83 | 511.95 | 511.11 | 511.11 | 47.0 |
| 2008-06-15 21:30:00 | CL | Futures | 511.23 | 511.23 | 510.77 | 511.0 | 44.0 |
| 2008-06-15 22:00:00 | CL | Futures | 510.81 | 511.3 | 510.66 | 510.81 | 41.0 |
| 2008-06-15 22:30:00 | CL | Futures | 510.7 | 511.0 | 510.62 | 510.81 | 75.0 |
| 2008-06-15 23:00:00 | CL | Futures | 510.81 | 510.96 | 510.43 | 510.58 | 70.0 |
| 2008-06-15 23:30:00 | CL | Futures | 510.51 | 510.7 | 510.32 | 510.7 | 16.0 |
| 2008-06-15 18:00:00 | GC | Futures | 1257.9 | 1261.2 | 1256.6 | 1260.6 | 224.0 |
| 2008-06-15 18:30:00 | GC | Futures | 1260.3 | 1260.3 | 1257.3 | 1259.6 | 149.0 |
> showing 50 of 389 rows — these rows as CSV