PREVIEW / futures_1hour / 2020-05-12

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-05-12.parquet
  size:    62 KB
  rows:    1,881

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
2020-05-12 00:00:00	ES	Futures	3187.05	3193.36	3185.4	3192.26	8996.0
2020-05-12 01:00:00	ES	Futures	3191.99	3199.12	3191.71	3193.91	9524.0
2020-05-12 02:00:00	ES	Futures	3193.63	3193.91	3179.64	3187.6	17845.0
2020-05-12 03:00:00	ES	Futures	3187.6	3202.69	3186.5	3199.67	29020.0
2020-05-12 04:00:00	ES	Futures	3199.95	3203.51	3193.91	3198.02	24734.0
2020-05-12 05:00:00	ES	Futures	3198.02	3207.08	3193.08	3205.98	27203.0
2020-05-12 06:00:00	ES	Futures	3205.71	3215.86	3203.79	3213.12	26611.0
2020-05-12 07:00:00	ES	Futures	3213.39	3222.72	3211.47	3220.8	29717.0
2020-05-12 08:00:00	ES	Futures	3221.08	3222.72	3213.67	3221.35	40426.0
2020-05-12 09:00:00	ES	Futures	3221.35	3226.29	3196.93	3204.88	204065.0
2020-05-12 10:00:00	ES	Futures	3204.61	3210.1	3197.2	3207.63	205821.0
2020-05-12 11:00:00	ES	Futures	3207.35	3214.21	3201.04	3207.35	152083.0
2020-05-12 12:00:00	ES	Futures	3207.63	3208.73	3201.59	3207.35	98502.0
2020-05-12 13:00:00	ES	Futures	3207.08	3207.63	3185.13	3196.1	163346.0
2020-05-12 14:00:00	ES	Futures	3195.83	3196.93	3182.11	3191.16	163492.0
2020-05-12 15:00:00	ES	Futures	3191.16	3191.99	3141.49	3142.32	372414.0
2020-05-12 16:00:00	ES	Futures	3142.59	3142.87	3115.15	3116.52	123312.0
2020-05-12 18:00:00	ES	Futures	3117.07	3127.5	3109.66	3119.82	24282.0
2020-05-12 19:00:00	ES	Futures	3119.82	3123.93	3103.35	3105.55	22775.0
2020-05-12 20:00:00	ES	Futures	3105.55	3119.54	3101.16	3116.8	31193.0
2020-05-12 21:00:00	ES	Futures	3116.8	3120.37	3109.66	3117.9	24621.0
2020-05-12 22:00:00	ES	Futures	3117.9	3129.15	3117.35	3125.58	18989.0
2020-05-12 23:00:00	ES	Futures	3125.58	3132.71	3124.21	3132.44	11841.0
2020-05-12 00:00:00	NQ	Futures	10572.13	10592.13	10563.28	10586.13	5637.0
2020-05-12 01:00:00	NQ	Futures	10585.56	10610.69	10584.7	10594.41	5482.0
2020-05-12 02:00:00	NQ	Futures	10593.84	10596.41	10546.14	10565.28	8713.0
2020-05-12 03:00:00	NQ	Futures	10566.42	10618.41	10562.42	10604.41	10062.0
2020-05-12 04:00:00	NQ	Futures	10604.41	10610.12	10583.27	10584.99	10614.0
2020-05-12 05:00:00	NQ	Futures	10585.27	10602.98	10565.85	10600.98	8576.0
2020-05-12 06:00:00	NQ	Futures	10600.7	10630.12	10590.41	10621.55	8335.0
2020-05-12 07:00:00	NQ	Futures	10621.83	10652.68	10615.55	10645.54	8772.0
2020-05-12 08:00:00	NQ	Futures	10645.26	10650.97	10620.98	10648.4	12629.0
2020-05-12 09:00:00	NQ	Futures	10648.11	10677.82	10553.56	10591.84	70007.0
2020-05-12 10:00:00	NQ	Futures	10591.27	10646.97	10569.85	10637.54	60320.0
2020-05-12 11:00:00	NQ	Futures	10637.83	10662.97	10616.98	10638.4	40858.0
2020-05-12 12:00:00	NQ	Futures	10638.69	10661.54	10623.55	10657.54	27348.0
2020-05-12 13:00:00	NQ	Futures	10657.25	10658.97	10572.7	10616.98	38177.0
2020-05-12 14:00:00	NQ	Futures	10616.98	10618.98	10568.13	10595.27	40172.0
2020-05-12 15:00:00	NQ	Futures	10594.7	10598.41	10397.89	10399.6	82989.0
2020-05-12 16:00:00	NQ	Futures	10399.6	10408.46	10329.34	10332.48	25896.0
2020-05-12 18:00:00	NQ	Futures	10335.34	10371.04	10317.34	10338.19	8435.0
2020-05-12 19:00:00	NQ	Futures	10337.33	10347.9	10290.78	10298.77	8409.0
2020-05-12 20:00:00	NQ	Futures	10299.92	10339.05	10280.21	10331.91	10509.0
2020-05-12 21:00:00	NQ	Futures	10332.19	10345.62	10313.06	10336.48	7327.0
2020-05-12 22:00:00	NQ	Futures	10337.05	10376.18	10334.76	10362.47	6005.0
2020-05-12 23:00:00	NQ	Futures	10362.76	10385.61	10355.62	10381.89	4430.0
2020-05-12 00:00:00	YM	Futures	26233.9	26285.4	26221.9	26276.7	2031.0
2020-05-12 01:00:00	YM	Futures	26276.7	26342.4	26275.6	26297.5	2660.0
2020-05-12 02:00:00	YM	Futures	26296.4	26298.6	26190.1	26249.3	4540.0
2020-05-12 03:00:00	YM	Futures	26251.5	26378.5	26244.9	26357.7	6700.0

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

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