PREVIEW / futures_1hour / 2021-06-10

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-06-10.parquet
  size:    59 KB
  rows:    1,808

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-06-10 00:00:00	ES	Futures	4747.82	4748.66	4746.41	4746.98	1762.0
2021-06-10 01:00:00	ES	Futures	4746.98	4746.98	4743.32	4745.29	4793.0
2021-06-10 02:00:00	ES	Futures	4745.01	4745.29	4740.8	4743.04	8531.0
2021-06-10 03:00:00	ES	Futures	4743.04	4744.45	4732.93	4743.89	25724.0
2021-06-10 04:00:00	ES	Futures	4743.89	4744.45	4735.74	4742.2	19740.0
2021-06-10 05:00:00	ES	Futures	4742.2	4744.45	4740.51	4743.61	10651.0
2021-06-10 06:00:00	ES	Futures	4743.89	4746.41	4742.48	4742.76	10257.0
2021-06-10 07:00:00	ES	Futures	4742.76	4746.13	4734.33	4741.08	28411.0
2021-06-10 08:00:00	ES	Futures	4741.08	4755.69	4728.15	4754.28	110611.0
2021-06-10 09:00:00	ES	Futures	4754.28	4774.23	4753.44	4771.14	174942.0
2021-06-10 10:00:00	ES	Futures	4771.14	4775.35	4740.8	4750.91	212934.0
2021-06-10 11:00:00	ES	Futures	4750.63	4762.99	4747.26	4762.15	137111.0
2021-06-10 12:00:00	ES	Futures	4762.43	4767.49	4758.22	4767.21	105608.0
2021-06-10 13:00:00	ES	Futures	4767.21	4769.17	4762.99	4769.17	85380.0
2021-06-10 14:00:00	ES	Futures	4769.17	4769.17	4761.31	4765.8	75569.0
2021-06-10 15:00:00	ES	Futures	4766.08	4766.36	4759.06	4763.55	146011.0
2021-06-10 16:00:00	ES	Futures	4763.55	4765.52	4761.31	4763.55	33722.0
2021-06-10 18:00:00	ES	Futures	4764.68	4764.96	4762.71	4763.27	2236.0
2021-06-10 19:00:00	ES	Futures	4763.55	4764.4	4761.59	4762.99	2046.0
2021-06-10 20:00:00	ES	Futures	4762.99	4765.8	4759.34	4764.96	6307.0
2021-06-10 21:00:00	ES	Futures	4765.24	4766.93	4763.83	4766.36	4118.0
2021-06-10 22:00:00	ES	Futures	4766.36	4766.36	4762.43	4764.4	2828.0
2021-06-10 23:00:00	ES	Futures	4764.68	4766.08	4763.83	4765.8	1498.0
2021-06-10 00:00:00	NQ	Futures	16019.22	16021.83	16013.14	16015.17	1286.0
2021-06-10 01:00:00	NQ	Futures	16015.75	16016.62	15999.25	16003.88	2795.0
2021-06-10 02:00:00	NQ	Futures	16003.59	16005.9	15964.8	15982.75	5541.0
2021-06-10 03:00:00	NQ	Futures	15983.32	15987.96	15949.45	15981.88	10245.0
2021-06-10 04:00:00	NQ	Futures	15981.59	15983.9	15938.74	15965.38	9573.0
2021-06-10 05:00:00	NQ	Futures	15965.66	15973.48	15944.24	15959.59	6757.0
2021-06-10 06:00:00	NQ	Futures	15959.01	15966.82	15940.19	15948.87	5317.0
2021-06-10 07:00:00	NQ	Futures	15948.3	15976.67	15917.61	15952.64	13221.0
2021-06-10 08:00:00	NQ	Futures	15952.64	16021.25	15894.45	16013.43	42610.0
2021-06-10 09:00:00	NQ	Futures	16014.01	16170.92	15993.17	16146.6	85371.0
2021-06-10 10:00:00	NQ	Futures	16147.18	16166.0	16009.96	16057.72	83191.0
2021-06-10 11:00:00	NQ	Futures	16057.43	16122.57	16035.72	16119.97	53921.0
2021-06-10 12:00:00	NQ	Futures	16119.97	16148.34	16111.28	16147.18	33846.0
2021-06-10 13:00:00	NQ	Futures	16147.18	16164.26	16120.83	16163.39	26881.0
2021-06-10 14:00:00	NQ	Futures	16163.39	16165.13	16136.76	16161.65	22865.0
2021-06-10 15:00:00	NQ	Futures	16161.94	16170.05	16131.26	16165.13	37100.0
2021-06-10 16:00:00	NQ	Futures	16165.13	16184.52	16161.94	16181.05	8677.0
2021-06-10 18:00:00	NQ	Futures	16183.37	16186.84	16171.79	16174.97	1844.0
2021-06-10 19:00:00	NQ	Futures	16175.55	16177.29	16166.57	16174.1	1582.0
2021-06-10 20:00:00	NQ	Futures	16174.39	16190.31	16168.89	16184.81	4124.0
2021-06-10 21:00:00	NQ	Futures	16185.1	16196.68	16179.89	16190.02	3068.0
2021-06-10 22:00:00	NQ	Futures	16189.44	16190.02	16176.42	16185.1	1963.0
2021-06-10 23:00:00	NQ	Futures	16185.1	16187.42	16179.6	16184.52	1269.0
2021-06-10 00:00:00	YM	Futures	38416.7	38416.7	38402.2	38404.4	35.0
2021-06-10 01:00:00	YM	Futures	38403.3	38403.3	38375.4	38386.5	30.0
2021-06-10 02:00:00	YM	Futures	38389.9	38396.6	38368.7	38387.7	76.0
2021-06-10 03:00:00	YM	Futures	38386.5	38394.4	38298.3	38394.4	401.0

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

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