PREVIEW / futures_1hour / 2019-10-23

all futures 1-hour files

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

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-23 00:00:00	ES	Futures	3245.45	3248.43	3245.45	3247.35	4786.0
2019-10-23 01:00:00	ES	Futures	3247.62	3250.61	3246.26	3249.25	8230.0
2019-10-23 02:00:00	ES	Futures	3249.52	3250.61	3247.89	3247.89	9240.0
2019-10-23 03:00:00	ES	Futures	3248.16	3251.15	3245.99	3248.71	20948.0
2019-10-23 04:00:00	ES	Futures	3248.71	3254.41	3248.71	3251.69	18059.0
2019-10-23 05:00:00	ES	Futures	3251.42	3252.51	3250.06	3251.15	8932.0
2019-10-23 06:00:00	ES	Futures	3250.88	3256.86	3244.9	3246.53	29932.0
2019-10-23 07:00:00	ES	Futures	3246.81	3248.71	3241.92	3247.62	34749.0
2019-10-23 08:00:00	ES	Futures	3247.62	3252.24	3245.99	3250.34	23848.0
2019-10-23 09:00:00	ES	Futures	3250.06	3258.21	3248.43	3257.13	140575.0
2019-10-23 10:00:00	ES	Futures	3257.13	3260.11	3251.42	3258.49	152414.0
2019-10-23 11:00:00	ES	Futures	3258.49	3262.29	3257.94	3259.03	104205.0
2019-10-23 12:00:00	ES	Futures	3258.76	3260.66	3256.31	3257.67	63692.0
2019-10-23 13:00:00	ES	Futures	3257.4	3259.57	3255.5	3256.86	43980.0
2019-10-23 14:00:00	ES	Futures	3257.13	3257.13	3251.42	3254.68	70121.0
2019-10-23 15:00:00	ES	Futures	3254.41	3264.46	3253.32	3263.37	151613.0
2019-10-23 16:00:00	ES	Futures	3263.65	3266.09	3262.83	3266.09	75814.0
2019-10-23 18:00:00	ES	Futures	3266.09	3270.44	3266.09	3267.99	7701.0
2019-10-23 19:00:00	ES	Futures	3267.99	3268.54	3266.36	3266.91	3606.0
2019-10-23 20:00:00	ES	Futures	3266.91	3267.18	3264.73	3265.55	7351.0
2019-10-23 21:00:00	ES	Futures	3265.55	3266.91	3263.92	3266.91	6876.0
2019-10-23 22:00:00	ES	Futures	3266.63	3267.72	3265.0	3265.0	5072.0
2019-10-23 23:00:00	ES	Futures	3265.0	3266.63	3264.73	3265.82	2740.0
2019-10-23 00:00:00	NQ	Futures	9103.16	9115.07	9102.58	9112.16	2347.0
2019-10-23 01:00:00	NQ	Futures	9112.16	9125.53	9109.55	9120.88	4344.0
2019-10-23 02:00:00	NQ	Futures	9121.17	9125.23	9108.1	9108.39	4857.0
2019-10-23 03:00:00	NQ	Futures	9108.39	9122.91	9106.93	9117.68	8335.0
2019-10-23 04:00:00	NQ	Futures	9117.39	9136.56	9117.39	9126.98	7292.0
2019-10-23 05:00:00	NQ	Futures	9126.98	9130.46	9121.75	9128.43	3966.0
2019-10-23 06:00:00	NQ	Futures	9128.14	9147.02	9111.87	9116.52	11425.0
2019-10-23 07:00:00	NQ	Futures	9116.23	9123.49	9103.16	9122.04	11272.0
2019-10-23 08:00:00	NQ	Futures	9122.62	9140.34	9117.1	9133.66	9779.0
2019-10-23 09:00:00	NQ	Futures	9133.66	9165.03	9124.94	9154.87	54347.0
2019-10-23 10:00:00	NQ	Futures	9155.16	9170.84	9125.82	9162.42	53993.0
2019-10-23 11:00:00	NQ	Futures	9162.13	9178.39	9154.87	9157.48	33690.0
2019-10-23 12:00:00	NQ	Futures	9157.19	9169.1	9147.31	9163.58	23022.0
2019-10-23 13:00:00	NQ	Futures	9163.29	9171.13	9156.32	9161.84	13608.0
2019-10-23 14:00:00	NQ	Futures	9161.84	9162.42	9137.15	9149.93	21536.0
2019-10-23 15:00:00	NQ	Futures	9149.64	9176.65	9144.7	9175.2	33619.0
2019-10-23 16:00:00	NQ	Futures	9175.49	9200.76	9156.61	9199.6	21152.0
2019-10-23 18:00:00	NQ	Futures	9205.99	9217.9	9203.96	9211.51	4598.0
2019-10-23 19:00:00	NQ	Futures	9211.8	9214.13	9206.57	9209.19	1759.0
2019-10-23 20:00:00	NQ	Futures	9208.9	9210.06	9201.34	9202.22	3417.0
2019-10-23 21:00:00	NQ	Futures	9201.92	9208.03	9194.95	9207.44	3873.0
2019-10-23 22:00:00	NQ	Futures	9207.73	9210.35	9200.47	9200.47	2620.0
2019-10-23 23:00:00	NQ	Futures	9200.47	9205.12	9199.02	9202.51	1573.0
2019-10-23 00:00:00	YM	Futures	29057.9	29076.4	29055.7	29068.8	837.0
2019-10-23 01:00:00	YM	Futures	29067.7	29093.8	29063.4	29087.3	1594.0
2019-10-23 02:00:00	YM	Futures	29088.4	29098.2	29071.0	29073.2	2348.0
2019-10-23 03:00:00	YM	Futures	29073.2	29097.1	29050.3	29078.6	4002.0

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

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