PREVIEW / futures_30min / 2008-07-06
file: by_date/futures_30min/2008/2008-07-06.parquet size: 17 KB rows: 396
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-07-06 18:00:00 | ES | Futures | 1169.98 | 1171.61 | 1169.51 | 1170.91 | 2011.0 |
| 2008-07-06 18:30:00 | ES | Futures | 1170.91 | 1172.3 | 1170.68 | 1171.61 | 607.0 |
| 2008-07-06 19:00:00 | ES | Futures | 1171.61 | 1171.84 | 1171.14 | 1171.14 | 452.0 |
| 2008-07-06 19:30:00 | ES | Futures | 1171.37 | 1171.37 | 1169.98 | 1170.21 | 1676.0 |
| 2008-07-06 20:00:00 | ES | Futures | 1170.21 | 1170.68 | 1169.05 | 1169.98 | 988.0 |
| 2008-07-06 20:30:00 | ES | Futures | 1169.75 | 1171.14 | 1169.05 | 1171.14 | 912.0 |
| 2008-07-06 21:00:00 | ES | Futures | 1171.14 | 1171.37 | 1169.75 | 1169.75 | 775.0 |
| 2008-07-06 21:30:00 | ES | Futures | 1169.75 | 1170.44 | 1168.58 | 1170.44 | 1661.0 |
| 2008-07-06 22:00:00 | ES | Futures | 1170.44 | 1170.91 | 1170.21 | 1170.44 | 1451.0 |
| 2008-07-06 22:30:00 | ES | Futures | 1170.44 | 1172.07 | 1169.98 | 1171.37 | 897.0 |
| 2008-07-06 23:00:00 | ES | Futures | 1171.84 | 1173.93 | 1171.14 | 1173.23 | 2360.0 |
| 2008-07-06 23:30:00 | ES | Futures | 1173.47 | 1174.16 | 1173.23 | 1173.7 | 933.0 |
| 2008-07-06 18:00:00 | NQ | Futures | 2043.0 | 2046.94 | 2043.0 | 2044.13 | 784.0 |
| 2008-07-06 18:30:00 | NQ | Futures | 2043.84 | 2044.69 | 2043.56 | 2043.84 | 136.0 |
| 2008-07-06 19:00:00 | NQ | Futures | 2043.84 | 2043.84 | 2043.56 | 2043.84 | 14.0 |
| 2008-07-06 19:30:00 | NQ | Futures | 2044.13 | 2044.13 | 2042.44 | 2042.44 | 84.0 |
| 2008-07-06 20:00:00 | NQ | Futures | 2042.44 | 2043.56 | 2041.59 | 2042.72 | 84.0 |
| 2008-07-06 20:30:00 | NQ | Futures | 2042.16 | 2044.69 | 2041.59 | 2044.41 | 76.0 |
| 2008-07-06 21:00:00 | NQ | Futures | 2044.97 | 2046.09 | 2043.56 | 2044.13 | 57.0 |
| 2008-07-06 21:30:00 | NQ | Futures | 2043.56 | 2045.81 | 2042.72 | 2045.25 | 133.0 |
| 2008-07-06 22:00:00 | NQ | Futures | 2045.53 | 2046.09 | 2044.41 | 2045.53 | 131.0 |
| 2008-07-06 22:30:00 | NQ | Futures | 2044.69 | 2047.5 | 2044.69 | 2047.22 | 94.0 |
| 2008-07-06 23:00:00 | NQ | Futures | 2047.5 | 2051.16 | 2046.66 | 2051.16 | 154.0 |
| 2008-07-06 23:30:00 | NQ | Futures | 2051.16 | 2051.16 | 2050.31 | 2050.6 | 73.0 |
| 2008-07-06 18:00:00 | YM | Futures | 10216.7 | 10234.8 | 10216.7 | 10232.1 | 223.0 |
| 2008-07-06 18:30:00 | YM | Futures | 10229.4 | 10238.5 | 10225.7 | 10238.5 | 47.0 |
| 2008-07-06 19:00:00 | YM | Futures | 10235.7 | 10241.2 | 10230.3 | 10230.3 | 88.0 |
| 2008-07-06 19:30:00 | YM | Futures | 10229.4 | 10231.2 | 10220.3 | 10225.7 | 91.0 |
| 2008-07-06 20:00:00 | YM | Futures | 10223.0 | 10224.8 | 10215.7 | 10223.0 | 60.0 |
| 2008-07-06 20:30:00 | YM | Futures | 10221.2 | 10232.1 | 10214.8 | 10232.1 | 71.0 |
| 2008-07-06 21:00:00 | YM | Futures | 10233.0 | 10233.0 | 10221.2 | 10223.0 | 37.0 |
| 2008-07-06 21:30:00 | YM | Futures | 10220.3 | 10224.8 | 10211.2 | 10221.2 | 158.0 |
| 2008-07-06 22:00:00 | YM | Futures | 10225.7 | 10231.2 | 10223.9 | 10227.6 | 94.0 |
| 2008-07-06 22:30:00 | YM | Futures | 10225.7 | 10238.5 | 10221.2 | 10233.9 | 67.0 |
| 2008-07-06 23:00:00 | YM | Futures | 10236.6 | 10252.1 | 10233.9 | 10245.7 | 212.0 |
| 2008-07-06 23:30:00 | YM | Futures | 10244.8 | 10254.8 | 10244.8 | 10252.1 | 95.0 |
| 2008-07-06 18:00:00 | CL | Futures | 547.51 | 548.49 | 547.17 | 547.96 | 372.0 |
| 2008-07-06 18:30:00 | CL | Futures | 547.96 | 548.0 | 547.47 | 547.66 | 156.0 |
| 2008-07-06 19:00:00 | CL | Futures | 547.66 | 547.66 | 546.1 | 546.64 | 195.0 |
| 2008-07-06 19:30:00 | CL | Futures | 546.67 | 547.81 | 546.67 | 547.24 | 99.0 |
| 2008-07-06 20:00:00 | CL | Futures | 547.2 | 547.39 | 546.67 | 546.9 | 48.0 |
| 2008-07-06 20:30:00 | CL | Futures | 546.98 | 547.13 | 546.22 | 546.22 | 113.0 |
| 2008-07-06 21:00:00 | CL | Futures | 546.41 | 546.71 | 546.14 | 546.29 | 86.0 |
| 2008-07-06 21:30:00 | CL | Futures | 546.29 | 546.48 | 545.34 | 545.46 | 347.0 |
| 2008-07-06 22:00:00 | CL | Futures | 545.38 | 545.91 | 545.08 | 545.65 | 198.0 |
| 2008-07-06 22:30:00 | CL | Futures | 545.61 | 545.72 | 545.34 | 545.53 | 54.0 |
| 2008-07-06 23:00:00 | CL | Futures | 545.53 | 545.72 | 545.34 | 545.34 | 54.0 |
| 2008-07-06 23:30:00 | CL | Futures | 545.34 | 545.69 | 545.27 | 545.46 | 50.0 |
| 2008-07-06 18:00:00 | GC | Futures | 1347.7 | 1347.9 | 1345.9 | 1347.1 | 154.0 |
| 2008-07-06 18:30:00 | GC | Futures | 1346.9 | 1347.1 | 1345.2 | 1345.2 | 63.0 |
> showing 50 of 396 rows — these rows as CSV