PREVIEW / futures_1hour / 2016-09-22

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-09-22.parquet
  size:    53 KB
  rows:    1,608

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
2016-09-22 00:00:00	ES	Futures	2346.14	2346.14	2345.59	2345.87	1105.0
2016-09-22 01:00:00	ES	Futures	2345.87	2346.41	2344.23	2344.5	3207.0
2016-09-22 02:00:00	ES	Futures	2344.23	2345.59	2342.87	2345.59	10096.0
2016-09-22 03:00:00	ES	Futures	2345.32	2346.95	2345.05	2346.68	23259.0
2016-09-22 04:00:00	ES	Futures	2346.68	2348.31	2345.59	2347.77	12731.0
2016-09-22 05:00:00	ES	Futures	2348.04	2353.21	2347.5	2352.67	28382.0
2016-09-22 06:00:00	ES	Futures	2352.67	2355.12	2352.4	2352.67	25229.0
2016-09-22 07:00:00	ES	Futures	2352.94	2355.93	2352.4	2355.66	21458.0
2016-09-22 08:00:00	ES	Futures	2355.66	2357.84	2353.76	2357.02	39980.0
2016-09-22 09:00:00	ES	Futures	2357.02	2363.55	2356.48	2361.92	257358.0
2016-09-22 10:00:00	ES	Futures	2361.65	2364.64	2358.92	2360.29	213426.0
2016-09-22 11:00:00	ES	Futures	2360.29	2361.1	2357.02	2358.38	144566.0
2016-09-22 12:00:00	ES	Futures	2358.11	2361.1	2357.56	2361.1	74412.0
2016-09-22 13:00:00	ES	Futures	2360.83	2363.55	2360.56	2361.92	83453.0
2016-09-22 14:00:00	ES	Futures	2361.65	2362.73	2355.39	2361.92	227954.0
2016-09-22 15:00:00	ES	Futures	2361.92	2364.09	2360.01	2360.29	245676.0
2016-09-22 16:00:00	ES	Futures	2360.29	2360.83	2357.84	2360.29	85301.0
2016-09-22 18:00:00	ES	Futures	2359.74	2360.29	2358.92	2359.2	2944.0
2016-09-22 19:00:00	ES	Futures	2359.2	2359.47	2358.11	2358.65	3406.0
2016-09-22 20:00:00	ES	Futures	2358.92	2360.01	2358.38	2358.92	6393.0
2016-09-22 21:00:00	ES	Futures	2358.92	2359.47	2357.84	2358.92	3477.0
2016-09-22 22:00:00	ES	Futures	2359.2	2360.01	2358.65	2358.92	3714.0
2016-09-22 23:00:00	ES	Futures	2358.92	2359.47	2358.65	2358.92	1828.0
2016-09-22 00:00:00	NQ	Futures	5787.1	5787.7	5786.21	5786.8	167.0
2016-09-22 01:00:00	NQ	Futures	5786.8	5788.29	5782.03	5782.03	583.0
2016-09-22 02:00:00	NQ	Futures	5781.73	5786.21	5779.05	5786.21	1192.0
2016-09-22 03:00:00	NQ	Futures	5785.91	5793.37	5784.71	5791.58	3396.0
2016-09-22 04:00:00	NQ	Futures	5791.87	5794.86	5788.59	5793.37	1881.0
2016-09-22 05:00:00	NQ	Futures	5793.66	5806.49	5793.37	5804.7	3954.0
2016-09-22 06:00:00	NQ	Futures	5804.4	5810.67	5804.11	5805.0	3168.0
2016-09-22 07:00:00	NQ	Futures	5805.0	5813.06	5804.11	5812.76	3203.0
2016-09-22 08:00:00	NQ	Futures	5812.76	5817.53	5807.98	5817.23	4906.0
2016-09-22 09:00:00	NQ	Futures	5817.53	5824.99	5812.76	5819.62	32974.0
2016-09-22 10:00:00	NQ	Futures	5820.22	5833.04	5815.44	5820.22	30387.0
2016-09-22 11:00:00	NQ	Futures	5820.51	5826.78	5817.83	5824.39	20017.0
2016-09-22 12:00:00	NQ	Futures	5824.69	5830.36	5822.9	5830.36	11462.0
2016-09-22 13:00:00	NQ	Futures	5830.36	5838.12	5828.87	5832.75	16597.0
2016-09-22 14:00:00	NQ	Futures	5832.75	5836.33	5815.74	5830.96	27207.0
2016-09-22 15:00:00	NQ	Futures	5830.96	5837.52	5828.27	5831.55	24649.0
2016-09-22 16:00:00	NQ	Futures	5831.25	5834.54	5827.67	5832.45	6210.0
2016-09-22 18:00:00	NQ	Futures	5832.15	5832.45	5829.17	5831.55	607.0
2016-09-22 19:00:00	NQ	Futures	5831.25	5831.55	5827.97	5829.17	881.0
2016-09-22 20:00:00	NQ	Futures	5828.57	5830.36	5826.18	5827.38	1101.0
2016-09-22 21:00:00	NQ	Futures	5827.08	5828.87	5825.59	5828.57	651.0
2016-09-22 22:00:00	NQ	Futures	5828.57	5833.04	5828.57	5829.46	1433.0
2016-09-22 23:00:00	NQ	Futures	5828.87	5830.96	5828.87	5830.06	316.0
2016-09-22 00:00:00	YM	Futures	19686.1	19687.2	19682.9	19686.1	181.0
2016-09-22 01:00:00	YM	Futures	19685.0	19689.3	19672.0	19672.0	844.0
2016-09-22 02:00:00	YM	Futures	19672.0	19683.9	19662.3	19682.9	1620.0
2016-09-22 03:00:00	YM	Futures	19681.8	19692.6	19677.4	19690.4	3073.0

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

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