PREVIEW / futures_30min / 2010-07-07
file: by_date/futures_30min/2010/2010-07-07.parquet size: 73 KB rows: 2,534
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-07-07 00:00:00 | ES | Futures | 1001.39 | 1001.64 | 999.92 | 1000.41 | 1551.0 |
| 2010-07-07 00:30:00 | ES | Futures | 1000.41 | 1001.15 | 999.92 | 1000.66 | 2554.0 |
| 2010-07-07 01:00:00 | ES | Futures | 1000.66 | 1003.6 | 1000.41 | 1001.88 | 2704.0 |
| 2010-07-07 01:30:00 | ES | Futures | 1001.88 | 1003.36 | 1000.66 | 1001.15 | 4020.0 |
| 2010-07-07 02:00:00 | ES | Futures | 1001.15 | 1002.87 | 1001.15 | 1002.38 | 4359.0 |
| 2010-07-07 02:30:00 | ES | Futures | 1002.38 | 1003.6 | 1001.64 | 1002.62 | 3469.0 |
| 2010-07-07 03:00:00 | ES | Futures | 1002.62 | 1004.34 | 1001.64 | 1002.13 | 15741.0 |
| 2010-07-07 03:30:00 | ES | Futures | 1002.13 | 1003.6 | 1000.9 | 1002.62 | 17608.0 |
| 2010-07-07 04:00:00 | ES | Futures | 1002.62 | 1003.11 | 1000.17 | 1000.17 | 11781.0 |
| 2010-07-07 04:30:00 | ES | Futures | 1000.41 | 1001.39 | 998.2 | 999.19 | 18381.0 |
| 2010-07-07 05:00:00 | ES | Futures | 998.94 | 1000.41 | 997.47 | 998.69 | 11544.0 |
| 2010-07-07 05:30:00 | ES | Futures | 998.69 | 999.68 | 997.71 | 998.69 | 7864.0 |
| 2010-07-07 06:00:00 | ES | Futures | 998.45 | 999.92 | 997.71 | 999.68 | 7784.0 |
| 2010-07-07 06:30:00 | ES | Futures | 999.92 | 1003.11 | 999.19 | 1002.62 | 12381.0 |
| 2010-07-07 07:00:00 | ES | Futures | 1002.62 | 1004.09 | 1001.88 | 1003.85 | 19971.0 |
| 2010-07-07 07:30:00 | ES | Futures | 1003.85 | 1004.83 | 1001.88 | 1002.38 | 22019.0 |
| 2010-07-07 08:00:00 | ES | Futures | 1002.38 | 1003.6 | 1000.9 | 1002.87 | 20759.0 |
| 2010-07-07 08:30:00 | ES | Futures | 1002.87 | 1006.79 | 1002.87 | 1005.81 | 58929.0 |
| 2010-07-07 09:00:00 | ES | Futures | 1005.81 | 1007.53 | 1004.34 | 1006.79 | 49889.0 |
| 2010-07-07 09:30:00 | ES | Futures | 1006.79 | 1011.95 | 1005.81 | 1011.7 | 213114.0 |
| 2010-07-07 10:00:00 | ES | Futures | 1011.45 | 1016.85 | 1011.45 | 1014.15 | 253075.0 |
| 2010-07-07 10:30:00 | ES | Futures | 1013.91 | 1022.5 | 1013.91 | 1021.27 | 244574.0 |
| 2010-07-07 11:00:00 | ES | Futures | 1021.27 | 1021.76 | 1017.1 | 1019.8 | 146219.0 |
| 2010-07-07 11:30:00 | ES | Futures | 1019.8 | 1022.25 | 1016.61 | 1018.08 | 133529.0 |
| 2010-07-07 12:00:00 | ES | Futures | 1017.83 | 1020.29 | 1017.59 | 1020.29 | 69892.0 |
| 2010-07-07 12:30:00 | ES | Futures | 1020.29 | 1021.76 | 1019.06 | 1020.53 | 61395.0 |
| 2010-07-07 13:00:00 | ES | Futures | 1020.53 | 1026.42 | 1020.29 | 1025.69 | 119028.0 |
| 2010-07-07 13:30:00 | ES | Futures | 1025.93 | 1027.4 | 1023.72 | 1026.18 | 104381.0 |
| 2010-07-07 14:00:00 | ES | Futures | 1026.18 | 1028.14 | 1025.93 | 1026.18 | 99960.0 |
| 2010-07-07 14:30:00 | ES | Futures | 1026.18 | 1028.88 | 1024.95 | 1028.63 | 87502.0 |
| 2010-07-07 15:00:00 | ES | Futures | 1028.88 | 1032.31 | 1026.67 | 1031.82 | 172620.0 |
| 2010-07-07 15:30:00 | ES | Futures | 1032.07 | 1037.96 | 1031.33 | 1036.73 | 344492.0 |
| 2010-07-07 16:00:00 | ES | Futures | 1036.48 | 1040.16 | 1036.48 | 1039.67 | 179365.0 |
| 2010-07-07 16:30:00 | ES | Futures | 1039.18 | 1039.67 | 1038.69 | 1039.43 | 7614.0 |
| 2010-07-07 17:00:00 | ES | Futures | 1039.43 | 1039.92 | 1038.69 | 1038.94 | 2663.0 |
| 2010-07-07 18:00:00 | ES | Futures | 1039.43 | 1039.92 | 1038.94 | 1039.18 | 3104.0 |
| 2010-07-07 18:30:00 | ES | Futures | 1039.18 | 1039.92 | 1038.94 | 1039.43 | 1184.0 |
| 2010-07-07 19:00:00 | ES | Futures | 1039.18 | 1039.43 | 1038.94 | 1038.94 | 503.0 |
| 2010-07-07 19:30:00 | ES | Futures | 1039.18 | 1039.43 | 1038.2 | 1038.69 | 2456.0 |
| 2010-07-07 20:00:00 | ES | Futures | 1038.45 | 1039.43 | 1037.96 | 1037.96 | 4927.0 |
| 2010-07-07 20:30:00 | ES | Futures | 1037.96 | 1039.18 | 1037.71 | 1038.94 | 3647.0 |
| 2010-07-07 21:00:00 | ES | Futures | 1038.94 | 1041.64 | 1038.45 | 1041.39 | 7434.0 |
| 2010-07-07 21:30:00 | ES | Futures | 1041.15 | 1042.62 | 1039.43 | 1040.16 | 8037.0 |
| 2010-07-07 22:00:00 | ES | Futures | 1039.92 | 1040.16 | 1038.69 | 1039.67 | 3049.0 |
| 2010-07-07 22:30:00 | ES | Futures | 1039.67 | 1040.41 | 1038.94 | 1039.92 | 2241.0 |
| 2010-07-07 23:00:00 | ES | Futures | 1039.92 | 1040.16 | 1038.69 | 1039.18 | 1820.0 |
| 2010-07-07 23:30:00 | ES | Futures | 1039.18 | 1040.16 | 1038.94 | 1039.67 | 1086.0 |
| 2010-07-07 00:00:00 | NQ | Futures | 1981.6 | 1981.6 | 1978.45 | 1979.88 | 244.0 |
| 2010-07-07 00:30:00 | NQ | Futures | 1979.88 | 1982.46 | 1979.6 | 1980.74 | 599.0 |
| 2010-07-07 01:00:00 | NQ | Futures | 1981.6 | 1986.48 | 1981.32 | 1983.9 | 471.0 |
> showing 50 of 2,534 rows — these rows as CSV