PREVIEW / futures_30min / 2010-06-30
file: by_date/futures_30min/2010/2010-06-30.parquet size: 73 KB rows: 2,552
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-06-30 00:00:00 | ES | Futures | 1019.8 | 1020.53 | 1019.31 | 1019.8 | 4577.0 |
| 2010-06-30 00:30:00 | ES | Futures | 1020.04 | 1020.53 | 1019.55 | 1019.55 | 2790.0 |
| 2010-06-30 01:00:00 | ES | Futures | 1019.8 | 1020.04 | 1018.08 | 1019.55 | 2901.0 |
| 2010-06-30 01:30:00 | ES | Futures | 1019.55 | 1021.51 | 1019.31 | 1020.78 | 4822.0 |
| 2010-06-30 02:00:00 | ES | Futures | 1020.53 | 1020.78 | 1019.06 | 1019.8 | 4515.0 |
| 2010-06-30 02:30:00 | ES | Futures | 1020.04 | 1022.5 | 1019.55 | 1022.25 | 9222.0 |
| 2010-06-30 03:00:00 | ES | Futures | 1022.01 | 1022.25 | 1019.31 | 1021.76 | 15952.0 |
| 2010-06-30 03:30:00 | ES | Futures | 1021.51 | 1022.5 | 1019.8 | 1022.25 | 12771.0 |
| 2010-06-30 04:00:00 | ES | Futures | 1022.5 | 1022.74 | 1021.27 | 1021.27 | 13521.0 |
| 2010-06-30 04:30:00 | ES | Futures | 1021.27 | 1021.76 | 1020.04 | 1020.78 | 8542.0 |
| 2010-06-30 05:00:00 | ES | Futures | 1020.29 | 1024.46 | 1018.32 | 1023.23 | 41712.0 |
| 2010-06-30 05:30:00 | ES | Futures | 1022.99 | 1024.7 | 1022.01 | 1023.97 | 19766.0 |
| 2010-06-30 06:00:00 | ES | Futures | 1023.97 | 1025.2 | 1023.23 | 1023.48 | 16092.0 |
| 2010-06-30 06:30:00 | ES | Futures | 1023.48 | 1024.46 | 1022.01 | 1023.48 | 11504.0 |
| 2010-06-30 07:00:00 | ES | Futures | 1023.72 | 1023.72 | 1022.5 | 1023.23 | 7876.0 |
| 2010-06-30 07:30:00 | ES | Futures | 1022.99 | 1023.72 | 1022.01 | 1022.25 | 11909.0 |
| 2010-06-30 08:00:00 | ES | Futures | 1022.01 | 1022.5 | 1014.64 | 1017.1 | 77497.0 |
| 2010-06-30 08:30:00 | ES | Futures | 1017.1 | 1019.06 | 1016.12 | 1016.12 | 63071.0 |
| 2010-06-30 09:00:00 | ES | Futures | 1016.12 | 1016.85 | 1014.4 | 1014.89 | 51911.0 |
| 2010-06-30 09:30:00 | ES | Futures | 1014.89 | 1023.23 | 1014.15 | 1020.04 | 250294.0 |
| 2010-06-30 10:00:00 | ES | Futures | 1019.8 | 1021.27 | 1017.83 | 1019.31 | 172611.0 |
| 2010-06-30 10:30:00 | ES | Futures | 1019.06 | 1022.5 | 1017.1 | 1017.59 | 190898.0 |
| 2010-06-30 11:00:00 | ES | Futures | 1017.59 | 1022.74 | 1017.1 | 1021.02 | 140896.0 |
| 2010-06-30 11:30:00 | ES | Futures | 1020.78 | 1024.46 | 1020.78 | 1022.5 | 109898.0 |
| 2010-06-30 12:00:00 | ES | Futures | 1022.5 | 1023.48 | 1021.76 | 1022.01 | 62675.0 |
| 2010-06-30 12:30:00 | ES | Futures | 1021.76 | 1022.74 | 1019.06 | 1020.53 | 69535.0 |
| 2010-06-30 13:00:00 | ES | Futures | 1020.53 | 1022.01 | 1019.31 | 1021.51 | 45838.0 |
| 2010-06-30 13:30:00 | ES | Futures | 1021.27 | 1022.25 | 1019.06 | 1021.27 | 56819.0 |
| 2010-06-30 14:00:00 | ES | Futures | 1021.02 | 1022.5 | 1016.36 | 1017.59 | 144226.0 |
| 2010-06-30 14:30:00 | ES | Futures | 1017.59 | 1019.8 | 1016.61 | 1018.08 | 102243.0 |
| 2010-06-30 15:00:00 | ES | Futures | 1018.08 | 1019.31 | 1013.17 | 1013.66 | 140943.0 |
| 2010-06-30 15:30:00 | ES | Futures | 1013.66 | 1013.66 | 1004.58 | 1007.04 | 506155.0 |
| 2010-06-30 16:00:00 | ES | Futures | 1007.04 | 1007.04 | 1004.09 | 1005.57 | 189575.0 |
| 2010-06-30 16:30:00 | ES | Futures | 1005.57 | 1006.79 | 1004.83 | 1006.06 | 9083.0 |
| 2010-06-30 17:00:00 | ES | Futures | 1006.06 | 1006.3 | 1004.83 | 1005.07 | 3307.0 |
| 2010-06-30 18:00:00 | ES | Futures | 1005.32 | 1005.57 | 1003.85 | 1004.58 | 4856.0 |
| 2010-06-30 18:30:00 | ES | Futures | 1004.83 | 1005.32 | 1004.34 | 1004.58 | 1312.0 |
| 2010-06-30 19:00:00 | ES | Futures | 1004.58 | 1006.06 | 1004.58 | 1006.06 | 1780.0 |
| 2010-06-30 19:30:00 | ES | Futures | 1005.81 | 1007.28 | 1005.81 | 1007.28 | 3811.0 |
| 2010-06-30 20:00:00 | ES | Futures | 1007.28 | 1008.76 | 1007.04 | 1007.77 | 5347.0 |
| 2010-06-30 20:30:00 | ES | Futures | 1007.53 | 1008.26 | 1004.83 | 1006.06 | 4832.0 |
| 2010-06-30 21:00:00 | ES | Futures | 1006.06 | 1006.06 | 997.22 | 999.68 | 17271.0 |
| 2010-06-30 21:30:00 | ES | Futures | 999.92 | 1002.62 | 999.19 | 999.43 | 6651.0 |
| 2010-06-30 22:00:00 | ES | Futures | 999.68 | 1000.66 | 998.2 | 999.68 | 4414.0 |
| 2010-06-30 22:30:00 | ES | Futures | 999.68 | 1001.88 | 999.19 | 1001.39 | 3746.0 |
| 2010-06-30 23:00:00 | ES | Futures | 1001.64 | 1002.87 | 999.68 | 1000.66 | 3894.0 |
| 2010-06-30 23:30:00 | ES | Futures | 1000.9 | 1001.39 | 999.92 | 1000.41 | 1709.0 |
| 2010-06-30 00:00:00 | NQ | Futures | 2027.74 | 2029.75 | 2027.74 | 2028.6 | 319.0 |
| 2010-06-30 00:30:00 | NQ | Futures | 2028.31 | 2029.75 | 2027.45 | 2027.45 | 347.0 |
| 2010-06-30 01:00:00 | NQ | Futures | 2027.74 | 2027.74 | 2024.02 | 2026.02 | 785.0 |
> showing 50 of 2,552 rows — these rows as CSV