PREVIEW / futures_1hour / 2020-09-28

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-09-28.parquet
  size:    59 KB
  rows:    1,864

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-09-28 00:00:00	ES	Futures	3696.97	3699.49	3696.13	3698.65	5250.0
2020-09-28 01:00:00	ES	Futures	3698.65	3709.57	3698.65	3709.29	12621.0
2020-09-28 02:00:00	ES	Futures	3709.29	3713.49	3706.77	3707.05	12844.0
2020-09-28 03:00:00	ES	Futures	3706.77	3715.45	3703.69	3712.09	22952.0
2020-09-28 04:00:00	ES	Futures	3711.81	3719.09	3707.05	3711.53	19538.0
2020-09-28 05:00:00	ES	Futures	3711.81	3718.81	3710.97	3717.41	13985.0
2020-09-28 06:00:00	ES	Futures	3717.41	3734.5	3716.01	3731.42	29562.0
2020-09-28 07:00:00	ES	Futures	3731.42	3734.22	3726.94	3733.1	22241.0
2020-09-28 08:00:00	ES	Futures	3733.1	3738.7	3731.42	3735.62	26600.0
2020-09-28 09:00:00	ES	Futures	3735.34	3740.94	3721.62	3728.9	177201.0
2020-09-28 10:00:00	ES	Futures	3728.62	3749.34	3723.86	3732.82	251075.0
2020-09-28 11:00:00	ES	Futures	3732.82	3745.7	3731.42	3739.54	173548.0
2020-09-28 12:00:00	ES	Futures	3739.54	3745.7	3732.82	3745.14	132952.0
2020-09-28 13:00:00	ES	Futures	3745.42	3752.15	3740.66	3750.19	85434.0
2020-09-28 14:00:00	ES	Futures	3749.91	3754.11	3745.14	3751.31	100714.0
2020-09-28 15:00:00	ES	Futures	3751.31	3751.87	3737.58	3745.42	255919.0
2020-09-28 16:00:00	ES	Futures	3745.42	3754.67	3741.78	3751.87	64553.0
2020-09-28 18:00:00	ES	Futures	3751.87	3757.19	3749.63	3754.95	7218.0
2020-09-28 19:00:00	ES	Futures	3754.95	3760.27	3754.67	3759.15	4785.0
2020-09-28 20:00:00	ES	Futures	3759.43	3762.79	3756.35	3761.11	8900.0
2020-09-28 21:00:00	ES	Futures	3761.11	3763.07	3756.35	3758.87	10118.0
2020-09-28 22:00:00	ES	Futures	3758.87	3761.67	3757.19	3758.31	7008.0
2020-09-28 23:00:00	ES	Futures	3758.31	3759.15	3755.23	3758.87	6099.0
2020-09-28 00:00:00	NQ	Futures	12942.72	12954.01	12937.22	12946.2	2225.0
2020-09-28 01:00:00	NQ	Futures	12946.78	12976.3	12946.49	12975.15	6447.0
2020-09-28 02:00:00	NQ	Futures	12976.3	12989.62	12963.57	12974.86	6264.0
2020-09-28 03:00:00	NQ	Futures	12973.99	13013.35	12973.41	13011.62	9206.0
2020-09-28 04:00:00	NQ	Futures	13011.04	13055.91	12994.54	13028.7	8649.0
2020-09-28 05:00:00	NQ	Futures	13028.99	13060.83	13026.96	13049.83	5212.0
2020-09-28 06:00:00	NQ	Futures	13049.54	13127.7	13042.88	13109.46	12887.0
2020-09-28 07:00:00	NQ	Futures	13108.88	13134.93	13086.01	13132.62	9916.0
2020-09-28 08:00:00	NQ	Futures	13132.04	13159.83	13122.48	13134.35	18554.0
2020-09-28 09:00:00	NQ	Futures	13134.93	13144.48	13027.83	13053.59	75830.0
2020-09-28 10:00:00	NQ	Futures	13053.3	13103.09	13009.01	13015.09	79350.0
2020-09-28 11:00:00	NQ	Futures	13015.38	13089.77	13011.33	13044.04	57906.0
2020-09-28 12:00:00	NQ	Futures	13044.04	13068.06	12998.59	13068.06	41767.0
2020-09-28 13:00:00	NQ	Futures	13067.77	13119.88	13042.88	13110.91	43338.0
2020-09-28 14:00:00	NQ	Futures	13110.91	13129.72	13078.2	13124.8	42017.0
2020-09-28 15:00:00	NQ	Futures	13124.8	13155.19	13091.51	13152.88	75208.0
2020-09-28 16:00:00	NQ	Futures	13153.75	13204.4	13147.67	13193.11	17350.0
2020-09-28 18:00:00	NQ	Futures	13185.88	13215.69	13180.09	13196.3	2896.0
2020-09-28 19:00:00	NQ	Futures	13196.01	13226.4	13195.72	13221.19	2808.0
2020-09-28 20:00:00	NQ	Futures	13220.61	13244.93	13211.93	13239.14	4596.0
2020-09-28 21:00:00	NQ	Futures	13239.72	13249.85	13219.17	13227.85	6044.0
2020-09-28 22:00:00	NQ	Futures	13227.85	13234.51	13209.04	13215.11	4062.0
2020-09-28 23:00:00	NQ	Futures	13215.4	13218.3	13196.3	13213.09	3870.0
2020-09-28 00:00:00	YM	Futures	30041.9	30064.0	30031.9	30054.1	1401.0
2020-09-28 01:00:00	YM	Futures	30054.1	30148.0	30054.1	30143.6	2343.0
2020-09-28 02:00:00	YM	Futures	30145.8	30175.7	30118.2	30119.3	3037.0
2020-09-28 03:00:00	YM	Futures	30118.2	30196.7	30080.6	30156.9	5394.0

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

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