PREVIEW / futures_1hour / 2020-10-02

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-10-02.parquet
  size:    53 KB
  rows:    1,545

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-10-02 00:00:00	ES	Futures	3767.55	3770.35	3734.22	3737.02	24254.0
2020-10-02 01:00:00	ES	Futures	3736.74	3737.86	3697.53	3710.97	97323.0
2020-10-02 02:00:00	ES	Futures	3710.97	3730.58	3706.49	3727.5	44130.0
2020-10-02 03:00:00	ES	Futures	3727.5	3741.5	3720.78	3728.34	45264.0
2020-10-02 04:00:00	ES	Futures	3728.34	3733.38	3721.34	3730.02	27106.0
2020-10-02 05:00:00	ES	Futures	3729.74	3736.46	3708.73	3713.21	37363.0
2020-10-02 06:00:00	ES	Futures	3712.93	3723.58	3701.73	3721.06	38472.0
2020-10-02 07:00:00	ES	Futures	3720.78	3725.54	3709.29	3712.37	39522.0
2020-10-02 08:00:00	ES	Futures	3712.09	3730.86	3706.77	3713.77	67778.0
2020-10-02 09:00:00	ES	Futures	3713.77	3746.82	3703.41	3742.34	244000.0
2020-10-02 10:00:00	ES	Futures	3742.34	3757.19	3737.58	3747.66	210473.0
2020-10-02 11:00:00	ES	Futures	3747.66	3757.19	3727.22	3728.06	202808.0
2020-10-02 12:00:00	ES	Futures	3728.34	3763.91	3719.09	3757.75	263466.0
2020-10-02 13:00:00	ES	Futures	3757.75	3762.79	3739.82	3747.66	149957.0
2020-10-02 14:00:00	ES	Futures	3747.38	3761.11	3746.82	3755.79	141837.0
2020-10-02 15:00:00	ES	Futures	3755.79	3759.99	3738.14	3740.38	216531.0
2020-10-02 16:00:00	ES	Futures	3740.38	3751.87	3736.74	3748.22	54416.0
2020-10-02 00:00:00	NQ	Futures	13380.4	13394.87	13260.27	13272.72	9479.0
2020-10-02 01:00:00	NQ	Futures	13271.56	13277.06	13086.01	13145.93	40214.0
2020-10-02 02:00:00	NQ	Futures	13146.8	13225.82	13132.04	13193.69	14913.0
2020-10-02 03:00:00	NQ	Futures	13191.96	13257.67	13167.35	13180.96	18776.0
2020-10-02 04:00:00	NQ	Futures	13181.54	13206.14	13151.72	13181.54	11305.0
2020-10-02 05:00:00	NQ	Futures	13182.69	13196.88	13083.99	13114.67	16008.0
2020-10-02 06:00:00	NQ	Futures	13113.51	13160.12	13072.99	13150.27	14608.0
2020-10-02 07:00:00	NQ	Futures	13149.41	13163.59	13061.99	13072.41	18024.0
2020-10-02 08:00:00	NQ	Futures	13071.54	13158.38	13064.59	13104.25	25825.0
2020-10-02 09:00:00	NQ	Futures	13103.96	13233.93	13060.83	13207.88	98894.0
2020-10-02 10:00:00	NQ	Futures	13208.75	13279.38	13181.25	13223.51	85888.0
2020-10-02 11:00:00	NQ	Futures	13223.8	13228.14	13042.59	13050.7	94920.0
2020-10-02 12:00:00	NQ	Futures	13051.28	13144.19	12973.41	13101.93	109602.0
2020-10-02 13:00:00	NQ	Futures	13101.93	13114.96	13038.25	13068.64	60611.0
2020-10-02 14:00:00	NQ	Futures	13067.2	13125.96	13029.85	13085.43	61097.0
2020-10-02 15:00:00	NQ	Futures	13085.72	13104.54	13009.59	13019.43	53658.0
2020-10-02 16:00:00	NQ	Futures	13019.14	13041.14	12993.67	13027.83	13761.0
2020-10-02 00:00:00	YM	Futures	30553.8	30577.0	30281.8	30299.5	7081.0
2020-10-02 01:00:00	YM	Futures	30299.5	30309.5	29972.2	30104.9	23416.0
2020-10-02 02:00:00	YM	Futures	30101.6	30261.9	30065.1	30245.3	6194.0
2020-10-02 03:00:00	YM	Futures	30248.6	30352.6	30186.7	30255.3	8337.0
2020-10-02 04:00:00	YM	Futures	30254.2	30296.2	30205.5	30264.1	4208.0
2020-10-02 05:00:00	YM	Futures	30269.6	30326.0	30116.0	30159.1	6398.0
2020-10-02 06:00:00	YM	Futures	30154.7	30243.1	30071.7	30222.1	7472.0
2020-10-02 07:00:00	YM	Futures	30223.2	30257.5	30130.3	30164.6	8161.0
2020-10-02 08:00:00	YM	Futures	30163.5	30265.2	30080.6	30142.5	12107.0
2020-10-02 09:00:00	YM	Futures	30140.3	30454.3	30065.1	30395.7	33913.0
2020-10-02 10:00:00	YM	Futures	30400.1	30496.3	30305.0	30401.2	25022.0
2020-10-02 11:00:00	YM	Futures	30401.2	30510.7	30305.0	30311.7	23307.0
2020-10-02 12:00:00	YM	Futures	30312.8	30655.5	30261.9	30612.4	33531.0
2020-10-02 13:00:00	YM	Futures	30609.1	30665.5	30468.7	30526.2	19227.0
2020-10-02 14:00:00	YM	Futures	30525.0	30650.0	30522.8	30598.0	15383.0
2020-10-02 15:00:00	YM	Futures	30600.2	30661.0	30460.9	30470.9	19626.0

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

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