PREVIEW / futures_1hour / 2010-06-29

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-06-29.parquet
  size:    46 KB
  rows:    1,370

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-29 00:00:00	ES	Futures	1047.77	1049.24	1044.09	1045.81	12652.0
2010-06-29 01:00:00	ES	Futures	1045.81	1045.81	1043.35	1043.6	7340.0
2010-06-29 02:00:00	ES	Futures	1043.84	1043.84	1040.65	1042.86	19733.0
2010-06-29 03:00:00	ES	Futures	1042.62	1043.11	1037.22	1038.2	51230.0
2010-06-29 04:00:00	ES	Futures	1038.2	1039.18	1035.5	1037.71	41115.0
2010-06-29 05:00:00	ES	Futures	1037.96	1039.43	1035.99	1037.96	26803.0
2010-06-29 06:00:00	ES	Futures	1037.96	1039.92	1037.46	1039.43	18439.0
2010-06-29 07:00:00	ES	Futures	1039.67	1039.92	1035.5	1037.96	42885.0
2010-06-29 08:00:00	ES	Futures	1037.96	1039.18	1036.97	1036.97	51325.0
2010-06-29 09:00:00	ES	Futures	1036.97	1038.94	1027.16	1028.88	408967.0
2010-06-29 10:00:00	ES	Futures	1028.88	1028.88	1018.32	1025.2	580409.0
2010-06-29 11:00:00	ES	Futures	1025.2	1027.89	1022.01	1022.25	272599.0
2010-06-29 12:00:00	ES	Futures	1022.5	1025.2	1020.04	1022.25	208512.0
2010-06-29 13:00:00	ES	Futures	1022.01	1022.74	1017.1	1021.76	253159.0
2010-06-29 14:00:00	ES	Futures	1021.76	1024.7	1019.06	1019.55	272568.0
2010-06-29 15:00:00	ES	Futures	1019.55	1022.74	1011.21	1017.83	652783.0
2010-06-29 16:00:00	ES	Futures	1017.83	1018.32	1014.64	1015.14	149173.0
2010-06-29 17:00:00	ES	Futures	1015.14	1015.63	1013.91	1014.64	2874.0
2010-06-29 18:00:00	ES	Futures	1014.64	1015.87	1013.66	1015.87	6229.0
2010-06-29 19:00:00	ES	Futures	1016.12	1016.85	1014.64	1016.61	5330.0
2010-06-29 20:00:00	ES	Futures	1016.36	1017.59	1014.4	1017.1	8714.0
2010-06-29 21:00:00	ES	Futures	1017.34	1018.32	1016.36	1017.34	4877.0
2010-06-29 22:00:00	ES	Futures	1017.34	1020.78	1016.61	1020.29	11289.0
2010-06-29 23:00:00	ES	Futures	1020.29	1020.29	1018.57	1019.55	9874.0
2010-06-29 00:00:00	NQ	Futures	2094.8	2097.66	2088.21	2091.36	594.0
2010-06-29 01:00:00	NQ	Futures	2091.36	2091.36	2083.34	2087.06	1046.0
2010-06-29 02:00:00	NQ	Futures	2086.77	2086.77	2080.47	2084.77	1073.0
2010-06-29 03:00:00	NQ	Futures	2085.05	2085.91	2072.73	2074.45	4898.0
2010-06-29 04:00:00	NQ	Futures	2074.45	2076.74	2068.72	2073.59	3697.0
2010-06-29 05:00:00	NQ	Futures	2073.31	2076.46	2069.87	2075.02	2106.0
2010-06-29 06:00:00	NQ	Futures	2075.02	2079.61	2074.16	2078.46	1944.0
2010-06-29 07:00:00	NQ	Futures	2078.46	2079.04	2069.87	2074.74	3382.0
2010-06-29 08:00:00	NQ	Futures	2075.02	2077.6	2072.16	2072.16	8206.0
2010-06-29 09:00:00	NQ	Futures	2072.45	2075.88	2041.21	2047.51	75949.0
2010-06-29 10:00:00	NQ	Futures	2043.22	2045.51	2024.59	2042.36	91825.0
2010-06-29 11:00:00	NQ	Futures	2042.07	2048.95	2034.62	2036.05	44977.0
2010-06-29 12:00:00	NQ	Futures	2036.34	2041.78	2031.75	2034.05	27541.0
2010-06-29 13:00:00	NQ	Futures	2034.05	2035.77	2025.74	2033.47	33655.0
2010-06-29 14:00:00	NQ	Futures	2033.19	2040.06	2026.88	2029.46	47245.0
2010-06-29 15:00:00	NQ	Futures	2029.46	2036.91	2003.67	2021.44	105226.0
2010-06-29 16:00:00	NQ	Futures	2021.44	2024.3	2019.14	2020.58	21278.0
2010-06-29 17:00:00	NQ	Futures	2020.58	2021.72	2018.57	2019.43	581.0
2010-06-29 18:00:00	NQ	Futures	2019.72	2022.58	2017.42	2021.15	252.0
2010-06-29 19:00:00	NQ	Futures	2022.3	2023.16	2019.14	2022.58	397.0
2010-06-29 20:00:00	NQ	Futures	2022.58	2024.88	2018.86	2024.59	794.0
2010-06-29 21:00:00	NQ	Futures	2024.59	2026.59	2022.58	2025.16	705.0
2010-06-29 22:00:00	NQ	Futures	2025.16	2029.75	2023.73	2028.89	1294.0
2010-06-29 23:00:00	NQ	Futures	2029.17	2029.17	2026.02	2027.74	519.0
2010-06-29 00:00:00	YM	Futures	9523.8	9530.4	9489.7	9505.8	659.0
2010-06-29 01:00:00	YM	Futures	9506.8	9506.8	9485.0	9491.6	409.0

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

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