PREVIEW / futures_1hour / 2019-04-30

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-04-30.parquet
  size:    55 KB
  rows:    1,753

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-30 00:00:00	ES	Futures	3188.16	3188.7	3187.35	3187.35	2111.0
2019-04-30 01:00:00	ES	Futures	3187.62	3189.52	3187.08	3188.16	4164.0
2019-04-30 02:00:00	ES	Futures	3188.16	3189.25	3187.08	3189.25	6445.0
2019-04-30 03:00:00	ES	Futures	3189.25	3190.6	3186.54	3187.62	14144.0
2019-04-30 04:00:00	ES	Futures	3187.89	3190.33	3187.62	3189.79	10341.0
2019-04-30 05:00:00	ES	Futures	3189.79	3191.69	3188.98	3190.33	9895.0
2019-04-30 06:00:00	ES	Futures	3190.33	3192.23	3189.25	3191.69	8026.0
2019-04-30 07:00:00	ES	Futures	3191.42	3192.23	3190.6	3191.69	10631.0
2019-04-30 08:00:00	ES	Futures	3191.96	3194.13	3187.08	3188.7	37381.0
2019-04-30 09:00:00	ES	Futures	3188.7	3190.33	3183.55	3184.91	167784.0
2019-04-30 10:00:00	ES	Futures	3184.64	3187.89	3182.74	3182.74	175571.0
2019-04-30 11:00:00	ES	Futures	3183.01	3187.89	3172.98	3185.45	258027.0
2019-04-30 12:00:00	ES	Futures	3185.45	3189.25	3184.91	3187.89	92057.0
2019-04-30 13:00:00	ES	Futures	3187.62	3195.21	3187.08	3194.94	109200.0
2019-04-30 14:00:00	ES	Futures	3194.94	3195.75	3191.96	3193.31	92751.0
2019-04-30 15:00:00	ES	Futures	3193.58	3199.28	3191.69	3195.21	277738.0
2019-04-30 16:00:00	ES	Futures	3195.21	3206.06	3193.31	3204.43	110245.0
2019-04-30 18:00:00	ES	Futures	3204.43	3204.97	3202.26	3203.07	6131.0
2019-04-30 19:00:00	ES	Futures	3202.8	3204.43	3201.72	3204.43	4284.0
2019-04-30 20:00:00	ES	Futures	3204.43	3206.33	3203.62	3206.33	5104.0
2019-04-30 21:00:00	ES	Futures	3206.33	3207.95	3204.97	3207.68	7141.0
2019-04-30 22:00:00	ES	Futures	3207.68	3210.66	3207.41	3210.12	6754.0
2019-04-30 23:00:00	ES	Futures	3210.12	3211.21	3209.04	3209.31	3564.0
2019-04-30 00:00:00	NQ	Futures	9078.54	9079.99	9070.97	9071.55	2373.0
2019-04-30 01:00:00	NQ	Futures	9071.55	9081.45	9070.68	9077.95	1939.0
2019-04-30 02:00:00	NQ	Futures	9078.54	9083.49	9074.46	9082.61	2325.0
2019-04-30 03:00:00	NQ	Futures	9082.61	9089.31	9079.12	9081.16	4300.0
2019-04-30 04:00:00	NQ	Futures	9081.45	9084.94	9079.12	9083.78	3290.0
2019-04-30 05:00:00	NQ	Futures	9084.07	9091.64	9082.03	9089.02	2833.0
2019-04-30 06:00:00	NQ	Futures	9089.02	9095.13	9086.98	9092.51	3192.0
2019-04-30 07:00:00	NQ	Futures	9092.22	9094.84	9085.82	9090.18	4222.0
2019-04-30 08:00:00	NQ	Futures	9090.47	9097.17	9066.02	9069.8	13581.0
2019-04-30 09:00:00	NQ	Futures	9069.8	9091.93	9056.7	9076.79	62542.0
2019-04-30 10:00:00	NQ	Futures	9077.08	9091.93	9048.84	9049.42	77045.0
2019-04-30 11:00:00	NQ	Futures	9049.71	9058.16	9014.19	9051.75	76991.0
2019-04-30 12:00:00	NQ	Futures	9051.75	9074.46	9050.29	9066.02	39220.0
2019-04-30 13:00:00	NQ	Futures	9066.6	9089.6	9054.95	9088.73	36330.0
2019-04-30 14:00:00	NQ	Futures	9088.73	9091.06	9070.97	9072.42	30509.0
2019-04-30 15:00:00	NQ	Futures	9072.42	9088.44	9064.85	9079.12	52619.0
2019-04-30 16:00:00	NQ	Futures	9079.12	9150.45	9075.92	9144.05	24674.0
2019-04-30 18:00:00	NQ	Futures	9140.84	9142.3	9129.49	9131.82	2673.0
2019-04-30 19:00:00	NQ	Futures	9132.11	9136.77	9129.49	9136.77	1566.0
2019-04-30 20:00:00	NQ	Futures	9137.06	9141.14	9133.57	9140.84	1879.0
2019-04-30 21:00:00	NQ	Futures	9140.84	9144.05	9135.6	9143.76	2484.0
2019-04-30 22:00:00	NQ	Futures	9143.46	9154.82	9142.01	9151.91	4112.0
2019-04-30 23:00:00	NQ	Futures	9152.2	9156.57	9148.71	9151.33	2293.0
2019-04-30 00:00:00	YM	Futures	28864.5	28870.0	28858.0	28861.2	551.0
2019-04-30 01:00:00	YM	Futures	28862.3	28881.9	28856.9	28867.8	795.0
2019-04-30 02:00:00	YM	Futures	28868.9	28868.9	28850.4	28865.6	1465.0
2019-04-30 03:00:00	YM	Futures	28864.5	28873.2	28848.2	28861.2	1992.0

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

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