PREVIEW / futures_1hour / 2021-06-04

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-06-04.parquet
  size:    52 KB
  rows:    1,562

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-04 00:00:00	ES	Futures	4712.42	4713.26	4709.61	4711.01	5616.0
2021-06-04 01:00:00	ES	Futures	4711.01	4712.7	4704.27	4705.11	8353.0
2021-06-04 02:00:00	ES	Futures	4705.11	4713.54	4703.71	4711.01	10099.0
2021-06-04 03:00:00	ES	Futures	4711.01	4715.79	4708.76	4710.73	15714.0
2021-06-04 04:00:00	ES	Futures	4710.45	4714.67	4707.08	4708.76	10775.0
2021-06-04 05:00:00	ES	Futures	4709.05	4712.42	4707.08	4711.29	10627.0
2021-06-04 06:00:00	ES	Futures	4711.29	4712.14	4702.02	4709.33	13266.0
2021-06-04 07:00:00	ES	Futures	4709.61	4715.51	4709.61	4714.67	15984.0
2021-06-04 08:00:00	ES	Futures	4714.38	4731.8	4711.86	4728.71	84947.0
2021-06-04 09:00:00	ES	Futures	4728.71	4740.23	4727.87	4737.42	152490.0
2021-06-04 10:00:00	ES	Futures	4737.14	4744.73	4736.86	4742.76	140258.0
2021-06-04 11:00:00	ES	Futures	4742.76	4746.13	4739.67	4741.36	82345.0
2021-06-04 12:00:00	ES	Futures	4741.36	4744.73	4739.67	4744.45	48815.0
2021-06-04 13:00:00	ES	Futures	4744.45	4748.66	4743.04	4747.54	50925.0
2021-06-04 14:00:00	ES	Futures	4747.54	4753.16	4747.54	4751.47	78190.0
2021-06-04 15:00:00	ES	Futures	4751.19	4756.25	4749.51	4752.03	160327.0
2021-06-04 16:00:00	ES	Futures	4752.03	4752.6	4748.1	4751.47	57434.0
2021-06-04 00:00:00	NQ	Futures	15666.91	15668.35	15652.72	15657.93	2367.0
2021-06-04 01:00:00	NQ	Futures	15658.51	15669.51	15631.88	15635.93	5465.0
2021-06-04 02:00:00	NQ	Futures	15635.35	15664.01	15624.06	15651.56	5881.0
2021-06-04 03:00:00	NQ	Futures	15652.14	15685.72	15638.54	15663.14	9379.0
2021-06-04 04:00:00	NQ	Futures	15662.56	15686.59	15654.17	15661.12	5966.0
2021-06-04 05:00:00	NQ	Futures	15662.56	15681.96	15656.48	15675.59	5356.0
2021-06-04 06:00:00	NQ	Futures	15675.59	15680.22	15632.75	15672.99	7247.0
2021-06-04 07:00:00	NQ	Futures	15673.27	15699.04	15673.27	15698.17	7581.0
2021-06-04 08:00:00	NQ	Futures	15698.17	15757.81	15663.72	15746.52	41878.0
2021-06-04 09:00:00	NQ	Futures	15746.52	15869.84	15739.86	15862.32	72807.0
2021-06-04 10:00:00	NQ	Futures	15862.89	15929.48	15862.89	15905.45	73324.0
2021-06-04 11:00:00	NQ	Futures	15905.45	15944.82	15899.95	15929.19	39481.0
2021-06-04 12:00:00	NQ	Futures	15929.48	15942.51	15918.19	15934.11	21085.0
2021-06-04 13:00:00	NQ	Futures	15934.11	15954.66	15926.87	15950.9	23191.0
2021-06-04 14:00:00	NQ	Futures	15950.9	15961.32	15946.85	15951.19	24875.0
2021-06-04 15:00:00	NQ	Futures	15951.19	15961.03	15929.48	15941.35	50194.0
2021-06-04 16:00:00	NQ	Futures	15941.64	15944.53	15929.48	15937.58	10680.0
2021-06-04 00:00:00	YM	Futures	38521.4	38522.5	38499.1	38504.7	976.0
2021-06-04 01:00:00	YM	Futures	38504.7	38514.7	38452.4	38457.9	1498.0
2021-06-04 02:00:00	YM	Futures	38455.7	38514.7	38446.8	38500.2	1625.0
2021-06-04 03:00:00	YM	Futures	38501.4	38530.3	38482.4	38486.9	2115.0
2021-06-04 04:00:00	YM	Futures	38483.5	38505.8	38449.0	38465.7	1958.0
2021-06-04 05:00:00	YM	Futures	38466.8	38485.8	38442.3	38476.9	1745.0
2021-06-04 06:00:00	YM	Futures	38476.9	38480.2	38397.8	38453.5	3205.0
2021-06-04 07:00:00	YM	Futures	38454.6	38492.4	38454.6	38470.2	2843.0
2021-06-04 08:00:00	YM	Futures	38470.2	38625.0	38461.3	38601.6	11012.0
2021-06-04 09:00:00	YM	Futures	38601.6	38660.6	38549.3	38589.4	20362.0
2021-06-04 10:00:00	YM	Futures	38588.2	38664.0	38557.1	38658.4	15795.0
2021-06-04 11:00:00	YM	Futures	38658.4	38674.0	38580.4	38598.3	11758.0
2021-06-04 12:00:00	YM	Futures	38598.3	38633.9	38588.2	38627.2	5289.0
2021-06-04 13:00:00	YM	Futures	38628.3	38656.2	38617.2	38650.6	5564.0
2021-06-04 14:00:00	YM	Futures	38650.6	38692.9	38648.4	38685.1	6611.0
2021-06-04 15:00:00	YM	Futures	38684.0	38710.8	38664.0	38696.3	11647.0

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

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