PREVIEW / futures_1hour / 2015-08-05

all futures 1-hour files

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

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-05 00:00:00	ES	Futures	2221.84	2222.11	2221.58	2221.84	1078.0
2015-08-05 01:00:00	ES	Futures	2221.84	2222.11	2220.78	2221.31	1733.0
2015-08-05 02:00:00	ES	Futures	2221.58	2224.24	2221.04	2223.17	6003.0
2015-08-05 03:00:00	ES	Futures	2223.44	2225.3	2222.37	2223.44	15966.0
2015-08-05 04:00:00	ES	Futures	2223.44	2225.04	2221.84	2224.5	10807.0
2015-08-05 05:00:00	ES	Futures	2224.77	2226.63	2223.71	2226.37	9138.0
2015-08-05 06:00:00	ES	Futures	2226.63	2229.3	2226.37	2228.23	16377.0
2015-08-05 07:00:00	ES	Futures	2228.5	2234.36	2228.23	2232.23	36644.0
2015-08-05 08:00:00	ES	Futures	2231.96	2239.95	2231.96	2234.89	71733.0
2015-08-05 09:00:00	ES	Futures	2235.15	2241.54	2233.82	2239.68	213953.0
2015-08-05 10:00:00	ES	Futures	2239.68	2243.94	2237.02	2241.01	215048.0
2015-08-05 11:00:00	ES	Futures	2241.28	2242.34	2234.89	2235.42	149076.0
2015-08-05 12:00:00	ES	Futures	2235.42	2235.95	2228.76	2233.29	174270.0
2015-08-05 13:00:00	ES	Futures	2233.02	2233.29	2226.63	2229.03	117836.0
2015-08-05 14:00:00	ES	Futures	2229.03	2234.09	2228.23	2232.23	109669.0
2015-08-05 15:00:00	ES	Futures	2232.23	2235.15	2229.56	2230.63	152661.0
2015-08-05 16:00:00	ES	Futures	2230.63	2232.49	2229.3	2230.63	58511.0
2015-08-05 17:00:00	ES	Futures	2230.36	2231.16	2230.36	2230.89	837.0
2015-08-05 18:00:00	ES	Futures	2230.1	2230.89	2229.3	2229.56	1615.0
2015-08-05 19:00:00	ES	Futures	2229.83	2230.1	2228.5	2229.03	1490.0
2015-08-05 20:00:00	ES	Futures	2229.03	2230.36	2228.5	2229.03	3045.0
2015-08-05 21:00:00	ES	Futures	2229.3	2229.83	2227.43	2228.5	3063.0
2015-08-05 22:00:00	ES	Futures	2228.23	2229.03	2227.97	2228.23	1769.0
2015-08-05 23:00:00	ES	Futures	2228.5	2228.5	2227.7	2228.23	1172.0
2015-08-05 00:00:00	NQ	Futures	5394.61	5394.9	5393.42	5393.72	189.0
2015-08-05 01:00:00	NQ	Futures	5394.02	5395.49	5391.95	5393.72	412.0
2015-08-05 02:00:00	NQ	Futures	5394.02	5401.71	5393.72	5399.64	1399.0
2015-08-05 03:00:00	NQ	Futures	5399.93	5404.96	5396.97	5402.3	2916.0
2015-08-05 04:00:00	NQ	Futures	5402.0	5402.89	5394.31	5402.3	1962.0
2015-08-05 05:00:00	NQ	Futures	5402.3	5406.14	5399.93	5406.14	1323.0
2015-08-05 06:00:00	NQ	Futures	5406.44	5410.28	5405.26	5407.33	3605.0
2015-08-05 07:00:00	NQ	Futures	5407.33	5426.26	5407.03	5420.93	6542.0
2015-08-05 08:00:00	NQ	Futures	5421.23	5445.78	5421.23	5429.21	11617.0
2015-08-05 09:00:00	NQ	Futures	5429.51	5462.64	5422.41	5459.98	46110.0
2015-08-05 10:00:00	NQ	Futures	5459.98	5471.51	5451.99	5468.85	37643.0
2015-08-05 11:00:00	NQ	Futures	5469.44	5476.84	5461.75	5463.23	24134.0
2015-08-05 12:00:00	NQ	Futures	5462.93	5463.23	5440.16	5454.36	26783.0
2015-08-05 13:00:00	NQ	Futures	5454.95	5454.95	5430.99	5435.72	19174.0
2015-08-05 14:00:00	NQ	Futures	5435.72	5453.77	5433.65	5444.89	23371.0
2015-08-05 15:00:00	NQ	Futures	5445.19	5453.47	5436.61	5439.57	29672.0
2015-08-05 16:00:00	NQ	Futures	5439.27	5443.12	5431.58	5436.31	6448.0
2015-08-05 17:00:00	NQ	Futures	5436.31	5436.61	5435.43	5436.02	81.0
2015-08-05 18:00:00	NQ	Futures	5432.76	5434.24	5431.29	5432.47	2158.0
2015-08-05 19:00:00	NQ	Futures	5432.76	5433.65	5430.1	5430.4	465.0
2015-08-05 20:00:00	NQ	Futures	5430.69	5436.02	5430.1	5433.06	466.0
2015-08-05 21:00:00	NQ	Futures	5433.06	5433.95	5427.44	5430.99	834.0
2015-08-05 22:00:00	NQ	Futures	5430.99	5433.06	5429.51	5430.99	510.0
2015-08-05 23:00:00	NQ	Futures	5430.4	5431.88	5429.21	5431.58	452.0
2015-08-05 00:00:00	YM	Futures	18379.7	18380.8	18375.5	18379.7	85.0
2015-08-05 01:00:00	YM	Futures	18379.7	18381.8	18371.3	18374.5	181.0

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

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