PREVIEW / futures_1hour / 2019-10-14

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-14.parquet
  size:    58 KB
  rows:    1,814

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-14 00:00:00	ES	Futures	3236.21	3238.38	3234.04	3234.04	4558.0
2019-10-14 01:00:00	ES	Futures	3234.04	3234.85	3230.51	3231.87	4950.0
2019-10-14 02:00:00	ES	Futures	3232.14	3234.58	3229.42	3231.87	12072.0
2019-10-14 03:00:00	ES	Futures	3231.87	3232.41	3222.9	3223.72	24228.0
2019-10-14 04:00:00	ES	Futures	3223.44	3228.33	3220.73	3226.7	15467.0
2019-10-14 05:00:00	ES	Futures	3226.43	3226.98	3209.32	3210.68	53413.0
2019-10-14 06:00:00	ES	Futures	3210.95	3218.83	3210.68	3217.74	18611.0
2019-10-14 07:00:00	ES	Futures	3217.74	3222.36	3215.84	3221.82	16532.0
2019-10-14 08:00:00	ES	Futures	3221.82	3225.62	3217.74	3219.37	24236.0
2019-10-14 09:00:00	ES	Futures	3219.37	3225.89	3217.2	3223.99	124687.0
2019-10-14 10:00:00	ES	Futures	3224.26	3229.15	3220.73	3228.61	103590.0
2019-10-14 11:00:00	ES	Futures	3228.61	3229.69	3223.44	3226.16	69175.0
2019-10-14 12:00:00	ES	Futures	3225.89	3226.98	3222.36	3223.99	44561.0
2019-10-14 13:00:00	ES	Futures	3223.72	3226.43	3221.27	3226.43	40498.0
2019-10-14 14:00:00	ES	Futures	3226.43	3228.33	3223.72	3224.8	40628.0
2019-10-14 15:00:00	ES	Futures	3224.8	3226.7	3221.27	3222.36	93796.0
2019-10-14 16:00:00	ES	Futures	3222.9	3224.53	3219.91	3222.9	49817.0
2019-10-14 18:00:00	ES	Futures	3223.44	3226.43	3223.17	3226.43	4547.0
2019-10-14 19:00:00	ES	Futures	3226.43	3231.32	3225.89	3229.96	6012.0
2019-10-14 20:00:00	ES	Futures	3229.96	3229.96	3224.26	3226.98	10546.0
2019-10-14 21:00:00	ES	Futures	3227.25	3231.05	3226.16	3228.61	11311.0
2019-10-14 22:00:00	ES	Futures	3228.88	3229.96	3228.06	3229.15	4691.0
2019-10-14 23:00:00	ES	Futures	3229.15	3229.96	3226.43	3229.15	3252.0
2019-10-14 00:00:00	NQ	Futures	9155.16	9163.29	9146.44	9147.31	2261.0
2019-10-14 01:00:00	NQ	Futures	9147.31	9149.06	9135.69	9140.34	3432.0
2019-10-14 02:00:00	NQ	Futures	9140.34	9148.76	9132.79	9142.37	5059.0
2019-10-14 03:00:00	NQ	Futures	9142.08	9143.83	9113.03	9114.78	10291.0
2019-10-14 04:00:00	NQ	Futures	9115.36	9130.75	9109.55	9124.65	7488.0
2019-10-14 05:00:00	NQ	Futures	9124.94	9126.69	9071.49	9074.69	19700.0
2019-10-14 06:00:00	NQ	Futures	9074.98	9098.22	9072.95	9094.73	8909.0
2019-10-14 07:00:00	NQ	Futures	9094.15	9115.36	9090.67	9114.49	8860.0
2019-10-14 08:00:00	NQ	Futures	9114.49	9125.82	9100.25	9105.77	11402.0
2019-10-14 09:00:00	NQ	Futures	9106.06	9139.76	9100.83	9128.72	50951.0
2019-10-14 10:00:00	NQ	Futures	9129.01	9153.41	9120.3	9151.09	42558.0
2019-10-14 11:00:00	NQ	Futures	9151.38	9154.87	9131.63	9136.85	25332.0
2019-10-14 12:00:00	NQ	Futures	9136.56	9140.63	9121.75	9127.27	18411.0
2019-10-14 13:00:00	NQ	Futures	9126.98	9139.47	9122.62	9138.89	15189.0
2019-10-14 14:00:00	NQ	Futures	9138.89	9146.73	9134.53	9138.6	14578.0
2019-10-14 15:00:00	NQ	Futures	9138.31	9146.15	9123.78	9126.11	26773.0
2019-10-14 16:00:00	NQ	Futures	9125.82	9138.6	9118.55	9132.79	8483.0
2019-10-14 18:00:00	NQ	Futures	9135.69	9142.66	9132.79	9141.21	2035.0
2019-10-14 19:00:00	NQ	Futures	9140.92	9156.9	9140.92	9154.28	2836.0
2019-10-14 20:00:00	NQ	Futures	9153.99	9153.99	9134.82	9144.12	4439.0
2019-10-14 21:00:00	NQ	Futures	9144.7	9158.93	9140.92	9150.51	5384.0
2019-10-14 22:00:00	NQ	Futures	9150.51	9154.57	9149.06	9152.25	1911.0
2019-10-14 23:00:00	NQ	Futures	9152.25	9155.16	9143.25	9151.38	1862.0
2019-10-14 00:00:00	YM	Futures	29217.9	29240.8	29200.5	29200.5	1169.0
2019-10-14 01:00:00	YM	Futures	29201.6	29211.4	29172.2	29183.1	1336.0
2019-10-14 02:00:00	YM	Futures	29184.2	29205.9	29165.7	29182.0	2249.0
2019-10-14 03:00:00	YM	Futures	29179.8	29186.3	29102.5	29110.2	4786.0

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

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