PREVIEW / futures_1hour / 2019-09-03

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-03.parquet
  size:    60 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-03 00:00:00	ES	Futures	3149.11	3152.09	3148.57	3151.55	3700.0
2019-09-03 01:00:00	ES	Futures	3151.82	3152.09	3146.13	3148.03	11670.0
2019-09-03 02:00:00	ES	Futures	3148.03	3155.07	3137.2	3146.41	31069.0
2019-09-03 03:00:00	ES	Futures	3146.41	3146.95	3134.49	3136.66	50176.0
2019-09-03 04:00:00	ES	Futures	3136.93	3152.09	3136.39	3145.32	43339.0
2019-09-03 05:00:00	ES	Futures	3145.32	3149.92	3133.95	3136.12	40359.0
2019-09-03 06:00:00	ES	Futures	3136.39	3145.86	3135.04	3145.32	26710.0
2019-09-03 07:00:00	ES	Futures	3145.59	3147.76	3141.8	3143.43	29778.0
2019-09-03 08:00:00	ES	Futures	3143.43	3153.98	3142.07	3147.76	56363.0
2019-09-03 09:00:00	ES	Futures	3147.76	3155.88	3141.53	3153.17	205797.0
2019-09-03 10:00:00	ES	Futures	3153.17	3153.17	3130.43	3147.76	339404.0
2019-09-03 11:00:00	ES	Futures	3147.76	3150.19	3136.12	3145.05	196473.0
2019-09-03 12:00:00	ES	Futures	3145.05	3147.22	3140.45	3141.53	102803.0
2019-09-03 13:00:00	ES	Futures	3141.53	3144.51	3133.95	3135.85	100921.0
2019-09-03 14:00:00	ES	Futures	3135.85	3141.53	3135.31	3140.45	82317.0
2019-09-03 15:00:00	ES	Futures	3140.45	3149.92	3138.28	3146.95	198404.0
2019-09-03 16:00:00	ES	Futures	3146.95	3148.57	3144.24	3145.05	55768.0
2019-09-03 18:00:00	ES	Futures	3143.43	3148.3	3143.43	3147.49	6065.0
2019-09-03 19:00:00	ES	Futures	3147.49	3148.57	3142.34	3143.16	9577.0
2019-09-03 20:00:00	ES	Futures	3143.43	3147.76	3142.89	3147.22	25534.0
2019-09-03 21:00:00	ES	Futures	3147.22	3160.21	3147.22	3159.67	28029.0
2019-09-03 22:00:00	ES	Futures	3159.4	3159.4	3156.42	3156.69	8070.0
2019-09-03 23:00:00	ES	Futures	3156.42	3156.96	3154.26	3155.61	9713.0
2019-09-03 00:00:00	NQ	Futures	8865.88	8875.46	8863.27	8873.72	2681.0
2019-09-03 01:00:00	NQ	Futures	8874.01	8875.75	8853.99	8860.66	6682.0
2019-09-03 02:00:00	NQ	Futures	8861.24	8888.51	8821.2	8855.15	12792.0
2019-09-03 03:00:00	NQ	Futures	8853.7	8856.02	8815.11	8822.94	17036.0
2019-09-03 04:00:00	NQ	Futures	8823.23	8878.07	8822.07	8849.92	13638.0
2019-09-03 05:00:00	NQ	Futures	8850.21	8866.75	8812.5	8819.46	10540.0
2019-09-03 06:00:00	NQ	Futures	8818.88	8859.5	8813.66	8857.47	9306.0
2019-09-03 07:00:00	NQ	Futures	8858.05	8866.75	8846.44	8851.38	9821.0
2019-09-03 08:00:00	NQ	Futures	8851.67	8892.29	8848.18	8874.01	21017.0
2019-09-03 09:00:00	NQ	Futures	8874.3	8909.4	8852.54	8899.54	64107.0
2019-09-03 10:00:00	NQ	Futures	8898.96	8898.96	8816.27	8875.17	99155.0
2019-09-03 11:00:00	NQ	Futures	8874.88	8875.17	8830.78	8858.63	57369.0
2019-09-03 12:00:00	NQ	Futures	8858.92	8867.04	8836.58	8841.22	31188.0
2019-09-03 13:00:00	NQ	Futures	8841.22	8849.92	8805.82	8809.88	35004.0
2019-09-03 14:00:00	NQ	Futures	8810.18	8824.39	8807.56	8817.72	32685.0
2019-09-03 15:00:00	NQ	Futures	8817.72	8851.38	8811.34	8836.87	42193.0
2019-09-03 16:00:00	NQ	Futures	8836.87	8847.02	8829.9	8840.06	9575.0
2019-09-03 18:00:00	NQ	Futures	8836.87	8849.34	8832.23	8848.18	2579.0
2019-09-03 19:00:00	NQ	Futures	8847.89	8849.92	8830.19	8834.26	3016.0
2019-09-03 20:00:00	NQ	Futures	8834.55	8847.89	8832.52	8845.86	7430.0
2019-09-03 21:00:00	NQ	Futures	8845.57	8894.32	8845.57	8892.58	12988.0
2019-09-03 22:00:00	NQ	Futures	8892.29	8892.87	8882.42	8883.29	4613.0
2019-09-03 23:00:00	NQ	Futures	8883.29	8885.03	8875.17	8880.1	3749.0
2019-09-03 00:00:00	YM	Futures	28546.9	28570.8	28539.3	28567.5	948.0
2019-09-03 01:00:00	YM	Futures	28568.6	28571.9	28517.5	28529.5	2530.0
2019-09-03 02:00:00	YM	Futures	28531.7	28591.5	28439.2	28520.8	6597.0
2019-09-03 03:00:00	YM	Futures	28520.8	28525.1	28417.5	28441.4	9135.0

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

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