PREVIEW / futures_1hour / 2010-09-17

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-09-17.parquet
  size:    39 KB
  rows:    1,131

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-09-17 00:00:00	ES	Futures	1111.87	1113.59	1111.62	1112.61	9078.0
2010-09-17 01:00:00	ES	Futures	1112.85	1114.33	1112.61	1113.35	8922.0
2010-09-17 02:00:00	ES	Futures	1113.35	1113.59	1112.61	1112.85	11536.0
2010-09-17 03:00:00	ES	Futures	1113.1	1116.8	1112.61	1115.81	33443.0
2010-09-17 04:00:00	ES	Futures	1115.81	1116.8	1114.82	1115.32	19618.0
2010-09-17 05:00:00	ES	Futures	1115.56	1116.55	1114.58	1115.32	16944.0
2010-09-17 06:00:00	ES	Futures	1115.56	1115.56	1112.85	1113.84	22119.0
2010-09-17 07:00:00	ES	Futures	1114.08	1115.56	1109.15	1110.39	59550.0
2010-09-17 08:00:00	ES	Futures	1110.39	1111.13	1107.68	1108.66	120169.0
2010-09-17 09:00:00	ES	Futures	1108.42	1111.13	1102.5	1103.73	388187.0
2010-09-17 10:00:00	ES	Futures	1103.49	1105.95	1101.27	1104.96	327078.0
2010-09-17 11:00:00	ES	Futures	1104.72	1107.43	1102.75	1103.49	223808.0
2010-09-17 12:00:00	ES	Futures	1103.73	1106.2	1102.99	1103.73	87014.0
2010-09-17 13:00:00	ES	Futures	1103.73	1105.21	1102.5	1104.47	97006.0
2010-09-17 14:00:00	ES	Futures	1104.72	1106.94	1103.98	1105.95	104717.0
2010-09-17 15:00:00	ES	Futures	1105.7	1105.95	1102.75	1104.47	204766.0
2010-09-17 16:00:00	ES	Futures	1104.23	1104.47	1103.24	1103.73	109534.0
2010-09-17 00:00:00	NQ	Futures	2250.75	2251.9	2250.18	2251.04	258.0
2010-09-17 01:00:00	NQ	Futures	2251.61	2254.77	2251.32	2253.62	538.0
2010-09-17 02:00:00	NQ	Futures	2253.62	2255.05	2252.76	2253.91	1455.0
2010-09-17 03:00:00	NQ	Futures	2253.62	2260.79	2252.76	2259.07	3756.0
2010-09-17 04:00:00	NQ	Futures	2259.07	2260.22	2254.77	2255.63	1937.0
2010-09-17 05:00:00	NQ	Futures	2255.63	2257.35	2253.33	2254.77	2104.0
2010-09-17 06:00:00	NQ	Futures	2255.05	2255.05	2248.45	2249.6	3482.0
2010-09-17 07:00:00	NQ	Futures	2249.6	2253.91	2242.72	2244.44	4190.0
2010-09-17 08:00:00	NQ	Futures	2244.73	2249.89	2239.85	2244.44	12001.0
2010-09-17 09:00:00	NQ	Futures	2244.44	2249.32	2229.23	2233.82	68565.0
2010-09-17 10:00:00	NQ	Futures	2234.11	2241.0	2230.09	2240.13	55578.0
2010-09-17 11:00:00	NQ	Futures	2239.85	2245.3	2236.12	2238.7	38764.0
2010-09-17 12:00:00	NQ	Futures	2238.7	2244.73	2237.55	2239.27	22601.0
2010-09-17 13:00:00	NQ	Futures	2239.56	2242.72	2236.12	2241.57	20344.0
2010-09-17 14:00:00	NQ	Futures	2241.57	2245.59	2240.13	2243.86	18963.0
2010-09-17 15:00:00	NQ	Futures	2244.15	2244.15	2237.84	2240.13	32133.0
2010-09-17 16:00:00	NQ	Futures	2240.13	2243.0	2239.56	2240.42	11126.0
2010-09-17 00:00:00	YM	Futures	10085.8	10098.1	10085.8	10092.4	334.0
2010-09-17 01:00:00	YM	Futures	10093.4	10103.9	10091.5	10098.1	442.0
2010-09-17 02:00:00	YM	Futures	10096.2	10100.0	10091.5	10095.3	533.0
2010-09-17 03:00:00	YM	Futures	10095.3	10121.0	10089.6	10116.2	1892.0
2010-09-17 04:00:00	YM	Futures	10116.2	10123.9	10108.6	10113.4	1507.0
2010-09-17 05:00:00	YM	Futures	10114.3	10120.0	10106.7	10113.4	1835.0
2010-09-17 06:00:00	YM	Futures	10113.4	10113.4	10095.3	10102.9	1384.0
2010-09-17 07:00:00	YM	Futures	10101.9	10113.4	10069.6	10080.0	2354.0
2010-09-17 08:00:00	YM	Futures	10081.0	10084.8	10061.0	10061.9	4677.0
2010-09-17 09:00:00	YM	Futures	10062.9	10081.0	10009.5	10016.2	29307.0
2010-09-17 10:00:00	YM	Futures	10017.2	10035.3	9999.1	10027.6	24717.0
2010-09-17 11:00:00	YM	Futures	10027.6	10049.6	10014.3	10020.0	17282.0
2010-09-17 12:00:00	YM	Futures	10019.1	10042.9	10019.1	10021.9	7832.0
2010-09-17 13:00:00	YM	Futures	10022.9	10040.0	10014.3	10035.3	9378.0
2010-09-17 14:00:00	YM	Futures	10034.3	10051.5	10030.5	10043.8	9303.0
2010-09-17 15:00:00	YM	Futures	10042.9	10044.8	10017.2	10034.3	16071.0

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

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