PREVIEW / futures_1hour / 2015-09-21

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-09-21.parquet
  size:    49 KB
  rows:    1,505

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
2015-09-21 00:00:00	ES	Futures	2077.47	2080.94	2077.47	2079.34	2684.0
2015-09-21 01:00:00	ES	Futures	2079.34	2084.15	2079.34	2080.94	5746.0
2015-09-21 02:00:00	ES	Futures	2080.68	2084.69	2079.34	2079.87	11797.0
2015-09-21 03:00:00	ES	Futures	2079.87	2086.03	2078.27	2082.82	23787.0
2015-09-21 04:00:00	ES	Futures	2082.82	2092.98	2080.68	2091.91	24391.0
2015-09-21 05:00:00	ES	Futures	2092.18	2094.32	2090.84	2092.18	19165.0
2015-09-21 06:00:00	ES	Futures	2092.45	2093.52	2088.44	2091.91	19353.0
2015-09-21 07:00:00	ES	Futures	2092.18	2102.35	2091.91	2101.01	37125.0
2015-09-21 08:00:00	ES	Futures	2100.74	2101.81	2097.53	2098.34	36037.0
2015-09-21 09:00:00	ES	Futures	2098.07	2100.74	2091.65	2095.66	184644.0
2015-09-21 10:00:00	ES	Futures	2095.39	2107.43	2094.05	2103.96	215899.0
2015-09-21 11:00:00	ES	Futures	2104.22	2106.36	2093.79	2095.13	159410.0
2015-09-21 12:00:00	ES	Futures	2095.13	2095.13	2080.94	2083.62	199240.0
2015-09-21 13:00:00	ES	Futures	2083.35	2094.59	2082.55	2088.7	141109.0
2015-09-21 14:00:00	ES	Futures	2088.7	2099.14	2085.76	2097.27	133500.0
2015-09-21 15:00:00	ES	Futures	2097.0	2098.34	2088.17	2094.59	174070.0
2015-09-21 16:00:00	ES	Futures	2094.59	2102.62	2094.32	2101.81	81031.0
2015-09-21 18:00:00	ES	Futures	2102.35	2103.15	2099.67	2100.21	4407.0
2015-09-21 19:00:00	ES	Futures	2100.21	2101.81	2099.67	2101.55	2741.0
2015-09-21 20:00:00	ES	Futures	2101.55	2101.81	2098.87	2099.67	3023.0
2015-09-21 21:00:00	ES	Futures	2099.41	2100.21	2095.93	2097.8	5357.0
2015-09-21 22:00:00	ES	Futures	2097.8	2098.34	2096.46	2097.0	3019.0
2015-09-21 23:00:00	ES	Futures	2096.73	2097.8	2095.93	2096.2	2621.0
2015-09-21 00:00:00	NQ	Futures	5103.5	5112.39	5103.2	5108.54	390.0
2015-09-21 01:00:00	NQ	Futures	5108.54	5118.62	5108.54	5112.1	1041.0
2015-09-21 02:00:00	NQ	Futures	5111.51	5121.88	5106.76	5109.13	1388.0
2015-09-21 03:00:00	NQ	Futures	5108.84	5123.96	5104.98	5118.62	4286.0
2015-09-21 04:00:00	NQ	Futures	5118.32	5146.79	5112.39	5144.42	4370.0
2015-09-21 05:00:00	NQ	Futures	5144.71	5149.16	5139.97	5145.01	3375.0
2015-09-21 06:00:00	NQ	Futures	5145.31	5148.27	5134.34	5141.15	2820.0
2015-09-21 07:00:00	NQ	Futures	5141.45	5164.28	5141.45	5161.32	5409.0
2015-09-21 08:00:00	NQ	Futures	5161.02	5161.91	5151.53	5153.9	4284.0
2015-09-21 09:00:00	NQ	Futures	5153.9	5154.79	5131.37	5144.42	29576.0
2015-09-21 10:00:00	NQ	Futures	5144.42	5172.58	5140.26	5164.28	30798.0
2015-09-21 11:00:00	NQ	Futures	5163.98	5170.51	5131.67	5134.04	25829.0
2015-09-21 12:00:00	NQ	Futures	5134.04	5134.04	5083.64	5090.45	38891.0
2015-09-21 13:00:00	NQ	Futures	5090.75	5127.81	5087.79	5110.62	28422.0
2015-09-21 14:00:00	NQ	Futures	5110.62	5141.15	5102.91	5136.41	24204.0
2015-09-21 15:00:00	NQ	Futures	5136.41	5142.04	5112.69	5130.18	30890.0
2015-09-21 16:00:00	NQ	Futures	5130.18	5151.53	5129.89	5150.94	9352.0
2015-09-21 18:00:00	NQ	Futures	5149.46	5153.01	5143.23	5143.53	785.0
2015-09-21 19:00:00	NQ	Futures	5143.23	5147.97	5142.34	5147.97	450.0
2015-09-21 20:00:00	NQ	Futures	5146.79	5147.08	5139.67	5142.34	628.0
2015-09-21 21:00:00	NQ	Futures	5142.04	5144.71	5134.63	5139.38	924.0
2015-09-21 22:00:00	NQ	Futures	5139.67	5140.56	5135.52	5136.41	573.0
2015-09-21 23:00:00	NQ	Futures	5135.82	5137.6	5132.85	5134.34	438.0
2015-09-21 00:00:00	YM	Futures	17208.6	17235.1	17208.6	17223.5	423.0
2015-09-21 01:00:00	YM	Futures	17224.5	17257.4	17224.5	17237.2	1253.0
2015-09-21 02:00:00	YM	Futures	17235.1	17263.7	17221.3	17229.8	1560.0
2015-09-21 03:00:00	YM	Futures	17226.6	17280.7	17217.1	17249.9	3482.0

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

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