PREVIEW / futures_30min / 2010-03-17
file: by_date/futures_30min/2010/2010-03-17.parquet size: 66 KB rows: 2,489
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-03-17 00:00:00 | ES | Futures | 1130.47 | 1130.72 | 1129.49 | 1130.23 | 2112.0 |
| 2010-03-17 00:30:00 | ES | Futures | 1130.23 | 1130.72 | 1129.98 | 1130.72 | 575.0 |
| 2010-03-17 01:00:00 | ES | Futures | 1130.96 | 1131.69 | 1130.47 | 1131.45 | 1656.0 |
| 2010-03-17 01:30:00 | ES | Futures | 1131.45 | 1131.69 | 1130.72 | 1131.45 | 1443.0 |
| 2010-03-17 02:00:00 | ES | Futures | 1131.45 | 1131.69 | 1130.96 | 1130.96 | 481.0 |
| 2010-03-17 02:30:00 | ES | Futures | 1131.2 | 1132.18 | 1131.2 | 1131.94 | 1364.0 |
| 2010-03-17 03:00:00 | ES | Futures | 1131.69 | 1132.18 | 1131.2 | 1131.69 | 4407.0 |
| 2010-03-17 03:30:00 | ES | Futures | 1131.69 | 1132.18 | 1131.2 | 1131.69 | 2500.0 |
| 2010-03-17 04:00:00 | ES | Futures | 1131.45 | 1131.94 | 1130.72 | 1131.2 | 7676.0 |
| 2010-03-17 04:30:00 | ES | Futures | 1130.96 | 1132.18 | 1130.96 | 1131.69 | 7057.0 |
| 2010-03-17 05:00:00 | ES | Futures | 1131.69 | 1131.69 | 1130.96 | 1131.2 | 4344.0 |
| 2010-03-17 05:30:00 | ES | Futures | 1131.2 | 1132.43 | 1130.72 | 1132.18 | 5352.0 |
| 2010-03-17 06:00:00 | ES | Futures | 1132.43 | 1132.67 | 1131.94 | 1132.43 | 9281.0 |
| 2010-03-17 06:30:00 | ES | Futures | 1132.43 | 1133.65 | 1132.18 | 1132.92 | 9214.0 |
| 2010-03-17 07:00:00 | ES | Futures | 1132.92 | 1133.16 | 1132.18 | 1132.43 | 7213.0 |
| 2010-03-17 07:30:00 | ES | Futures | 1132.43 | 1132.43 | 1131.2 | 1131.2 | 6205.0 |
| 2010-03-17 08:00:00 | ES | Futures | 1131.45 | 1131.94 | 1130.23 | 1130.96 | 14049.0 |
| 2010-03-17 08:30:00 | ES | Futures | 1130.96 | 1131.94 | 1130.72 | 1131.94 | 21931.0 |
| 2010-03-17 09:00:00 | ES | Futures | 1131.94 | 1132.67 | 1131.2 | 1132.18 | 33593.0 |
| 2010-03-17 09:30:00 | ES | Futures | 1132.18 | 1135.36 | 1131.69 | 1134.87 | 191604.0 |
| 2010-03-17 10:00:00 | ES | Futures | 1135.12 | 1135.6 | 1132.92 | 1133.4 | 136435.0 |
| 2010-03-17 10:30:00 | ES | Futures | 1133.4 | 1134.63 | 1132.67 | 1134.38 | 124608.0 |
| 2010-03-17 11:00:00 | ES | Futures | 1134.63 | 1136.58 | 1133.89 | 1135.85 | 130142.0 |
| 2010-03-17 11:30:00 | ES | Futures | 1135.85 | 1136.83 | 1135.12 | 1135.6 | 95093.0 |
| 2010-03-17 12:00:00 | ES | Futures | 1135.6 | 1136.34 | 1134.87 | 1135.36 | 64207.0 |
| 2010-03-17 12:30:00 | ES | Futures | 1135.36 | 1136.09 | 1134.87 | 1135.85 | 45083.0 |
| 2010-03-17 13:00:00 | ES | Futures | 1136.09 | 1137.56 | 1135.6 | 1137.07 | 68284.0 |
| 2010-03-17 13:30:00 | ES | Futures | 1136.83 | 1139.52 | 1136.83 | 1138.05 | 191363.0 |
| 2010-03-17 14:00:00 | ES | Futures | 1138.29 | 1139.27 | 1137.8 | 1138.29 | 54836.0 |
| 2010-03-17 14:30:00 | ES | Futures | 1138.54 | 1138.78 | 1134.38 | 1134.38 | 140088.0 |
| 2010-03-17 15:00:00 | ES | Futures | 1134.63 | 1135.85 | 1131.94 | 1133.16 | 151606.0 |
| 2010-03-17 15:30:00 | ES | Futures | 1133.4 | 1135.85 | 1132.43 | 1135.85 | 152784.0 |
| 2010-03-17 16:00:00 | ES | Futures | 1135.85 | 1136.09 | 1134.87 | 1135.12 | 89573.0 |
| 2010-03-17 16:30:00 | ES | Futures | 1134.87 | 1136.34 | 1134.63 | 1136.34 | 5852.0 |
| 2010-03-17 17:00:00 | ES | Futures | 1136.34 | 1136.58 | 1135.36 | 1135.6 | 1448.0 |
| 2010-03-17 18:00:00 | ES | Futures | 1135.85 | 1136.58 | 1135.6 | 1135.6 | 2668.0 |
| 2010-03-17 18:30:00 | ES | Futures | 1135.85 | 1135.85 | 1135.36 | 1135.85 | 701.0 |
| 2010-03-17 19:00:00 | ES | Futures | 1135.85 | 1137.56 | 1135.36 | 1136.83 | 4504.0 |
| 2010-03-17 19:30:00 | ES | Futures | 1136.83 | 1138.05 | 1136.34 | 1137.32 | 4315.0 |
| 2010-03-17 20:00:00 | ES | Futures | 1137.32 | 1137.32 | 1135.85 | 1136.58 | 2005.0 |
| 2010-03-17 20:30:00 | ES | Futures | 1136.34 | 1136.58 | 1135.6 | 1135.6 | 826.0 |
| 2010-03-17 21:00:00 | ES | Futures | 1135.6 | 1136.34 | 1135.6 | 1135.85 | 1139.0 |
| 2010-03-17 21:30:00 | ES | Futures | 1135.85 | 1136.34 | 1135.6 | 1135.85 | 570.0 |
| 2010-03-17 22:00:00 | ES | Futures | 1135.85 | 1136.09 | 1135.6 | 1135.6 | 797.0 |
| 2010-03-17 22:30:00 | ES | Futures | 1135.6 | 1135.85 | 1135.36 | 1135.36 | 601.0 |
| 2010-03-17 23:00:00 | ES | Futures | 1135.12 | 1135.6 | 1134.87 | 1135.6 | 1412.0 |
| 2010-03-17 23:30:00 | ES | Futures | 1135.6 | 1136.34 | 1135.36 | 1135.85 | 1240.0 |
| 2010-03-17 00:00:00 | NQ | Futures | 2211.37 | 2211.66 | 2209.94 | 2211.37 | 141.0 |
| 2010-03-17 00:30:00 | NQ | Futures | 2211.37 | 2211.94 | 2211.08 | 2211.66 | 100.0 |
| 2010-03-17 01:00:00 | NQ | Futures | 2211.94 | 2212.51 | 2211.94 | 2212.51 | 103.0 |
> showing 50 of 2,489 rows — these rows as CSV