PREVIEW / futures_30min / 2010-01-19
file: by_date/futures_30min/2010/2010-01-19.parquet size: 73 KB rows: 2,613
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-01-19 00:00:00 | ES | Futures | 1104.39 | 1104.64 | 1103.91 | 1103.91 | 1634.0 |
| 2010-01-19 00:30:00 | ES | Futures | 1103.91 | 1104.64 | 1103.91 | 1104.39 | 913.0 |
| 2010-01-19 01:00:00 | ES | Futures | 1104.64 | 1104.88 | 1103.91 | 1104.39 | 1012.0 |
| 2010-01-19 01:30:00 | ES | Futures | 1104.39 | 1105.37 | 1103.91 | 1104.88 | 1572.0 |
| 2010-01-19 02:00:00 | ES | Futures | 1104.88 | 1105.85 | 1104.39 | 1105.37 | 3237.0 |
| 2010-01-19 02:30:00 | ES | Futures | 1105.61 | 1105.61 | 1104.88 | 1105.61 | 2094.0 |
| 2010-01-19 03:00:00 | ES | Futures | 1105.61 | 1105.61 | 1102.69 | 1103.18 | 15603.0 |
| 2010-01-19 03:30:00 | ES | Futures | 1103.18 | 1103.91 | 1102.45 | 1102.94 | 7192.0 |
| 2010-01-19 04:00:00 | ES | Futures | 1102.69 | 1103.18 | 1100.99 | 1101.23 | 11721.0 |
| 2010-01-19 04:30:00 | ES | Futures | 1101.23 | 1101.72 | 1099.53 | 1100.75 | 17478.0 |
| 2010-01-19 05:00:00 | ES | Futures | 1100.75 | 1101.72 | 1099.77 | 1101.48 | 11396.0 |
| 2010-01-19 05:30:00 | ES | Futures | 1101.48 | 1101.96 | 1100.02 | 1100.26 | 5602.0 |
| 2010-01-19 06:00:00 | ES | Futures | 1100.26 | 1100.99 | 1099.77 | 1100.26 | 5978.0 |
| 2010-01-19 06:30:00 | ES | Futures | 1100.02 | 1100.75 | 1098.56 | 1099.77 | 11086.0 |
| 2010-01-19 07:00:00 | ES | Futures | 1100.02 | 1100.5 | 1098.8 | 1099.04 | 7151.0 |
| 2010-01-19 07:30:00 | ES | Futures | 1099.29 | 1099.53 | 1098.56 | 1098.8 | 9854.0 |
| 2010-01-19 08:00:00 | ES | Futures | 1098.8 | 1100.99 | 1095.88 | 1100.26 | 60186.0 |
| 2010-01-19 08:30:00 | ES | Futures | 1100.26 | 1102.21 | 1100.02 | 1100.26 | 38059.0 |
| 2010-01-19 09:00:00 | ES | Futures | 1100.26 | 1101.48 | 1100.02 | 1100.99 | 17906.0 |
| 2010-01-19 09:30:00 | ES | Futures | 1100.99 | 1108.04 | 1100.75 | 1106.83 | 258555.0 |
| 2010-01-19 10:00:00 | ES | Futures | 1107.07 | 1110.23 | 1106.83 | 1108.77 | 180880.0 |
| 2010-01-19 10:30:00 | ES | Futures | 1108.77 | 1111.94 | 1108.77 | 1110.96 | 140729.0 |
| 2010-01-19 11:00:00 | ES | Futures | 1110.96 | 1110.96 | 1109.75 | 1110.48 | 103469.0 |
| 2010-01-19 11:30:00 | ES | Futures | 1110.48 | 1110.96 | 1109.5 | 1110.23 | 70728.0 |
| 2010-01-19 12:00:00 | ES | Futures | 1110.23 | 1113.4 | 1109.99 | 1112.67 | 117358.0 |
| 2010-01-19 12:30:00 | ES | Futures | 1112.91 | 1114.13 | 1112.42 | 1113.15 | 72279.0 |
| 2010-01-19 13:00:00 | ES | Futures | 1113.15 | 1113.64 | 1112.18 | 1112.91 | 60213.0 |
| 2010-01-19 13:30:00 | ES | Futures | 1113.15 | 1113.4 | 1112.42 | 1113.4 | 37858.0 |
| 2010-01-19 14:00:00 | ES | Futures | 1113.4 | 1114.13 | 1112.91 | 1113.88 | 43274.0 |
| 2010-01-19 14:30:00 | ES | Futures | 1113.88 | 1113.88 | 1112.91 | 1113.4 | 51680.0 |
| 2010-01-19 15:00:00 | ES | Futures | 1113.15 | 1115.83 | 1112.18 | 1115.58 | 109285.0 |
| 2010-01-19 15:30:00 | ES | Futures | 1115.58 | 1116.07 | 1114.37 | 1115.34 | 157526.0 |
| 2010-01-19 16:00:00 | ES | Futures | 1115.34 | 1115.58 | 1114.37 | 1114.86 | 150781.0 |
| 2010-01-19 16:30:00 | ES | Futures | 1114.13 | 1114.37 | 1112.91 | 1113.64 | 8156.0 |
| 2010-01-19 17:00:00 | ES | Futures | 1113.4 | 1114.13 | 1113.15 | 1113.64 | 1898.0 |
| 2010-01-19 18:00:00 | ES | Futures | 1113.64 | 1114.13 | 1113.15 | 1113.64 | 3251.0 |
| 2010-01-19 18:30:00 | ES | Futures | 1113.64 | 1113.88 | 1113.15 | 1113.64 | 1471.0 |
| 2010-01-19 19:00:00 | ES | Futures | 1113.4 | 1113.88 | 1113.4 | 1113.64 | 812.0 |
| 2010-01-19 19:30:00 | ES | Futures | 1113.88 | 1115.58 | 1113.64 | 1115.34 | 2821.0 |
| 2010-01-19 20:00:00 | ES | Futures | 1115.58 | 1115.58 | 1112.91 | 1114.86 | 4132.0 |
| 2010-01-19 20:30:00 | ES | Futures | 1114.86 | 1114.86 | 1112.67 | 1112.91 | 4381.0 |
| 2010-01-19 21:00:00 | ES | Futures | 1113.15 | 1114.13 | 1111.94 | 1112.67 | 6685.0 |
| 2010-01-19 21:30:00 | ES | Futures | 1112.67 | 1114.61 | 1111.94 | 1114.13 | 4830.0 |
| 2010-01-19 22:00:00 | ES | Futures | 1114.37 | 1114.61 | 1113.64 | 1113.88 | 1912.0 |
| 2010-01-19 22:30:00 | ES | Futures | 1114.13 | 1114.61 | 1113.64 | 1114.13 | 1934.0 |
| 2010-01-19 23:00:00 | ES | Futures | 1114.13 | 1114.61 | 1112.91 | 1113.15 | 2175.0 |
| 2010-01-19 23:30:00 | ES | Futures | 1113.15 | 1113.4 | 1112.67 | 1112.91 | 1217.0 |
| 2010-01-19 00:00:00 | NQ | Futures | 2137.93 | 2138.22 | 2137.08 | 2137.65 | 113.0 |
| 2010-01-19 00:30:00 | NQ | Futures | 2137.65 | 2138.51 | 2137.08 | 2138.51 | 98.0 |
| 2010-01-19 01:00:00 | NQ | Futures | 2138.22 | 2139.08 | 2137.65 | 2138.22 | 131.0 |
> showing 50 of 2,613 rows — these rows as CSV