PREVIEW / futures_1hour / 2020-05-28

all futures 1-hour files

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

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-28 00:00:00	ES	Futures	3330.02	3337.43	3323.98	3333.59	21162.0
2020-05-28 01:00:00	ES	Futures	3333.59	3345.66	3328.65	3345.11	18437.0
2020-05-28 02:00:00	ES	Futures	3345.38	3350.05	3336.33	3337.15	25085.0
2020-05-28 03:00:00	ES	Futures	3337.15	3345.66	3327.27	3341.54	43833.0
2020-05-28 04:00:00	ES	Futures	3341.54	3345.11	3330.29	3334.41	39708.0
2020-05-28 05:00:00	ES	Futures	3334.13	3342.64	3323.71	3327.55	26878.0
2020-05-28 06:00:00	ES	Futures	3327.27	3337.98	3325.9	3336.05	24581.0
2020-05-28 07:00:00	ES	Futures	3335.78	3343.19	3331.12	3337.7	28603.0
2020-05-28 08:00:00	ES	Futures	3337.7	3343.19	3331.39	3340.72	63142.0
2020-05-28 09:00:00	ES	Futures	3340.72	3346.76	3325.9	3335.23	215542.0
2020-05-28 10:00:00	ES	Futures	3335.23	3346.76	3329.74	3345.66	198905.0
2020-05-28 11:00:00	ES	Futures	3345.38	3350.6	3338.8	3350.6	165776.0
2020-05-28 12:00:00	ES	Futures	3350.6	3360.2	3346.48	3358.56	126938.0
2020-05-28 13:00:00	ES	Futures	3358.28	3364.87	3358.01	3360.75	110636.0
2020-05-28 14:00:00	ES	Futures	3360.48	3362.67	3349.5	3354.99	135218.0
2020-05-28 15:00:00	ES	Futures	3355.26	3360.48	3314.38	3322.06	420444.0
2020-05-28 16:00:00	ES	Futures	3322.33	3336.05	3322.06	3333.86	71591.0
2020-05-28 18:00:00	ES	Futures	3332.49	3335.78	3325.35	3329.19	11849.0
2020-05-28 19:00:00	ES	Futures	3329.47	3333.31	3319.59	3320.69	11362.0
2020-05-28 20:00:00	ES	Futures	3320.69	3325.35	3306.97	3309.99	25508.0
2020-05-28 21:00:00	ES	Futures	3309.99	3323.43	3305.32	3321.79	24592.0
2020-05-28 22:00:00	ES	Futures	3321.79	3330.02	3317.39	3327.82	15142.0
2020-05-28 23:00:00	ES	Futures	3327.55	3328.65	3319.59	3322.33	7999.0
2020-05-28 00:00:00	NQ	Futures	10716.95	10744.94	10692.96	10734.38	7690.0
2020-05-28 01:00:00	NQ	Futures	10732.95	10778.36	10720.66	10776.36	6698.0
2020-05-28 02:00:00	NQ	Futures	10777.79	10793.22	10722.66	10728.09	8612.0
2020-05-28 03:00:00	NQ	Futures	10728.66	10770.08	10706.38	10759.8	12227.0
2020-05-28 04:00:00	NQ	Futures	10760.94	10777.22	10731.23	10746.09	10418.0
2020-05-28 05:00:00	NQ	Futures	10745.8	10768.08	10699.53	10714.95	7284.0
2020-05-28 06:00:00	NQ	Futures	10713.52	10756.08	10706.67	10745.52	7976.0
2020-05-28 07:00:00	NQ	Futures	10746.09	10756.37	10717.24	10717.24	7552.0
2020-05-28 08:00:00	NQ	Futures	10718.09	10720.66	10649.25	10673.82	29581.0
2020-05-28 09:00:00	NQ	Futures	10674.11	10811.78	10670.11	10774.36	69171.0
2020-05-28 10:00:00	NQ	Futures	10774.65	10852.63	10748.09	10844.35	57106.0
2020-05-28 11:00:00	NQ	Futures	10844.63	10873.77	10809.78	10872.63	46766.0
2020-05-28 12:00:00	NQ	Futures	10872.34	10915.47	10863.77	10904.05	37975.0
2020-05-28 13:00:00	NQ	Futures	10904.05	10929.18	10895.76	10901.48	29456.0
2020-05-28 14:00:00	NQ	Futures	10901.48	10910.04	10860.91	10880.91	36227.0
2020-05-28 15:00:00	NQ	Futures	10881.19	10908.9	10724.95	10757.51	76995.0
2020-05-28 16:00:00	NQ	Futures	10757.51	10816.64	10757.23	10806.93	12126.0
2020-05-28 18:00:00	NQ	Futures	10801.22	10809.78	10779.22	10789.5	3293.0
2020-05-28 19:00:00	NQ	Futures	10788.36	10799.5	10757.51	10760.65	3637.0
2020-05-28 20:00:00	NQ	Futures	10761.23	10782.36	10726.95	10735.8	8603.0
2020-05-28 21:00:00	NQ	Futures	10735.23	10782.08	10718.67	10777.79	6969.0
2020-05-28 22:00:00	NQ	Futures	10777.79	10801.79	10760.94	10796.36	4882.0
2020-05-28 23:00:00	NQ	Futures	10796.36	10797.79	10770.94	10780.08	3119.0
2020-05-28 00:00:00	YM	Futures	28057.7	28122.3	28002.9	28091.6	3617.0
2020-05-28 01:00:00	YM	Futures	28091.6	28209.9	28051.1	28207.7	3212.0
2020-05-28 02:00:00	YM	Futures	28208.8	28252.6	28127.8	28139.8	5618.0
2020-05-28 03:00:00	YM	Futures	28140.9	28209.9	28031.4	28160.6	8481.0

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

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