PREVIEW / futures_1hour / 2009-11-12

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-11-12.parquet
  size:    45 KB
  rows:    1,331

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
2009-11-12 00:00:00	ES	Futures	1058.27	1059.48	1057.3	1059.48	5053.0
2009-11-12 01:00:00	ES	Futures	1059.24	1059.72	1057.54	1058.02	3334.0
2009-11-12 02:00:00	ES	Futures	1058.27	1059.48	1057.3	1057.78	7292.0
2009-11-12 03:00:00	ES	Futures	1057.54	1060.45	1057.3	1058.51	30672.0
2009-11-12 04:00:00	ES	Futures	1058.75	1058.99	1055.12	1056.57	33963.0
2009-11-12 05:00:00	ES	Futures	1056.57	1060.93	1056.09	1059.96	22944.0
2009-11-12 06:00:00	ES	Futures	1060.2	1060.93	1057.3	1058.27	23023.0
2009-11-12 07:00:00	ES	Futures	1058.27	1060.45	1055.84	1057.54	35424.0
2009-11-12 08:00:00	ES	Futures	1057.54	1061.42	1057.3	1059.48	62642.0
2009-11-12 09:00:00	ES	Futures	1059.48	1066.26	1057.78	1065.29	264368.0
2009-11-12 10:00:00	ES	Futures	1065.05	1066.74	1060.2	1061.66	312001.0
2009-11-12 11:00:00	ES	Futures	1061.42	1061.66	1054.63	1056.09	336975.0
2009-11-12 12:00:00	ES	Futures	1056.09	1058.51	1054.63	1056.09	135563.0
2009-11-12 13:00:00	ES	Futures	1056.09	1056.81	1053.18	1055.36	155240.0
2009-11-12 14:00:00	ES	Futures	1055.36	1057.06	1052.21	1052.94	147975.0
2009-11-12 15:00:00	ES	Futures	1052.7	1053.42	1048.82	1051.73	318375.0
2009-11-12 16:00:00	ES	Futures	1051.48	1053.91	1051.48	1052.7	97440.0
2009-11-12 17:00:00	ES	Futures	1052.94	1053.18	1052.21	1052.45	1503.0
2009-11-12 18:00:00	ES	Futures	1052.7	1053.66	1052.45	1052.94	2532.0
2009-11-12 19:00:00	ES	Futures	1053.18	1053.66	1051.48	1051.97	4524.0
2009-11-12 20:00:00	ES	Futures	1051.97	1052.45	1051.24	1051.73	3256.0
2009-11-12 21:00:00	ES	Futures	1051.73	1054.15	1051.48	1053.66	3748.0
2009-11-12 22:00:00	ES	Futures	1053.91	1055.36	1053.42	1054.88	4843.0
2009-11-12 23:00:00	ES	Futures	1054.39	1054.63	1053.18	1054.63	2777.0
2009-11-12 00:00:00	NQ	Futures	2028.3	2029.73	2026.3	2029.73	398.0
2009-11-12 01:00:00	NQ	Futures	2029.44	2030.3	2026.59	2027.16	257.0
2009-11-12 02:00:00	NQ	Futures	2027.45	2029.73	2025.73	2027.16	1107.0
2009-11-12 03:00:00	NQ	Futures	2027.16	2032.01	2026.3	2028.87	2224.0
2009-11-12 04:00:00	NQ	Futures	2028.59	2029.44	2021.74	2023.74	3245.0
2009-11-12 05:00:00	NQ	Futures	2023.45	2031.72	2023.17	2029.73	1852.0
2009-11-12 06:00:00	NQ	Futures	2030.01	2031.72	2024.88	2027.73	1106.0
2009-11-12 07:00:00	NQ	Futures	2027.45	2031.44	2022.6	2024.88	2987.0
2009-11-12 08:00:00	NQ	Futures	2025.16	2032.01	2024.59	2029.73	4959.0
2009-11-12 09:00:00	NQ	Futures	2030.01	2045.41	2029.44	2043.13	49325.0
2009-11-12 10:00:00	NQ	Futures	2043.42	2045.98	2033.15	2036.0	43782.0
2009-11-12 11:00:00	NQ	Futures	2036.0	2037.43	2026.02	2028.59	44785.0
2009-11-12 12:00:00	NQ	Futures	2028.59	2034.0	2026.59	2030.01	21015.0
2009-11-12 13:00:00	NQ	Futures	2030.01	2030.58	2024.59	2028.87	20253.0
2009-11-12 14:00:00	NQ	Futures	2028.87	2031.15	2022.6	2023.74	20980.0
2009-11-12 15:00:00	NQ	Futures	2023.45	2026.02	2017.46	2022.03	48394.0
2009-11-12 16:00:00	NQ	Futures	2021.74	2023.45	2020.32	2022.03	9616.0
2009-11-12 17:00:00	NQ	Futures	2022.03	2022.6	2021.17	2022.03	151.0
2009-11-12 18:00:00	NQ	Futures	2021.46	2023.74	2021.17	2022.6	226.0
2009-11-12 19:00:00	NQ	Futures	2022.6	2023.45	2019.75	2020.32	367.0
2009-11-12 20:00:00	NQ	Futures	2020.32	2021.46	2019.46	2020.6	200.0
2009-11-12 21:00:00	NQ	Futures	2020.32	2024.88	2020.03	2024.59	328.0
2009-11-12 22:00:00	NQ	Futures	2024.88	2028.3	2023.74	2026.3	389.0
2009-11-12 23:00:00	NQ	Futures	2026.3	2026.3	2023.45	2025.45	151.0
2009-11-12 00:00:00	YM	Futures	9513.9	9522.3	9505.6	9521.4	323.0
2009-11-12 01:00:00	YM	Futures	9523.2	9524.2	9508.3	9513.0	387.0

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

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