PREVIEW / futures_1hour / 2019-11-12

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-11-12.parquet
  size:    59 KB
  rows:    1,865

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-11-12 00:00:00	ES	Futures	3352.2	3358.99	3351.38	3358.17	10348.0
2019-11-12 01:00:00	ES	Futures	3358.17	3361.7	3356.54	3358.99	12093.0
2019-11-12 02:00:00	ES	Futures	3358.99	3360.35	3357.63	3358.17	11243.0
2019-11-12 03:00:00	ES	Futures	3357.9	3358.99	3354.37	3355.73	18179.0
2019-11-12 04:00:00	ES	Futures	3355.73	3356.54	3352.2	3354.37	10766.0
2019-11-12 05:00:00	ES	Futures	3354.37	3358.45	3354.37	3357.36	13780.0
2019-11-12 06:00:00	ES	Futures	3357.36	3359.26	3355.46	3356.27	9279.0
2019-11-12 07:00:00	ES	Futures	3356.27	3357.09	3354.64	3356.27	7266.0
2019-11-12 08:00:00	ES	Futures	3356.27	3356.54	3353.28	3354.91	13280.0
2019-11-12 09:00:00	ES	Futures	3354.91	3364.42	3354.37	3364.42	140643.0
2019-11-12 10:00:00	ES	Futures	3364.15	3370.4	3362.52	3367.68	160414.0
2019-11-12 11:00:00	ES	Futures	3367.95	3369.04	3362.79	3363.88	118422.0
2019-11-12 12:00:00	ES	Futures	3363.88	3365.24	3358.99	3362.79	111533.0
2019-11-12 13:00:00	ES	Futures	3363.06	3365.78	3361.98	3364.69	64275.0
2019-11-12 14:00:00	ES	Futures	3364.69	3364.96	3349.75	3352.74	133488.0
2019-11-12 15:00:00	ES	Futures	3352.74	3359.53	3352.2	3358.72	150231.0
2019-11-12 16:00:00	ES	Futures	3358.45	3359.8	3356.54	3357.9	44417.0
2019-11-12 18:00:00	ES	Futures	3358.72	3359.26	3354.37	3355.73	6838.0
2019-11-12 19:00:00	ES	Futures	3356.0	3356.0	3351.93	3352.47	11486.0
2019-11-12 20:00:00	ES	Futures	3352.74	3354.91	3349.75	3350.3	16177.0
2019-11-12 21:00:00	ES	Futures	3350.3	3350.57	3348.67	3350.57	9938.0
2019-11-12 22:00:00	ES	Futures	3350.3	3352.2	3350.02	3350.3	6931.0
2019-11-12 23:00:00	ES	Futures	3350.3	3350.84	3348.94	3350.02	4212.0
2019-11-12 00:00:00	NQ	Futures	9578.98	9605.42	9577.24	9602.8	5124.0
2019-11-12 01:00:00	NQ	Futures	9602.8	9614.13	9597.87	9603.39	5412.0
2019-11-12 02:00:00	NQ	Futures	9603.39	9608.61	9597.87	9599.32	4447.0
2019-11-12 03:00:00	NQ	Futures	9599.03	9602.22	9589.73	9593.51	6214.0
2019-11-12 04:00:00	NQ	Futures	9593.8	9595.54	9580.73	9588.86	3565.0
2019-11-12 05:00:00	NQ	Futures	9589.15	9604.55	9589.15	9601.64	5361.0
2019-11-12 06:00:00	NQ	Futures	9601.35	9607.45	9593.22	9594.67	3542.0
2019-11-12 07:00:00	NQ	Futures	9594.67	9597.87	9590.31	9596.12	2796.0
2019-11-12 08:00:00	NQ	Futures	9595.83	9599.03	9586.83	9589.73	5212.0
2019-11-12 09:00:00	NQ	Futures	9590.02	9613.84	9588.57	9612.1	43926.0
2019-11-12 10:00:00	NQ	Futures	9612.39	9639.12	9607.16	9632.14	41166.0
2019-11-12 11:00:00	NQ	Futures	9632.43	9644.64	9624.59	9627.79	32300.0
2019-11-12 12:00:00	NQ	Futures	9627.79	9637.95	9616.75	9628.37	33738.0
2019-11-12 13:00:00	NQ	Futures	9628.66	9635.34	9624.88	9630.11	18550.0
2019-11-12 14:00:00	NQ	Futures	9630.11	9630.4	9578.11	9589.15	44576.0
2019-11-12 15:00:00	NQ	Futures	9589.15	9614.42	9587.12	9611.23	37967.0
2019-11-12 16:00:00	NQ	Futures	9611.23	9615.88	9607.16	9610.94	6737.0
2019-11-12 18:00:00	NQ	Futures	9612.97	9613.84	9599.32	9603.09	2436.0
2019-11-12 19:00:00	NQ	Futures	9603.39	9604.55	9587.99	9590.89	3935.0
2019-11-12 20:00:00	NQ	Futures	9590.89	9597.87	9580.73	9582.76	5544.0
2019-11-12 21:00:00	NQ	Futures	9583.05	9586.54	9576.95	9586.25	3562.0
2019-11-12 22:00:00	NQ	Futures	9585.96	9592.06	9583.05	9583.34	2522.0
2019-11-12 23:00:00	NQ	Futures	9583.63	9584.79	9578.11	9583.63	2117.0
2019-11-12 00:00:00	YM	Futures	30077.7	30144.1	30072.3	30137.6	2452.0
2019-11-12 01:00:00	YM	Futures	30137.6	30166.9	30123.4	30148.4	2453.0
2019-11-12 02:00:00	YM	Futures	30147.4	30158.2	30129.9	30138.7	2183.0
2019-11-12 03:00:00	YM	Futures	30137.6	30145.2	30104.9	30114.7	3709.0

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

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