PREVIEW / futures_30min / 2010-07-04
file: by_date/futures_30min/2010/2010-07-04.parquet size: 15 KB rows: 323
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-07-04 18:00:00 | ES | Futures | 996.24 | 997.71 | 995.01 | 995.26 | 2967.0 |
| 2010-07-04 18:30:00 | ES | Futures | 995.26 | 996.49 | 995.01 | 996.0 | 703.0 |
| 2010-07-04 19:00:00 | ES | Futures | 995.5 | 996.0 | 994.28 | 994.52 | 840.0 |
| 2010-07-04 19:30:00 | ES | Futures | 994.77 | 996.98 | 994.52 | 996.24 | 2176.0 |
| 2010-07-04 20:00:00 | ES | Futures | 996.24 | 998.69 | 996.24 | 997.47 | 3041.0 |
| 2010-07-04 20:30:00 | ES | Futures | 997.22 | 998.45 | 996.73 | 996.73 | 3762.0 |
| 2010-07-04 21:00:00 | ES | Futures | 996.73 | 998.45 | 996.73 | 997.71 | 2945.0 |
| 2010-07-04 21:30:00 | ES | Futures | 997.71 | 998.45 | 996.0 | 996.98 | 2085.0 |
| 2010-07-04 22:00:00 | ES | Futures | 996.49 | 999.43 | 996.0 | 998.69 | 5520.0 |
| 2010-07-04 22:30:00 | ES | Futures | 998.69 | 998.94 | 997.96 | 998.2 | 884.0 |
| 2010-07-04 23:00:00 | ES | Futures | 997.96 | 998.94 | 997.22 | 997.71 | 948.0 |
| 2010-07-04 23:30:00 | ES | Futures | 997.47 | 997.96 | 996.49 | 996.73 | 4193.0 |
| 2010-07-04 18:00:00 | NQ | Futures | 1973.87 | 1975.01 | 1970.14 | 1972.72 | 212.0 |
| 2010-07-04 18:30:00 | NQ | Futures | 1972.43 | 1973.58 | 1971.57 | 1973.58 | 14.0 |
| 2010-07-04 19:00:00 | NQ | Futures | 1972.72 | 1972.72 | 1971.0 | 1971.0 | 72.0 |
| 2010-07-04 19:30:00 | NQ | Futures | 1971.57 | 1975.59 | 1971.57 | 1973.87 | 116.0 |
| 2010-07-04 20:00:00 | NQ | Futures | 1974.15 | 1978.45 | 1974.15 | 1976.16 | 183.0 |
| 2010-07-04 20:30:00 | NQ | Futures | 1975.59 | 1978.74 | 1975.3 | 1975.3 | 280.0 |
| 2010-07-04 21:00:00 | NQ | Futures | 1975.59 | 1977.88 | 1975.3 | 1977.31 | 127.0 |
| 2010-07-04 21:30:00 | NQ | Futures | 1977.59 | 1977.59 | 1973.87 | 1975.3 | 117.0 |
| 2010-07-04 22:00:00 | NQ | Futures | 1975.01 | 1980.46 | 1973.58 | 1979.6 | 314.0 |
| 2010-07-04 22:30:00 | NQ | Futures | 1979.31 | 1979.88 | 1978.45 | 1978.45 | 60.0 |
| 2010-07-04 23:00:00 | NQ | Futures | 1978.17 | 1978.45 | 1975.59 | 1976.45 | 100.0 |
| 2010-07-04 23:30:00 | NQ | Futures | 1977.02 | 1977.59 | 1975.01 | 1975.01 | 120.0 |
| 2010-07-04 18:00:00 | YM | Futures | 9081.7 | 9126.2 | 9081.7 | 9083.6 | 96.0 |
| 2010-07-04 18:30:00 | YM | Futures | 9084.6 | 9086.5 | 9079.8 | 9085.5 | 18.0 |
| 2010-07-04 19:00:00 | YM | Futures | 9083.6 | 9083.6 | 9075.1 | 9075.1 | 45.0 |
| 2010-07-04 19:30:00 | YM | Futures | 9076.1 | 9086.5 | 9074.2 | 9078.9 | 765.0 |
| 2010-07-04 20:00:00 | YM | Futures | 9079.8 | 9100.7 | 9079.8 | 9090.3 | 262.0 |
| 2010-07-04 20:30:00 | YM | Futures | 9090.3 | 9101.6 | 9086.5 | 9087.4 | 414.0 |
| 2010-07-04 21:00:00 | YM | Futures | 9088.4 | 9100.7 | 9088.4 | 9096.9 | 178.0 |
| 2010-07-04 21:30:00 | YM | Futures | 9096.9 | 9098.8 | 9085.5 | 9089.3 | 212.0 |
| 2010-07-04 22:00:00 | YM | Futures | 9092.2 | 9104.5 | 9082.7 | 9101.6 | 354.0 |
| 2010-07-04 22:30:00 | YM | Futures | 9100.7 | 9102.6 | 9095.0 | 9095.0 | 43.0 |
| 2010-07-04 23:00:00 | YM | Futures | 9096.9 | 9100.7 | 9092.2 | 9095.0 | 98.0 |
| 2010-07-04 23:30:00 | YM | Futures | 9095.0 | 9095.0 | 9087.4 | 9088.4 | 119.0 |
| 2010-07-04 18:00:00 | CL | Futures | 139.11 | 139.83 | 139.11 | 139.79 | 182.0 |
| 2010-07-04 18:30:00 | CL | Futures | 139.81 | 140.1 | 139.77 | 140.0 | 247.0 |
| 2010-07-04 19:00:00 | CL | Futures | 140.0 | 140.0 | 139.48 | 139.52 | 218.0 |
| 2010-07-04 19:30:00 | CL | Futures | 139.63 | 139.96 | 139.63 | 139.86 | 90.0 |
| 2010-07-04 20:00:00 | CL | Futures | 139.94 | 140.1 | 139.69 | 139.84 | 135.0 |
| 2010-07-04 20:30:00 | CL | Futures | 139.86 | 140.1 | 139.86 | 139.9 | 73.0 |
| 2010-07-04 21:00:00 | CL | Futures | 139.98 | 140.12 | 139.9 | 139.9 | 149.0 |
| 2010-07-04 21:30:00 | CL | Futures | 140.0 | 140.13 | 139.77 | 140.04 | 172.0 |
| 2010-07-04 22:00:00 | CL | Futures | 140.04 | 140.35 | 139.96 | 140.31 | 303.0 |
| 2010-07-04 22:30:00 | CL | Futures | 140.33 | 140.35 | 139.88 | 139.98 | 268.0 |
| 2010-07-04 23:00:00 | CL | Futures | 139.98 | 140.1 | 139.88 | 139.92 | 93.0 |
| 2010-07-04 23:30:00 | CL | Futures | 139.98 | 140.04 | 139.96 | 140.0 | 63.0 |
| 2010-07-04 18:00:00 | GC | Futures | 1701.3 | 1705.2 | 1700.8 | 1702.6 | 311.0 |
| 2010-07-04 18:30:00 | GC | Futures | 1702.4 | 1702.4 | 1700.1 | 1700.8 | 124.0 |
> showing 50 of 323 rows — these rows as CSV