PREVIEW / futures_1hour / 2010-05-28

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-05-28.parquet
  size:    38 KB
  rows:    1,085

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
2010-05-28 00:00:00	ES	Futures	1074.01	1074.99	1072.05	1072.79	3982.0
2010-05-28 01:00:00	ES	Futures	1072.54	1075.23	1072.3	1074.5	4254.0
2010-05-28 02:00:00	ES	Futures	1074.25	1077.92	1073.03	1076.7	15732.0
2010-05-28 03:00:00	ES	Futures	1076.45	1076.94	1072.54	1075.48	41687.0
2010-05-28 04:00:00	ES	Futures	1075.48	1080.12	1074.99	1078.16	29586.0
2010-05-28 05:00:00	ES	Futures	1078.16	1079.39	1076.94	1078.65	18201.0
2010-05-28 06:00:00	ES	Futures	1078.9	1079.39	1076.45	1077.68	13876.0
2010-05-28 07:00:00	ES	Futures	1077.92	1082.08	1076.7	1080.36	35569.0
2010-05-28 08:00:00	ES	Futures	1080.36	1081.59	1076.45	1077.43	68765.0
2010-05-28 09:00:00	ES	Futures	1077.43	1079.14	1069.61	1074.5	278904.0
2010-05-28 10:00:00	ES	Futures	1074.5	1076.94	1068.88	1070.59	285276.0
2010-05-28 11:00:00	ES	Futures	1070.59	1073.03	1066.19	1071.08	240674.0
2010-05-28 12:00:00	ES	Futures	1071.08	1073.52	1060.32	1065.94	319775.0
2010-05-28 13:00:00	ES	Futures	1065.7	1068.14	1062.03	1062.77	143086.0
2010-05-28 14:00:00	ES	Futures	1062.52	1072.05	1059.1	1068.63	212908.0
2010-05-28 15:00:00	ES	Futures	1068.63	1074.99	1062.77	1064.72	396349.0
2010-05-28 16:00:00	ES	Futures	1064.23	1065.45	1059.83	1063.25	192763.0
2010-05-28 00:00:00	NQ	Futures	2130.04	2131.18	2126.6	2128.03	470.0
2010-05-28 01:00:00	NQ	Futures	2127.46	2132.04	2124.03	2130.9	974.0
2010-05-28 02:00:00	NQ	Futures	2130.61	2135.77	2128.61	2134.33	1687.0
2010-05-28 03:00:00	NQ	Futures	2134.05	2134.05	2125.17	2132.9	4191.0
2010-05-28 04:00:00	NQ	Futures	2132.62	2140.92	2130.9	2137.2	2898.0
2010-05-28 05:00:00	NQ	Futures	2137.2	2139.2	2134.91	2138.06	950.0
2010-05-28 06:00:00	NQ	Futures	2138.34	2138.63	2134.05	2135.48	1203.0
2010-05-28 07:00:00	NQ	Futures	2135.77	2146.94	2134.05	2143.5	4164.0
2010-05-28 08:00:00	NQ	Futures	2143.5	2146.36	2135.48	2136.91	10022.0
2010-05-28 09:00:00	NQ	Futures	2136.91	2139.49	2122.59	2132.04	38378.0
2010-05-28 10:00:00	NQ	Futures	2132.04	2138.63	2119.73	2123.45	37416.0
2010-05-28 11:00:00	NQ	Futures	2123.45	2126.03	2114.0	2121.16	28368.0
2010-05-28 12:00:00	NQ	Futures	2121.16	2128.89	2102.83	2112.57	46156.0
2010-05-28 13:00:00	NQ	Futures	2112.28	2117.15	2107.13	2109.13	21145.0
2010-05-28 14:00:00	NQ	Futures	2108.85	2129.75	2102.55	2125.74	30980.0
2010-05-28 15:00:00	NQ	Futures	2125.46	2138.63	2119.16	2121.73	59564.0
2010-05-28 16:00:00	NQ	Futures	2121.73	2123.17	2114.86	2120.59	19970.0
2010-05-28 00:00:00	YM	Futures	9609.3	9615.9	9594.2	9601.8	450.0
2010-05-28 01:00:00	YM	Futures	9600.8	9624.3	9597.1	9616.8	601.0
2010-05-28 02:00:00	YM	Futures	9615.9	9644.1	9609.3	9638.5	1803.0
2010-05-28 03:00:00	YM	Futures	9638.5	9639.4	9600.8	9630.9	3394.0
2010-05-28 04:00:00	YM	Futures	9630.9	9655.4	9626.2	9642.2	2219.0
2010-05-28 05:00:00	YM	Futures	9643.2	9649.7	9634.7	9646.9	1022.0
2010-05-28 06:00:00	YM	Futures	9645.0	9652.6	9631.9	9640.3	919.0
2010-05-28 07:00:00	YM	Futures	9640.3	9670.5	9632.8	9662.0	2083.0
2010-05-28 08:00:00	YM	Futures	9662.0	9666.7	9628.1	9634.7	4361.0
2010-05-28 09:00:00	YM	Futures	9635.6	9649.7	9576.4	9608.3	19896.0
2010-05-28 10:00:00	YM	Futures	9609.3	9626.2	9569.8	9581.1	17201.0
2010-05-28 11:00:00	YM	Futures	9581.1	9605.5	9552.8	9588.6	14505.0
2010-05-28 12:00:00	YM	Futures	9587.6	9607.4	9494.5	9535.9	21621.0
2010-05-28 13:00:00	YM	Futures	9536.8	9559.4	9509.5	9515.2	9039.0
2010-05-28 14:00:00	YM	Futures	9514.2	9587.6	9487.9	9566.0	13445.0
2010-05-28 15:00:00	YM	Futures	9565.1	9614.9	9515.2	9528.4	24247.0

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

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