PREVIEW / futures_1hour / 2015-08-04

all futures 1-hour files

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

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-04 00:00:00	ES	Futures	2225.04	2225.57	2224.77	2225.04	1408.0
2015-08-04 01:00:00	ES	Futures	2224.77	2227.7	2224.5	2227.17	2728.0
2015-08-04 02:00:00	ES	Futures	2227.43	2227.43	2224.77	2225.84	3981.0
2015-08-04 03:00:00	ES	Futures	2225.84	2225.84	2220.51	2223.71	19702.0
2015-08-04 04:00:00	ES	Futures	2223.71	2229.56	2222.64	2225.3	20643.0
2015-08-04 05:00:00	ES	Futures	2225.3	2228.23	2224.77	2225.3	11088.0
2015-08-04 06:00:00	ES	Futures	2225.57	2225.84	2221.58	2222.64	14861.0
2015-08-04 07:00:00	ES	Futures	2222.91	2223.17	2219.71	2222.91	21631.0
2015-08-04 08:00:00	ES	Futures	2223.17	2227.97	2222.64	2227.17	30130.0
2015-08-04 09:00:00	ES	Futures	2227.43	2229.83	2223.71	2227.97	179423.0
2015-08-04 10:00:00	ES	Futures	2227.97	2232.49	2222.64	2224.24	227494.0
2015-08-04 11:00:00	ES	Futures	2224.24	2227.97	2223.71	2226.1	103079.0
2015-08-04 12:00:00	ES	Futures	2225.84	2228.76	2222.37	2223.44	75952.0
2015-08-04 13:00:00	ES	Futures	2223.44	2228.5	2219.45	2220.24	162207.0
2015-08-04 14:00:00	ES	Futures	2220.24	2225.3	2216.78	2224.5	155843.0
2015-08-04 15:00:00	ES	Futures	2224.24	2225.84	2219.45	2222.64	197607.0
2015-08-04 16:00:00	ES	Futures	2222.37	2223.17	2217.85	2219.45	78944.0
2015-08-04 17:00:00	ES	Futures	2219.45	2219.45	2218.11	2218.11	1951.0
2015-08-04 18:00:00	ES	Futures	2217.85	2219.98	2217.58	2219.71	3372.0
2015-08-04 19:00:00	ES	Futures	2219.71	2219.98	2218.65	2218.91	1598.0
2015-08-04 20:00:00	ES	Futures	2219.18	2219.98	2218.65	2219.45	2351.0
2015-08-04 21:00:00	ES	Futures	2219.45	2221.04	2219.45	2221.04	1941.0
2015-08-04 22:00:00	ES	Futures	2221.04	2223.44	2220.78	2222.91	4869.0
2015-08-04 23:00:00	ES	Futures	2223.17	2223.17	2221.58	2221.84	2028.0
2015-08-04 00:00:00	NQ	Futures	5405.26	5406.14	5404.07	5404.66	342.0
2015-08-04 01:00:00	NQ	Futures	5404.07	5412.65	5403.19	5412.35	793.0
2015-08-04 02:00:00	NQ	Futures	5412.06	5412.06	5405.26	5409.1	886.0
2015-08-04 03:00:00	NQ	Futures	5408.81	5408.81	5393.72	5402.3	2704.0
2015-08-04 04:00:00	NQ	Futures	5402.3	5420.34	5399.93	5405.85	4461.0
2015-08-04 05:00:00	NQ	Futures	5405.85	5413.54	5404.66	5404.66	2490.0
2015-08-04 06:00:00	NQ	Futures	5404.96	5405.55	5392.24	5396.68	3623.0
2015-08-04 07:00:00	NQ	Futures	5396.97	5398.75	5390.17	5397.57	3687.0
2015-08-04 08:00:00	NQ	Futures	5397.86	5407.62	5395.49	5406.14	4698.0
2015-08-04 09:00:00	NQ	Futures	5406.44	5412.35	5386.33	5400.82	39258.0
2015-08-04 10:00:00	NQ	Futures	5400.82	5415.61	5375.68	5379.52	50492.0
2015-08-04 11:00:00	NQ	Futures	5379.23	5396.68	5378.34	5392.54	21680.0
2015-08-04 12:00:00	NQ	Futures	5392.54	5405.26	5384.55	5388.69	17638.0
2015-08-04 13:00:00	NQ	Futures	5388.69	5413.24	5383.96	5387.51	27597.0
2015-08-04 14:00:00	NQ	Futures	5387.51	5409.99	5378.93	5406.44	26389.0
2015-08-04 15:00:00	NQ	Futures	5406.14	5411.17	5388.4	5397.57	33264.0
2015-08-04 16:00:00	NQ	Futures	5397.57	5399.04	5384.85	5389.28	7598.0
2015-08-04 17:00:00	NQ	Futures	5389.58	5389.58	5384.25	5384.55	926.0
2015-08-04 18:00:00	NQ	Futures	5385.14	5389.58	5384.55	5389.28	557.0
2015-08-04 19:00:00	NQ	Futures	5389.58	5390.47	5387.21	5387.51	299.0
2015-08-04 20:00:00	NQ	Futures	5387.51	5389.58	5386.62	5388.99	468.0
2015-08-04 21:00:00	NQ	Futures	5388.99	5393.42	5388.1	5392.54	500.0
2015-08-04 22:00:00	NQ	Futures	5392.24	5399.64	5392.24	5397.27	806.0
2015-08-04 23:00:00	NQ	Futures	5397.86	5398.16	5393.13	5394.31	572.0
2015-08-04 00:00:00	YM	Futures	18432.4	18433.4	18428.2	18430.3	178.0
2015-08-04 01:00:00	YM	Futures	18430.3	18452.4	18427.1	18451.4	525.0

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

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