PREVIEW / futures_1hour / 2022-08-05

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-08-05.parquet
  size:    57 KB
  rows:    1,643

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-05 00:00:00	ES	Futures	4717.32	4718.45	4715.62	4717.6	1778.0
2022-08-05 01:00:00	ES	Futures	4717.6	4717.89	4713.92	4717.32	2934.0
2022-08-05 02:00:00	ES	Futures	4717.32	4717.32	4711.09	4711.09	5858.0
2022-08-05 03:00:00	ES	Futures	4711.37	4715.05	4708.54	4712.5	11437.0
2022-08-05 04:00:00	ES	Futures	4712.5	4713.35	4702.31	4705.14	8369.0
2022-08-05 05:00:00	ES	Futures	4705.42	4708.26	4702.31	4706.84	7484.0
2022-08-05 06:00:00	ES	Futures	4706.84	4707.12	4699.76	4702.31	7934.0
2022-08-05 07:00:00	ES	Futures	4702.31	4711.37	4698.06	4710.52	12361.0
2022-08-05 08:00:00	ES	Futures	4710.52	4715.9	4649.9	4655.85	128701.0
2022-08-05 09:00:00	ES	Futures	4655.57	4683.89	4651.6	4681.91	245759.0
2022-08-05 10:00:00	ES	Futures	4681.91	4705.99	4679.08	4693.24	263961.0
2022-08-05 11:00:00	ES	Futures	4693.24	4693.81	4659.25	4666.05	235824.0
2022-08-05 12:00:00	ES	Futures	4665.76	4687.86	4665.48	4687.01	163419.0
2022-08-05 13:00:00	ES	Futures	4686.73	4698.06	4683.89	4687.29	144410.0
2022-08-05 14:00:00	ES	Futures	4687.29	4688.99	4674.83	4681.63	129104.0
2022-08-05 15:00:00	ES	Futures	4681.34	4701.17	4679.08	4697.77	226617.0
2022-08-05 16:00:00	ES	Futures	4697.77	4698.06	4690.98	4692.96	46157.0
2022-08-05 00:00:00	NQ	Futures	15469.95	15474.0	15462.43	15471.98	1223.0
2022-08-05 01:00:00	NQ	Futures	15470.24	15471.98	15449.41	15463.59	2030.0
2022-08-05 02:00:00	NQ	Futures	15463.3	15464.17	15436.69	15436.69	2436.0
2022-08-05 03:00:00	NQ	Futures	15436.4	15459.54	15430.04	15451.15	5457.0
2022-08-05 04:00:00	NQ	Futures	15451.44	15456.65	15402.56	15416.15	5257.0
2022-08-05 05:00:00	NQ	Futures	15416.44	15427.14	15395.91	15413.26	4299.0
2022-08-05 06:00:00	NQ	Futures	15413.55	15413.55	15381.73	15392.43	5618.0
2022-08-05 07:00:00	NQ	Futures	15393.3	15432.06	15376.24	15428.01	6793.0
2022-08-05 08:00:00	NQ	Futures	15428.01	15446.81	15178.4	15199.51	56175.0
2022-08-05 09:00:00	NQ	Futures	15198.93	15285.71	15164.22	15250.71	100102.0
2022-08-05 10:00:00	NQ	Futures	15251.57	15399.09	15233.93	15305.08	109616.0
2022-08-05 11:00:00	NQ	Futures	15305.66	15305.95	15138.77	15183.03	103467.0
2022-08-05 12:00:00	NQ	Futures	15183.6	15275.0	15180.13	15271.82	65365.0
2022-08-05 13:00:00	NQ	Futures	15271.53	15320.41	15246.37	15262.86	63478.0
2022-08-05 14:00:00	NQ	Futures	15263.43	15269.51	15208.77	15233.35	52115.0
2022-08-05 15:00:00	NQ	Futures	15233.64	15315.21	15222.36	15302.19	67972.0
2022-08-05 16:00:00	NQ	Futures	15301.9	15307.4	15276.16	15290.91	13821.0
2022-08-05 00:00:00	YM	Futures	36975.8	36986.0	36965.7	36982.6	556.0
2022-08-05 01:00:00	YM	Futures	36982.6	36986.0	36965.7	36982.6	493.0
2022-08-05 02:00:00	YM	Futures	36981.5	36983.7	36942.0	36944.2	1328.0
2022-08-05 03:00:00	YM	Futures	36945.4	36966.8	36927.3	36949.9	2826.0
2022-08-05 04:00:00	YM	Futures	36947.6	36947.6	36886.7	36905.9	2863.0
2022-08-05 05:00:00	YM	Futures	36904.7	36929.6	36884.4	36925.0	2215.0
2022-08-05 06:00:00	YM	Futures	36925.0	36925.0	36888.9	36904.7	2394.0
2022-08-05 07:00:00	YM	Futures	36905.9	36952.1	36879.9	36948.7	2888.0
2022-08-05 08:00:00	YM	Futures	36948.7	36987.1	36593.3	36632.8	23368.0
2022-08-05 09:00:00	YM	Futures	36631.7	36788.5	36604.6	36773.8	32321.0
2022-08-05 10:00:00	YM	Futures	36775.0	36900.2	36755.8	36864.1	23877.0
2022-08-05 11:00:00	YM	Futures	36865.2	36869.8	36663.3	36700.5	19111.0
2022-08-05 12:00:00	YM	Futures	36700.5	36873.1	36693.7	36863.0	13985.0
2022-08-05 13:00:00	YM	Futures	36861.9	36942.0	36842.7	36879.9	12495.0
2022-08-05 14:00:00	YM	Futures	36881.0	36890.1	36798.7	36865.2	9263.0
2022-08-05 15:00:00	YM	Futures	36864.1	36979.2	36843.8	36952.1	16336.0

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

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