PREVIEW / futures_1hour / 2019-07-17

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-07-17.parquet
  size:    59 KB
  rows:    1,809

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-17 00:00:00	ES	Futures	3257.39	3258.75	3257.12	3258.48	2098.0
2019-07-17 01:00:00	ES	Futures	3258.48	3259.29	3257.66	3258.48	2608.0
2019-07-17 02:00:00	ES	Futures	3258.48	3259.02	3257.12	3258.48	6982.0
2019-07-17 03:00:00	ES	Futures	3258.75	3260.37	3257.94	3259.83	17858.0
2019-07-17 04:00:00	ES	Futures	3259.83	3262.54	3259.56	3260.1	16547.0
2019-07-17 05:00:00	ES	Futures	3260.1	3262.27	3259.83	3262.27	11420.0
2019-07-17 06:00:00	ES	Futures	3262.0	3262.27	3257.39	3258.75	11997.0
2019-07-17 07:00:00	ES	Futures	3258.48	3258.75	3255.23	3258.75	12315.0
2019-07-17 08:00:00	ES	Futures	3258.48	3258.75	3254.42	3255.23	19355.0
2019-07-17 09:00:00	ES	Futures	3255.5	3258.48	3252.52	3254.42	125368.0
2019-07-17 10:00:00	ES	Futures	3254.15	3255.5	3240.88	3244.67	187044.0
2019-07-17 11:00:00	ES	Futures	3244.67	3251.17	3244.4	3249.0	113527.0
2019-07-17 12:00:00	ES	Futures	3249.0	3249.54	3245.48	3247.38	59817.0
2019-07-17 13:00:00	ES	Futures	3247.38	3249.81	3245.48	3247.92	45822.0
2019-07-17 14:00:00	ES	Futures	3247.92	3248.19	3242.23	3243.86	71809.0
2019-07-17 15:00:00	ES	Futures	3243.59	3244.67	3234.38	3234.65	182483.0
2019-07-17 16:00:00	ES	Futures	3234.65	3238.17	3227.35	3228.16	87398.0
2019-07-17 18:00:00	ES	Futures	3227.62	3231.14	3227.35	3229.78	5798.0
2019-07-17 19:00:00	ES	Futures	3230.05	3231.14	3227.62	3228.97	5081.0
2019-07-17 20:00:00	ES	Futures	3229.24	3229.78	3220.85	3223.01	17682.0
2019-07-17 21:00:00	ES	Futures	3223.01	3225.99	3220.85	3224.1	16969.0
2019-07-17 22:00:00	ES	Futures	3223.83	3226.53	3222.2	3225.72	10935.0
2019-07-17 23:00:00	ES	Futures	3225.99	3227.35	3224.64	3225.18	5684.0
2019-07-17 00:00:00	NQ	Futures	9220.44	9224.21	9219.57	9222.76	674.0
2019-07-17 01:00:00	NQ	Futures	9222.76	9225.95	9218.99	9223.63	1192.0
2019-07-17 02:00:00	NQ	Futures	9223.34	9229.43	9219.86	9227.4	2497.0
2019-07-17 03:00:00	NQ	Futures	9227.11	9236.97	9225.08	9233.2	4542.0
2019-07-17 04:00:00	NQ	Futures	9233.2	9245.39	9231.75	9236.97	4955.0
2019-07-17 05:00:00	NQ	Futures	9237.26	9244.23	9236.97	9242.49	3014.0
2019-07-17 06:00:00	NQ	Futures	9242.49	9243.94	9228.56	9233.2	3445.0
2019-07-17 07:00:00	NQ	Futures	9232.91	9233.49	9220.73	9230.88	4121.0
2019-07-17 08:00:00	NQ	Futures	9230.59	9233.49	9216.95	9221.02	6805.0
2019-07-17 09:00:00	NQ	Futures	9221.31	9241.04	9216.95	9234.94	47292.0
2019-07-17 10:00:00	NQ	Futures	9235.23	9239.01	9193.16	9205.93	54337.0
2019-07-17 11:00:00	NQ	Futures	9205.93	9223.63	9202.74	9217.83	32187.0
2019-07-17 12:00:00	NQ	Futures	9218.12	9222.47	9209.12	9218.99	19133.0
2019-07-17 13:00:00	NQ	Futures	9219.28	9222.76	9209.7	9220.73	14177.0
2019-07-17 14:00:00	NQ	Futures	9220.73	9221.6	9203.32	9213.18	21935.0
2019-07-17 15:00:00	NQ	Futures	9212.89	9214.63	9178.08	9179.24	44029.0
2019-07-17 16:00:00	NQ	Futures	9179.24	9190.26	9131.36	9133.97	25454.0
2019-07-17 18:00:00	NQ	Futures	9131.36	9146.45	9131.36	9141.81	3219.0
2019-07-17 19:00:00	NQ	Futures	9142.1	9142.1	9133.1	9137.17	2148.0
2019-07-17 20:00:00	NQ	Futures	9137.46	9139.2	9102.64	9109.31	7182.0
2019-07-17 21:00:00	NQ	Futures	9109.89	9121.79	9104.09	9114.82	6357.0
2019-07-17 22:00:00	NQ	Futures	9114.53	9119.18	9104.67	9116.57	3763.0
2019-07-17 23:00:00	NQ	Futures	9116.57	9121.5	9111.63	9113.66	2233.0
2019-07-17 00:00:00	YM	Futures	29726.8	29737.7	29725.7	29736.6	430.0
2019-07-17 01:00:00	YM	Futures	29736.6	29744.2	29731.2	29737.7	664.0
2019-07-17 02:00:00	YM	Futures	29737.7	29738.8	29726.8	29734.4	1369.0
2019-07-17 03:00:00	YM	Futures	29734.4	29754.0	29727.9	29747.5	2896.0

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

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