PREVIEW / futures_1hour / 2015-08-13

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-08-13.parquet
  size:    50 KB
  rows:    1,530

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-13 00:00:00	ES	Futures	2223.71	2224.77	2222.91	2224.5	3012.0
2015-08-13 01:00:00	ES	Futures	2224.77	2225.3	2223.97	2224.24	5436.0
2015-08-13 02:00:00	ES	Futures	2224.24	2229.03	2223.97	2225.57	17041.0
2015-08-13 03:00:00	ES	Futures	2225.57	2227.7	2223.44	2224.24	36613.0
2015-08-13 04:00:00	ES	Futures	2223.97	2225.3	2218.91	2225.3	31840.0
2015-08-13 05:00:00	ES	Futures	2225.57	2225.57	2221.58	2222.91	10307.0
2015-08-13 06:00:00	ES	Futures	2223.17	2226.63	2222.64	2225.57	15598.0
2015-08-13 07:00:00	ES	Futures	2225.57	2227.17	2223.44	2223.44	22029.0
2015-08-13 08:00:00	ES	Futures	2223.17	2224.24	2217.05	2217.32	43780.0
2015-08-13 09:00:00	ES	Futures	2217.32	2219.18	2209.06	2211.99	238026.0
2015-08-13 10:00:00	ES	Futures	2211.99	2217.85	2208.0	2214.12	230968.0
2015-08-13 11:00:00	ES	Futures	2214.12	2219.18	2210.66	2217.58	175908.0
2015-08-13 12:00:00	ES	Futures	2217.58	2223.17	2217.58	2221.84	117063.0
2015-08-13 13:00:00	ES	Futures	2222.11	2224.77	2219.18	2220.78	99895.0
2015-08-13 14:00:00	ES	Futures	2221.04	2224.5	2219.71	2223.71	65168.0
2015-08-13 15:00:00	ES	Futures	2223.44	2224.24	2212.26	2214.92	247117.0
2015-08-13 16:00:00	ES	Futures	2214.92	2216.78	2214.39	2216.25	63248.0
2015-08-13 17:00:00	ES	Futures	2216.25	2216.25	2214.39	2214.65	3146.0
2015-08-13 18:00:00	ES	Futures	2214.39	2215.19	2213.32	2213.59	2737.0
2015-08-13 19:00:00	ES	Futures	2213.85	2214.12	2213.06	2213.85	1701.0
2015-08-13 20:00:00	ES	Futures	2213.85	2214.39	2213.59	2214.12	2206.0
2015-08-13 21:00:00	ES	Futures	2214.12	2217.58	2213.85	2214.12	6181.0
2015-08-13 22:00:00	ES	Futures	2214.39	2217.58	2213.85	2215.45	3027.0
2015-08-13 23:00:00	ES	Futures	2215.45	2215.98	2213.85	2214.39	3164.0
2015-08-13 00:00:00	NQ	Futures	5377.45	5381.59	5376.86	5380.71	569.0
2015-08-13 01:00:00	NQ	Futures	5380.41	5383.07	5377.75	5379.52	592.0
2015-08-13 02:00:00	NQ	Futures	5379.82	5391.65	5378.04	5381.59	2778.0
2015-08-13 03:00:00	NQ	Futures	5381.59	5391.06	5379.23	5380.71	4332.0
2015-08-13 04:00:00	NQ	Futures	5381.0	5382.48	5365.92	5382.18	3749.0
2015-08-13 05:00:00	NQ	Futures	5382.78	5382.78	5370.35	5374.49	1606.0
2015-08-13 06:00:00	NQ	Futures	5374.49	5385.14	5374.2	5380.41	2363.0
2015-08-13 07:00:00	NQ	Futures	5380.11	5384.85	5378.04	5379.52	3832.0
2015-08-13 08:00:00	NQ	Futures	5379.52	5380.11	5362.96	5362.96	5586.0
2015-08-13 09:00:00	NQ	Futures	5363.25	5376.27	5339.29	5345.8	45927.0
2015-08-13 10:00:00	NQ	Futures	5345.21	5370.06	5334.56	5354.68	39447.0
2015-08-13 11:00:00	NQ	Futures	5354.68	5372.72	5345.21	5365.32	20780.0
2015-08-13 12:00:00	NQ	Futures	5365.62	5383.07	5365.03	5377.16	18269.0
2015-08-13 13:00:00	NQ	Futures	5377.45	5387.21	5369.76	5374.2	13119.0
2015-08-13 14:00:00	NQ	Futures	5373.9	5383.07	5370.35	5381.89	9443.0
2015-08-13 15:00:00	NQ	Futures	5382.18	5382.78	5340.77	5344.32	42941.0
2015-08-13 16:00:00	NQ	Futures	5344.32	5348.17	5341.37	5346.39	7050.0
2015-08-13 17:00:00	NQ	Futures	5346.39	5346.39	5341.66	5341.66	258.0
2015-08-13 18:00:00	NQ	Futures	5341.37	5342.84	5338.41	5339.89	485.0
2015-08-13 19:00:00	NQ	Futures	5339.89	5340.48	5337.22	5338.7	264.0
2015-08-13 20:00:00	NQ	Futures	5339.59	5340.77	5338.41	5340.77	236.0
2015-08-13 21:00:00	NQ	Futures	5340.48	5349.94	5339.89	5339.89	943.0
2015-08-13 22:00:00	NQ	Futures	5340.48	5349.65	5338.7	5343.14	801.0
2015-08-13 23:00:00	NQ	Futures	5343.14	5344.62	5339.59	5340.48	350.0
2015-08-13 00:00:00	YM	Futures	18319.7	18335.5	18318.6	18332.3	660.0
2015-08-13 01:00:00	YM	Futures	18331.3	18335.5	18323.9	18329.2	737.0

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

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