PREVIEW / futures_1hour / 2015-08-07

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-08-07.parquet
  size:    44 KB
  rows:    1,267

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-08-07 00:00:00	ES	Futures	2217.58	2217.85	2216.52	2217.05	1357.0
2015-08-07 01:00:00	ES	Futures	2216.78	2217.05	2215.72	2216.25	1974.0
2015-08-07 02:00:00	ES	Futures	2216.25	2216.25	2213.59	2213.85	6641.0
2015-08-07 03:00:00	ES	Futures	2213.59	2213.59	2210.39	2212.52	20506.0
2015-08-07 04:00:00	ES	Futures	2212.52	2216.78	2211.72	2214.65	15396.0
2015-08-07 05:00:00	ES	Futures	2214.65	2215.19	2210.93	2211.19	10060.0
2015-08-07 06:00:00	ES	Futures	2211.19	2212.79	2210.66	2211.99	10785.0
2015-08-07 07:00:00	ES	Futures	2211.99	2212.79	2209.06	2210.13	19247.0
2015-08-07 08:00:00	ES	Futures	2210.13	2217.58	2205.87	2217.58	123329.0
2015-08-07 09:00:00	ES	Futures	2217.58	2218.11	2204.8	2210.66	295664.0
2015-08-07 10:00:00	ES	Futures	2210.66	2210.66	2201.61	2204.27	250883.0
2015-08-07 11:00:00	ES	Futures	2204.27	2206.13	2196.81	2200.28	208182.0
2015-08-07 12:00:00	ES	Futures	2200.28	2202.41	2197.35	2199.48	121364.0
2015-08-07 13:00:00	ES	Futures	2199.21	2201.34	2196.02	2199.21	99275.0
2015-08-07 14:00:00	ES	Futures	2198.94	2202.14	2197.08	2201.34	92208.0
2015-08-07 15:00:00	ES	Futures	2201.34	2207.73	2198.68	2207.46	222060.0
2015-08-07 16:00:00	ES	Futures	2207.46	2208.8	2207.2	2208.0	74536.0
2015-08-07 17:00:00	ES	Futures	2207.73	2208.0	2206.93	2207.2	1778.0
2015-08-07 00:00:00	NQ	Futures	5362.96	5364.14	5360.59	5361.77	426.0
2015-08-07 01:00:00	NQ	Futures	5362.07	5362.07	5358.23	5360.3	509.0
2015-08-07 02:00:00	NQ	Futures	5360.3	5360.3	5351.42	5352.01	1050.0
2015-08-07 03:00:00	NQ	Futures	5352.31	5352.31	5340.77	5347.58	3125.0
2015-08-07 04:00:00	NQ	Futures	5347.28	5358.82	5345.21	5354.68	2198.0
2015-08-07 05:00:00	NQ	Futures	5354.97	5355.86	5344.32	5344.62	1219.0
2015-08-07 06:00:00	NQ	Futures	5344.62	5348.46	5343.44	5346.39	2952.0
2015-08-07 07:00:00	NQ	Futures	5346.39	5347.87	5340.48	5342.84	2900.0
2015-08-07 08:00:00	NQ	Futures	5342.84	5355.86	5326.58	5355.27	13991.0
2015-08-07 09:00:00	NQ	Futures	5355.56	5358.23	5322.14	5353.49	51958.0
2015-08-07 10:00:00	NQ	Futures	5353.49	5354.08	5318.59	5327.46	39535.0
2015-08-07 11:00:00	NQ	Futures	5327.17	5331.6	5301.14	5315.34	30799.0
2015-08-07 12:00:00	NQ	Futures	5315.63	5325.1	5310.31	5313.27	16410.0
2015-08-07 13:00:00	NQ	Futures	5312.97	5318.0	5301.73	5308.83	13688.0
2015-08-07 14:00:00	NQ	Futures	5308.53	5324.21	5304.98	5323.91	11863.0
2015-08-07 15:00:00	NQ	Futures	5323.91	5348.17	5319.77	5344.91	41276.0
2015-08-07 16:00:00	NQ	Futures	5344.91	5349.06	5342.55	5343.73	8040.0
2015-08-07 17:00:00	NQ	Futures	5343.73	5343.73	5341.07	5341.07	242.0
2015-08-07 00:00:00	YM	Futures	18327.0	18327.0	18319.7	18321.8	241.0
2015-08-07 01:00:00	YM	Futures	18320.7	18320.7	18311.2	18315.5	427.0
2015-08-07 02:00:00	YM	Futures	18314.4	18314.4	18292.3	18294.4	1076.0
2015-08-07 03:00:00	YM	Futures	18293.3	18293.3	18262.8	18282.8	2509.0
2015-08-07 04:00:00	YM	Futures	18281.7	18318.6	18277.5	18304.9	1632.0
2015-08-07 05:00:00	YM	Futures	18304.9	18309.1	18272.3	18273.3	1360.0
2015-08-07 06:00:00	YM	Futures	18272.3	18287.0	18271.2	18283.9	934.0
2015-08-07 07:00:00	YM	Futures	18282.8	18287.0	18261.7	18267.0	1779.0
2015-08-07 08:00:00	YM	Futures	18268.1	18322.8	18232.2	18322.8	11466.0
2015-08-07 09:00:00	YM	Futures	18321.8	18322.8	18221.7	18264.9	32478.0
2015-08-07 10:00:00	YM	Futures	18264.9	18264.9	18184.8	18202.7	26054.0
2015-08-07 11:00:00	YM	Futures	18202.7	18217.5	18150.1	18176.4	19853.0
2015-08-07 12:00:00	YM	Futures	18176.4	18192.2	18146.9	18158.5	11380.0
2015-08-07 13:00:00	YM	Futures	18157.4	18198.5	18141.6	18185.9	10849.0

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

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