PREVIEW / futures_1hour / 2019-04-29

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-04-29.parquet
  size:    54 KB
  rows:    1,752

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-29 00:00:00	ES	Futures	3190.6	3191.14	3190.33	3190.87	1639.0
2019-04-29 01:00:00	ES	Futures	3190.6	3193.31	3190.06	3192.23	5023.0
2019-04-29 02:00:00	ES	Futures	3191.96	3192.5	3190.06	3190.06	5561.0
2019-04-29 03:00:00	ES	Futures	3190.33	3192.23	3189.52	3191.96	9946.0
2019-04-29 04:00:00	ES	Futures	3191.96	3195.48	3191.69	3192.23	14764.0
2019-04-29 05:00:00	ES	Futures	3192.23	3192.77	3188.16	3188.98	12562.0
2019-04-29 06:00:00	ES	Futures	3188.98	3190.06	3186.54	3187.08	9335.0
2019-04-29 07:00:00	ES	Futures	3187.08	3188.43	3185.72	3187.89	11000.0
2019-04-29 08:00:00	ES	Futures	3187.89	3190.33	3187.35	3190.06	16470.0
2019-04-29 09:00:00	ES	Futures	3190.06	3196.57	3188.98	3193.31	166544.0
2019-04-29 10:00:00	ES	Futures	3193.31	3197.11	3189.25	3194.67	166052.0
2019-04-29 11:00:00	ES	Futures	3194.94	3196.3	3192.5	3193.86	80101.0
2019-04-29 12:00:00	ES	Futures	3193.86	3199.01	3192.5	3198.46	69526.0
2019-04-29 13:00:00	ES	Futures	3198.46	3198.74	3196.3	3197.92	46260.0
2019-04-29 14:00:00	ES	Futures	3198.19	3200.63	3197.11	3197.65	75800.0
2019-04-29 15:00:00	ES	Futures	3197.92	3199.01	3193.04	3193.58	125238.0
2019-04-29 16:00:00	ES	Futures	3193.58	3194.4	3190.06	3191.69	63361.0
2019-04-29 18:00:00	ES	Futures	3190.87	3191.69	3189.79	3190.6	4924.0
2019-04-29 19:00:00	ES	Futures	3190.87	3190.87	3188.98	3189.25	3328.0
2019-04-29 20:00:00	ES	Futures	3189.52	3189.79	3187.89	3189.25	5189.0
2019-04-29 21:00:00	ES	Futures	3189.25	3189.52	3183.55	3185.99	23880.0
2019-04-29 22:00:00	ES	Futures	3185.72	3189.25	3185.45	3188.7	8446.0
2019-04-29 23:00:00	ES	Futures	3188.7	3189.25	3187.62	3188.16	3154.0
2019-04-29 00:00:00	NQ	Futures	9135.02	9137.35	9133.86	9135.6	864.0
2019-04-29 01:00:00	NQ	Futures	9135.6	9142.88	9133.57	9139.97	2306.0
2019-04-29 02:00:00	NQ	Futures	9140.26	9144.05	9136.19	9136.77	2381.0
2019-04-29 03:00:00	NQ	Futures	9136.77	9145.21	9133.27	9142.59	3206.0
2019-04-29 04:00:00	NQ	Futures	9142.59	9153.66	9140.55	9143.17	4959.0
2019-04-29 05:00:00	NQ	Futures	9142.88	9144.34	9126.29	9130.36	4497.0
2019-04-29 06:00:00	NQ	Futures	9130.36	9132.98	9120.17	9121.05	3695.0
2019-04-29 07:00:00	NQ	Futures	9121.34	9126.87	9116.1	9122.79	3950.0
2019-04-29 08:00:00	NQ	Futures	9122.79	9132.69	9117.55	9128.62	7326.0
2019-04-29 09:00:00	NQ	Futures	9128.62	9144.34	9119.59	9131.53	58170.0
2019-04-29 10:00:00	NQ	Futures	9131.53	9152.78	9115.8	9146.67	57861.0
2019-04-29 11:00:00	NQ	Futures	9146.38	9151.91	9134.44	9136.19	30872.0
2019-04-29 12:00:00	NQ	Futures	9136.19	9156.86	9132.69	9151.62	24247.0
2019-04-29 13:00:00	NQ	Futures	9151.91	9153.07	9142.01	9149.0	17646.0
2019-04-29 14:00:00	NQ	Futures	9149.0	9162.97	9147.83	9159.48	24489.0
2019-04-29 15:00:00	NQ	Futures	9159.48	9160.64	9140.55	9147.83	31901.0
2019-04-29 16:00:00	NQ	Futures	9147.83	9154.53	9090.47	9091.93	27281.0
2019-04-29 18:00:00	NQ	Futures	9090.18	9093.68	9085.82	9092.51	2683.0
2019-04-29 19:00:00	NQ	Futures	9092.51	9092.8	9086.4	9087.27	1648.0
2019-04-29 20:00:00	NQ	Futures	9087.27	9089.31	9077.95	9083.2	2814.0
2019-04-29 21:00:00	NQ	Futures	9083.2	9083.49	9059.61	9068.64	8787.0
2019-04-29 22:00:00	NQ	Futures	9068.35	9081.16	9067.18	9077.95	3696.0
2019-04-29 23:00:00	NQ	Futures	9078.54	9080.57	9075.92	9078.25	1489.0
2019-04-29 00:00:00	YM	Futures	28856.9	28865.6	28856.9	28859.1	496.0
2019-04-29 01:00:00	YM	Futures	28858.0	28886.3	28852.5	28877.6	1099.0
2019-04-29 02:00:00	YM	Futures	28877.6	28879.7	28860.2	28862.3	1136.0
2019-04-29 03:00:00	YM	Futures	28863.4	28884.1	28853.6	28881.9	1508.0

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

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