PREVIEW / futures_1hour / 2009-12-07

all futures 1-hour files

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

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-07 00:00:00	ES	Futures	1072.56	1073.77	1071.1	1071.35	4274.0
2009-12-07 01:00:00	ES	Futures	1071.35	1072.07	1070.86	1071.35	2827.0
2009-12-07 02:00:00	ES	Futures	1071.1	1071.59	1069.89	1070.38	6161.0
2009-12-07 03:00:00	ES	Futures	1070.38	1070.62	1064.81	1065.29	41609.0
2009-12-07 04:00:00	ES	Futures	1065.53	1070.62	1064.56	1070.38	22818.0
2009-12-07 05:00:00	ES	Futures	1070.14	1072.07	1068.92	1069.17	18426.0
2009-12-07 06:00:00	ES	Futures	1068.92	1070.86	1068.44	1069.65	9308.0
2009-12-07 07:00:00	ES	Futures	1069.89	1071.83	1068.68	1071.1	18858.0
2009-12-07 08:00:00	ES	Futures	1071.1	1071.59	1070.14	1070.86	25899.0
2009-12-07 09:00:00	ES	Futures	1070.86	1075.95	1069.41	1074.5	218916.0
2009-12-07 10:00:00	ES	Futures	1074.5	1075.22	1070.62	1073.04	242945.0
2009-12-07 11:00:00	ES	Futures	1072.8	1073.04	1071.1	1072.8	124687.0
2009-12-07 12:00:00	ES	Futures	1072.56	1074.98	1071.1	1074.01	132015.0
2009-12-07 13:00:00	ES	Futures	1074.01	1075.71	1072.32	1073.04	124174.0
2009-12-07 14:00:00	ES	Futures	1073.04	1073.53	1065.78	1067.71	223015.0
2009-12-07 15:00:00	ES	Futures	1067.71	1070.38	1066.26	1068.44	218023.0
2009-12-07 16:00:00	ES	Futures	1068.68	1071.59	1068.2	1071.1	77280.0
2009-12-07 17:00:00	ES	Futures	1071.35	1072.32	1071.1	1071.83	4501.0
2009-12-07 18:00:00	ES	Futures	1071.59	1072.07	1071.1	1071.1	2219.0
2009-12-07 19:00:00	ES	Futures	1071.1	1073.04	1071.1	1072.56	5703.0
2009-12-07 20:00:00	ES	Futures	1072.56	1072.8	1072.07	1072.07	1419.0
2009-12-07 21:00:00	ES	Futures	1072.07	1072.32	1070.14	1071.1	3781.0
2009-12-07 22:00:00	ES	Futures	1071.1	1071.35	1070.38	1070.86	2167.0
2009-12-07 23:00:00	ES	Futures	1070.86	1071.35	1070.62	1070.86	1853.0
2009-12-07 00:00:00	NQ	Futures	2045.41	2047.41	2042.56	2043.13	238.0
2009-12-07 01:00:00	NQ	Futures	2043.42	2044.84	2042.85	2043.7	138.0
2009-12-07 02:00:00	NQ	Futures	2043.13	2043.7	2040.56	2041.7	575.0
2009-12-07 03:00:00	NQ	Futures	2041.7	2041.99	2030.87	2031.72	3264.0
2009-12-07 04:00:00	NQ	Futures	2031.72	2041.7	2030.58	2041.13	1701.0
2009-12-07 05:00:00	NQ	Futures	2041.42	2044.27	2038.57	2038.57	1391.0
2009-12-07 06:00:00	NQ	Futures	2038.28	2042.56	2037.14	2040.28	739.0
2009-12-07 07:00:00	NQ	Futures	2040.28	2044.27	2038.28	2043.7	1010.0
2009-12-07 08:00:00	NQ	Futures	2043.42	2043.7	2040.56	2042.28	2178.0
2009-12-07 09:00:00	NQ	Futures	2042.56	2051.12	2039.99	2047.69	38380.0
2009-12-07 10:00:00	NQ	Futures	2047.41	2049.98	2042.56	2045.7	36702.0
2009-12-07 11:00:00	NQ	Futures	2045.98	2045.98	2040.56	2043.7	21000.0
2009-12-07 12:00:00	NQ	Futures	2043.42	2045.98	2040.28	2043.42	23610.0
2009-12-07 13:00:00	NQ	Futures	2043.13	2046.55	2040.56	2041.13	21322.0
2009-12-07 14:00:00	NQ	Futures	2041.13	2042.28	2029.44	2032.86	35418.0
2009-12-07 15:00:00	NQ	Futures	2032.86	2036.86	2030.01	2033.72	39038.0
2009-12-07 16:00:00	NQ	Futures	2033.72	2040.28	2032.86	2039.42	9530.0
2009-12-07 17:00:00	NQ	Futures	2039.42	2040.85	2038.85	2039.71	441.0
2009-12-07 18:00:00	NQ	Futures	2037.71	2039.99	2037.71	2038.85	183.0
2009-12-07 19:00:00	NQ	Futures	2038.57	2041.7	2038.28	2040.85	381.0
2009-12-07 20:00:00	NQ	Futures	2040.56	2041.13	2039.99	2039.99	58.0
2009-12-07 21:00:00	NQ	Futures	2040.28	2040.56	2035.43	2037.71	269.0
2009-12-07 22:00:00	NQ	Futures	2037.71	2038.28	2036.57	2037.71	210.0
2009-12-07 23:00:00	NQ	Futures	2037.71	2038.28	2037.43	2037.43	109.0
2009-12-07 00:00:00	YM	Futures	9664.6	9673.9	9652.5	9658.1	323.0
2009-12-07 01:00:00	YM	Futures	9657.2	9662.8	9654.4	9656.2	138.0

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

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