PREVIEW / futures_1hour / 2016-03-30

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-30.parquet
  size:    53 KB
  rows:    1,615

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-03-30 00:00:00	ES	Futures	2212.49	2212.76	2211.14	2211.95	2607.0
2016-03-30 01:00:00	ES	Futures	2211.95	2212.49	2211.14	2212.22	3907.0
2016-03-30 02:00:00	ES	Futures	2211.95	2214.65	2211.41	2213.3	9759.0
2016-03-30 03:00:00	ES	Futures	2213.3	2221.67	2213.3	2221.4	47642.0
2016-03-30 04:00:00	ES	Futures	2221.4	2222.75	2220.59	2221.4	27193.0
2016-03-30 05:00:00	ES	Futures	2221.4	2223.56	2220.86	2222.48	19883.0
2016-03-30 06:00:00	ES	Futures	2222.48	2226.25	2222.21	2223.83	25524.0
2016-03-30 07:00:00	ES	Futures	2224.1	2224.91	2222.75	2223.02	20764.0
2016-03-30 08:00:00	ES	Futures	2223.02	2224.37	2220.59	2224.1	40732.0
2016-03-30 09:00:00	ES	Futures	2224.1	2228.14	2220.32	2225.98	246667.0
2016-03-30 10:00:00	ES	Futures	2225.72	2228.41	2223.56	2226.79	234657.0
2016-03-30 11:00:00	ES	Futures	2226.79	2229.49	2218.7	2221.67	252328.0
2016-03-30 12:00:00	ES	Futures	2221.94	2223.29	2217.62	2218.97	130139.0
2016-03-30 13:00:00	ES	Futures	2219.24	2221.13	2215.46	2219.78	134091.0
2016-03-30 14:00:00	ES	Futures	2219.78	2223.02	2218.97	2221.94	126789.0
2016-03-30 15:00:00	ES	Futures	2221.67	2225.45	2218.97	2220.59	192827.0
2016-03-30 16:00:00	ES	Futures	2220.59	2220.86	2218.97	2219.78	69072.0
2016-03-30 18:00:00	ES	Futures	2219.78	2220.32	2218.43	2218.97	3469.0
2016-03-30 19:00:00	ES	Futures	2218.7	2219.24	2217.62	2218.43	3031.0
2016-03-30 20:00:00	ES	Futures	2218.7	2219.78	2217.62	2218.7	4559.0
2016-03-30 21:00:00	ES	Futures	2218.7	2218.97	2216.27	2216.54	6802.0
2016-03-30 22:00:00	ES	Futures	2217.08	2218.16	2215.73	2215.73	4413.0
2016-03-30 23:00:00	ES	Futures	2216.0	2217.89	2214.11	2216.54	6880.0
2016-03-30 00:00:00	NQ	Futures	5308.52	5308.52	5304.36	5305.85	544.0
2016-03-30 01:00:00	NQ	Futures	5305.85	5307.04	5303.76	5305.25	663.0
2016-03-30 02:00:00	NQ	Futures	5305.85	5314.48	5304.66	5311.8	1717.0
2016-03-30 03:00:00	NQ	Futures	5311.5	5336.2	5311.5	5336.2	7660.0
2016-03-30 04:00:00	NQ	Futures	5336.2	5340.36	5333.22	5334.41	3219.0
2016-03-30 05:00:00	NQ	Futures	5334.71	5340.06	5333.82	5338.87	2288.0
2016-03-30 06:00:00	NQ	Futures	5338.28	5350.77	5337.98	5343.04	3711.0
2016-03-30 07:00:00	NQ	Futures	5343.04	5348.1	5340.66	5343.34	2644.0
2016-03-30 08:00:00	NQ	Futures	5343.04	5345.12	5337.39	5342.44	4762.0
2016-03-30 09:00:00	NQ	Futures	5342.15	5366.84	5333.22	5361.19	41154.0
2016-03-30 10:00:00	NQ	Futures	5361.19	5367.73	5354.05	5358.51	31524.0
2016-03-30 11:00:00	NQ	Futures	5358.51	5363.57	5325.48	5335.6	42419.0
2016-03-30 12:00:00	NQ	Futures	5335.6	5337.98	5322.81	5328.46	18237.0
2016-03-30 13:00:00	NQ	Futures	5328.76	5336.79	5322.51	5333.52	15315.0
2016-03-30 14:00:00	NQ	Futures	5333.52	5341.25	5328.76	5338.58	14852.0
2016-03-30 15:00:00	NQ	Futures	5338.87	5348.1	5331.73	5334.71	22135.0
2016-03-30 16:00:00	NQ	Futures	5334.71	5335.3	5329.35	5332.03	5003.0
2016-03-30 18:00:00	NQ	Futures	5332.03	5333.52	5327.86	5329.35	452.0
2016-03-30 19:00:00	NQ	Futures	5329.65	5330.84	5328.16	5329.35	356.0
2016-03-30 20:00:00	NQ	Futures	5328.76	5331.43	5328.16	5329.95	562.0
2016-03-30 21:00:00	NQ	Futures	5329.65	5329.65	5322.51	5324.29	838.0
2016-03-30 22:00:00	NQ	Futures	5324.29	5326.38	5319.83	5320.43	739.0
2016-03-30 23:00:00	NQ	Futures	5319.83	5325.19	5316.56	5322.21	824.0
2016-03-30 00:00:00	YM	Futures	18791.8	18791.8	18777.9	18785.3	655.0
2016-03-30 01:00:00	YM	Futures	18784.3	18789.6	18780.0	18787.5	531.0
2016-03-30 02:00:00	YM	Futures	18787.5	18805.7	18783.2	18798.2	1436.0
2016-03-30 03:00:00	YM	Futures	18798.2	18866.7	18798.2	18865.6	6462.0

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

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