PREVIEW / futures_30min / 2010-12-19
file: by_date/futures_30min/2010/2010-12-19.parquet size: 19 KB rows: 476
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-12-19 18:00:00 | ES | Futures | 1227.24 | 1227.49 | 1226.5 | 1227.24 | 3984.0 |
| 2010-12-19 18:30:00 | ES | Futures | 1227.24 | 1227.73 | 1226.99 | 1227.49 | 1495.0 |
| 2010-12-19 19:00:00 | ES | Futures | 1227.49 | 1227.98 | 1226.74 | 1226.99 | 2018.0 |
| 2010-12-19 19:30:00 | ES | Futures | 1226.99 | 1226.99 | 1225.26 | 1225.51 | 2847.0 |
| 2010-12-19 20:00:00 | ES | Futures | 1225.75 | 1226.0 | 1225.01 | 1225.26 | 1547.0 |
| 2010-12-19 20:30:00 | ES | Futures | 1225.51 | 1226.0 | 1225.01 | 1225.01 | 1161.0 |
| 2010-12-19 21:00:00 | ES | Futures | 1225.26 | 1226.5 | 1225.26 | 1225.51 | 1032.0 |
| 2010-12-19 21:30:00 | ES | Futures | 1225.51 | 1226.5 | 1225.51 | 1226.0 | 689.0 |
| 2010-12-19 22:00:00 | ES | Futures | 1226.0 | 1226.0 | 1222.78 | 1223.28 | 4927.0 |
| 2010-12-19 22:30:00 | ES | Futures | 1223.03 | 1224.02 | 1221.55 | 1222.04 | 7374.0 |
| 2010-12-19 23:00:00 | ES | Futures | 1222.04 | 1222.78 | 1221.3 | 1222.54 | 2047.0 |
| 2010-12-19 23:30:00 | ES | Futures | 1222.54 | 1222.78 | 1222.04 | 1222.29 | 1249.0 |
| 2010-12-19 18:00:00 | NQ | Futures | 2544.26 | 2545.4 | 2543.39 | 2544.54 | 327.0 |
| 2010-12-19 18:30:00 | NQ | Futures | 2544.83 | 2545.98 | 2544.54 | 2544.83 | 71.0 |
| 2010-12-19 19:00:00 | NQ | Futures | 2545.12 | 2545.69 | 2543.68 | 2544.26 | 145.0 |
| 2010-12-19 19:30:00 | NQ | Futures | 2544.26 | 2544.26 | 2541.39 | 2542.53 | 150.0 |
| 2010-12-19 20:00:00 | NQ | Futures | 2542.53 | 2542.82 | 2540.81 | 2541.96 | 146.0 |
| 2010-12-19 20:30:00 | NQ | Futures | 2542.25 | 2542.82 | 2541.1 | 2541.1 | 145.0 |
| 2010-12-19 21:00:00 | NQ | Futures | 2541.39 | 2543.39 | 2541.1 | 2541.67 | 117.0 |
| 2010-12-19 21:30:00 | NQ | Futures | 2541.67 | 2542.53 | 2541.67 | 2541.96 | 33.0 |
| 2010-12-19 22:00:00 | NQ | Futures | 2541.96 | 2541.96 | 2536.51 | 2537.08 | 471.0 |
| 2010-12-19 22:30:00 | NQ | Futures | 2536.79 | 2538.8 | 2534.21 | 2535.07 | 458.0 |
| 2010-12-19 23:00:00 | NQ | Futures | 2535.07 | 2536.22 | 2533.92 | 2536.22 | 165.0 |
| 2010-12-19 23:30:00 | NQ | Futures | 2535.93 | 2535.93 | 2534.5 | 2534.5 | 124.0 |
| 2010-12-19 18:00:00 | YM | Futures | 10959.9 | 10963.7 | 10954.2 | 10957.0 | 222.0 |
| 2010-12-19 18:30:00 | YM | Futures | 10958.0 | 10961.8 | 10958.0 | 10958.0 | 31.0 |
| 2010-12-19 19:00:00 | YM | Futures | 10959.9 | 10975.2 | 10958.0 | 10958.9 | 219.0 |
| 2010-12-19 19:30:00 | YM | Futures | 10956.1 | 10956.1 | 10945.5 | 10948.4 | 148.0 |
| 2010-12-19 20:00:00 | YM | Futures | 10949.4 | 10951.3 | 10941.7 | 10943.6 | 87.0 |
| 2010-12-19 20:30:00 | YM | Futures | 10949.4 | 10950.3 | 10941.7 | 10941.7 | 45.0 |
| 2010-12-19 21:00:00 | YM | Futures | 10944.6 | 10951.3 | 10944.6 | 10946.5 | 47.0 |
| 2010-12-19 21:30:00 | YM | Futures | 10946.5 | 10950.3 | 10946.5 | 10947.5 | 35.0 |
| 2010-12-19 22:00:00 | YM | Futures | 10946.5 | 10946.5 | 10920.6 | 10925.4 | 193.0 |
| 2010-12-19 22:30:00 | YM | Futures | 10925.4 | 10931.2 | 10913.9 | 10915.8 | 181.0 |
| 2010-12-19 23:00:00 | YM | Futures | 10917.8 | 10923.5 | 10914.9 | 10923.5 | 140.0 |
| 2010-12-19 23:30:00 | YM | Futures | 10923.5 | 10923.5 | 10917.8 | 10919.7 | 63.0 |
| 2010-12-19 18:00:00 | CL | Futures | 164.68 | 164.69 | 164.42 | 164.55 | 346.0 |
| 2010-12-19 18:30:00 | CL | Futures | 164.51 | 165.08 | 164.49 | 165.08 | 454.0 |
| 2010-12-19 19:00:00 | CL | Futures | 165.07 | 165.2 | 165.05 | 165.12 | 551.0 |
| 2010-12-19 19:30:00 | CL | Futures | 165.1 | 165.1 | 164.86 | 164.92 | 471.0 |
| 2010-12-19 20:00:00 | CL | Futures | 164.92 | 165.1 | 164.82 | 164.97 | 421.0 |
| 2010-12-19 20:30:00 | CL | Futures | 164.99 | 165.07 | 164.92 | 164.94 | 228.0 |
| 2010-12-19 21:00:00 | CL | Futures | 164.94 | 165.08 | 164.9 | 165.05 | 315.0 |
| 2010-12-19 21:30:00 | CL | Futures | 165.07 | 165.07 | 164.71 | 164.75 | 337.0 |
| 2010-12-19 22:00:00 | CL | Futures | 164.75 | 164.77 | 164.21 | 164.21 | 668.0 |
| 2010-12-19 22:30:00 | CL | Futures | 164.21 | 164.4 | 163.86 | 164.03 | 1042.0 |
| 2010-12-19 23:00:00 | CL | Futures | 164.05 | 164.19 | 163.95 | 164.19 | 266.0 |
| 2010-12-19 23:30:00 | CL | Futures | 164.18 | 164.21 | 163.9 | 163.9 | 318.0 |
| 2010-12-19 18:00:00 | GC | Futures | 1923.4 | 1930.4 | 1923.4 | 1926.0 | 2615.0 |
| 2010-12-19 18:30:00 | GC | Futures | 1926.0 | 1932.3 | 1925.5 | 1930.4 | 1069.0 |
> showing 50 of 476 rows — these rows as CSV