PREVIEW / futures_1hour / 2022-08-09

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-08-09.parquet
  size:    65 KB
  rows:    2,042

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-08-09 00:00:00	ES	Futures	4706.27	4706.84	4702.31	4704.01	2246.0
2022-08-09 01:00:00	ES	Futures	4704.01	4705.14	4700.61	4702.02	3671.0
2022-08-09 02:00:00	ES	Futures	4702.02	4702.31	4695.51	4699.76	5482.0
2022-08-09 03:00:00	ES	Futures	4699.76	4705.14	4691.54	4698.06	12806.0
2022-08-09 04:00:00	ES	Futures	4698.06	4702.02	4692.68	4700.04	7071.0
2022-08-09 05:00:00	ES	Futures	4700.32	4702.59	4694.38	4695.22	6639.0
2022-08-09 06:00:00	ES	Futures	4694.94	4696.64	4680.78	4685.03	17617.0
2022-08-09 07:00:00	ES	Futures	4685.03	4688.43	4673.98	4675.96	20076.0
2022-08-09 08:00:00	ES	Futures	4675.68	4684.46	4672.28	4681.63	22168.0
2022-08-09 09:00:00	ES	Futures	4681.63	4689.56	4668.6	4670.86	185400.0
2022-08-09 10:00:00	ES	Futures	4671.15	4682.48	4666.33	4673.13	177804.0
2022-08-09 11:00:00	ES	Futures	4673.13	4684.74	4661.8	4673.13	158635.0
2022-08-09 12:00:00	ES	Futures	4673.13	4675.96	4663.22	4668.03	114629.0
2022-08-09 13:00:00	ES	Futures	4668.31	4675.11	4661.52	4672.85	109587.0
2022-08-09 14:00:00	ES	Futures	4672.85	4675.96	4660.38	4669.73	127816.0
2022-08-09 15:00:00	ES	Futures	4669.73	4678.23	4666.9	4673.98	191715.0
2022-08-09 16:00:00	ES	Futures	4673.7	4679.36	4673.41	4678.8	37567.0
2022-08-09 18:00:00	ES	Futures	4678.23	4679.08	4675.4	4676.53	3454.0
2022-08-09 19:00:00	ES	Futures	4676.53	4679.36	4675.4	4678.51	2734.0
2022-08-09 20:00:00	ES	Futures	4678.51	4679.93	4668.88	4668.88	7503.0
2022-08-09 21:00:00	ES	Futures	4668.88	4677.38	4668.88	4673.7	7014.0
2022-08-09 22:00:00	ES	Futures	4673.98	4675.11	4668.03	4671.71	6905.0
2022-08-09 23:00:00	ES	Futures	4672.0	4673.41	4669.73	4670.3	2187.0
2022-08-09 00:00:00	NQ	Futures	15297.56	15299.88	15282.52	15291.78	1394.0
2022-08-09 01:00:00	NQ	Futures	15291.2	15292.65	15276.74	15280.21	1850.0
2022-08-09 02:00:00	NQ	Futures	15280.21	15280.79	15255.34	15272.11	2785.0
2022-08-09 03:00:00	NQ	Futures	15272.4	15298.72	15243.19	15261.99	7316.0
2022-08-09 04:00:00	NQ	Futures	15261.99	15276.74	15234.8	15266.33	5576.0
2022-08-09 05:00:00	NQ	Futures	15266.9	15274.71	15227.86	15232.77	4359.0
2022-08-09 06:00:00	NQ	Futures	15231.62	15237.98	15156.99	15174.06	12556.0
2022-08-09 07:00:00	NQ	Futures	15174.93	15194.31	15135.01	15145.14	12034.0
2022-08-09 08:00:00	NQ	Futures	15144.85	15174.93	15128.94	15157.57	12795.0
2022-08-09 09:00:00	NQ	Futures	15157.57	15170.3	15032.91	15041.88	86445.0
2022-08-09 10:00:00	NQ	Futures	15042.74	15112.45	15009.48	15071.38	86454.0
2022-08-09 11:00:00	NQ	Futures	15071.38	15118.24	15021.63	15054.31	70888.0
2022-08-09 12:00:00	NQ	Futures	15054.31	15063.57	14997.91	15022.5	55467.0
2022-08-09 13:00:00	NQ	Futures	15022.21	15077.74	15009.19	15068.2	45537.0
2022-08-09 14:00:00	NQ	Futures	15068.2	15098.57	15027.7	15076.01	49072.0
2022-08-09 15:00:00	NQ	Futures	15076.01	15109.56	15064.73	15077.45	62272.0
2022-08-09 16:00:00	NQ	Futures	15078.03	15106.09	15076.59	15104.93	11419.0
2022-08-09 18:00:00	NQ	Futures	15098.28	15104.93	15087.87	15093.36	2142.0
2022-08-09 19:00:00	NQ	Futures	15093.07	15103.48	15084.97	15101.75	2055.0
2022-08-09 20:00:00	NQ	Futures	15100.88	15104.64	15058.07	15062.12	4136.0
2022-08-09 21:00:00	NQ	Futures	15061.54	15088.44	15060.97	15072.25	3608.0
2022-08-09 22:00:00	NQ	Futures	15071.09	15073.98	15047.37	15062.99	3474.0
2022-08-09 23:00:00	NQ	Futures	15062.7	15068.78	15052.0	15055.76	1736.0
2022-08-09 00:00:00	YM	Futures	37095.4	37098.8	37066.1	37074.0	524.0
2022-08-09 01:00:00	YM	Futures	37069.5	37084.1	37052.5	37065.0	554.0
2022-08-09 02:00:00	YM	Futures	37063.8	37066.1	37030.0	37053.7	1155.0
2022-08-09 03:00:00	YM	Futures	37054.8	37085.3	36995.0	37040.1	3299.0

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

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