PREVIEW / futures_1hour / 2016-09-19

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-09-19.parquet
  size:    51 KB
  rows:    1,605

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-19 00:00:00	ES	Futures	2328.45	2328.45	2327.64	2327.91	1135.0
2016-09-19 01:00:00	ES	Futures	2327.91	2329.0	2327.91	2328.45	3093.0
2016-09-19 02:00:00	ES	Futures	2328.72	2331.17	2328.45	2330.08	9141.0
2016-09-19 03:00:00	ES	Futures	2330.08	2333.35	2328.18	2330.9	26567.0
2016-09-19 04:00:00	ES	Futures	2330.9	2332.81	2329.54	2331.17	15262.0
2016-09-19 05:00:00	ES	Futures	2331.17	2333.62	2330.63	2330.63	12784.0
2016-09-19 06:00:00	ES	Futures	2330.9	2331.17	2329.81	2330.08	10664.0
2016-09-19 07:00:00	ES	Futures	2330.08	2332.53	2329.0	2331.44	16469.0
2016-09-19 08:00:00	ES	Futures	2331.44	2332.81	2329.81	2330.36	23086.0
2016-09-19 09:00:00	ES	Futures	2330.36	2335.25	2327.36	2334.71	184568.0
2016-09-19 10:00:00	ES	Futures	2334.98	2336.34	2329.27	2330.36	194371.0
2016-09-19 11:00:00	ES	Futures	2330.36	2333.08	2329.54	2332.26	122263.0
2016-09-19 12:00:00	ES	Futures	2332.26	2333.08	2322.19	2322.47	158429.0
2016-09-19 13:00:00	ES	Futures	2322.74	2324.64	2315.66	2321.11	209167.0
2016-09-19 14:00:00	ES	Futures	2320.83	2327.91	2320.29	2327.36	153417.0
2016-09-19 15:00:00	ES	Futures	2327.36	2327.91	2318.11	2319.47	286501.0
2016-09-19 16:00:00	ES	Futures	2319.2	2322.47	2318.93	2321.92	64950.0
2016-09-19 18:00:00	ES	Futures	2322.19	2322.74	2321.38	2321.65	2877.0
2016-09-19 19:00:00	ES	Futures	2321.92	2323.28	2318.93	2320.02	3364.0
2016-09-19 20:00:00	ES	Futures	2319.75	2324.37	2319.75	2322.74	5830.0
2016-09-19 21:00:00	ES	Futures	2323.01	2326.28	2322.47	2324.37	7808.0
2016-09-19 22:00:00	ES	Futures	2324.1	2325.46	2323.55	2324.37	2803.0
2016-09-19 23:00:00	ES	Futures	2324.37	2325.19	2323.83	2324.92	2402.0
2016-09-19 00:00:00	NQ	Futures	5762.34	5763.23	5761.44	5761.74	147.0
2016-09-19 01:00:00	NQ	Futures	5762.34	5766.81	5762.34	5766.22	840.0
2016-09-19 02:00:00	NQ	Futures	5765.92	5773.68	5765.62	5769.8	1947.0
2016-09-19 03:00:00	NQ	Futures	5769.5	5777.85	5765.92	5771.89	4297.0
2016-09-19 04:00:00	NQ	Futures	5772.18	5774.27	5767.41	5770.69	3364.0
2016-09-19 05:00:00	NQ	Futures	5769.8	5774.87	5767.71	5767.71	1552.0
2016-09-19 06:00:00	NQ	Futures	5768.01	5769.2	5764.73	5765.32	1640.0
2016-09-19 07:00:00	NQ	Futures	5765.02	5766.81	5761.44	5764.13	3089.0
2016-09-19 08:00:00	NQ	Futures	5763.83	5768.6	5760.55	5761.44	3582.0
2016-09-19 09:00:00	NQ	Futures	5761.15	5774.27	5755.48	5773.68	33228.0
2016-09-19 10:00:00	NQ	Futures	5773.97	5775.76	5741.75	5746.23	34103.0
2016-09-19 11:00:00	NQ	Futures	5746.23	5754.88	5742.65	5753.99	22271.0
2016-09-19 12:00:00	NQ	Futures	5753.99	5755.48	5724.75	5725.64	25326.0
2016-09-19 13:00:00	NQ	Futures	5725.35	5731.91	5707.15	5722.06	27726.0
2016-09-19 14:00:00	NQ	Futures	5721.47	5740.26	5720.27	5738.77	24912.0
2016-09-19 15:00:00	NQ	Futures	5738.77	5739.67	5714.9	5718.48	35312.0
2016-09-19 16:00:00	NQ	Futures	5718.19	5724.15	5716.99	5723.56	4744.0
2016-09-19 18:00:00	NQ	Futures	5724.15	5726.54	5719.68	5720.57	740.0
2016-09-19 19:00:00	NQ	Futures	5720.87	5725.35	5716.1	5718.48	711.0
2016-09-19 20:00:00	NQ	Futures	5718.78	5730.12	5717.89	5724.45	968.0
2016-09-19 21:00:00	NQ	Futures	5724.75	5734.59	5724.15	5729.22	1472.0
2016-09-19 22:00:00	NQ	Futures	5728.93	5732.51	5727.14	5728.63	482.0
2016-09-19 23:00:00	NQ	Futures	5728.93	5732.21	5728.93	5730.42	377.0
2016-09-19 00:00:00	YM	Futures	19576.9	19576.9	19571.5	19572.6	197.0
2016-09-19 01:00:00	YM	Futures	19573.7	19582.3	19573.7	19579.1	600.0
2016-09-19 02:00:00	YM	Futures	19578.0	19599.6	19576.9	19589.9	1333.0
2016-09-19 03:00:00	YM	Futures	19588.8	19614.8	19578.0	19597.5	4234.0

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

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