PREVIEW / futures_1hour / 2019-04-15

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-04-15.parquet
  size:    52 KB
  rows:    1,718

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-04-15 00:00:00	ES	Futures	3156.71	3157.53	3156.71	3157.53	1498.0
2019-04-15 01:00:00	ES	Futures	3157.53	3157.8	3156.44	3156.71	3401.0
2019-04-15 02:00:00	ES	Futures	3156.71	3157.26	3155.9	3156.17	4659.0
2019-04-15 03:00:00	ES	Futures	3155.9	3157.26	3155.09	3155.9	9172.0
2019-04-15 04:00:00	ES	Futures	3156.17	3158.07	3155.36	3157.53	7328.0
2019-04-15 05:00:00	ES	Futures	3157.8	3160.24	3157.26	3159.7	9914.0
2019-04-15 06:00:00	ES	Futures	3159.43	3159.97	3158.07	3158.88	7098.0
2019-04-15 07:00:00	ES	Futures	3158.88	3160.51	3157.8	3158.61	11446.0
2019-04-15 08:00:00	ES	Futures	3158.88	3159.15	3156.44	3157.53	15832.0
2019-04-15 09:00:00	ES	Futures	3157.53	3159.43	3151.56	3153.46	126187.0
2019-04-15 10:00:00	ES	Futures	3153.19	3155.09	3145.33	3149.12	153498.0
2019-04-15 11:00:00	ES	Futures	3149.12	3152.38	3147.77	3148.85	97639.0
2019-04-15 12:00:00	ES	Futures	3149.12	3150.21	3146.14	3149.12	73543.0
2019-04-15 13:00:00	ES	Futures	3149.4	3154.27	3148.85	3153.73	84419.0
2019-04-15 14:00:00	ES	Futures	3153.73	3154.82	3151.84	3154.27	90073.0
2019-04-15 15:00:00	ES	Futures	3154.0	3156.44	3152.65	3155.63	133966.0
2019-04-15 16:00:00	ES	Futures	3155.36	3156.71	3154.27	3156.17	49444.0
2019-04-15 18:00:00	ES	Futures	3155.9	3157.26	3155.63	3156.17	3345.0
2019-04-15 19:00:00	ES	Futures	3155.9	3156.44	3155.63	3155.63	2446.0
2019-04-15 20:00:00	ES	Futures	3155.63	3160.24	3155.63	3158.07	9634.0
2019-04-15 21:00:00	ES	Futures	3158.07	3158.88	3156.44	3156.71	9734.0
2019-04-15 22:00:00	ES	Futures	3156.99	3158.61	3155.63	3158.07	6890.0
2019-04-15 23:00:00	ES	Futures	3157.8	3159.43	3157.53	3158.61	8218.0
2019-04-15 00:00:00	NQ	Futures	8903.55	8905.88	8902.39	8903.84	1257.0
2019-04-15 01:00:00	NQ	Futures	8904.13	8908.21	8901.81	8902.97	1741.0
2019-04-15 02:00:00	NQ	Futures	8902.97	8905.88	8900.93	8901.22	2173.0
2019-04-15 03:00:00	NQ	Futures	8900.93	8903.84	8895.69	8900.06	3317.0
2019-04-15 04:00:00	NQ	Futures	8900.35	8906.46	8898.6	8905.3	2886.0
2019-04-15 05:00:00	NQ	Futures	8905.3	8913.16	8904.13	8911.7	3254.0
2019-04-15 06:00:00	NQ	Futures	8911.41	8912.58	8906.75	8907.92	2430.0
2019-04-15 07:00:00	NQ	Futures	8907.92	8911.7	8904.13	8909.38	4010.0
2019-04-15 08:00:00	NQ	Futures	8909.08	8909.96	8904.72	8906.46	4694.0
2019-04-15 09:00:00	NQ	Futures	8906.46	8919.86	8897.15	8902.39	43563.0
2019-04-15 10:00:00	NQ	Futures	8902.1	8902.97	8849.69	8867.74	62757.0
2019-04-15 11:00:00	NQ	Futures	8867.74	8884.63	8865.12	8878.51	41621.0
2019-04-15 12:00:00	NQ	Futures	8878.8	8882.01	8865.7	8878.22	23475.0
2019-04-15 13:00:00	NQ	Futures	8878.51	8895.98	8877.93	8893.07	22895.0
2019-04-15 14:00:00	NQ	Futures	8893.07	8910.25	8891.32	8909.67	32336.0
2019-04-15 15:00:00	NQ	Futures	8909.38	8919.27	8903.26	8910.83	37730.0
2019-04-15 16:00:00	NQ	Futures	8910.54	8912.58	8904.13	8910.83	7073.0
2019-04-15 18:00:00	NQ	Futures	8910.25	8915.78	8908.5	8910.25	1547.0
2019-04-15 19:00:00	NQ	Futures	8910.25	8911.41	8907.92	8909.67	879.0
2019-04-15 20:00:00	NQ	Futures	8909.38	8925.1	8909.08	8918.69	5143.0
2019-04-15 21:00:00	NQ	Futures	8918.98	8921.6	8912.87	8916.36	4678.0
2019-04-15 22:00:00	NQ	Futures	8916.65	8921.6	8910.83	8917.53	3376.0
2019-04-15 23:00:00	NQ	Futures	8917.53	8924.52	8916.36	8922.77	3503.0
2019-04-15 00:00:00	YM	Futures	28735.1	28748.1	28734.0	28743.8	517.0
2019-04-15 01:00:00	YM	Futures	28743.8	28749.2	28727.5	28731.8	987.0
2019-04-15 02:00:00	YM	Futures	28730.7	28737.3	28719.9	28722.0	1264.0
2019-04-15 03:00:00	YM	Futures	28720.9	28734.0	28711.2	28716.6	1923.0

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

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