PREVIEW / futures_1hour / 2009-12-09

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-12-09.parquet
  size:    46 KB
  rows:    1,374

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-12-09 00:00:00	ES	Futures	1058.75	1061.42	1058.75	1060.93	6555.0
2009-12-09 01:00:00	ES	Futures	1061.17	1061.42	1057.3	1057.3	5008.0
2009-12-09 02:00:00	ES	Futures	1057.3	1058.75	1056.09	1057.78	14305.0
2009-12-09 03:00:00	ES	Futures	1057.54	1061.17	1057.3	1058.99	24581.0
2009-12-09 04:00:00	ES	Futures	1058.75	1059.24	1055.84	1056.81	18651.0
2009-12-09 05:00:00	ES	Futures	1056.57	1061.42	1056.33	1061.17	21226.0
2009-12-09 06:00:00	ES	Futures	1060.93	1062.63	1059.24	1062.63	18146.0
2009-12-09 07:00:00	ES	Futures	1062.38	1063.35	1060.69	1061.17	20665.0
2009-12-09 08:00:00	ES	Futures	1061.42	1062.38	1058.99	1059.72	46218.0
2009-12-09 09:00:00	ES	Futures	1059.48	1059.72	1051.24	1055.12	314120.0
2009-12-09 10:00:00	ES	Futures	1055.12	1061.17	1052.7	1058.75	320598.0
2009-12-09 11:00:00	ES	Futures	1058.75	1060.2	1056.33	1058.02	162371.0
2009-12-09 12:00:00	ES	Futures	1057.78	1058.02	1054.15	1056.09	153753.0
2009-12-09 13:00:00	ES	Futures	1056.33	1056.33	1052.21	1053.42	214159.0
2009-12-09 14:00:00	ES	Futures	1053.42	1058.27	1052.94	1057.54	189659.0
2009-12-09 15:00:00	ES	Futures	1057.54	1062.87	1057.3	1060.93	300782.0
2009-12-09 16:00:00	ES	Futures	1060.93	1062.38	1060.45	1062.14	79475.0
2009-12-09 17:00:00	ES	Futures	1062.14	1062.87	1061.9	1062.87	1134.0
2009-12-09 18:00:00	ES	Futures	1063.11	1063.35	1062.14	1062.63	3943.0
2009-12-09 19:00:00	ES	Futures	1062.63	1065.05	1062.38	1064.32	7507.0
2009-12-09 20:00:00	ES	Futures	1064.08	1064.81	1062.38	1062.87	5236.0
2009-12-09 21:00:00	ES	Futures	1062.87	1063.35	1062.38	1062.38	2322.0
2009-12-09 22:00:00	ES	Futures	1062.63	1062.63	1060.69	1060.93	4970.0
2009-12-09 23:00:00	ES	Futures	1060.69	1061.42	1059.48	1059.96	4597.0
2009-12-09 00:00:00	NQ	Futures	2023.74	2027.45	2023.74	2027.16	318.0
2009-12-09 01:00:00	NQ	Futures	2027.45	2027.45	2019.75	2020.03	368.0
2009-12-09 02:00:00	NQ	Futures	2019.75	2023.45	2017.46	2020.32	953.0
2009-12-09 03:00:00	NQ	Futures	2020.6	2027.16	2019.17	2022.6	2163.0
2009-12-09 04:00:00	NQ	Futures	2022.88	2022.88	2016.32	2018.03	1464.0
2009-12-09 05:00:00	NQ	Futures	2018.03	2028.02	2017.46	2026.87	1303.0
2009-12-09 06:00:00	NQ	Futures	2026.59	2030.3	2024.02	2030.01	1012.0
2009-12-09 07:00:00	NQ	Futures	2030.01	2031.72	2026.02	2027.16	1618.0
2009-12-09 08:00:00	NQ	Futures	2027.45	2030.01	2022.88	2024.02	3822.0
2009-12-09 09:00:00	NQ	Futures	2024.02	2024.02	2006.34	2015.47	50210.0
2009-12-09 10:00:00	NQ	Futures	2015.47	2031.15	2012.04	2026.3	54600.0
2009-12-09 11:00:00	NQ	Futures	2026.3	2029.44	2023.17	2026.59	26733.0
2009-12-09 12:00:00	NQ	Futures	2026.3	2026.87	2019.46	2024.02	28264.0
2009-12-09 13:00:00	NQ	Futures	2024.31	2024.88	2018.32	2020.6	33957.0
2009-12-09 14:00:00	NQ	Futures	2020.6	2031.44	2020.03	2030.01	35506.0
2009-12-09 15:00:00	NQ	Futures	2030.3	2043.7	2030.3	2041.13	65649.0
2009-12-09 16:00:00	NQ	Futures	2041.42	2045.7	2039.99	2045.7	16903.0
2009-12-09 17:00:00	NQ	Futures	2045.98	2046.55	2045.41	2046.55	136.0
2009-12-09 18:00:00	NQ	Futures	2046.55	2047.98	2045.98	2047.12	426.0
2009-12-09 19:00:00	NQ	Futures	2046.84	2050.83	2046.27	2049.98	614.0
2009-12-09 20:00:00	NQ	Futures	2049.98	2050.55	2046.55	2047.12	390.0
2009-12-09 21:00:00	NQ	Futures	2046.84	2047.41	2044.84	2045.41	511.0
2009-12-09 22:00:00	NQ	Futures	2045.13	2045.13	2041.42	2041.7	598.0
2009-12-09 23:00:00	NQ	Futures	2041.7	2042.56	2038.85	2039.99	513.0
2009-12-09 00:00:00	YM	Futures	9576.3	9593.0	9575.3	9591.1	501.0
2009-12-09 01:00:00	YM	Futures	9591.1	9593.9	9561.4	9562.3	727.0

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

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