PREVIEW / futures_1hour / 2009-12-17

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-12-17.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-17 00:00:00	ES	Futures	1073.01	1073.5	1070.58	1071.07	8120.0
2009-12-17 01:00:00	ES	Futures	1071.07	1072.28	1070.58	1071.55	3137.0
2009-12-17 02:00:00	ES	Futures	1071.8	1072.04	1069.12	1071.07	14355.0
2009-12-17 03:00:00	ES	Futures	1071.31	1073.99	1070.34	1073.26	21045.0
2009-12-17 04:00:00	ES	Futures	1073.5	1074.23	1070.83	1071.55	19085.0
2009-12-17 05:00:00	ES	Futures	1071.55	1072.04	1069.37	1069.37	14358.0
2009-12-17 06:00:00	ES	Futures	1069.37	1069.85	1066.93	1069.61	34013.0
2009-12-17 07:00:00	ES	Futures	1069.61	1070.34	1066.2	1066.69	35817.0
2009-12-17 08:00:00	ES	Futures	1066.93	1068.64	1066.2	1067.42	57757.0
2009-12-17 09:00:00	ES	Futures	1067.66	1069.85	1064.01	1064.01	235766.0
2009-12-17 10:00:00	ES	Futures	1064.26	1068.64	1063.77	1068.39	238763.0
2009-12-17 11:00:00	ES	Futures	1068.15	1069.12	1064.01	1064.99	223564.0
2009-12-17 12:00:00	ES	Futures	1064.99	1065.47	1061.34	1063.04	165651.0
2009-12-17 13:00:00	ES	Futures	1063.04	1064.99	1062.8	1064.74	126616.0
2009-12-17 14:00:00	ES	Futures	1064.74	1066.93	1064.26	1065.23	150252.0
2009-12-17 15:00:00	ES	Futures	1064.99	1065.96	1062.07	1062.31	270266.0
2009-12-17 16:00:00	ES	Futures	1062.31	1064.99	1061.58	1064.5	146503.0
2009-12-17 17:00:00	ES	Futures	1064.74	1065.47	1064.26	1065.23	3327.0
2009-12-17 18:00:00	ES	Futures	1064.99	1065.47	1064.5	1065.23	4076.0
2009-12-17 19:00:00	ES	Futures	1065.23	1065.23	1064.26	1064.74	4513.0
2009-12-17 20:00:00	ES	Futures	1064.99	1065.96	1064.5	1065.72	2957.0
2009-12-17 21:00:00	ES	Futures	1065.72	1067.91	1065.72	1066.93	6948.0
2009-12-17 22:00:00	ES	Futures	1066.93	1068.15	1065.96	1067.66	3371.0
2009-12-17 23:00:00	ES	Futures	1067.66	1067.66	1067.18	1067.42	1467.0
2009-12-17 00:00:00	NQ	Futures	2052.53	2053.39	2047.68	2048.53	559.0
2009-12-17 01:00:00	NQ	Futures	2048.25	2050.82	2047.96	2049.96	166.0
2009-12-17 02:00:00	NQ	Futures	2049.96	2050.82	2040.53	2046.25	2519.0
2009-12-17 03:00:00	NQ	Futures	2046.25	2053.1	2044.82	2050.82	2078.0
2009-12-17 04:00:00	NQ	Futures	2050.53	2051.96	2045.68	2046.82	1541.0
2009-12-17 05:00:00	NQ	Futures	2046.82	2047.96	2041.68	2041.68	1278.0
2009-12-17 06:00:00	NQ	Futures	2041.68	2044.53	2038.25	2043.68	3211.0
2009-12-17 07:00:00	NQ	Futures	2043.96	2046.53	2039.68	2040.53	2742.0
2009-12-17 08:00:00	NQ	Futures	2040.82	2045.39	2040.25	2043.68	3882.0
2009-12-17 09:00:00	NQ	Futures	2043.68	2048.53	2026.82	2034.54	49095.0
2009-12-17 10:00:00	NQ	Futures	2034.54	2039.39	2028.54	2039.11	55678.0
2009-12-17 11:00:00	NQ	Futures	2039.11	2042.25	2033.11	2034.54	35802.0
2009-12-17 12:00:00	NQ	Futures	2034.54	2035.39	2027.68	2030.25	25323.0
2009-12-17 13:00:00	NQ	Futures	2030.54	2033.68	2029.4	2033.11	16823.0
2009-12-17 14:00:00	NQ	Futures	2033.39	2037.96	2032.82	2035.39	19074.0
2009-12-17 15:00:00	NQ	Futures	2035.11	2037.68	2030.54	2030.82	37990.0
2009-12-17 16:00:00	NQ	Futures	2031.11	2041.68	2028.25	2039.39	16556.0
2009-12-17 17:00:00	NQ	Futures	2039.68	2041.39	2039.39	2040.82	298.0
2009-12-17 18:00:00	NQ	Futures	2039.39	2039.39	2038.82	2039.11	859.0
2009-12-17 19:00:00	NQ	Futures	2039.11	2040.25	2038.25	2038.82	1036.0
2009-12-17 20:00:00	NQ	Futures	2039.11	2040.25	2038.25	2040.25	277.0
2009-12-17 21:00:00	NQ	Futures	2039.68	2045.1	2039.68	2043.96	1017.0
2009-12-17 22:00:00	NQ	Futures	2043.96	2044.82	2042.82	2044.53	309.0
2009-12-17 23:00:00	NQ	Futures	2044.25	2044.53	2043.96	2043.96	221.0
2009-12-17 00:00:00	YM	Futures	9698.8	9701.6	9680.0	9684.7	542.0
2009-12-17 01:00:00	YM	Futures	9683.8	9692.2	9680.0	9683.8	281.0

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

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