PREVIEW / futures_30min / 2010-04-25
file: by_date/futures_30min/2010/2010-04-25.parquet size: 18 KB rows: 445
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-04-25 18:00:00 | ES | Futures | 1184.25 | 1184.49 | 1183.02 | 1184.0 | 4350.0 |
| 2010-04-25 18:30:00 | ES | Futures | 1184.0 | 1184.0 | 1183.27 | 1183.51 | 1268.0 |
| 2010-04-25 19:00:00 | ES | Futures | 1183.51 | 1184.0 | 1183.02 | 1183.27 | 532.0 |
| 2010-04-25 19:30:00 | ES | Futures | 1183.27 | 1184.49 | 1183.02 | 1184.0 | 1270.0 |
| 2010-04-25 20:00:00 | ES | Futures | 1184.25 | 1185.71 | 1183.76 | 1185.71 | 2734.0 |
| 2010-04-25 20:30:00 | ES | Futures | 1185.71 | 1186.45 | 1185.47 | 1186.2 | 2659.0 |
| 2010-04-25 21:00:00 | ES | Futures | 1186.2 | 1187.42 | 1186.2 | 1186.93 | 4403.0 |
| 2010-04-25 21:30:00 | ES | Futures | 1186.93 | 1187.91 | 1186.93 | 1187.67 | 2588.0 |
| 2010-04-25 22:00:00 | ES | Futures | 1187.67 | 1188.16 | 1186.93 | 1186.93 | 3504.0 |
| 2010-04-25 22:30:00 | ES | Futures | 1186.69 | 1187.18 | 1186.45 | 1187.18 | 1320.0 |
| 2010-04-25 23:00:00 | ES | Futures | 1187.18 | 1187.67 | 1186.93 | 1187.42 | 506.0 |
| 2010-04-25 23:30:00 | ES | Futures | 1187.18 | 1187.42 | 1186.45 | 1186.69 | 1249.0 |
| 2010-04-25 18:00:00 | NQ | Futures | 2348.26 | 2349.69 | 2347.11 | 2348.54 | 598.0 |
| 2010-04-25 18:30:00 | NQ | Futures | 2348.54 | 2348.83 | 2346.82 | 2348.54 | 468.0 |
| 2010-04-25 19:00:00 | NQ | Futures | 2348.54 | 2348.54 | 2347.68 | 2347.68 | 62.0 |
| 2010-04-25 19:30:00 | NQ | Futures | 2347.4 | 2348.54 | 2346.82 | 2348.26 | 51.0 |
| 2010-04-25 20:00:00 | NQ | Futures | 2348.26 | 2351.69 | 2347.97 | 2351.12 | 345.0 |
| 2010-04-25 20:30:00 | NQ | Futures | 2351.12 | 2353.7 | 2350.83 | 2353.12 | 305.0 |
| 2010-04-25 21:00:00 | NQ | Futures | 2352.84 | 2353.98 | 2352.26 | 2353.12 | 552.0 |
| 2010-04-25 21:30:00 | NQ | Futures | 2353.12 | 2355.13 | 2353.12 | 2354.84 | 380.0 |
| 2010-04-25 22:00:00 | NQ | Futures | 2354.84 | 2355.41 | 2353.7 | 2353.98 | 146.0 |
| 2010-04-25 22:30:00 | NQ | Futures | 2353.7 | 2354.27 | 2353.41 | 2354.27 | 104.0 |
| 2010-04-25 23:00:00 | NQ | Futures | 2354.56 | 2354.84 | 2354.27 | 2354.56 | 42.0 |
| 2010-04-25 23:30:00 | NQ | Futures | 2354.27 | 2354.27 | 2353.41 | 2353.41 | 101.0 |
| 2010-04-25 18:00:00 | YM | Futures | 10481.6 | 10482.5 | 10471.2 | 10477.8 | 387.0 |
| 2010-04-25 18:30:00 | YM | Futures | 10477.8 | 10477.8 | 10472.2 | 10476.9 | 102.0 |
| 2010-04-25 19:00:00 | YM | Futures | 10476.9 | 10477.8 | 10473.1 | 10473.1 | 30.0 |
| 2010-04-25 19:30:00 | YM | Futures | 10472.2 | 10478.8 | 10471.2 | 10476.9 | 75.0 |
| 2010-04-25 20:00:00 | YM | Futures | 10476.9 | 10489.1 | 10476.9 | 10489.1 | 215.0 |
| 2010-04-25 20:30:00 | YM | Futures | 10490.0 | 10498.5 | 10488.2 | 10497.6 | 168.0 |
| 2010-04-25 21:00:00 | YM | Futures | 10497.6 | 10503.2 | 10495.7 | 10501.3 | 127.0 |
| 2010-04-25 21:30:00 | YM | Futures | 10501.3 | 10507.0 | 10501.3 | 10506.0 | 84.0 |
| 2010-04-25 22:00:00 | YM | Futures | 10507.0 | 10510.7 | 10499.5 | 10499.5 | 145.0 |
| 2010-04-25 22:30:00 | YM | Futures | 10500.4 | 10503.2 | 10497.6 | 10503.2 | 42.0 |
| 2010-04-25 23:00:00 | YM | Futures | 10503.2 | 10505.1 | 10501.3 | 10503.2 | 31.0 |
| 2010-04-25 23:30:00 | YM | Futures | 10503.2 | 10504.2 | 10496.6 | 10498.5 | 128.0 |
| 2010-04-25 18:00:00 | CL | Futures | 178.23 | 178.48 | 178.02 | 178.34 | 799.0 |
| 2010-04-25 18:30:00 | CL | Futures | 178.36 | 178.63 | 178.32 | 178.57 | 320.0 |
| 2010-04-25 19:00:00 | CL | Futures | 178.57 | 178.65 | 178.36 | 178.42 | 417.0 |
| 2010-04-25 19:30:00 | CL | Futures | 178.38 | 178.38 | 178.13 | 178.17 | 173.0 |
| 2010-04-25 20:00:00 | CL | Futures | 178.17 | 178.61 | 178.15 | 178.61 | 577.0 |
| 2010-04-25 20:30:00 | CL | Futures | 178.57 | 178.94 | 178.55 | 178.8 | 1162.0 |
| 2010-04-25 21:00:00 | CL | Futures | 178.82 | 178.94 | 178.76 | 178.82 | 343.0 |
| 2010-04-25 21:30:00 | CL | Futures | 178.82 | 178.86 | 178.65 | 178.78 | 238.0 |
| 2010-04-25 22:00:00 | CL | Futures | 178.76 | 178.82 | 178.71 | 178.76 | 133.0 |
| 2010-04-25 22:30:00 | CL | Futures | 178.76 | 178.92 | 178.74 | 178.82 | 261.0 |
| 2010-04-25 23:00:00 | CL | Futures | 178.82 | 178.88 | 178.57 | 178.69 | 628.0 |
| 2010-04-25 23:30:00 | CL | Futures | 178.67 | 178.78 | 178.63 | 178.69 | 231.0 |
| 2010-04-25 18:00:00 | GC | Futures | 1628.9 | 1629.6 | 1626.4 | 1629.5 | 1276.0 |
| 2010-04-25 18:30:00 | GC | Futures | 1629.3 | 1629.9 | 1627.8 | 1628.8 | 343.0 |
> showing 50 of 445 rows — these rows as CSV