PREVIEW / futures_1hour / 2019-11-15

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-11-15.parquet
  size:    49 KB
  rows:    1,508

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-15 00:00:00	ES	Futures	3376.37	3377.19	3376.1	3376.37	4377.0
2019-11-15 01:00:00	ES	Futures	3376.37	3377.46	3375.56	3376.92	5615.0
2019-11-15 02:00:00	ES	Futures	3376.92	3376.92	3374.74	3375.01	13837.0
2019-11-15 03:00:00	ES	Futures	3375.01	3375.83	3372.03	3373.39	17346.0
2019-11-15 04:00:00	ES	Futures	3373.66	3376.64	3372.84	3375.56	13011.0
2019-11-15 05:00:00	ES	Futures	3375.29	3376.37	3371.21	3372.03	18296.0
2019-11-15 06:00:00	ES	Futures	3372.03	3373.11	3370.94	3372.3	12055.0
2019-11-15 07:00:00	ES	Futures	3372.57	3375.56	3372.03	3373.66	20272.0
2019-11-15 08:00:00	ES	Futures	3373.66	3376.64	3372.3	3376.37	22934.0
2019-11-15 09:00:00	ES	Futures	3376.1	3380.45	3371.76	3372.57	165322.0
2019-11-15 10:00:00	ES	Futures	3372.3	3379.36	3372.03	3378.55	129612.0
2019-11-15 11:00:00	ES	Futures	3378.55	3385.07	3378.55	3382.62	146196.0
2019-11-15 12:00:00	ES	Futures	3382.89	3385.07	3382.08	3382.89	92770.0
2019-11-15 13:00:00	ES	Futures	3382.89	3383.16	3380.72	3381.53	60493.0
2019-11-15 14:00:00	ES	Futures	3381.81	3385.88	3381.26	3385.61	68676.0
2019-11-15 15:00:00	ES	Futures	3385.61	3389.14	3381.26	3389.14	203627.0
2019-11-15 16:00:00	ES	Futures	3388.87	3389.41	3386.97	3388.87	89007.0
2019-11-15 00:00:00	NQ	Futures	9641.44	9644.05	9639.99	9640.28	5684.0
2019-11-15 01:00:00	NQ	Futures	9640.57	9644.64	9637.66	9642.6	1859.0
2019-11-15 02:00:00	NQ	Futures	9642.31	9644.05	9637.37	9638.83	7271.0
2019-11-15 03:00:00	NQ	Futures	9638.83	9642.6	9627.5	9632.72	8158.0
2019-11-15 04:00:00	NQ	Futures	9633.02	9644.93	9631.85	9643.18	5279.0
2019-11-15 05:00:00	NQ	Futures	9643.47	9647.54	9629.53	9632.43	6431.0
2019-11-15 06:00:00	NQ	Futures	9632.14	9638.24	9627.79	9635.63	4011.0
2019-11-15 07:00:00	NQ	Futures	9635.63	9648.12	9634.47	9642.31	5969.0
2019-11-15 08:00:00	NQ	Futures	9642.31	9658.29	9638.24	9656.55	9566.0
2019-11-15 09:00:00	NQ	Futures	9656.55	9668.46	9631.56	9632.72	57917.0
2019-11-15 10:00:00	NQ	Futures	9632.43	9658.87	9631.56	9655.96	45973.0
2019-11-15 11:00:00	NQ	Futures	9655.96	9670.49	9651.03	9655.67	42387.0
2019-11-15 12:00:00	NQ	Futures	9655.67	9662.94	9649.86	9659.74	30550.0
2019-11-15 13:00:00	NQ	Futures	9659.74	9661.77	9653.35	9655.96	17789.0
2019-11-15 14:00:00	NQ	Futures	9655.67	9663.81	9650.74	9655.67	16680.0
2019-11-15 15:00:00	NQ	Futures	9655.96	9666.42	9640.86	9666.13	38781.0
2019-11-15 16:00:00	NQ	Futures	9665.84	9672.23	9661.77	9671.36	12767.0
2019-11-15 00:00:00	YM	Futures	30301.9	30309.5	30298.6	30305.2	1048.0
2019-11-15 01:00:00	YM	Futures	30305.2	30316.1	30298.6	30308.4	984.0
2019-11-15 02:00:00	YM	Futures	30308.4	30309.5	30286.7	30286.7	2141.0
2019-11-15 03:00:00	YM	Futures	30288.8	30299.7	30266.0	30276.9	3409.0
2019-11-15 04:00:00	YM	Futures	30276.9	30304.1	30274.7	30293.2	2225.0
2019-11-15 05:00:00	YM	Futures	30294.3	30301.9	30257.3	30262.7	2858.0
2019-11-15 06:00:00	YM	Futures	30262.7	30276.9	30255.1	30270.3	1952.0
2019-11-15 07:00:00	YM	Futures	30270.3	30301.9	30267.1	30286.7	4067.0
2019-11-15 08:00:00	YM	Futures	30285.6	30315.0	30270.3	30308.4	4599.0
2019-11-15 09:00:00	YM	Futures	30306.3	30330.2	30280.1	30289.9	20785.0
2019-11-15 10:00:00	YM	Futures	30289.9	30341.1	30281.2	30332.4	16648.0
2019-11-15 11:00:00	YM	Futures	30333.5	30390.1	30332.4	30362.9	13367.0
2019-11-15 12:00:00	YM	Futures	30361.8	30381.4	30356.3	30359.6	7836.0
2019-11-15 13:00:00	YM	Futures	30358.5	30360.7	30340.0	30354.1	6538.0
2019-11-15 14:00:00	YM	Futures	30354.1	30415.1	30350.9	30410.7	9342.0
2019-11-15 15:00:00	YM	Futures	30410.7	30442.3	30383.5	30441.2	18486.0

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

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