PREVIEW / futures_1hour / 2019-10-22

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-22.parquet
  size:    60 KB
  rows:    1,857

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-10-22 00:00:00	ES	Futures	3272.61	3273.42	3272.07	3273.15	2117.0
2019-10-22 01:00:00	ES	Futures	3273.42	3273.42	3271.8	3272.07	2411.0
2019-10-22 02:00:00	ES	Futures	3271.8	3272.07	3268.54	3269.08	8920.0
2019-10-22 03:00:00	ES	Futures	3269.35	3270.17	3263.65	3264.19	18731.0
2019-10-22 04:00:00	ES	Futures	3264.19	3264.73	3260.39	3263.1	16883.0
2019-10-22 05:00:00	ES	Futures	3263.37	3267.72	3262.83	3267.45	13165.0
2019-10-22 06:00:00	ES	Futures	3267.45	3267.72	3265.28	3267.45	11182.0
2019-10-22 07:00:00	ES	Futures	3267.45	3270.71	3266.63	3270.17	17774.0
2019-10-22 08:00:00	ES	Futures	3270.17	3272.61	3267.99	3270.98	25239.0
2019-10-22 09:00:00	ES	Futures	3270.98	3273.7	3268.54	3272.34	116255.0
2019-10-22 10:00:00	ES	Futures	3272.34	3274.78	3267.72	3272.34	142427.0
2019-10-22 11:00:00	ES	Futures	3272.34	3274.78	3266.91	3268.26	96860.0
2019-10-22 12:00:00	ES	Futures	3268.54	3274.78	3267.45	3273.7	86604.0
2019-10-22 13:00:00	ES	Futures	3273.7	3273.7	3268.81	3270.71	60002.0
2019-10-22 14:00:00	ES	Futures	3270.71	3273.42	3259.3	3261.74	144265.0
2019-10-22 15:00:00	ES	Futures	3261.74	3265.0	3253.32	3254.41	220561.0
2019-10-22 16:00:00	ES	Futures	3254.41	3254.95	3246.81	3248.98	86101.0
2019-10-22 18:00:00	ES	Futures	3250.88	3253.32	3248.71	3251.97	6077.0
2019-10-22 19:00:00	ES	Futures	3251.97	3252.78	3248.71	3249.52	4718.0
2019-10-22 20:00:00	ES	Futures	3249.52	3249.52	3240.01	3247.35	28970.0
2019-10-22 21:00:00	ES	Futures	3247.35	3248.43	3242.73	3243.27	10680.0
2019-10-22 22:00:00	ES	Futures	3243.27	3247.89	3243.0	3244.36	8479.0
2019-10-22 23:00:00	ES	Futures	3244.09	3245.99	3242.73	3245.18	5434.0
2019-10-22 00:00:00	NQ	Futures	9258.28	9259.73	9256.25	9259.44	1332.0
2019-10-22 01:00:00	NQ	Futures	9259.44	9261.77	9253.34	9254.5	2724.0
2019-10-22 02:00:00	NQ	Futures	9254.5	9257.12	9246.37	9249.28	3523.0
2019-10-22 03:00:00	NQ	Futures	9248.98	9253.63	9231.26	9234.75	6578.0
2019-10-22 04:00:00	NQ	Futures	9234.75	9236.2	9220.23	9230.1	6368.0
2019-10-22 05:00:00	NQ	Futures	9229.52	9244.34	9229.23	9243.47	4499.0
2019-10-22 06:00:00	NQ	Futures	9243.47	9252.76	9237.95	9252.18	5808.0
2019-10-22 07:00:00	NQ	Futures	9252.18	9262.93	9244.63	9262.35	8251.0
2019-10-22 08:00:00	NQ	Futures	9262.06	9270.77	9258.86	9263.22	8295.0
2019-10-22 09:00:00	NQ	Futures	9263.22	9282.68	9249.57	9261.19	49599.0
2019-10-22 10:00:00	NQ	Futures	9261.19	9269.61	9245.21	9245.79	50600.0
2019-10-22 11:00:00	NQ	Futures	9246.37	9251.02	9203.67	9208.32	45473.0
2019-10-22 12:00:00	NQ	Futures	9208.32	9229.81	9204.54	9226.62	26125.0
2019-10-22 13:00:00	NQ	Futures	9226.91	9227.2	9198.73	9206.28	20002.0
2019-10-22 14:00:00	NQ	Futures	9205.99	9220.23	9176.07	9183.91	41284.0
2019-10-22 15:00:00	NQ	Futures	9184.2	9192.92	9157.48	9161.84	50830.0
2019-10-22 16:00:00	NQ	Futures	9161.55	9164.74	9106.64	9111.87	22907.0
2019-10-22 18:00:00	NQ	Futures	9117.1	9133.95	9114.2	9124.65	2788.0
2019-10-22 19:00:00	NQ	Futures	9124.65	9128.14	9111.87	9114.49	2238.0
2019-10-22 20:00:00	NQ	Futures	9114.78	9115.07	9075.27	9104.03	11908.0
2019-10-22 21:00:00	NQ	Futures	9104.03	9111.87	9092.41	9094.73	4784.0
2019-10-22 22:00:00	NQ	Futures	9095.02	9110.71	9093.57	9098.8	4395.0
2019-10-22 23:00:00	NQ	Futures	9098.8	9105.19	9094.44	9102.87	2182.0
2019-10-22 00:00:00	YM	Futures	29213.6	29216.8	29204.8	29214.6	457.0
2019-10-22 01:00:00	YM	Futures	29214.6	29216.8	29202.7	29203.8	598.0
2019-10-22 02:00:00	YM	Futures	29203.8	29207.0	29180.9	29185.3	1847.0
2019-10-22 03:00:00	YM	Futures	29185.3	29192.9	29131.9	29138.5	4451.0

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

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