PREVIEW / futures_30min / 2009-05-24
file: by_date/futures_30min/2009/2009-05-24.parquet size: 14 KB rows: 288
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 |
|---|---|---|---|---|---|---|---|
| 2009-05-24 18:00:00 | ES | Futures | 848.3 | 850.22 | 848.3 | 849.26 | 1557.0 |
| 2009-05-24 18:30:00 | ES | Futures | 849.26 | 849.98 | 848.54 | 849.74 | 261.0 |
| 2009-05-24 19:00:00 | ES | Futures | 849.5 | 849.74 | 849.26 | 849.5 | 73.0 |
| 2009-05-24 19:30:00 | ES | Futures | 849.5 | 850.94 | 849.26 | 850.22 | 991.0 |
| 2009-05-24 20:00:00 | ES | Futures | 850.22 | 852.86 | 850.22 | 852.62 | 2087.0 |
| 2009-05-24 20:30:00 | ES | Futures | 852.86 | 854.05 | 852.38 | 852.86 | 1943.0 |
| 2009-05-24 21:00:00 | ES | Futures | 853.1 | 853.34 | 850.7 | 852.14 | 1165.0 |
| 2009-05-24 21:30:00 | ES | Futures | 852.14 | 852.62 | 849.74 | 849.74 | 1368.0 |
| 2009-05-24 22:00:00 | ES | Futures | 849.74 | 850.22 | 849.02 | 849.74 | 819.0 |
| 2009-05-24 22:30:00 | ES | Futures | 849.74 | 849.98 | 841.83 | 845.43 | 6454.0 |
| 2009-05-24 23:00:00 | ES | Futures | 845.43 | 847.11 | 844.47 | 846.39 | 1012.0 |
| 2009-05-24 23:30:00 | ES | Futures | 846.39 | 847.82 | 845.67 | 847.35 | 1005.0 |
| 2009-05-24 18:00:00 | NQ | Futures | 1545.44 | 1549.7 | 1545.44 | 1547.43 | 97.0 |
| 2009-05-24 18:30:00 | NQ | Futures | 1548.56 | 1548.56 | 1544.58 | 1547.43 | 73.0 |
| 2009-05-24 19:00:00 | NQ | Futures | 1547.99 | 1548.28 | 1546.29 | 1547.71 | 10.0 |
| 2009-05-24 19:30:00 | NQ | Futures | 1547.99 | 1549.98 | 1546.86 | 1549.98 | 9.0 |
| 2009-05-24 20:00:00 | NQ | Futures | 1550.27 | 1552.26 | 1549.13 | 1552.26 | 232.0 |
| 2009-05-24 20:30:00 | NQ | Futures | 1552.54 | 1554.24 | 1551.97 | 1551.97 | 44.0 |
| 2009-05-24 21:00:00 | NQ | Futures | 1553.11 | 1553.11 | 1550.55 | 1551.12 | 63.0 |
| 2009-05-24 21:30:00 | NQ | Futures | 1551.4 | 1551.97 | 1547.99 | 1547.99 | 89.0 |
| 2009-05-24 22:00:00 | NQ | Futures | 1547.99 | 1548.28 | 1546.0 | 1547.43 | 32.0 |
| 2009-05-24 22:30:00 | NQ | Futures | 1546.86 | 1546.86 | 1533.22 | 1538.62 | 433.0 |
| 2009-05-24 23:00:00 | NQ | Futures | 1539.47 | 1542.03 | 1537.48 | 1541.46 | 121.0 |
| 2009-05-24 23:30:00 | NQ | Futures | 1541.46 | 1543.16 | 1540.04 | 1542.6 | 38.0 |
| 2009-05-24 18:00:00 | YM | Futures | 7598.8 | 7604.3 | 7594.2 | 7597.0 | 59.0 |
| 2009-05-24 18:30:00 | YM | Futures | 7594.2 | 7597.9 | 7594.2 | 7597.9 | 25.0 |
| 2009-05-24 19:00:00 | YM | Futures | 7595.1 | 7604.3 | 7595.1 | 7604.3 | 22.0 |
| 2009-05-24 19:30:00 | YM | Futures | 7604.3 | 7604.3 | 7599.7 | 7599.7 | 26.0 |
| 2009-05-24 20:00:00 | YM | Futures | 7602.5 | 7622.7 | 7602.5 | 7622.7 | 166.0 |
| 2009-05-24 20:30:00 | YM | Futures | 7624.5 | 7634.6 | 7618.1 | 7624.5 | 250.0 |
| 2009-05-24 21:00:00 | YM | Futures | 7625.4 | 7626.4 | 7613.5 | 7618.1 | 146.0 |
| 2009-05-24 21:30:00 | YM | Futures | 7622.7 | 7622.7 | 7603.4 | 7603.4 | 124.0 |
| 2009-05-24 22:00:00 | YM | Futures | 7603.4 | 7606.1 | 7595.1 | 7599.7 | 92.0 |
| 2009-05-24 22:30:00 | YM | Futures | 7602.5 | 7602.5 | 7539.1 | 7568.5 | 616.0 |
| 2009-05-24 23:00:00 | YM | Futures | 7570.3 | 7583.2 | 7560.2 | 7579.5 | 111.0 |
| 2009-05-24 23:30:00 | YM | Futures | 7580.4 | 7583.2 | 7572.1 | 7580.4 | 187.0 |
| 2009-05-24 18:00:00 | CL | Futures | 146.923 | 148.117 | 146.899 | 148.022 | 261.0 |
| 2009-05-24 18:30:00 | CL | Futures | 147.95 | 148.499 | 147.926 | 148.356 | 205.0 |
| 2009-05-24 19:00:00 | CL | Futures | 148.356 | 148.428 | 147.759 | 148.141 | 135.0 |
| 2009-05-24 19:30:00 | CL | Futures | 148.141 | 148.141 | 147.998 | 148.117 | 31.0 |
| 2009-05-24 20:00:00 | CL | Futures | 148.022 | 148.045 | 147.568 | 147.711 | 118.0 |
| 2009-05-24 20:30:00 | CL | Futures | 147.735 | 147.926 | 147.735 | 147.878 | 78.0 |
| 2009-05-24 21:00:00 | CL | Futures | 147.878 | 147.95 | 147.615 | 147.615 | 111.0 |
| 2009-05-24 21:30:00 | CL | Futures | 147.615 | 147.639 | 147.209 | 147.233 | 101.0 |
| 2009-05-24 22:00:00 | CL | Futures | 147.185 | 147.377 | 147.066 | 147.09 | 107.0 |
| 2009-05-24 22:30:00 | CL | Futures | 147.066 | 147.209 | 146.373 | 146.445 | 179.0 |
| 2009-05-24 23:00:00 | CL | Futures | 146.516 | 146.564 | 146.397 | 146.54 | 96.0 |
| 2009-05-24 23:30:00 | CL | Futures | 146.564 | 146.803 | 146.564 | 146.731 | 98.0 |
| 2009-05-24 18:00:00 | GC | Futures | 1359.0 | 1359.0 | 1357.5 | 1359.0 | 94.0 |
| 2009-05-24 18:30:00 | GC | Futures | 1358.8 | 1359.5 | 1357.8 | 1359.0 | 63.0 |
> showing 50 of 288 rows — these rows as CSV