PREVIEW / futures_1hour / 2019-09-17

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-17.parquet
  size:    58 KB
  rows:    1,839

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-09-17 00:00:00	ES	Futures	3259.3	3259.57	3258.49	3258.49	2667.0
2019-09-17 01:00:00	ES	Futures	3258.76	3258.76	3254.68	3255.5	8615.0
2019-09-17 02:00:00	ES	Futures	3255.77	3257.13	3254.95	3256.58	13114.0
2019-09-17 03:00:00	ES	Futures	3256.58	3261.47	3254.68	3259.3	15961.0
2019-09-17 04:00:00	ES	Futures	3259.03	3263.65	3257.4	3258.76	22201.0
2019-09-17 05:00:00	ES	Futures	3258.76	3261.74	3256.86	3256.86	15649.0
2019-09-17 06:00:00	ES	Futures	3257.13	3258.49	3254.95	3255.77	9972.0
2019-09-17 07:00:00	ES	Futures	3255.77	3262.29	3254.95	3260.39	12691.0
2019-09-17 08:00:00	ES	Futures	3260.39	3260.66	3252.78	3256.58	26362.0
2019-09-17 09:00:00	ES	Futures	3256.58	3262.83	3253.05	3259.84	165585.0
2019-09-17 10:00:00	ES	Futures	3260.11	3262.29	3256.58	3258.49	98673.0
2019-09-17 11:00:00	ES	Futures	3258.21	3264.46	3258.21	3261.47	98362.0
2019-09-17 12:00:00	ES	Futures	3261.74	3263.37	3257.67	3258.21	66675.0
2019-09-17 13:00:00	ES	Futures	3258.49	3265.28	3257.67	3261.74	54721.0
2019-09-17 14:00:00	ES	Futures	3261.74	3264.73	3259.57	3261.47	58601.0
2019-09-17 15:00:00	ES	Futures	3261.74	3269.35	3260.11	3268.26	102825.0
2019-09-17 16:00:00	ES	Futures	3268.54	3269.08	3266.91	3268.54	41702.0
2019-09-17 18:00:00	ES	Futures	3269.08	3269.08	3265.82	3267.99	5260.0
2019-09-17 19:00:00	ES	Futures	3267.99	3268.26	3266.09	3266.91	3546.0
2019-09-17 20:00:00	ES	Futures	3267.18	3267.45	3264.73	3265.55	7969.0
2019-09-17 21:00:00	ES	Futures	3265.82	3266.36	3264.19	3265.0	4967.0
2019-09-17 22:00:00	ES	Futures	3265.28	3266.09	3263.92	3265.28	2904.0
2019-09-17 23:00:00	ES	Futures	3265.28	3266.09	3262.83	3264.19	4098.0
2019-09-17 00:00:00	NQ	Futures	9144.41	9145.28	9138.89	9140.05	756.0
2019-09-17 01:00:00	NQ	Futures	9140.05	9140.34	9123.2	9125.82	3282.0
2019-09-17 02:00:00	NQ	Futures	9126.11	9134.82	9122.33	9131.63	5386.0
2019-09-17 03:00:00	NQ	Futures	9131.34	9151.09	9122.91	9143.25	6858.0
2019-09-17 04:00:00	NQ	Futures	9143.25	9158.93	9137.44	9142.37	6606.0
2019-09-17 05:00:00	NQ	Futures	9142.66	9152.25	9136.85	9138.31	5604.0
2019-09-17 06:00:00	NQ	Futures	9138.6	9142.95	9129.59	9132.21	3949.0
2019-09-17 07:00:00	NQ	Futures	9132.79	9163.0	9130.75	9156.61	6160.0
2019-09-17 08:00:00	NQ	Futures	9156.32	9157.19	9133.08	9147.89	11357.0
2019-09-17 09:00:00	NQ	Futures	9147.6	9171.42	9135.98	9154.87	51226.0
2019-09-17 10:00:00	NQ	Futures	9155.45	9160.97	9141.79	9146.73	32686.0
2019-09-17 11:00:00	NQ	Futures	9146.73	9170.26	9146.44	9161.55	27790.0
2019-09-17 12:00:00	NQ	Futures	9161.84	9168.52	9149.06	9154.87	18271.0
2019-09-17 13:00:00	NQ	Futures	9155.16	9175.78	9153.12	9164.45	17155.0
2019-09-17 14:00:00	NQ	Futures	9164.74	9172.88	9156.61	9167.65	17175.0
2019-09-17 15:00:00	NQ	Futures	9167.65	9200.18	9164.74	9196.7	27147.0
2019-09-17 16:00:00	NQ	Futures	9196.41	9204.54	9191.18	9198.73	8949.0
2019-09-17 18:00:00	NQ	Futures	9198.44	9199.6	9188.56	9197.86	2222.0
2019-09-17 19:00:00	NQ	Futures	9197.86	9199.02	9190.89	9194.08	1893.0
2019-09-17 20:00:00	NQ	Futures	9194.08	9196.11	9185.37	9187.4	4752.0
2019-09-17 21:00:00	NQ	Futures	9187.69	9191.47	9181.88	9186.24	3716.0
2019-09-17 22:00:00	NQ	Futures	9186.53	9190.01	9182.46	9186.53	1548.0
2019-09-17 23:00:00	NQ	Futures	9186.82	9189.72	9177.52	9180.72	2096.0
2019-09-17 00:00:00	YM	Futures	29460.6	29465.0	29453.0	29453.0	576.0
2019-09-17 01:00:00	YM	Futures	29453.0	29455.2	29418.2	29428.0	1232.0
2019-09-17 02:00:00	YM	Futures	29429.0	29438.8	29419.3	29434.5	1690.0
2019-09-17 03:00:00	YM	Futures	29434.5	29468.2	29412.7	29449.7	3378.0

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

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