PREVIEW / futures_30min / 2009-09-06
file: by_date/futures_30min/2009/2009-09-06.parquet size: 13 KB rows: 290
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 |
|---|---|---|---|---|---|---|---|
| 2009-09-06 18:00:00 | ES | Futures | 977.69 | 978.17 | 976.72 | 977.93 | 1765.0 |
| 2009-09-06 18:30:00 | ES | Futures | 977.93 | 979.62 | 977.69 | 979.37 | 1037.0 |
| 2009-09-06 19:00:00 | ES | Futures | 979.13 | 979.13 | 977.2 | 977.45 | 1237.0 |
| 2009-09-06 19:30:00 | ES | Futures | 977.69 | 977.69 | 976.72 | 976.96 | 795.0 |
| 2009-09-06 20:00:00 | ES | Futures | 976.96 | 977.45 | 976.48 | 977.2 | 1133.0 |
| 2009-09-06 20:30:00 | ES | Futures | 977.2 | 977.45 | 976.48 | 976.96 | 780.0 |
| 2009-09-06 21:00:00 | ES | Futures | 976.96 | 977.93 | 976.48 | 977.45 | 656.0 |
| 2009-09-06 21:30:00 | ES | Futures | 977.45 | 977.69 | 976.48 | 976.96 | 399.0 |
| 2009-09-06 22:00:00 | ES | Futures | 976.96 | 977.93 | 976.48 | 977.93 | 714.0 |
| 2009-09-06 22:30:00 | ES | Futures | 978.17 | 978.65 | 976.72 | 977.2 | 874.0 |
| 2009-09-06 23:00:00 | ES | Futures | 977.2 | 978.41 | 977.2 | 977.93 | 761.0 |
| 2009-09-06 23:30:00 | ES | Futures | 977.93 | 978.41 | 977.69 | 977.93 | 1001.0 |
| 2009-09-06 18:00:00 | NQ | Futures | 1863.23 | 1864.08 | 1861.81 | 1864.08 | 111.0 |
| 2009-09-06 18:30:00 | NQ | Futures | 1864.08 | 1867.22 | 1863.8 | 1866.93 | 114.0 |
| 2009-09-06 19:00:00 | NQ | Futures | 1866.65 | 1866.65 | 1862.95 | 1862.95 | 26.0 |
| 2009-09-06 19:30:00 | NQ | Futures | 1863.23 | 1863.8 | 1862.38 | 1862.66 | 66.0 |
| 2009-09-06 20:00:00 | NQ | Futures | 1862.66 | 1863.51 | 1862.66 | 1863.23 | 133.0 |
| 2009-09-06 20:30:00 | NQ | Futures | 1862.95 | 1862.95 | 1861.81 | 1862.38 | 109.0 |
| 2009-09-06 21:00:00 | NQ | Futures | 1862.09 | 1863.51 | 1861.81 | 1863.51 | 81.0 |
| 2009-09-06 21:30:00 | NQ | Futures | 1862.95 | 1862.95 | 1861.24 | 1862.09 | 68.0 |
| 2009-09-06 22:00:00 | NQ | Futures | 1861.81 | 1864.65 | 1861.81 | 1864.65 | 36.0 |
| 2009-09-06 22:30:00 | NQ | Futures | 1864.94 | 1864.94 | 1862.38 | 1863.23 | 43.0 |
| 2009-09-06 23:00:00 | NQ | Futures | 1863.51 | 1865.22 | 1863.51 | 1864.65 | 113.0 |
| 2009-09-06 23:30:00 | NQ | Futures | 1864.37 | 1864.94 | 1863.8 | 1864.37 | 157.0 |
| 2009-09-06 18:00:00 | YM | Futures | 8700.8 | 8706.4 | 8695.3 | 8704.5 | 123.0 |
| 2009-09-06 18:30:00 | YM | Futures | 8704.5 | 8717.5 | 8704.5 | 8717.5 | 38.0 |
| 2009-09-06 19:00:00 | YM | Futures | 8714.7 | 8714.7 | 8701.8 | 8702.7 | 33.0 |
| 2009-09-06 19:30:00 | YM | Futures | 8702.7 | 8702.7 | 8699.0 | 8699.0 | 30.0 |
| 2009-09-06 20:00:00 | YM | Futures | 8698.1 | 8701.8 | 8693.5 | 8699.0 | 112.0 |
| 2009-09-06 20:30:00 | YM | Futures | 8697.2 | 8698.1 | 8692.5 | 8698.1 | 80.0 |
| 2009-09-06 21:00:00 | YM | Futures | 8698.1 | 8704.5 | 8695.3 | 8699.0 | 49.0 |
| 2009-09-06 21:30:00 | YM | Futures | 8698.1 | 8699.9 | 8696.2 | 8697.2 | 31.0 |
| 2009-09-06 22:00:00 | YM | Futures | 8696.2 | 8703.6 | 8694.4 | 8703.6 | 97.0 |
| 2009-09-06 22:30:00 | YM | Futures | 8705.5 | 8707.3 | 8695.3 | 8699.0 | 64.0 |
| 2009-09-06 23:00:00 | YM | Futures | 8700.8 | 8706.4 | 8700.8 | 8705.5 | 99.0 |
| 2009-09-06 23:30:00 | YM | Futures | 8704.5 | 8707.3 | 8703.6 | 8706.4 | 52.0 |
| 2009-09-06 18:00:00 | CL | Futures | 154.17 | 154.19 | 153.67 | 153.78 | 207.0 |
| 2009-09-06 18:30:00 | CL | Futures | 153.78 | 154.12 | 153.78 | 154.03 | 190.0 |
| 2009-09-06 19:00:00 | CL | Futures | 154.01 | 154.01 | 153.69 | 153.69 | 66.0 |
| 2009-09-06 19:30:00 | CL | Futures | 153.76 | 153.76 | 153.42 | 153.46 | 102.0 |
| 2009-09-06 20:00:00 | CL | Futures | 153.51 | 153.87 | 153.42 | 153.85 | 148.0 |
| 2009-09-06 20:30:00 | CL | Futures | 153.83 | 154.12 | 153.78 | 154.05 | 68.0 |
| 2009-09-06 21:00:00 | CL | Futures | 154.01 | 154.19 | 153.92 | 154.1 | 126.0 |
| 2009-09-06 21:30:00 | CL | Futures | 154.15 | 154.33 | 154.05 | 154.17 | 153.0 |
| 2009-09-06 22:00:00 | CL | Futures | 154.1 | 154.46 | 154.1 | 154.4 | 112.0 |
| 2009-09-06 22:30:00 | CL | Futures | 154.4 | 154.74 | 154.4 | 154.71 | 172.0 |
| 2009-09-06 23:00:00 | CL | Futures | 154.76 | 154.8 | 154.46 | 154.64 | 108.0 |
| 2009-09-06 23:30:00 | CL | Futures | 154.64 | 154.87 | 154.64 | 154.8 | 102.0 |
| 2009-09-06 18:00:00 | GC | Futures | 1404.4 | 1406.8 | 1402.8 | 1406.3 | 417.0 |
| 2009-09-06 18:30:00 | GC | Futures | 1406.1 | 1406.6 | 1404.9 | 1406.5 | 211.0 |
> showing 50 of 290 rows — these rows as CSV