PREVIEW / futures_1hour / 2016-10-20

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-10-20.parquet
  size:    52 KB
  rows:    1,625

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-10-20 00:00:00	ES	Futures	2331.99	2331.99	2330.08	2330.08	2782.0
2016-10-20 01:00:00	ES	Futures	2330.36	2331.44	2329.54	2330.63	3412.0
2016-10-20 02:00:00	ES	Futures	2330.9	2331.72	2328.45	2329.0	6737.0
2016-10-20 03:00:00	ES	Futures	2329.0	2329.81	2326.82	2328.45	15714.0
2016-10-20 04:00:00	ES	Futures	2328.45	2329.54	2327.36	2328.18	9332.0
2016-10-20 05:00:00	ES	Futures	2328.18	2329.54	2327.64	2329.27	7239.0
2016-10-20 06:00:00	ES	Futures	2329.54	2330.36	2328.72	2330.36	5454.0
2016-10-20 07:00:00	ES	Futures	2330.36	2330.36	2327.64	2328.72	9918.0
2016-10-20 08:00:00	ES	Futures	2328.72	2329.54	2320.56	2324.1	66874.0
2016-10-20 09:00:00	ES	Futures	2324.37	2326.55	2319.2	2326.0	245450.0
2016-10-20 10:00:00	ES	Futures	2326.0	2330.36	2314.58	2317.3	352022.0
2016-10-20 11:00:00	ES	Futures	2317.02	2323.83	2315.66	2323.55	180757.0
2016-10-20 12:00:00	ES	Futures	2323.55	2329.27	2323.01	2326.28	199410.0
2016-10-20 13:00:00	ES	Futures	2326.28	2327.91	2320.56	2322.19	116316.0
2016-10-20 14:00:00	ES	Futures	2322.19	2327.09	2321.92	2325.46	93356.0
2016-10-20 15:00:00	ES	Futures	2325.73	2327.36	2322.19	2323.55	185814.0
2016-10-20 16:00:00	ES	Futures	2323.28	2326.28	2323.28	2325.46	67015.0
2016-10-20 18:00:00	ES	Futures	2324.64	2326.0	2323.28	2326.0	3960.0
2016-10-20 19:00:00	ES	Futures	2325.73	2327.36	2325.73	2326.0	2897.0
2016-10-20 20:00:00	ES	Futures	2326.0	2326.55	2322.19	2323.83	7285.0
2016-10-20 21:00:00	ES	Futures	2323.55	2324.64	2323.01	2324.1	3321.0
2016-10-20 22:00:00	ES	Futures	2324.1	2324.92	2322.47	2323.01	3799.0
2016-10-20 23:00:00	ES	Futures	2323.01	2323.28	2320.56	2320.83	6359.0
2016-10-20 00:00:00	NQ	Futures	5775.47	5776.36	5772.78	5773.08	575.0
2016-10-20 01:00:00	NQ	Futures	5773.38	5776.66	5771.29	5775.76	830.0
2016-10-20 02:00:00	NQ	Futures	5775.76	5777.55	5770.99	5772.18	1229.0
2016-10-20 03:00:00	NQ	Futures	5772.18	5773.68	5765.62	5769.5	2877.0
2016-10-20 04:00:00	NQ	Futures	5769.2	5770.99	5765.92	5767.41	1259.0
2016-10-20 05:00:00	NQ	Futures	5767.41	5771.29	5766.52	5771.29	884.0
2016-10-20 06:00:00	NQ	Futures	5771.29	5773.68	5769.8	5773.38	872.0
2016-10-20 07:00:00	NQ	Futures	5773.38	5773.68	5768.9	5770.99	1627.0
2016-10-20 08:00:00	NQ	Futures	5770.69	5771.89	5753.39	5760.85	8013.0
2016-10-20 09:00:00	NQ	Futures	5760.55	5762.34	5736.68	5757.57	40505.0
2016-10-20 10:00:00	NQ	Futures	5757.57	5773.08	5726.54	5736.38	54823.0
2016-10-20 11:00:00	NQ	Futures	5736.38	5752.2	5730.72	5752.2	27390.0
2016-10-20 12:00:00	NQ	Futures	5752.2	5771.89	5749.81	5764.43	30427.0
2016-10-20 13:00:00	NQ	Futures	5764.73	5766.52	5743.54	5747.42	18246.0
2016-10-20 14:00:00	NQ	Futures	5747.72	5770.39	5746.53	5765.62	18442.0
2016-10-20 15:00:00	NQ	Futures	5765.62	5770.1	5757.57	5760.85	20725.0
2016-10-20 16:00:00	NQ	Futures	5760.85	5784.42	5760.55	5782.03	13286.0
2016-10-20 18:00:00	NQ	Futures	5780.84	5783.82	5778.15	5782.92	1192.0
2016-10-20 19:00:00	NQ	Futures	5782.63	5786.5	5782.63	5784.12	875.0
2016-10-20 20:00:00	NQ	Futures	5784.12	5784.71	5774.57	5778.75	1629.0
2016-10-20 21:00:00	NQ	Futures	5779.05	5781.13	5777.26	5779.64	512.0
2016-10-20 22:00:00	NQ	Futures	5779.34	5780.84	5775.17	5778.15	718.0
2016-10-20 23:00:00	NQ	Futures	5778.15	5778.45	5772.48	5773.38	811.0
2016-10-20 00:00:00	YM	Futures	19633.1	19635.3	19621.2	19621.2	653.0
2016-10-20 01:00:00	YM	Futures	19622.3	19628.8	19616.9	19624.5	719.0
2016-10-20 02:00:00	YM	Futures	19625.6	19633.1	19608.3	19616.9	1120.0
2016-10-20 03:00:00	YM	Futures	19616.9	19621.2	19599.6	19612.6	2542.0

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

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