PREVIEW / futures_30min / 2008-08-01
file: by_date/futures_30min/2008/2008-08-01.parquet size: 57 KB rows: 1,833
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-08-01 00:00:00 | ES | Futures | 1175.79 | 1176.72 | 1175.56 | 1176.25 | 527.0 |
| 2008-08-01 00:30:00 | ES | Futures | 1175.79 | 1176.25 | 1175.56 | 1176.25 | 342.0 |
| 2008-08-01 01:00:00 | ES | Futures | 1176.25 | 1176.72 | 1175.56 | 1176.49 | 253.0 |
| 2008-08-01 01:30:00 | ES | Futures | 1176.49 | 1177.18 | 1176.25 | 1176.72 | 358.0 |
| 2008-08-01 02:00:00 | ES | Futures | 1176.49 | 1177.42 | 1175.09 | 1177.18 | 2532.0 |
| 2008-08-01 02:30:00 | ES | Futures | 1177.42 | 1178.35 | 1176.72 | 1177.42 | 3182.0 |
| 2008-08-01 03:00:00 | ES | Futures | 1177.65 | 1178.58 | 1176.72 | 1178.58 | 7072.0 |
| 2008-08-01 03:30:00 | ES | Futures | 1178.35 | 1179.28 | 1177.88 | 1179.04 | 5251.0 |
| 2008-08-01 04:00:00 | ES | Futures | 1179.04 | 1179.51 | 1178.58 | 1179.28 | 2721.0 |
| 2008-08-01 04:30:00 | ES | Futures | 1179.04 | 1179.97 | 1178.81 | 1179.04 | 4278.0 |
| 2008-08-01 05:00:00 | ES | Futures | 1179.04 | 1179.97 | 1178.58 | 1179.97 | 3411.0 |
| 2008-08-01 05:30:00 | ES | Futures | 1179.74 | 1181.13 | 1179.74 | 1180.67 | 5966.0 |
| 2008-08-01 06:00:00 | ES | Futures | 1180.67 | 1182.3 | 1180.67 | 1181.83 | 6497.0 |
| 2008-08-01 06:30:00 | ES | Futures | 1181.6 | 1182.3 | 1180.9 | 1180.9 | 7841.0 |
| 2008-08-01 07:00:00 | ES | Futures | 1181.13 | 1181.13 | 1174.63 | 1175.09 | 22681.0 |
| 2008-08-01 07:30:00 | ES | Futures | 1175.09 | 1177.18 | 1174.86 | 1176.49 | 8859.0 |
| 2008-08-01 08:00:00 | ES | Futures | 1176.72 | 1183.69 | 1176.25 | 1180.21 | 19859.0 |
| 2008-08-01 08:30:00 | ES | Futures | 1180.44 | 1185.32 | 1179.97 | 1182.3 | 100496.0 |
| 2008-08-01 09:00:00 | ES | Futures | 1182.06 | 1182.99 | 1180.21 | 1180.67 | 26122.0 |
| 2008-08-01 09:30:00 | ES | Futures | 1180.44 | 1182.3 | 1169.28 | 1172.07 | 273993.0 |
| 2008-08-01 10:00:00 | ES | Futures | 1172.07 | 1174.16 | 1164.87 | 1167.65 | 265634.0 |
| 2008-08-01 10:30:00 | ES | Futures | 1167.65 | 1173.23 | 1167.42 | 1172.07 | 145221.0 |
| 2008-08-01 11:00:00 | ES | Futures | 1172.07 | 1173.0 | 1168.58 | 1170.44 | 91387.0 |
| 2008-08-01 11:30:00 | ES | Futures | 1170.44 | 1174.63 | 1170.21 | 1173.0 | 96578.0 |
| 2008-08-01 12:00:00 | ES | Futures | 1173.0 | 1173.47 | 1169.05 | 1170.68 | 77105.0 |
| 2008-08-01 12:30:00 | ES | Futures | 1170.68 | 1171.14 | 1165.56 | 1166.49 | 78716.0 |
| 2008-08-01 13:00:00 | ES | Futures | 1166.49 | 1173.23 | 1166.03 | 1172.07 | 62429.0 |
| 2008-08-01 13:30:00 | ES | Futures | 1172.07 | 1174.39 | 1170.21 | 1171.84 | 73377.0 |
| 2008-08-01 14:00:00 | ES | Futures | 1171.84 | 1172.77 | 1167.42 | 1170.21 | 81312.0 |
| 2008-08-01 14:30:00 | ES | Futures | 1170.21 | 1173.0 | 1167.65 | 1172.3 | 65983.0 |
| 2008-08-01 15:00:00 | ES | Futures | 1172.3 | 1173.93 | 1168.58 | 1172.07 | 67433.0 |
| 2008-08-01 15:30:00 | ES | Futures | 1171.84 | 1175.79 | 1169.98 | 1171.14 | 166290.0 |
| 2008-08-01 16:00:00 | ES | Futures | 1171.14 | 1172.3 | 1169.51 | 1170.91 | 68303.0 |
| 2008-08-01 00:00:00 | NQ | Futures | 2078.44 | 2078.72 | 2077.32 | 2078.72 | 8.0 |
| 2008-08-01 00:30:00 | NQ | Futures | 2078.44 | 2079.29 | 2078.44 | 2078.72 | 44.0 |
| 2008-08-01 01:00:00 | NQ | Futures | 2079.01 | 2080.13 | 2078.72 | 2080.13 | 11.0 |
| 2008-08-01 01:30:00 | NQ | Futures | 2079.29 | 2080.69 | 2079.29 | 2080.69 | 130.0 |
| 2008-08-01 02:00:00 | NQ | Futures | 2080.13 | 2081.54 | 2077.04 | 2081.54 | 379.0 |
| 2008-08-01 02:30:00 | NQ | Futures | 2082.38 | 2083.22 | 2080.13 | 2081.82 | 95.0 |
| 2008-08-01 03:00:00 | NQ | Futures | 2081.82 | 2083.22 | 2079.29 | 2082.94 | 794.0 |
| 2008-08-01 03:30:00 | NQ | Futures | 2082.94 | 2083.22 | 2082.1 | 2082.94 | 409.0 |
| 2008-08-01 04:00:00 | NQ | Futures | 2082.66 | 2083.22 | 2082.1 | 2082.94 | 248.0 |
| 2008-08-01 04:30:00 | NQ | Futures | 2083.22 | 2084.07 | 2082.38 | 2082.38 | 254.0 |
| 2008-08-01 05:00:00 | NQ | Futures | 2082.94 | 2084.35 | 2080.97 | 2084.07 | 201.0 |
| 2008-08-01 05:30:00 | NQ | Futures | 2084.35 | 2086.6 | 2084.07 | 2086.04 | 329.0 |
| 2008-08-01 06:00:00 | NQ | Futures | 2086.04 | 2089.69 | 2086.04 | 2089.13 | 494.0 |
| 2008-08-01 06:30:00 | NQ | Futures | 2089.13 | 2092.23 | 2088.57 | 2090.54 | 706.0 |
| 2008-08-01 07:00:00 | NQ | Futures | 2090.54 | 2091.66 | 2080.69 | 2082.1 | 3096.0 |
| 2008-08-01 07:30:00 | NQ | Futures | 2082.1 | 2083.22 | 2079.57 | 2080.97 | 1680.0 |
| 2008-08-01 08:00:00 | NQ | Futures | 2080.69 | 2086.04 | 2077.04 | 2080.69 | 3375.0 |
> showing 50 of 1,833 rows — these rows as CSV