PREVIEW / futures_1hour / 2020-05-11

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-05-11.parquet
  size:    61 KB
  rows:    1,858

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-11 00:00:00	ES	Futures	3229.31	3232.6	3225.74	3226.84	9484.0
2020-05-11 01:00:00	ES	Futures	3227.11	3227.11	3217.23	3217.23	11217.0
2020-05-11 02:00:00	ES	Futures	3217.23	3224.64	3212.84	3223.27	13682.0
2020-05-11 03:00:00	ES	Futures	3223.27	3229.31	3216.68	3225.19	20130.0
2020-05-11 04:00:00	ES	Futures	3225.19	3225.47	3206.81	3210.65	27864.0
2020-05-11 05:00:00	ES	Futures	3210.37	3210.65	3198.02	3202.69	35971.0
2020-05-11 06:00:00	ES	Futures	3202.69	3204.34	3190.34	3193.91	26826.0
2020-05-11 07:00:00	ES	Futures	3193.91	3196.1	3177.99	3180.46	40478.0
2020-05-11 08:00:00	ES	Futures	3180.46	3183.21	3171.95	3176.89	63105.0
2020-05-11 09:00:00	ES	Futures	3176.89	3193.08	3176.89	3184.58	172902.0
2020-05-11 10:00:00	ES	Futures	3184.58	3195.01	3183.48	3189.24	183883.0
2020-05-11 11:00:00	ES	Futures	3189.24	3201.59	3188.42	3201.04	132775.0
2020-05-11 12:00:00	ES	Futures	3200.77	3213.67	3198.3	3212.57	115010.0
2020-05-11 13:00:00	ES	Futures	3212.84	3223.82	3210.37	3216.96	110149.0
2020-05-11 14:00:00	ES	Futures	3216.96	3220.8	3209.55	3218.33	123046.0
2020-05-11 15:00:00	ES	Futures	3218.33	3223.82	3206.53	3207.63	227526.0
2020-05-11 16:00:00	ES	Futures	3207.63	3209.55	3202.14	3204.06	69160.0
2020-05-11 18:00:00	ES	Futures	3204.34	3213.67	3204.06	3207.63	10250.0
2020-05-11 19:00:00	ES	Futures	3207.63	3209.82	3197.2	3200.77	9462.0
2020-05-11 20:00:00	ES	Futures	3201.04	3203.51	3185.95	3188.42	21872.0
2020-05-11 21:00:00	ES	Futures	3188.69	3195.28	3183.21	3186.5	19992.0
2020-05-11 22:00:00	ES	Futures	3186.22	3190.62	3179.64	3184.85	12462.0
2020-05-11 23:00:00	ES	Futures	3184.85	3187.32	3177.17	3187.32	13037.0
2020-05-11 00:00:00	NQ	Futures	10596.41	10605.84	10581.56	10586.7	3673.0
2020-05-11 01:00:00	NQ	Futures	10586.7	10586.98	10553.28	10553.85	4781.0
2020-05-11 02:00:00	NQ	Futures	10553.85	10578.99	10542.71	10573.56	6055.0
2020-05-11 03:00:00	NQ	Futures	10574.13	10592.98	10556.42	10584.41	8870.0
2020-05-11 04:00:00	NQ	Futures	10584.41	10584.7	10521.57	10532.14	9348.0
2020-05-11 05:00:00	NQ	Futures	10532.14	10539.0	10504.15	10528.71	11941.0
2020-05-11 06:00:00	NQ	Futures	10529.29	10534.71	10483.58	10497.86	9328.0
2020-05-11 07:00:00	NQ	Futures	10497.58	10510.15	10448.16	10453.88	13254.0
2020-05-11 08:00:00	NQ	Futures	10454.16	10461.02	10418.46	10447.31	19761.0
2020-05-11 09:00:00	NQ	Futures	10447.59	10538.71	10444.16	10516.72	48845.0
2020-05-11 10:00:00	NQ	Futures	10516.72	10573.56	10514.15	10545.0	51844.0
2020-05-11 11:00:00	NQ	Futures	10544.71	10586.98	10538.71	10585.56	31104.0
2020-05-11 12:00:00	NQ	Futures	10585.56	10605.55	10571.85	10602.41	25390.0
2020-05-11 13:00:00	NQ	Futures	10602.12	10652.11	10595.55	10635.54	29987.0
2020-05-11 14:00:00	NQ	Futures	10635.54	10657.25	10618.69	10651.54	26148.0
2020-05-11 15:00:00	NQ	Futures	10652.11	10670.39	10610.69	10610.69	43602.0
2020-05-11 16:00:00	NQ	Futures	10610.41	10620.98	10586.7	10603.84	13635.0
2020-05-11 18:00:00	NQ	Futures	10605.27	10638.69	10603.84	10619.26	4067.0
2020-05-11 19:00:00	NQ	Futures	10618.69	10628.12	10582.41	10599.27	5386.0
2020-05-11 20:00:00	NQ	Futures	10599.27	10608.41	10553.85	10565.85	8362.0
2020-05-11 21:00:00	NQ	Futures	10566.42	10593.55	10550.42	10560.13	7015.0
2020-05-11 22:00:00	NQ	Futures	10559.85	10574.13	10542.71	10560.99	4721.0
2020-05-11 23:00:00	NQ	Futures	10561.28	10573.27	10539.0	10572.42	5098.0
2020-05-11 00:00:00	YM	Futures	26773.9	26798.0	26737.8	26747.7	1461.0
2020-05-11 01:00:00	YM	Futures	26747.7	26748.7	26652.4	26653.5	2301.0
2020-05-11 02:00:00	YM	Futures	26654.6	26709.3	26611.8	26699.5	3087.0
2020-05-11 03:00:00	YM	Futures	26698.4	26752.0	26638.1	26714.8	5078.0

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

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