PREVIEW / futures_1hour / 2009-11-23

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-11-23.parquet
  size:    43 KB
  rows:    1,292

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-23 00:00:00	ES	Futures	1059.96	1060.45	1059.24	1059.96	1685.0
2009-11-23 01:00:00	ES	Futures	1059.72	1059.96	1058.75	1059.72	1775.0
2009-11-23 02:00:00	ES	Futures	1059.72	1064.56	1059.72	1062.87	22189.0
2009-11-23 03:00:00	ES	Futures	1062.87	1067.71	1062.87	1066.26	32592.0
2009-11-23 04:00:00	ES	Futures	1066.26	1067.47	1065.29	1066.5	13456.0
2009-11-23 05:00:00	ES	Futures	1066.74	1067.71	1066.02	1067.47	9603.0
2009-11-23 06:00:00	ES	Futures	1067.23	1067.71	1066.26	1067.23	8760.0
2009-11-23 07:00:00	ES	Futures	1066.99	1067.96	1066.26	1066.74	16078.0
2009-11-23 08:00:00	ES	Futures	1066.74	1066.99	1065.53	1066.99	22046.0
2009-11-23 09:00:00	ES	Futures	1066.99	1076.92	1066.74	1076.19	291874.0
2009-11-23 10:00:00	ES	Futures	1075.95	1076.92	1073.04	1073.53	320921.0
2009-11-23 11:00:00	ES	Futures	1073.77	1074.5	1071.35	1071.59	120502.0
2009-11-23 12:00:00	ES	Futures	1071.83	1072.56	1069.41	1070.86	141696.0
2009-11-23 13:00:00	ES	Futures	1070.86	1071.35	1068.68	1069.41	89632.0
2009-11-23 14:00:00	ES	Futures	1069.41	1070.38	1067.71	1069.41	106802.0
2009-11-23 15:00:00	ES	Futures	1069.41	1071.1	1066.99	1069.65	221544.0
2009-11-23 16:00:00	ES	Futures	1069.89	1069.89	1068.44	1068.68	89865.0
2009-11-23 17:00:00	ES	Futures	1068.68	1068.68	1068.2	1068.44	934.0
2009-11-23 18:00:00	ES	Futures	1068.68	1069.41	1068.44	1068.68	2292.0
2009-11-23 19:00:00	ES	Futures	1068.68	1068.92	1067.71	1067.96	6602.0
2009-11-23 20:00:00	ES	Futures	1067.71	1068.2	1066.99	1067.23	4265.0
2009-11-23 21:00:00	ES	Futures	1067.47	1067.96	1067.23	1067.47	1957.0
2009-11-23 22:00:00	ES	Futures	1067.23	1067.47	1066.74	1067.23	4853.0
2009-11-23 23:00:00	ES	Futures	1067.23	1067.71	1066.74	1066.74	3291.0
2009-11-23 00:00:00	NQ	Futures	2020.03	2020.03	2018.89	2019.46	38.0
2009-11-23 01:00:00	NQ	Futures	2018.89	2020.32	2017.18	2019.75	173.0
2009-11-23 02:00:00	NQ	Futures	2019.75	2027.16	2019.46	2024.02	1812.0
2009-11-23 03:00:00	NQ	Futures	2023.74	2033.43	2023.74	2030.58	2382.0
2009-11-23 04:00:00	NQ	Futures	2030.58	2032.29	2028.3	2030.58	1112.0
2009-11-23 05:00:00	NQ	Futures	2030.58	2032.29	2029.16	2031.44	826.0
2009-11-23 06:00:00	NQ	Futures	2031.72	2032.29	2029.44	2031.72	990.0
2009-11-23 07:00:00	NQ	Futures	2031.44	2032.58	2028.87	2029.73	2148.0
2009-11-23 08:00:00	NQ	Futures	2029.73	2030.58	2027.45	2030.3	3405.0
2009-11-23 09:00:00	NQ	Futures	2030.58	2054.54	2030.58	2053.97	62284.0
2009-11-23 10:00:00	NQ	Futures	2053.68	2055.39	2047.12	2048.26	58300.0
2009-11-23 11:00:00	NQ	Futures	2047.98	2049.69	2041.99	2042.28	21654.0
2009-11-23 12:00:00	NQ	Futures	2042.28	2044.84	2038.57	2043.13	21908.0
2009-11-23 13:00:00	NQ	Futures	2043.13	2044.84	2039.71	2040.85	15390.0
2009-11-23 14:00:00	NQ	Futures	2040.85	2042.28	2037.71	2040.28	14548.0
2009-11-23 15:00:00	NQ	Futures	2040.56	2045.41	2037.14	2044.27	39451.0
2009-11-23 16:00:00	NQ	Futures	2044.56	2044.56	2041.7	2041.99	13725.0
2009-11-23 17:00:00	NQ	Futures	2041.99	2042.28	2041.42	2041.42	54.0
2009-11-23 18:00:00	NQ	Futures	2041.42	2043.42	2041.42	2042.28	117.0
2009-11-23 19:00:00	NQ	Futures	2042.28	2042.28	2039.42	2039.42	310.0
2009-11-23 20:00:00	NQ	Futures	2039.42	2040.56	2038.0	2038.57	192.0
2009-11-23 21:00:00	NQ	Futures	2038.28	2039.99	2038.28	2038.28	123.0
2009-11-23 22:00:00	NQ	Futures	2038.28	2038.28	2036.57	2037.43	286.0
2009-11-23 23:00:00	NQ	Futures	2037.71	2038.57	2036.86	2037.14	101.0
2009-11-23 00:00:00	YM	Futures	9619.0	9620.0	9612.5	9614.4	230.0
2009-11-23 01:00:00	YM	Futures	9612.5	9616.2	9606.9	9616.2	194.0

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

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