PREVIEW / futures_1hour / 2019-07-19

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-07-19.parquet
  size:    49 KB
  rows:    1,479

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-07-19 00:00:00	ES	Futures	3255.5	3256.58	3253.87	3256.58	5879.0
2019-07-19 01:00:00	ES	Futures	3256.58	3257.39	3254.96	3255.23	6449.0
2019-07-19 02:00:00	ES	Futures	3255.5	3255.77	3252.52	3252.79	9906.0
2019-07-19 03:00:00	ES	Futures	3252.52	3257.39	3252.25	3256.04	21613.0
2019-07-19 04:00:00	ES	Futures	3256.04	3257.66	3254.15	3254.96	18126.0
2019-07-19 05:00:00	ES	Futures	3254.96	3255.23	3248.73	3249.27	22758.0
2019-07-19 06:00:00	ES	Futures	3249.27	3250.9	3246.3	3247.38	28033.0
2019-07-19 07:00:00	ES	Futures	3247.65	3252.25	3245.75	3250.9	29177.0
2019-07-19 08:00:00	ES	Futures	3250.9	3255.23	3250.63	3254.96	28973.0
2019-07-19 09:00:00	ES	Futures	3254.96	3259.02	3251.17	3253.6	166485.0
2019-07-19 10:00:00	ES	Futures	3253.6	3255.5	3246.02	3248.73	176766.0
2019-07-19 11:00:00	ES	Futures	3248.73	3252.79	3240.88	3244.13	156179.0
2019-07-19 12:00:00	ES	Futures	3244.13	3251.71	3243.86	3250.36	78783.0
2019-07-19 13:00:00	ES	Futures	3250.63	3250.9	3243.86	3247.11	70139.0
2019-07-19 14:00:00	ES	Futures	3247.38	3249.54	3235.47	3238.99	155815.0
2019-07-19 15:00:00	ES	Futures	3239.26	3239.26	3224.37	3226.53	279659.0
2019-07-19 16:00:00	ES	Futures	3226.8	3228.16	3215.43	3217.06	81154.0
2019-07-19 00:00:00	NQ	Futures	9242.2	9247.13	9236.39	9245.68	1658.0
2019-07-19 01:00:00	NQ	Futures	9245.68	9249.45	9239.88	9240.46	2185.0
2019-07-19 02:00:00	NQ	Futures	9240.46	9244.52	9231.75	9232.91	3091.0
2019-07-19 03:00:00	NQ	Futures	9232.91	9250.61	9230.3	9244.81	5217.0
2019-07-19 04:00:00	NQ	Futures	9245.1	9252.64	9242.2	9248.0	5093.0
2019-07-19 05:00:00	NQ	Futures	9248.0	9248.0	9229.43	9232.04	5644.0
2019-07-19 06:00:00	NQ	Futures	9231.75	9236.1	9216.08	9218.99	7880.0
2019-07-19 07:00:00	NQ	Futures	9219.28	9231.46	9212.31	9227.11	8335.0
2019-07-19 08:00:00	NQ	Futures	9226.82	9245.39	9224.79	9244.52	9357.0
2019-07-19 09:00:00	NQ	Futures	9244.52	9262.22	9216.66	9226.24	56512.0
2019-07-19 10:00:00	NQ	Futures	9226.24	9231.75	9188.52	9201.0	64122.0
2019-07-19 11:00:00	NQ	Futures	9201.0	9220.15	9168.79	9183.01	54765.0
2019-07-19 12:00:00	NQ	Futures	9182.72	9211.73	9181.56	9203.61	28922.0
2019-07-19 13:00:00	NQ	Futures	9203.61	9204.19	9176.92	9189.97	25619.0
2019-07-19 14:00:00	NQ	Futures	9189.68	9198.39	9138.62	9151.96	49815.0
2019-07-19 15:00:00	NQ	Futures	9151.96	9152.25	9109.02	9114.24	63073.0
2019-07-19 16:00:00	NQ	Futures	9114.24	9119.18	9070.14	9075.66	14552.0
2019-07-19 00:00:00	YM	Futures	29704.0	29711.6	29690.9	29711.6	1136.0
2019-07-19 01:00:00	YM	Futures	29711.6	29719.2	29698.5	29699.6	1409.0
2019-07-19 02:00:00	YM	Futures	29700.7	29708.3	29679.0	29679.0	2381.0
2019-07-19 03:00:00	YM	Futures	29679.0	29724.6	29676.8	29712.7	3371.0
2019-07-19 04:00:00	YM	Futures	29712.7	29727.9	29688.8	29698.5	3473.0
2019-07-19 05:00:00	YM	Futures	29697.5	29698.5	29645.3	29649.6	5065.0
2019-07-19 06:00:00	YM	Futures	29648.5	29658.3	29617.0	29628.9	4955.0
2019-07-19 07:00:00	YM	Futures	29628.9	29676.8	29615.9	29664.8	5114.0
2019-07-19 08:00:00	YM	Futures	29664.8	29701.8	29657.2	29700.7	5311.0
2019-07-19 09:00:00	YM	Futures	29699.6	29726.8	29647.4	29675.7	21612.0
2019-07-19 10:00:00	YM	Futures	29674.6	29709.4	29625.7	29661.6	24375.0
2019-07-19 11:00:00	YM	Futures	29661.6	29696.4	29614.8	29643.1	21261.0
2019-07-19 12:00:00	YM	Futures	29643.1	29709.4	29642.0	29697.5	13960.0
2019-07-19 13:00:00	YM	Futures	29697.5	29700.7	29655.0	29680.1	9979.0
2019-07-19 14:00:00	YM	Futures	29679.0	29697.5	29592.0	29620.2	20238.0
2019-07-19 15:00:00	YM	Futures	29620.2	29620.2	29514.8	29528.9	29066.0

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

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