PREVIEW / futures_30min / 2010-07-01
file: by_date/futures_30min/2010/2010-07-01.parquet size: 74 KB rows: 2,557
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-01 00:00:00 | ES | Futures | 1000.41 | 1002.62 | 999.43 | 1002.38 | 2866.0 |
| 2010-07-01 00:30:00 | ES | Futures | 1002.62 | 1003.85 | 1001.39 | 1002.13 | 2819.0 |
| 2010-07-01 01:00:00 | ES | Futures | 1002.38 | 1004.09 | 1002.13 | 1003.6 | 3602.0 |
| 2010-07-01 01:30:00 | ES | Futures | 1003.6 | 1005.57 | 1002.62 | 1003.6 | 5983.0 |
| 2010-07-01 02:00:00 | ES | Futures | 1003.85 | 1004.58 | 1001.88 | 1002.38 | 4515.0 |
| 2010-07-01 02:30:00 | ES | Futures | 1002.62 | 1003.6 | 1001.64 | 1003.6 | 6103.0 |
| 2010-07-01 03:00:00 | ES | Futures | 1003.36 | 1005.57 | 1001.39 | 1003.6 | 26218.0 |
| 2010-07-01 03:30:00 | ES | Futures | 1003.6 | 1003.85 | 1001.39 | 1002.87 | 16708.0 |
| 2010-07-01 04:00:00 | ES | Futures | 1002.87 | 1005.81 | 1001.64 | 1004.83 | 24480.0 |
| 2010-07-01 04:30:00 | ES | Futures | 1005.07 | 1006.55 | 1004.09 | 1005.32 | 18411.0 |
| 2010-07-01 05:00:00 | ES | Futures | 1005.57 | 1005.57 | 1002.62 | 1003.36 | 11767.0 |
| 2010-07-01 05:30:00 | ES | Futures | 1003.36 | 1004.83 | 1002.62 | 1004.09 | 15229.0 |
| 2010-07-01 06:00:00 | ES | Futures | 1004.09 | 1007.28 | 1004.09 | 1006.55 | 16105.0 |
| 2010-07-01 06:30:00 | ES | Futures | 1006.79 | 1008.51 | 1006.3 | 1008.51 | 13475.0 |
| 2010-07-01 07:00:00 | ES | Futures | 1008.51 | 1008.76 | 1005.81 | 1006.55 | 14445.0 |
| 2010-07-01 07:30:00 | ES | Futures | 1006.3 | 1006.55 | 1003.85 | 1004.34 | 22162.0 |
| 2010-07-01 08:00:00 | ES | Futures | 1004.58 | 1005.81 | 1003.36 | 1005.32 | 25554.0 |
| 2010-07-01 08:30:00 | ES | Futures | 1005.32 | 1007.28 | 1000.17 | 1007.28 | 86253.0 |
| 2010-07-01 09:00:00 | ES | Futures | 1007.04 | 1008.51 | 1006.55 | 1007.28 | 46954.0 |
| 2010-07-01 09:30:00 | ES | Futures | 1007.28 | 1010.72 | 1003.6 | 1004.34 | 271698.0 |
| 2010-07-01 10:00:00 | ES | Futures | 1004.34 | 1004.58 | 995.26 | 997.47 | 360129.0 |
| 2010-07-01 10:30:00 | ES | Futures | 997.71 | 998.2 | 988.88 | 991.33 | 379974.0 |
| 2010-07-01 11:00:00 | ES | Futures | 991.09 | 995.01 | 987.41 | 994.52 | 304393.0 |
| 2010-07-01 11:30:00 | ES | Futures | 994.52 | 998.69 | 993.54 | 996.49 | 195267.0 |
| 2010-07-01 12:00:00 | ES | Futures | 996.24 | 996.49 | 992.81 | 995.01 | 110353.0 |
| 2010-07-01 12:30:00 | ES | Futures | 995.01 | 1005.32 | 994.52 | 1001.39 | 229191.0 |
| 2010-07-01 13:00:00 | ES | Futures | 1001.39 | 1003.85 | 998.94 | 1001.15 | 127707.0 |
| 2010-07-01 13:30:00 | ES | Futures | 1001.15 | 1005.81 | 1000.41 | 1003.85 | 154796.0 |
| 2010-07-01 14:00:00 | ES | Futures | 1003.85 | 1007.28 | 1002.13 | 1003.85 | 123420.0 |
| 2010-07-01 14:30:00 | ES | Futures | 1003.85 | 1004.83 | 996.98 | 1000.66 | 156667.0 |
| 2010-07-01 15:00:00 | ES | Futures | 1000.41 | 1004.83 | 999.43 | 1003.11 | 152720.0 |
| 2010-07-01 15:30:00 | ES | Futures | 1003.11 | 1006.3 | 999.92 | 1004.09 | 252442.0 |
| 2010-07-01 16:00:00 | ES | Futures | 1004.09 | 1004.58 | 1002.38 | 1003.11 | 88370.0 |
| 2010-07-01 16:30:00 | ES | Futures | 1003.36 | 1004.09 | 1002.62 | 1002.87 | 4159.0 |
| 2010-07-01 17:00:00 | ES | Futures | 1002.87 | 1003.85 | 1002.62 | 1003.6 | 1408.0 |
| 2010-07-01 18:00:00 | ES | Futures | 1003.6 | 1004.58 | 1003.6 | 1004.09 | 1632.0 |
| 2010-07-01 18:30:00 | ES | Futures | 1004.34 | 1004.83 | 1004.09 | 1004.34 | 879.0 |
| 2010-07-01 19:00:00 | ES | Futures | 1004.34 | 1004.83 | 1004.09 | 1004.34 | 494.0 |
| 2010-07-01 19:30:00 | ES | Futures | 1004.34 | 1005.32 | 1003.85 | 1005.32 | 1980.0 |
| 2010-07-01 20:00:00 | ES | Futures | 1005.32 | 1006.3 | 1004.83 | 1006.06 | 3780.0 |
| 2010-07-01 20:30:00 | ES | Futures | 1006.3 | 1007.53 | 1003.6 | 1004.09 | 5352.0 |
| 2010-07-01 21:00:00 | ES | Futures | 1003.85 | 1006.3 | 1003.6 | 1005.57 | 3002.0 |
| 2010-07-01 21:30:00 | ES | Futures | 1005.32 | 1008.26 | 1004.83 | 1008.02 | 3769.0 |
| 2010-07-01 22:00:00 | ES | Futures | 1008.26 | 1009.0 | 1008.02 | 1008.76 | 5771.0 |
| 2010-07-01 22:30:00 | ES | Futures | 1008.76 | 1009.0 | 1008.26 | 1008.76 | 2511.0 |
| 2010-07-01 23:00:00 | ES | Futures | 1008.76 | 1008.76 | 1005.81 | 1006.55 | 3069.0 |
| 2010-07-01 23:30:00 | ES | Futures | 1006.55 | 1007.28 | 1005.32 | 1005.57 | 1574.0 |
| 2010-07-01 00:00:00 | NQ | Futures | 1976.45 | 1981.6 | 1975.59 | 1981.03 | 412.0 |
| 2010-07-01 00:30:00 | NQ | Futures | 1981.6 | 1983.04 | 1979.02 | 1980.46 | 281.0 |
| 2010-07-01 01:00:00 | NQ | Futures | 1981.03 | 1983.32 | 1981.03 | 1982.46 | 285.0 |
> showing 50 of 2,557 rows — these rows as CSV