PREVIEW / futures_30min / 2010-03-14
file: by_date/futures_30min/2010/2010-03-14.parquet size: 17 KB rows: 412
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-03-14 18:00:00 | ES | Futures | 1120.45 | 1120.94 | 1119.23 | 1119.47 | 2587.0 |
| 2010-03-14 18:30:00 | ES | Futures | 1119.47 | 1120.45 | 1119.23 | 1120.45 | 821.0 |
| 2010-03-14 19:00:00 | ES | Futures | 1120.21 | 1120.45 | 1119.47 | 1119.72 | 624.0 |
| 2010-03-14 19:30:00 | ES | Futures | 1119.72 | 1120.21 | 1119.47 | 1120.21 | 979.0 |
| 2010-03-14 20:00:00 | ES | Futures | 1120.21 | 1120.21 | 1119.47 | 1119.47 | 996.0 |
| 2010-03-14 20:30:00 | ES | Futures | 1119.47 | 1119.47 | 1117.76 | 1117.76 | 1920.0 |
| 2010-03-14 21:00:00 | ES | Futures | 1118.01 | 1118.01 | 1116.78 | 1116.78 | 3525.0 |
| 2010-03-14 21:30:00 | ES | Futures | 1117.03 | 1117.52 | 1115.56 | 1115.81 | 5248.0 |
| 2010-03-14 22:00:00 | ES | Futures | 1115.81 | 1116.29 | 1114.83 | 1116.29 | 4425.0 |
| 2010-03-14 22:30:00 | ES | Futures | 1116.29 | 1116.29 | 1115.07 | 1115.56 | 2278.0 |
| 2010-03-14 23:00:00 | ES | Futures | 1115.32 | 1115.81 | 1115.07 | 1115.81 | 1032.0 |
| 2010-03-14 23:30:00 | ES | Futures | 1115.56 | 1116.29 | 1115.32 | 1115.81 | 919.0 |
| 2010-03-14 18:00:00 | NQ | Futures | 2200.49 | 2201.92 | 2199.34 | 2200.2 | 84.0 |
| 2010-03-14 18:30:00 | NQ | Futures | 2200.49 | 2201.35 | 2200.2 | 2201.35 | 27.0 |
| 2010-03-14 19:00:00 | NQ | Futures | 2201.35 | 2201.63 | 2200.77 | 2200.77 | 40.0 |
| 2010-03-14 19:30:00 | NQ | Futures | 2201.06 | 2202.21 | 2201.06 | 2201.92 | 164.0 |
| 2010-03-14 20:00:00 | NQ | Futures | 2202.21 | 2202.21 | 2200.77 | 2200.77 | 78.0 |
| 2010-03-14 20:30:00 | NQ | Futures | 2200.49 | 2200.49 | 2198.2 | 2198.2 | 114.0 |
| 2010-03-14 21:00:00 | NQ | Futures | 2197.91 | 2197.91 | 2196.76 | 2197.05 | 219.0 |
| 2010-03-14 21:30:00 | NQ | Futures | 2196.76 | 2197.62 | 2195.33 | 2195.62 | 271.0 |
| 2010-03-14 22:00:00 | NQ | Futures | 2195.62 | 2196.48 | 2194.76 | 2196.19 | 233.0 |
| 2010-03-14 22:30:00 | NQ | Futures | 2196.19 | 2196.19 | 2193.9 | 2194.19 | 410.0 |
| 2010-03-14 23:00:00 | NQ | Futures | 2194.19 | 2195.62 | 2194.19 | 2195.05 | 110.0 |
| 2010-03-14 23:30:00 | NQ | Futures | 2195.33 | 2195.91 | 2195.05 | 2195.33 | 138.0 |
| 2010-03-14 18:00:00 | YM | Futures | 9948.0 | 9948.0 | 9934.9 | 9936.7 | 55.0 |
| 2010-03-14 18:30:00 | YM | Futures | 9936.7 | 9941.5 | 9934.9 | 9941.5 | 26.0 |
| 2010-03-14 19:00:00 | YM | Futures | 9941.5 | 9945.2 | 9934.9 | 9938.6 | 68.0 |
| 2010-03-14 19:30:00 | YM | Futures | 9939.6 | 9942.4 | 9934.9 | 9939.6 | 38.0 |
| 2010-03-14 20:00:00 | YM | Futures | 9941.5 | 9941.5 | 9938.6 | 9938.6 | 84.0 |
| 2010-03-14 20:30:00 | YM | Futures | 9937.7 | 9938.6 | 9924.5 | 9924.5 | 72.0 |
| 2010-03-14 21:00:00 | YM | Futures | 9924.5 | 9924.5 | 9917.0 | 9917.9 | 252.0 |
| 2010-03-14 21:30:00 | YM | Futures | 9917.9 | 9920.8 | 9905.7 | 9907.6 | 266.0 |
| 2010-03-14 22:00:00 | YM | Futures | 9907.6 | 9911.3 | 9901.9 | 9911.3 | 78.0 |
| 2010-03-14 22:30:00 | YM | Futures | 9911.3 | 9914.2 | 9905.7 | 9907.6 | 135.0 |
| 2010-03-14 23:00:00 | YM | Futures | 9906.6 | 9910.4 | 9905.7 | 9908.5 | 68.0 |
| 2010-03-14 23:30:00 | YM | Futures | 9909.5 | 9913.2 | 9907.6 | 9908.5 | 122.0 |
| 2010-03-14 18:00:00 | CL | Futures | 172.52 | 172.52 | 171.97 | 172.27 | 73.0 |
| 2010-03-14 18:30:00 | CL | Futures | 172.29 | 172.37 | 172.27 | 172.33 | 12.0 |
| 2010-03-14 19:00:00 | CL | Futures | 172.37 | 172.59 | 171.65 | 171.72 | 126.0 |
| 2010-03-14 19:30:00 | CL | Futures | 171.76 | 171.93 | 171.76 | 171.93 | 22.0 |
| 2010-03-14 20:00:00 | CL | Futures | 171.97 | 172.14 | 171.97 | 171.97 | 36.0 |
| 2010-03-14 20:30:00 | CL | Futures | 171.97 | 172.18 | 171.78 | 172.06 | 131.0 |
| 2010-03-14 21:00:00 | CL | Futures | 172.04 | 172.1 | 171.78 | 171.78 | 101.0 |
| 2010-03-14 21:30:00 | CL | Futures | 171.76 | 171.89 | 171.68 | 171.76 | 66.0 |
| 2010-03-14 22:00:00 | CL | Futures | 171.76 | 171.78 | 171.65 | 171.7 | 45.0 |
| 2010-03-14 22:30:00 | CL | Futures | 171.7 | 171.82 | 171.55 | 171.72 | 68.0 |
| 2010-03-14 23:00:00 | CL | Futures | 171.72 | 171.76 | 171.68 | 171.76 | 18.0 |
| 2010-03-14 23:30:00 | CL | Futures | 171.72 | 171.76 | 171.61 | 171.65 | 77.0 |
| 2010-03-14 18:00:00 | GC | Futures | 1551.0 | 1552.6 | 1550.1 | 1550.9 | 759.0 |
| 2010-03-14 18:30:00 | GC | Futures | 1551.0 | 1554.0 | 1550.9 | 1553.4 | 390.0 |
> showing 50 of 412 rows — these rows as CSV