PREVIEW / futures_1hour / 2019-11-22

all futures 1-hour files

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

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-22 00:00:00	ES	Futures	3376.92	3378.55	3375.56	3375.56	4764.0
2019-11-22 01:00:00	ES	Futures	3375.83	3376.92	3375.01	3375.29	4790.0
2019-11-22 02:00:00	ES	Futures	3375.56	3376.92	3374.74	3375.83	7684.0
2019-11-22 03:00:00	ES	Futures	3375.56	3383.98	3375.01	3382.89	34803.0
2019-11-22 04:00:00	ES	Futures	3382.62	3383.44	3376.64	3379.09	25577.0
2019-11-22 05:00:00	ES	Futures	3379.09	3380.45	3377.46	3378.27	11611.0
2019-11-22 06:00:00	ES	Futures	3378.27	3378.55	3373.93	3377.19	14234.0
2019-11-22 07:00:00	ES	Futures	3377.19	3379.63	3377.19	3378.55	13250.0
2019-11-22 08:00:00	ES	Futures	3378.55	3380.99	3374.2	3379.36	42953.0
2019-11-22 09:00:00	ES	Futures	3379.36	3380.99	3375.56	3379.63	126427.0
2019-11-22 10:00:00	ES	Futures	3379.63	3380.99	3369.58	3372.03	153260.0
2019-11-22 11:00:00	ES	Futures	3372.03	3375.01	3365.78	3373.39	124632.0
2019-11-22 12:00:00	ES	Futures	3373.66	3377.73	3373.11	3376.92	57791.0
2019-11-22 13:00:00	ES	Futures	3377.19	3378.27	3375.29	3377.46	44661.0
2019-11-22 14:00:00	ES	Futures	3377.46	3378.55	3375.56	3377.46	43437.0
2019-11-22 15:00:00	ES	Futures	3377.73	3379.09	3373.93	3378.82	124053.0
2019-11-22 16:00:00	ES	Futures	3378.55	3381.26	3378.27	3381.26	55854.0
2019-11-22 00:00:00	NQ	Futures	9636.21	9644.34	9634.47	9634.47	2338.0
2019-11-22 01:00:00	NQ	Futures	9634.76	9637.37	9632.14	9633.02	2476.0
2019-11-22 02:00:00	NQ	Futures	9633.02	9639.41	9628.37	9631.85	4417.0
2019-11-22 03:00:00	NQ	Futures	9631.85	9660.03	9628.95	9654.8	14100.0
2019-11-22 04:00:00	NQ	Futures	9654.8	9655.96	9634.47	9645.22	9917.0
2019-11-22 05:00:00	NQ	Futures	9644.93	9648.99	9638.53	9642.89	4771.0
2019-11-22 06:00:00	NQ	Futures	9642.6	9644.64	9629.82	9640.57	5466.0
2019-11-22 07:00:00	NQ	Futures	9640.57	9647.25	9636.21	9639.7	6670.0
2019-11-22 08:00:00	NQ	Futures	9639.41	9644.05	9621.98	9638.83	16674.0
2019-11-22 09:00:00	NQ	Futures	9639.41	9642.89	9618.2	9627.5	48255.0
2019-11-22 10:00:00	NQ	Futures	9627.79	9635.34	9579.27	9589.15	61085.0
2019-11-22 11:00:00	NQ	Futures	9589.44	9603.97	9566.78	9596.99	45043.0
2019-11-22 12:00:00	NQ	Futures	9596.99	9615.3	9595.83	9612.97	22228.0
2019-11-22 13:00:00	NQ	Futures	9612.97	9616.46	9597.87	9606.87	16879.0
2019-11-22 14:00:00	NQ	Futures	9606.87	9612.97	9597.58	9609.49	18373.0
2019-11-22 15:00:00	NQ	Futures	9609.78	9619.07	9599.9	9618.49	30795.0
2019-11-22 16:00:00	NQ	Futures	9618.2	9624.59	9616.75	9624.59	8371.0
2019-11-22 00:00:00	YM	Futures	30237.7	30251.8	30224.6	30224.6	816.0
2019-11-22 01:00:00	YM	Futures	30225.7	30234.4	30218.1	30222.5	1033.0
2019-11-22 02:00:00	YM	Futures	30221.4	30234.4	30213.7	30226.8	1314.0
2019-11-22 03:00:00	YM	Futures	30225.7	30301.9	30220.3	30291.0	7475.0
2019-11-22 04:00:00	YM	Futures	30291.0	30295.4	30235.5	30255.1	5214.0
2019-11-22 05:00:00	YM	Futures	30254.0	30266.0	30241.0	30249.7	1935.0
2019-11-22 06:00:00	YM	Futures	30249.7	30254.0	30208.3	30239.9	2966.0
2019-11-22 07:00:00	YM	Futures	30239.9	30260.5	30237.7	30249.7	3098.0
2019-11-22 08:00:00	YM	Futures	30250.8	30273.6	30222.5	30257.3	8703.0
2019-11-22 09:00:00	YM	Futures	30258.4	30284.5	30224.6	30272.5	17714.0
2019-11-22 10:00:00	YM	Futures	30272.5	30305.2	30218.1	30238.8	21182.0
2019-11-22 11:00:00	YM	Futures	30237.7	30278.0	30196.3	30259.5	15643.0
2019-11-22 12:00:00	YM	Futures	30259.5	30289.9	30251.8	30283.4	6262.0
2019-11-22 13:00:00	YM	Futures	30283.4	30301.9	30279.1	30296.5	5256.0
2019-11-22 14:00:00	YM	Futures	30296.5	30347.6	30280.1	30309.5	7909.0
2019-11-22 15:00:00	YM	Futures	30310.6	30315.0	30259.5	30307.3	10853.0

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

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