PREVIEW / futures_1hour / 2022-08-12

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-08-12.parquet
  size:    56 KB
  rows:    1,639

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-12 00:00:00	ES	Futures	4777.37	4778.79	4775.96	4776.24	3858.0
2022-08-12 01:00:00	ES	Futures	4776.24	4780.77	4775.96	4780.77	4746.0
2022-08-12 02:00:00	ES	Futures	4780.77	4784.74	4779.36	4783.04	6467.0
2022-08-12 03:00:00	ES	Futures	4783.32	4799.75	4778.79	4797.2	19663.0
2022-08-12 04:00:00	ES	Futures	4797.2	4801.45	4792.67	4794.37	13823.0
2022-08-12 05:00:00	ES	Futures	4794.09	4798.9	4792.95	4796.92	9763.0
2022-08-12 06:00:00	ES	Futures	4796.92	4797.2	4786.16	4788.42	15339.0
2022-08-12 07:00:00	ES	Futures	4788.14	4790.12	4781.34	4787.57	17368.0
2022-08-12 08:00:00	ES	Futures	4787.57	4795.79	4784.74	4794.94	26910.0
2022-08-12 09:00:00	ES	Futures	4794.65	4804.0	4787.57	4800.6	149786.0
2022-08-12 10:00:00	ES	Futures	4800.6	4804.0	4782.76	4798.62	216370.0
2022-08-12 11:00:00	ES	Futures	4798.9	4814.48	4797.2	4809.95	153134.0
2022-08-12 12:00:00	ES	Futures	4810.23	4820.71	4809.38	4818.73	88610.0
2022-08-12 13:00:00	ES	Futures	4818.73	4828.36	4817.31	4825.81	76718.0
2022-08-12 14:00:00	ES	Futures	4825.81	4837.71	4824.68	4836.29	81334.0
2022-08-12 15:00:00	ES	Futures	4836.29	4852.72	4834.88	4851.02	229101.0
2022-08-12 16:00:00	ES	Futures	4850.74	4851.87	4847.06	4850.46	77621.0
2022-08-12 00:00:00	NQ	Futures	15437.84	15443.34	15432.35	15435.24	1411.0
2022-08-12 01:00:00	NQ	Futures	15434.95	15449.99	15433.22	15449.13	1891.0
2022-08-12 02:00:00	NQ	Futures	15449.99	15463.3	15442.47	15458.09	2366.0
2022-08-12 03:00:00	NQ	Futures	15457.22	15508.13	15428.59	15491.64	9455.0
2022-08-12 04:00:00	NQ	Futures	15493.38	15512.47	15476.31	15485.28	6543.0
2022-08-12 05:00:00	NQ	Futures	15485.86	15509.29	15478.92	15497.43	4912.0
2022-08-12 06:00:00	NQ	Futures	15496.85	15497.43	15459.83	15467.06	6282.0
2022-08-12 07:00:00	NQ	Futures	15467.06	15470.53	15436.11	15462.14	6915.0
2022-08-12 08:00:00	NQ	Futures	15462.72	15496.56	15452.31	15493.67	11182.0
2022-08-12 09:00:00	NQ	Futures	15493.67	15544.57	15456.07	15532.14	68526.0
2022-08-12 10:00:00	NQ	Futures	15531.27	15575.52	15462.14	15540.81	95564.0
2022-08-12 11:00:00	NQ	Futures	15540.24	15606.76	15533.29	15569.16	66188.0
2022-08-12 12:00:00	NQ	Futures	15569.45	15618.62	15565.11	15597.22	33492.0
2022-08-12 13:00:00	NQ	Futures	15597.5	15633.37	15591.14	15623.83	30064.0
2022-08-12 14:00:00	NQ	Futures	15624.11	15669.24	15621.51	15667.5	37768.0
2022-08-12 15:00:00	NQ	Futures	15668.08	15715.23	15659.4	15710.89	80254.0
2022-08-12 16:00:00	NQ	Futures	15710.6	15713.78	15692.09	15711.47	16364.0
2022-08-12 00:00:00	YM	Futures	37623.5	37632.5	37614.5	37616.7	422.0
2022-08-12 01:00:00	YM	Futures	37614.5	37641.5	37614.5	37641.5	861.0
2022-08-12 02:00:00	YM	Futures	37641.5	37664.1	37635.9	37664.1	1209.0
2022-08-12 03:00:00	YM	Futures	37664.1	37787.1	37642.7	37770.2	4881.0
2022-08-12 04:00:00	YM	Futures	37771.3	37795.0	37740.8	37749.9	3435.0
2022-08-12 05:00:00	YM	Futures	37748.7	37779.2	37736.3	37769.0	3052.0
2022-08-12 06:00:00	YM	Futures	37770.2	37771.3	37683.3	37705.9	3976.0
2022-08-12 07:00:00	YM	Futures	37707.0	37718.3	37665.2	37704.7	3850.0
2022-08-12 08:00:00	YM	Futures	37704.7	37753.2	37686.7	37747.6	4557.0
2022-08-12 09:00:00	YM	Futures	37746.5	37799.5	37694.6	37757.8	18458.0
2022-08-12 10:00:00	YM	Futures	37752.1	37752.1	37639.3	37691.2	21956.0
2022-08-12 11:00:00	YM	Futures	37692.3	37825.5	37682.2	37809.7	15081.0
2022-08-12 12:00:00	YM	Futures	37809.7	37893.2	37807.4	37880.7	9532.0
2022-08-12 13:00:00	YM	Futures	37880.7	37929.3	37872.9	37904.4	8448.0
2022-08-12 14:00:00	YM	Futures	37905.6	37975.5	37885.3	37956.3	8683.0
2022-08-12 15:00:00	YM	Futures	37957.5	38056.8	37949.6	38047.7	15442.0

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

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