PREVIEW / futures_1hour / 2019-04-09

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-04-09.parquet
  size:    54 KB
  rows:    1,741

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
2019-04-09 00:00:00	ES	Futures	3140.72	3140.72	3139.91	3140.45	1948.0
2019-04-09 01:00:00	ES	Futures	3140.45	3140.72	3139.36	3140.18	2931.0
2019-04-09 02:00:00	ES	Futures	3139.91	3140.18	3137.47	3139.64	7375.0
2019-04-09 03:00:00	ES	Futures	3139.36	3140.18	3138.28	3139.09	10704.0
2019-04-09 04:00:00	ES	Futures	3139.09	3141.8	3138.28	3141.26	10001.0
2019-04-09 05:00:00	ES	Futures	3141.26	3142.35	3138.55	3140.45	13680.0
2019-04-09 06:00:00	ES	Futures	3140.72	3141.26	3139.91	3140.99	6257.0
2019-04-09 07:00:00	ES	Futures	3141.26	3141.26	3139.09	3139.09	10845.0
2019-04-09 08:00:00	ES	Futures	3139.09	3140.18	3134.48	3134.76	23053.0
2019-04-09 09:00:00	ES	Futures	3134.48	3135.57	3123.1	3127.98	223574.0
2019-04-09 10:00:00	ES	Futures	3128.25	3132.32	3124.72	3128.79	194355.0
2019-04-09 11:00:00	ES	Futures	3129.06	3131.77	3127.16	3129.33	124324.0
2019-04-09 12:00:00	ES	Futures	3129.33	3135.03	3128.79	3130.42	78457.0
2019-04-09 13:00:00	ES	Futures	3130.42	3130.69	3125.81	3127.16	63576.0
2019-04-09 14:00:00	ES	Futures	3127.16	3127.71	3122.28	3123.91	111156.0
2019-04-09 15:00:00	ES	Futures	3123.91	3127.44	3120.12	3127.16	188799.0
2019-04-09 16:00:00	ES	Futures	3126.89	3127.44	3123.91	3125.54	59176.0
2019-04-09 18:00:00	ES	Futures	3125.27	3126.35	3124.72	3125.27	2848.0
2019-04-09 19:00:00	ES	Futures	3125.27	3126.08	3123.37	3125.0	3335.0
2019-04-09 20:00:00	ES	Futures	3125.0	3127.44	3124.45	3126.35	6838.0
2019-04-09 21:00:00	ES	Futures	3126.35	3127.16	3120.93	3123.91	9723.0
2019-04-09 22:00:00	ES	Futures	3123.91	3126.35	3123.1	3126.35	5806.0
2019-04-09 23:00:00	ES	Futures	3126.35	3127.98	3125.54	3126.89	4218.0
2019-04-09 00:00:00	NQ	Futures	8876.18	8876.18	8873.56	8875.6	796.0
2019-04-09 01:00:00	NQ	Futures	8875.6	8875.89	8870.36	8872.69	1516.0
2019-04-09 02:00:00	NQ	Futures	8872.69	8873.27	8864.25	8869.2	3763.0
2019-04-09 03:00:00	NQ	Futures	8869.49	8870.65	8864.25	8865.41	5941.0
2019-04-09 04:00:00	NQ	Futures	8865.41	8873.27	8864.25	8868.9	4742.0
2019-04-09 05:00:00	NQ	Futures	8868.61	8870.65	8859.88	8868.9	5005.0
2019-04-09 06:00:00	NQ	Futures	8868.61	8869.78	8863.66	8867.45	2219.0
2019-04-09 07:00:00	NQ	Futures	8867.74	8871.23	8862.5	8866.58	3702.0
2019-04-09 08:00:00	NQ	Futures	8866.28	8870.07	8850.27	8855.51	9480.0
2019-04-09 09:00:00	NQ	Futures	8855.51	8862.5	8833.09	8858.42	71608.0
2019-04-09 10:00:00	NQ	Futures	8858.13	8875.02	8845.61	8859.88	74566.0
2019-04-09 11:00:00	NQ	Futures	8860.46	8871.82	8854.06	8861.33	41229.0
2019-04-09 12:00:00	NQ	Futures	8861.33	8875.31	8858.71	8862.79	28883.0
2019-04-09 13:00:00	NQ	Futures	8862.79	8863.37	8839.21	8844.45	28245.0
2019-04-09 14:00:00	NQ	Futures	8844.45	8848.81	8835.13	8842.41	32659.0
2019-04-09 15:00:00	NQ	Futures	8842.41	8851.73	8826.4	8845.61	47916.0
2019-04-09 16:00:00	NQ	Futures	8845.61	8848.23	8835.13	8838.04	8620.0
2019-04-09 18:00:00	NQ	Futures	8840.08	8842.41	8836.59	8838.62	1117.0
2019-04-09 19:00:00	NQ	Futures	8838.62	8839.5	8832.22	8836.29	1452.0
2019-04-09 20:00:00	NQ	Futures	8836.59	8845.61	8834.26	8841.24	3309.0
2019-04-09 21:00:00	NQ	Futures	8841.54	8843.57	8822.9	8834.26	5489.0
2019-04-09 22:00:00	NQ	Futures	8833.97	8842.99	8831.64	8841.24	3286.0
2019-04-09 23:00:00	NQ	Futures	8841.24	8847.07	8838.33	8845.03	2420.0
2019-04-09 00:00:00	YM	Futures	28615.4	28617.6	28608.9	28610.0	499.0
2019-04-09 01:00:00	YM	Futures	28611.1	28612.2	28600.2	28607.8	662.0
2019-04-09 02:00:00	YM	Futures	28607.8	28608.9	28578.5	28594.8	2117.0
2019-04-09 03:00:00	YM	Futures	28596.9	28607.8	28587.2	28595.9	1476.0

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

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