PREVIEW / futures_1hour / 2010-06-30

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-06-30.parquet
  size:    47 KB
  rows:    1,385

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.55	7367.0
2010-06-30 01:00:00	ES	Futures	1019.8	1021.51	1018.08	1020.78	7723.0
2010-06-30 02:00:00	ES	Futures	1020.53	1022.5	1019.06	1022.25	13737.0
2010-06-30 03:00:00	ES	Futures	1022.01	1022.5	1019.31	1022.25	28723.0
2010-06-30 04:00:00	ES	Futures	1022.5	1022.74	1020.04	1020.78	22063.0
2010-06-30 05:00:00	ES	Futures	1020.29	1024.7	1018.32	1023.97	61478.0
2010-06-30 06:00:00	ES	Futures	1023.97	1025.2	1022.01	1023.48	27596.0
2010-06-30 07:00:00	ES	Futures	1023.72	1023.72	1022.01	1022.25	19785.0
2010-06-30 08:00:00	ES	Futures	1022.01	1022.5	1014.64	1016.12	140568.0
2010-06-30 09:00:00	ES	Futures	1016.12	1023.23	1014.15	1020.04	302205.0
2010-06-30 10:00:00	ES	Futures	1019.8	1022.5	1017.1	1017.59	363509.0
2010-06-30 11:00:00	ES	Futures	1017.59	1024.46	1017.1	1022.5	250794.0
2010-06-30 12:00:00	ES	Futures	1022.5	1023.48	1019.06	1020.53	132210.0
2010-06-30 13:00:00	ES	Futures	1020.53	1022.25	1019.06	1021.27	102657.0
2010-06-30 14:00:00	ES	Futures	1021.02	1022.5	1016.36	1018.08	246469.0
2010-06-30 15:00:00	ES	Futures	1018.08	1019.31	1004.58	1007.04	647098.0
2010-06-30 16:00:00	ES	Futures	1007.04	1007.04	1004.09	1006.06	198658.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	6168.0
2010-06-30 19:00:00	ES	Futures	1004.58	1007.28	1004.58	1007.28	5591.0
2010-06-30 20:00:00	ES	Futures	1007.28	1008.76	1004.83	1006.06	10179.0
2010-06-30 21:00:00	ES	Futures	1006.06	1006.06	997.22	999.43	23922.0
2010-06-30 22:00:00	ES	Futures	999.68	1001.88	998.2	1001.39	8160.0
2010-06-30 23:00:00	ES	Futures	1001.64	1002.87	999.68	1000.41	5603.0
2010-06-30 00:00:00	NQ	Futures	2027.74	2029.75	2027.45	2027.45	666.0
2010-06-30 01:00:00	NQ	Futures	2027.74	2029.75	2024.02	2028.89	1202.0
2010-06-30 02:00:00	NQ	Futures	2028.89	2031.47	2026.31	2031.18	1176.0
2010-06-30 03:00:00	NQ	Futures	2030.89	2031.47	2025.74	2031.18	2455.0
2010-06-30 04:00:00	NQ	Futures	2030.89	2031.75	2027.45	2027.74	1673.0
2010-06-30 05:00:00	NQ	Futures	2028.03	2036.34	2023.44	2035.19	4221.0
2010-06-30 06:00:00	NQ	Futures	2035.19	2037.48	2031.47	2033.47	2782.0
2010-06-30 07:00:00	NQ	Futures	2033.76	2034.05	2031.18	2031.75	2371.0
2010-06-30 08:00:00	NQ	Futures	2032.04	2032.33	2018.28	2021.15	11979.0
2010-06-30 09:00:00	NQ	Futures	2021.44	2032.9	2013.41	2026.02	52789.0
2010-06-30 10:00:00	NQ	Futures	2025.74	2032.33	2019.14	2020.29	55385.0
2010-06-30 11:00:00	NQ	Futures	2020.0	2034.62	2018.86	2030.61	35757.0
2010-06-30 12:00:00	NQ	Futures	2030.61	2034.62	2024.3	2028.03	20007.0
2010-06-30 13:00:00	NQ	Futures	2028.03	2030.61	2022.3	2024.3	20072.0
2010-06-30 14:00:00	NQ	Futures	2024.3	2026.59	2013.13	2017.71	42930.0
2010-06-30 15:00:00	NQ	Futures	2017.71	2019.72	1986.48	1991.06	90185.0
2010-06-30 16:00:00	NQ	Futures	1991.06	1992.78	1988.2	1989.91	19533.0
2010-06-30 17:00:00	NQ	Futures	1990.2	1990.49	1988.48	1988.48	174.0
2010-06-30 18:00:00	NQ	Futures	1988.77	1989.63	1985.62	1987.34	702.0
2010-06-30 19:00:00	NQ	Futures	1987.34	1992.21	1987.34	1991.35	418.0
2010-06-30 20:00:00	NQ	Futures	1991.63	1994.5	1987.62	1989.63	703.0
2010-06-30 21:00:00	NQ	Futures	1989.91	1989.91	1972.15	1975.59	2595.0
2010-06-30 22:00:00	NQ	Futures	1975.87	1979.88	1973.58	1978.45	1036.0
2010-06-30 23:00:00	NQ	Futures	1978.74	1980.74	1975.3	1976.73	812.0
2010-06-30 00:00:00	YM	Futures	9304.2	9311.8	9302.3	9305.1	390.0
2010-06-30 01:00:00	YM	Futures	9304.2	9315.6	9286.2	9309.9	460.0

> showing 50 of 1,385 rows — these rows as CSV

> unlock the full archive -- $79 one-time