PREVIEW / futures_1hour / 2022-10-18

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-10-18.parquet
  size:    69 KB
  rows:    2,081

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
2022-10-18 00:00:00	ES	Futures	4219.95	4245.04	4219.38	4232.63	36794.0
2022-10-18 01:00:00	ES	Futures	4232.63	4235.17	4221.64	4223.89	17039.0
2022-10-18 02:00:00	ES	Futures	4224.18	4239.96	4219.38	4227.56	28339.0
2022-10-18 03:00:00	ES	Futures	4227.28	4234.89	4209.8	4231.79	40999.0
2022-10-18 04:00:00	ES	Futures	4231.79	4233.2	4205.57	4206.42	31701.0
2022-10-18 05:00:00	ES	Futures	4206.7	4214.31	4198.52	4213.75	35782.0
2022-10-18 06:00:00	ES	Futures	4213.46	4231.22	4210.93	4216.56	33494.0
2022-10-18 07:00:00	ES	Futures	4216.56	4241.93	4214.87	4236.86	42611.0
2022-10-18 08:00:00	ES	Futures	4237.14	4257.72	4235.73	4254.9	78896.0
2022-10-18 09:00:00	ES	Futures	4254.9	4259.13	4225.02	4232.35	347448.0
2022-10-18 10:00:00	ES	Futures	4232.35	4246.73	4208.11	4214.31	364709.0
2022-10-18 11:00:00	ES	Futures	4214.31	4219.67	4168.92	4187.81	386190.0
2022-10-18 12:00:00	ES	Futures	4188.09	4213.46	4180.48	4201.91	217099.0
2022-10-18 13:00:00	ES	Futures	4201.91	4224.46	4187.53	4219.95	203497.0
2022-10-18 14:00:00	ES	Futures	4220.23	4223.05	4175.69	4190.35	261860.0
2022-10-18 15:00:00	ES	Futures	4190.35	4212.05	4178.79	4210.08	348900.0
2022-10-18 16:00:00	ES	Futures	4210.08	4241.65	4198.52	4237.42	131661.0
2022-10-18 18:00:00	ES	Futures	4239.4	4241.65	4230.38	4239.4	11088.0
2022-10-18 19:00:00	ES	Futures	4239.68	4254.62	4239.12	4243.63	21738.0
2022-10-18 20:00:00	ES	Futures	4243.34	4249.83	4236.58	4247.01	22548.0
2022-10-18 21:00:00	ES	Futures	4247.01	4255.75	4242.5	4251.24	14503.0
2022-10-18 22:00:00	ES	Futures	4251.24	4251.52	4239.12	4243.63	12356.0
2022-10-18 23:00:00	ES	Futures	4243.63	4245.32	4237.42	4241.93	7593.0
2022-10-18 00:00:00	NQ	Futures	12983.97	13059.54	12979.37	13023.91	14330.0
2022-10-18 01:00:00	NQ	Futures	13023.33	13032.53	12984.83	12994.6	6850.0
2022-10-18 02:00:00	NQ	Futures	12993.45	13047.47	12972.48	13000.06	12561.0
2022-10-18 03:00:00	NQ	Futures	12999.49	13030.23	12945.47	13022.18	17709.0
2022-10-18 04:00:00	NQ	Futures	13022.47	13027.36	12937.71	12940.58	15808.0
2022-10-18 05:00:00	NQ	Futures	12940.3	12979.37	12915.59	12977.07	17573.0
2022-10-18 06:00:00	NQ	Futures	12976.5	13021.9	12963.86	12973.63	14765.0
2022-10-18 07:00:00	NQ	Futures	12973.63	13051.78	12968.74	13033.39	17846.0
2022-10-18 08:00:00	NQ	Futures	13033.96	13100.34	13028.51	13091.43	27378.0
2022-10-18 09:00:00	NQ	Futures	13092.29	13138.55	12978.51	12995.75	102938.0
2022-10-18 10:00:00	NQ	Futures	12995.46	13039.14	12888.29	12922.48	103904.0
2022-10-18 11:00:00	NQ	Futures	12922.77	12937.71	12738.31	12822.78	114620.0
2022-10-18 12:00:00	NQ	Futures	12823.07	12926.5	12791.17	12865.02	68029.0
2022-10-18 13:00:00	NQ	Futures	12865.59	12935.12	12811.57	12920.18	56910.0
2022-10-18 14:00:00	NQ	Futures	12920.47	12928.23	12736.01	12802.38	70661.0
2022-10-18 15:00:00	NQ	Futures	12802.95	12892.31	12755.26	12875.36	79591.0
2022-10-18 16:00:00	NQ	Futures	12875.36	13031.38	12822.49	13013.28	43611.0
2022-10-18 18:00:00	NQ	Futures	13010.4	13031.95	12994.89	13022.76	4460.0
2022-10-18 19:00:00	NQ	Futures	13023.62	13082.24	13021.32	13038.27	8197.0
2022-10-18 20:00:00	NQ	Futures	13036.55	13056.09	13005.81	13043.45	8030.0
2022-10-18 21:00:00	NQ	Futures	13044.6	13076.2	13031.95	13059.25	5931.0
2022-10-18 22:00:00	NQ	Futures	13059.25	13061.55	13016.44	13031.67	5084.0
2022-10-18 23:00:00	NQ	Futures	13031.67	13036.84	13010.4	13023.91	3610.0
2022-10-18 00:00:00	YM	Futures	34333.6	34527.8	34331.4	34434.6	4164.0
2022-10-18 01:00:00	YM	Futures	34434.6	34451.5	34353.8	34368.4	1772.0
2022-10-18 02:00:00	YM	Futures	34372.9	34487.4	34337.0	34398.7	2917.0
2022-10-18 03:00:00	YM	Futures	34396.5	34451.5	34273.0	34431.3	4463.0

> showing 50 of 2,081 rows — these rows as CSV

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