PREVIEW / futures_1hour / 2016-09-09

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-09-09.parquet
  size:    46 KB
  rows:    1,303

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-09 00:00:00	ES	Futures	2362.85	2362.85	2362.3	2362.3	1057.0
2016-09-09 01:00:00	ES	Futures	2362.58	2362.58	2361.22	2361.76	3705.0
2016-09-09 02:00:00	ES	Futures	2361.49	2362.58	2360.14	2360.41	4230.0
2016-09-09 03:00:00	ES	Futures	2360.14	2360.68	2358.24	2359.05	13413.0
2016-09-09 04:00:00	ES	Futures	2359.05	2360.68	2357.69	2360.14	11102.0
2016-09-09 05:00:00	ES	Futures	2360.14	2360.41	2358.51	2359.05	5562.0
2016-09-09 06:00:00	ES	Futures	2358.78	2359.05	2355.53	2355.8	12294.0
2016-09-09 07:00:00	ES	Futures	2355.53	2355.8	2351.46	2353.08	21039.0
2016-09-09 08:00:00	ES	Futures	2353.36	2353.36	2347.39	2348.47	47235.0
2016-09-09 09:00:00	ES	Futures	2348.2	2350.1	2339.8	2342.24	185037.0
2016-09-09 10:00:00	ES	Futures	2342.24	2343.59	2333.83	2338.17	211916.0
2016-09-09 11:00:00	ES	Futures	2338.44	2338.98	2331.12	2332.47	114188.0
2016-09-09 12:00:00	ES	Futures	2332.47	2334.37	2328.41	2330.3	83793.0
2016-09-09 13:00:00	ES	Futures	2330.3	2330.58	2318.92	2321.63	112362.0
2016-09-09 14:00:00	ES	Futures	2321.36	2322.71	2315.12	2319.73	160795.0
2016-09-09 15:00:00	ES	Futures	2319.73	2320.81	2306.71	2306.98	244367.0
2016-09-09 16:00:00	ES	Futures	2307.25	2308.34	2299.39	2301.02	110262.0
2016-09-09 00:00:00	NQ	Futures	5718.72	5720.21	5718.12	5719.31	240.0
2016-09-09 01:00:00	NQ	Futures	5719.61	5719.91	5716.03	5716.63	557.0
2016-09-09 02:00:00	NQ	Futures	5716.93	5718.42	5713.95	5714.54	639.0
2016-09-09 03:00:00	NQ	Futures	5714.24	5715.44	5707.39	5709.48	2557.0
2016-09-09 04:00:00	NQ	Futures	5709.77	5713.95	5707.39	5712.46	712.0
2016-09-09 05:00:00	NQ	Futures	5711.26	5712.75	5708.58	5710.37	469.0
2016-09-09 06:00:00	NQ	Futures	5709.77	5710.97	5703.51	5704.71	1239.0
2016-09-09 07:00:00	NQ	Futures	5704.71	5704.71	5694.57	5698.15	2399.0
2016-09-09 08:00:00	NQ	Futures	5697.85	5698.45	5678.78	5681.76	7179.0
2016-09-09 09:00:00	NQ	Futures	5681.46	5689.8	5674.6	5679.67	22165.0
2016-09-09 10:00:00	NQ	Futures	5679.67	5687.42	5657.32	5665.66	25997.0
2016-09-09 11:00:00	NQ	Futures	5665.66	5667.15	5639.14	5642.71	19347.0
2016-09-09 12:00:00	NQ	Futures	5642.71	5647.18	5625.13	5632.58	20311.0
2016-09-09 13:00:00	NQ	Futures	5632.28	5632.58	5605.46	5611.71	12941.0
2016-09-09 14:00:00	NQ	Futures	5611.42	5618.27	5595.92	5613.21	20078.0
2016-09-09 15:00:00	NQ	Futures	5613.21	5616.48	5580.12	5580.42	26701.0
2016-09-09 16:00:00	NQ	Futures	5580.12	5584.29	5561.64	5565.81	8223.0
2016-09-09 00:00:00	YM	Futures	19863.5	19865.7	19860.3	19861.4	151.0
2016-09-09 01:00:00	YM	Futures	19862.4	19863.5	19854.9	19854.9	427.0
2016-09-09 02:00:00	YM	Futures	19854.9	19863.5	19844.1	19844.1	799.0
2016-09-09 03:00:00	YM	Futures	19844.1	19848.4	19828.0	19833.4	2334.0
2016-09-09 04:00:00	YM	Futures	19833.4	19847.4	19825.8	19843.1	1216.0
2016-09-09 05:00:00	YM	Futures	19842.0	19842.0	19829.1	19832.3	640.0
2016-09-09 06:00:00	YM	Futures	19833.4	19833.4	19807.6	19811.9	1482.0
2016-09-09 07:00:00	YM	Futures	19811.9	19811.9	19778.5	19792.5	2866.0
2016-09-09 08:00:00	YM	Futures	19792.5	19795.7	19746.2	19751.6	5490.0
2016-09-09 09:00:00	YM	Futures	19751.6	19769.9	19702.1	19719.3	16893.0
2016-09-09 10:00:00	YM	Futures	19720.4	19735.4	19654.7	19683.8	24410.0
2016-09-09 11:00:00	YM	Futures	19683.8	19689.2	19621.4	19639.7	13867.0
2016-09-09 12:00:00	YM	Futures	19638.6	19650.4	19607.4	19628.9	10664.0
2016-09-09 13:00:00	YM	Futures	19628.9	19631.1	19552.5	19566.5	12114.0
2016-09-09 14:00:00	YM	Futures	19566.5	19578.3	19521.3	19558.9	14335.0
2016-09-09 15:00:00	YM	Futures	19560.0	19571.9	19457.8	19461.0	15406.0

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

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