PREVIEW / futures_30min / 2010-12-26
file: by_date/futures_30min/2010/2010-12-26.parquet size: 18 KB rows: 450
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-26 18:00:00 | ES | Futures | 1236.64 | 1237.14 | 1234.41 | 1234.66 | 8422.0 |
| 2010-12-26 18:30:00 | ES | Futures | 1234.91 | 1235.16 | 1232.68 | 1234.41 | 6254.0 |
| 2010-12-26 19:00:00 | ES | Futures | 1234.41 | 1234.91 | 1233.42 | 1234.17 | 3524.0 |
| 2010-12-26 19:30:00 | ES | Futures | 1234.17 | 1234.66 | 1233.42 | 1234.41 | 1387.0 |
| 2010-12-26 20:00:00 | ES | Futures | 1234.41 | 1235.16 | 1234.41 | 1234.66 | 764.0 |
| 2010-12-26 20:30:00 | ES | Futures | 1234.41 | 1234.41 | 1233.67 | 1234.41 | 1296.0 |
| 2010-12-26 21:00:00 | ES | Futures | 1234.41 | 1236.39 | 1234.17 | 1236.15 | 2107.0 |
| 2010-12-26 21:30:00 | ES | Futures | 1236.39 | 1237.14 | 1235.9 | 1236.64 | 1857.0 |
| 2010-12-26 22:00:00 | ES | Futures | 1236.64 | 1237.63 | 1235.9 | 1237.14 | 2031.0 |
| 2010-12-26 22:30:00 | ES | Futures | 1237.38 | 1237.63 | 1236.89 | 1237.14 | 769.0 |
| 2010-12-26 23:00:00 | ES | Futures | 1237.14 | 1237.63 | 1237.14 | 1237.38 | 220.0 |
| 2010-12-26 23:30:00 | ES | Futures | 1237.14 | 1237.63 | 1237.14 | 1237.38 | 314.0 |
| 2010-12-26 18:00:00 | NQ | Futures | 2557.17 | 2557.46 | 2551.72 | 2551.72 | 923.0 |
| 2010-12-26 18:30:00 | NQ | Futures | 2552.29 | 2553.15 | 2548.27 | 2551.72 | 853.0 |
| 2010-12-26 19:00:00 | NQ | Futures | 2551.72 | 2553.44 | 2550.28 | 2550.57 | 550.0 |
| 2010-12-26 19:30:00 | NQ | Futures | 2550.86 | 2552.87 | 2550.28 | 2552.01 | 125.0 |
| 2010-12-26 20:00:00 | NQ | Futures | 2552.58 | 2553.15 | 2552.29 | 2552.29 | 149.0 |
| 2010-12-26 20:30:00 | NQ | Futures | 2552.01 | 2552.01 | 2550.57 | 2552.01 | 91.0 |
| 2010-12-26 21:00:00 | NQ | Futures | 2552.29 | 2556.02 | 2551.43 | 2555.45 | 270.0 |
| 2010-12-26 21:30:00 | NQ | Futures | 2555.45 | 2557.46 | 2555.16 | 2556.02 | 185.0 |
| 2010-12-26 22:00:00 | NQ | Futures | 2556.31 | 2558.32 | 2555.45 | 2557.75 | 225.0 |
| 2010-12-26 22:30:00 | NQ | Futures | 2558.03 | 2558.61 | 2556.89 | 2557.46 | 113.0 |
| 2010-12-26 23:00:00 | NQ | Futures | 2557.46 | 2557.75 | 2557.17 | 2557.46 | 28.0 |
| 2010-12-26 23:30:00 | NQ | Futures | 2557.46 | 2557.75 | 2557.17 | 2557.46 | 27.0 |
| 2010-12-26 18:00:00 | YM | Futures | 11013.5 | 11013.5 | 10986.7 | 10992.5 | 489.0 |
| 2010-12-26 18:30:00 | YM | Futures | 10992.5 | 10994.4 | 10971.4 | 10989.6 | 312.0 |
| 2010-12-26 19:00:00 | YM | Futures | 10983.8 | 10990.6 | 10981.9 | 10984.8 | 164.0 |
| 2010-12-26 19:30:00 | YM | Futures | 10983.8 | 10991.5 | 10982.9 | 10989.6 | 84.0 |
| 2010-12-26 20:00:00 | YM | Futures | 10989.6 | 10992.5 | 10989.6 | 10990.6 | 45.0 |
| 2010-12-26 20:30:00 | YM | Futures | 10989.6 | 10991.5 | 10984.8 | 10990.6 | 99.0 |
| 2010-12-26 21:00:00 | YM | Futures | 10990.6 | 11006.8 | 10988.6 | 11006.8 | 239.0 |
| 2010-12-26 21:30:00 | YM | Futures | 11001.1 | 11009.7 | 11001.1 | 11004.9 | 83.0 |
| 2010-12-26 22:00:00 | YM | Futures | 11004.0 | 11014.5 | 11004.0 | 11012.6 | 170.0 |
| 2010-12-26 22:30:00 | YM | Futures | 11013.5 | 11013.5 | 11009.7 | 11010.7 | 32.0 |
| 2010-12-26 23:00:00 | YM | Futures | 11011.6 | 11012.6 | 11010.7 | 11011.6 | 23.0 |
| 2010-12-26 23:30:00 | YM | Futures | 11011.6 | 11011.6 | 11009.7 | 11011.6 | 20.0 |
| 2010-12-26 18:00:00 | CL | Futures | 168.92 | 169.18 | 168.4 | 168.46 | 1896.0 |
| 2010-12-26 18:30:00 | CL | Futures | 168.46 | 168.55 | 168.4 | 168.52 | 784.0 |
| 2010-12-26 19:00:00 | CL | Futures | 168.48 | 169.09 | 168.46 | 169.02 | 803.0 |
| 2010-12-26 19:30:00 | CL | Futures | 169.05 | 169.09 | 168.81 | 168.96 | 457.0 |
| 2010-12-26 20:00:00 | CL | Futures | 168.96 | 169.24 | 168.92 | 168.96 | 494.0 |
| 2010-12-26 20:30:00 | CL | Futures | 168.94 | 169.28 | 168.89 | 169.18 | 168.0 |
| 2010-12-26 21:00:00 | CL | Futures | 169.2 | 169.54 | 169.18 | 169.44 | 424.0 |
| 2010-12-26 21:30:00 | CL | Futures | 169.42 | 169.46 | 169.35 | 169.42 | 323.0 |
| 2010-12-26 22:00:00 | CL | Futures | 169.44 | 169.55 | 169.37 | 169.55 | 297.0 |
| 2010-12-26 22:30:00 | CL | Futures | 169.55 | 169.55 | 169.41 | 169.42 | 202.0 |
| 2010-12-26 23:00:00 | CL | Futures | 169.44 | 169.5 | 169.39 | 169.48 | 83.0 |
| 2010-12-26 23:30:00 | CL | Futures | 169.46 | 169.72 | 169.44 | 169.63 | 379.0 |
| 2010-12-26 18:00:00 | GC | Futures | 1926.0 | 1926.0 | 1919.5 | 1920.0 | 2310.0 |
| 2010-12-26 18:30:00 | GC | Futures | 1919.9 | 1921.7 | 1917.4 | 1918.6 | 1211.0 |
> showing 50 of 450 rows — these rows as CSV