PREVIEW / futures_30min / 2008-07-03
file: by_date/futures_30min/2008/2008-07-03.parquet size: 61 KB rows: 2,042
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-07-03 00:00:00 | ES | Futures | 1174.63 | 1177.18 | 1174.39 | 1176.95 | 2240.0 |
| 2008-07-03 00:30:00 | ES | Futures | 1176.72 | 1178.35 | 1176.72 | 1177.65 | 2319.0 |
| 2008-07-03 01:00:00 | ES | Futures | 1177.88 | 1178.58 | 1177.18 | 1177.88 | 848.0 |
| 2008-07-03 01:30:00 | ES | Futures | 1177.88 | 1177.88 | 1177.18 | 1177.65 | 803.0 |
| 2008-07-03 02:00:00 | ES | Futures | 1177.65 | 1178.35 | 1174.86 | 1175.09 | 2977.0 |
| 2008-07-03 02:30:00 | ES | Futures | 1175.32 | 1175.56 | 1173.23 | 1174.16 | 4461.0 |
| 2008-07-03 03:00:00 | ES | Futures | 1173.93 | 1176.02 | 1172.3 | 1174.86 | 8852.0 |
| 2008-07-03 03:30:00 | ES | Futures | 1175.09 | 1175.32 | 1172.54 | 1175.09 | 7485.0 |
| 2008-07-03 04:00:00 | ES | Futures | 1175.32 | 1178.11 | 1175.09 | 1176.95 | 11702.0 |
| 2008-07-03 04:30:00 | ES | Futures | 1176.95 | 1178.81 | 1175.79 | 1176.02 | 5716.0 |
| 2008-07-03 05:00:00 | ES | Futures | 1176.25 | 1179.28 | 1176.02 | 1177.42 | 11159.0 |
| 2008-07-03 05:30:00 | ES | Futures | 1177.18 | 1177.42 | 1174.39 | 1174.86 | 4878.0 |
| 2008-07-03 06:00:00 | ES | Futures | 1174.63 | 1175.32 | 1173.93 | 1175.09 | 4655.0 |
| 2008-07-03 06:30:00 | ES | Futures | 1175.09 | 1175.32 | 1173.7 | 1173.7 | 4808.0 |
| 2008-07-03 07:00:00 | ES | Futures | 1173.93 | 1175.56 | 1172.3 | 1174.86 | 18891.0 |
| 2008-07-03 07:30:00 | ES | Futures | 1175.09 | 1176.95 | 1171.14 | 1174.63 | 18184.0 |
| 2008-07-03 08:00:00 | ES | Futures | 1174.63 | 1176.72 | 1173.23 | 1173.47 | 21377.0 |
| 2008-07-03 08:30:00 | ES | Futures | 1173.47 | 1182.99 | 1171.84 | 1182.06 | 129783.0 |
| 2008-07-03 09:00:00 | ES | Futures | 1182.06 | 1184.16 | 1181.6 | 1183.23 | 56928.0 |
| 2008-07-03 09:30:00 | ES | Futures | 1182.99 | 1183.23 | 1167.42 | 1172.54 | 360346.0 |
| 2008-07-03 10:00:00 | ES | Futures | 1172.54 | 1176.72 | 1163.7 | 1176.49 | 318252.0 |
| 2008-07-03 10:30:00 | ES | Futures | 1176.49 | 1181.37 | 1175.09 | 1178.11 | 226284.0 |
| 2008-07-03 11:00:00 | ES | Futures | 1178.35 | 1183.23 | 1177.42 | 1182.76 | 159044.0 |
| 2008-07-03 11:30:00 | ES | Futures | 1182.76 | 1183.23 | 1177.65 | 1179.28 | 126476.0 |
| 2008-07-03 12:00:00 | ES | Futures | 1179.04 | 1179.51 | 1173.7 | 1177.42 | 113183.0 |
| 2008-07-03 12:30:00 | ES | Futures | 1177.65 | 1177.88 | 1172.77 | 1174.63 | 147883.0 |
| 2008-07-03 13:00:00 | ES | Futures | 1174.39 | 1176.49 | 1173.93 | 1176.49 | 51697.0 |
| 2008-07-03 16:30:00 | ES | Futures | 1176.49 | 1177.88 | 1172.77 | 1175.09 | 2236.0 |
| 2008-07-03 17:00:00 | ES | Futures | 1174.86 | 1178.35 | 1174.39 | 1176.72 | 692.0 |
| 2008-07-03 18:00:00 | ES | Futures | 1176.25 | 1179.04 | 1176.25 | 1177.88 | 585.0 |
| 2008-07-03 18:30:00 | ES | Futures | 1178.11 | 1178.35 | 1177.18 | 1177.18 | 115.0 |
| 2008-07-03 19:00:00 | ES | Futures | 1176.95 | 1176.95 | 1176.25 | 1176.25 | 430.0 |
| 2008-07-03 19:30:00 | ES | Futures | 1176.25 | 1176.72 | 1176.02 | 1176.25 | 466.0 |
| 2008-07-03 20:00:00 | ES | Futures | 1176.02 | 1177.88 | 1175.79 | 1176.95 | 240.0 |
| 2008-07-03 20:30:00 | ES | Futures | 1176.95 | 1176.95 | 1175.79 | 1176.02 | 234.0 |
| 2008-07-03 21:00:00 | ES | Futures | 1176.02 | 1176.72 | 1176.02 | 1176.72 | 140.0 |
| 2008-07-03 21:30:00 | ES | Futures | 1176.49 | 1176.49 | 1176.02 | 1176.25 | 130.0 |
| 2008-07-03 22:00:00 | ES | Futures | 1176.02 | 1176.72 | 1175.79 | 1176.72 | 192.0 |
| 2008-07-03 22:30:00 | ES | Futures | 1176.49 | 1176.72 | 1176.02 | 1176.49 | 115.0 |
| 2008-07-03 23:00:00 | ES | Futures | 1176.49 | 1176.95 | 1176.02 | 1176.72 | 176.0 |
| 2008-07-03 23:30:00 | ES | Futures | 1176.49 | 1176.95 | 1175.79 | 1176.25 | 358.0 |
| 2008-07-03 00:00:00 | NQ | Futures | 2044.69 | 2050.03 | 2044.69 | 2050.03 | 154.0 |
| 2008-07-03 00:30:00 | NQ | Futures | 2049.75 | 2051.44 | 2049.19 | 2049.75 | 152.0 |
| 2008-07-03 01:00:00 | NQ | Futures | 2050.6 | 2052.0 | 2050.03 | 2051.72 | 56.0 |
| 2008-07-03 01:30:00 | NQ | Futures | 2051.44 | 2052.85 | 2050.88 | 2052.0 | 240.0 |
| 2008-07-03 02:00:00 | NQ | Futures | 2052.56 | 2053.13 | 2048.91 | 2049.75 | 307.0 |
| 2008-07-03 02:30:00 | NQ | Futures | 2048.91 | 2050.03 | 2043.28 | 2046.66 | 500.0 |
| 2008-07-03 03:00:00 | NQ | Futures | 2046.66 | 2050.31 | 2043.56 | 2048.34 | 446.0 |
| 2008-07-03 03:30:00 | NQ | Futures | 2048.06 | 2048.06 | 2042.72 | 2045.81 | 991.0 |
| 2008-07-03 04:00:00 | NQ | Futures | 2046.38 | 2053.13 | 2046.09 | 2051.44 | 1260.0 |
> showing 50 of 2,042 rows — these rows as CSV