PREVIEW / futures_30min / 2008-04-14
file: by_date/futures_30min/2008/2008-04-14.parquet size: 66 KB rows: 2,223
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-14 00:00:00 | ES | Futures | 1238.96 | 1240.59 | 1238.26 | 1240.13 | 723.0 |
| 2008-04-14 00:30:00 | ES | Futures | 1240.36 | 1240.59 | 1239.43 | 1239.89 | 247.0 |
| 2008-04-14 01:00:00 | ES | Futures | 1239.89 | 1240.36 | 1239.89 | 1240.13 | 317.0 |
| 2008-04-14 01:30:00 | ES | Futures | 1240.13 | 1241.29 | 1239.89 | 1241.06 | 786.0 |
| 2008-04-14 02:00:00 | ES | Futures | 1241.29 | 1242.22 | 1239.19 | 1241.99 | 2698.0 |
| 2008-04-14 02:30:00 | ES | Futures | 1241.99 | 1241.99 | 1240.36 | 1241.29 | 2538.0 |
| 2008-04-14 03:00:00 | ES | Futures | 1241.29 | 1243.62 | 1241.06 | 1241.52 | 8611.0 |
| 2008-04-14 03:30:00 | ES | Futures | 1241.29 | 1241.29 | 1238.5 | 1239.89 | 5674.0 |
| 2008-04-14 04:00:00 | ES | Futures | 1239.66 | 1242.22 | 1239.66 | 1242.22 | 4215.0 |
| 2008-04-14 04:30:00 | ES | Futures | 1241.99 | 1242.45 | 1240.59 | 1242.22 | 2568.0 |
| 2008-04-14 05:00:00 | ES | Futures | 1242.45 | 1244.32 | 1241.52 | 1243.62 | 5063.0 |
| 2008-04-14 05:30:00 | ES | Futures | 1243.62 | 1244.55 | 1242.22 | 1244.08 | 5071.0 |
| 2008-04-14 06:00:00 | ES | Futures | 1243.85 | 1243.85 | 1237.8 | 1239.43 | 9723.0 |
| 2008-04-14 06:30:00 | ES | Futures | 1239.19 | 1239.43 | 1237.8 | 1238.96 | 6117.0 |
| 2008-04-14 07:00:00 | ES | Futures | 1238.96 | 1239.43 | 1237.33 | 1238.26 | 8355.0 |
| 2008-04-14 07:30:00 | ES | Futures | 1238.26 | 1239.19 | 1236.4 | 1236.63 | 11824.0 |
| 2008-04-14 08:00:00 | ES | Futures | 1236.63 | 1237.33 | 1234.77 | 1236.87 | 19478.0 |
| 2008-04-14 08:30:00 | ES | Futures | 1236.63 | 1241.06 | 1235.93 | 1240.36 | 48348.0 |
| 2008-04-14 09:00:00 | ES | Futures | 1240.59 | 1243.15 | 1240.13 | 1242.22 | 27182.0 |
| 2008-04-14 09:30:00 | ES | Futures | 1242.22 | 1243.15 | 1240.13 | 1242.22 | 157976.0 |
| 2008-04-14 10:00:00 | ES | Futures | 1242.22 | 1243.85 | 1238.03 | 1239.89 | 173213.0 |
| 2008-04-14 10:30:00 | ES | Futures | 1239.66 | 1243.15 | 1239.43 | 1242.22 | 106127.0 |
| 2008-04-14 11:00:00 | ES | Futures | 1242.22 | 1243.15 | 1237.33 | 1238.26 | 85827.0 |
| 2008-04-14 11:30:00 | ES | Futures | 1238.26 | 1239.66 | 1236.4 | 1239.43 | 86417.0 |
| 2008-04-14 12:00:00 | ES | Futures | 1239.66 | 1242.92 | 1238.26 | 1242.92 | 74995.0 |
| 2008-04-14 12:30:00 | ES | Futures | 1242.92 | 1245.25 | 1241.52 | 1245.02 | 94775.0 |
| 2008-04-14 13:00:00 | ES | Futures | 1244.78 | 1245.48 | 1241.29 | 1242.69 | 69628.0 |
| 2008-04-14 13:30:00 | ES | Futures | 1242.45 | 1243.15 | 1239.66 | 1240.82 | 53812.0 |
| 2008-04-14 14:00:00 | ES | Futures | 1240.82 | 1241.29 | 1238.73 | 1239.66 | 62606.0 |
| 2008-04-14 14:30:00 | ES | Futures | 1239.66 | 1241.99 | 1237.56 | 1238.03 | 74600.0 |
| 2008-04-14 15:00:00 | ES | Futures | 1238.26 | 1239.19 | 1236.87 | 1237.33 | 70103.0 |
| 2008-04-14 15:30:00 | ES | Futures | 1237.1 | 1240.36 | 1236.17 | 1238.5 | 111097.0 |
| 2008-04-14 16:00:00 | ES | Futures | 1238.73 | 1240.13 | 1238.26 | 1239.66 | 44210.0 |
| 2008-04-14 16:30:00 | ES | Futures | 1239.66 | 1240.82 | 1239.43 | 1240.13 | 5260.0 |
| 2008-04-14 17:00:00 | ES | Futures | 1240.13 | 1240.82 | 1238.5 | 1239.19 | 1564.0 |
| 2008-04-14 18:00:00 | ES | Futures | 1238.96 | 1239.66 | 1238.5 | 1239.19 | 1563.0 |
| 2008-04-14 18:30:00 | ES | Futures | 1239.43 | 1239.66 | 1238.96 | 1238.96 | 152.0 |
| 2008-04-14 19:00:00 | ES | Futures | 1238.96 | 1241.29 | 1238.73 | 1240.82 | 3034.0 |
| 2008-04-14 19:30:00 | ES | Futures | 1241.06 | 1241.29 | 1240.59 | 1241.29 | 464.0 |
| 2008-04-14 20:00:00 | ES | Futures | 1241.29 | 1241.29 | 1240.36 | 1240.59 | 423.0 |
| 2008-04-14 20:30:00 | ES | Futures | 1240.59 | 1241.29 | 1240.36 | 1240.82 | 584.0 |
| 2008-04-14 21:00:00 | ES | Futures | 1240.82 | 1241.52 | 1240.82 | 1241.29 | 445.0 |
| 2008-04-14 21:30:00 | ES | Futures | 1241.52 | 1243.15 | 1241.29 | 1242.92 | 2411.0 |
| 2008-04-14 22:00:00 | ES | Futures | 1242.92 | 1243.39 | 1241.99 | 1242.22 | 866.0 |
| 2008-04-14 22:30:00 | ES | Futures | 1242.45 | 1242.45 | 1239.19 | 1239.43 | 1814.0 |
| 2008-04-14 23:00:00 | ES | Futures | 1239.66 | 1241.29 | 1239.19 | 1241.29 | 536.0 |
| 2008-04-14 23:30:00 | ES | Futures | 1241.52 | 1242.22 | 1240.36 | 1240.82 | 362.0 |
| 2008-04-14 00:00:00 | NQ | Futures | 2036.37 | 2038.91 | 2036.37 | 2038.63 | 51.0 |
| 2008-04-14 00:30:00 | NQ | Futures | 2038.63 | 2038.63 | 2037.78 | 2037.78 | 44.0 |
| 2008-04-14 01:00:00 | NQ | Futures | 2038.35 | 2038.35 | 2036.93 | 2036.93 | 15.0 |
> showing 50 of 2,223 rows — these rows as CSV