PREVIEW / futures_1hour / 2021-05-04

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-05-04.parquet
  size:    65 KB
  rows:    1,962

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
2021-05-04 00:00:00	ES	Futures	4692.19	4692.75	4690.5	4692.19	2959.0
2021-05-04 01:00:00	ES	Futures	4692.47	4695.84	4691.91	4695.0	4622.0
2021-05-04 02:00:00	ES	Futures	4695.28	4698.37	4694.44	4697.25	5552.0
2021-05-04 03:00:00	ES	Futures	4697.25	4702.86	4690.22	4693.87	25868.0
2021-05-04 04:00:00	ES	Futures	4693.87	4699.49	4690.78	4695.28	14924.0
2021-05-04 05:00:00	ES	Futures	4695.28	4701.18	4693.03	4700.05	11525.0
2021-05-04 06:00:00	ES	Futures	4700.05	4702.58	4697.25	4700.05	12508.0
2021-05-04 07:00:00	ES	Futures	4700.05	4701.74	4677.58	4685.44	62269.0
2021-05-04 08:00:00	ES	Futures	4685.44	4686.01	4672.24	4678.98	65342.0
2021-05-04 09:00:00	ES	Futures	4678.98	4686.85	4654.54	4655.94	324346.0
2021-05-04 10:00:00	ES	Futures	4655.94	4663.81	4647.51	4648.92	339155.0
2021-05-04 11:00:00	ES	Futures	4649.2	4654.54	4630.94	4635.99	297057.0
2021-05-04 12:00:00	ES	Futures	4635.99	4651.73	4634.31	4643.3	144562.0
2021-05-04 13:00:00	ES	Futures	4643.3	4656.79	4641.33	4651.45	140924.0
2021-05-04 14:00:00	ES	Futures	4651.73	4661.56	4647.79	4657.63	123978.0
2021-05-04 15:00:00	ES	Futures	4657.91	4676.45	4651.17	4676.17	282948.0
2021-05-04 16:00:00	ES	Futures	4676.17	4678.14	4668.59	4673.36	65290.0
2021-05-04 18:00:00	ES	Futures	4673.36	4674.77	4669.99	4672.8	5752.0
2021-05-04 19:00:00	ES	Futures	4672.8	4675.05	4671.4	4674.77	4260.0
2021-05-04 20:00:00	ES	Futures	4674.77	4684.04	4674.21	4682.35	12790.0
2021-05-04 21:00:00	ES	Futures	4682.63	4690.22	4680.95	4688.25	12846.0
2021-05-04 22:00:00	ES	Futures	4688.25	4689.38	4685.16	4687.41	6394.0
2021-05-04 23:00:00	ES	Futures	4687.41	4688.82	4686.57	4687.41	3993.0
2021-05-04 00:00:00	NQ	Futures	15911.53	15914.13	15906.32	15913.56	1185.0
2021-05-04 01:00:00	NQ	Futures	15913.27	15938.45	15910.08	15933.24	2525.0
2021-05-04 02:00:00	NQ	Futures	15932.95	15946.56	15929.48	15940.48	2822.0
2021-05-04 03:00:00	NQ	Futures	15940.77	15954.09	15894.45	15914.13	8964.0
2021-05-04 04:00:00	NQ	Futures	15914.13	15941.06	15893.87	15907.77	7380.0
2021-05-04 05:00:00	NQ	Futures	15906.03	15930.64	15899.08	15926.0	4124.0
2021-05-04 06:00:00	NQ	Futures	15926.0	15937.29	15901.69	15915.29	5001.0
2021-05-04 07:00:00	NQ	Futures	15915.0	15925.71	15806.73	15851.31	21799.0
2021-05-04 08:00:00	NQ	Futures	15850.45	15855.95	15811.94	15843.5	18979.0
2021-05-04 09:00:00	NQ	Futures	15843.5	15860.29	15673.56	15682.83	104807.0
2021-05-04 10:00:00	NQ	Futures	15683.12	15693.54	15599.16	15607.85	115887.0
2021-05-04 11:00:00	NQ	Futures	15607.56	15629.56	15494.66	15519.55	100380.0
2021-05-04 12:00:00	NQ	Futures	15518.97	15576.0	15510.29	15529.11	51891.0
2021-05-04 13:00:00	NQ	Futures	15529.11	15589.61	15523.03	15557.77	49868.0
2021-05-04 14:00:00	NQ	Futures	15558.06	15622.32	15543.0	15608.43	53111.0
2021-05-04 15:00:00	NQ	Futures	15608.14	15683.7	15578.61	15682.83	73365.0
2021-05-04 16:00:00	NQ	Futures	15683.12	15693.83	15649.83	15657.93	13398.0
2021-05-04 18:00:00	NQ	Futures	15662.56	15667.2	15641.72	15656.77	3173.0
2021-05-04 19:00:00	NQ	Futures	15657.06	15664.88	15646.06	15661.98	1880.0
2021-05-04 20:00:00	NQ	Futures	15661.98	15703.67	15659.38	15698.75	5545.0
2021-05-04 21:00:00	NQ	Futures	15698.75	15722.78	15684.85	15714.38	4456.0
2021-05-04 22:00:00	NQ	Futures	15714.38	15727.99	15711.2	15723.94	3098.0
2021-05-04 23:00:00	NQ	Futures	15724.52	15729.73	15714.96	15718.73	2045.0
2021-05-04 00:00:00	YM	Futures	37824.2	37830.8	37814.1	37826.4	484.0
2021-05-04 01:00:00	YM	Futures	37828.6	37847.5	37824.2	37839.8	1112.0
2021-05-04 02:00:00	YM	Futures	37839.8	37863.1	37833.1	37858.7	1436.0
2021-05-04 03:00:00	YM	Futures	37857.6	37902.1	37813.0	37835.3	4797.0

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

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