PREVIEW / futures_1hour / 2021-07-30

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-07-30.parquet
  size:    54 KB
  rows:    1,586

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-07-30 00:00:00	ES	Futures	4932.19	4933.04	4929.94	4930.5	3775.0
2021-07-30 01:00:00	ES	Futures	4930.22	4930.5	4922.9	4924.03	15675.0
2021-07-30 02:00:00	ES	Futures	4924.03	4931.63	4922.9	4926.0	17834.0
2021-07-30 03:00:00	ES	Futures	4926.28	4930.79	4922.9	4928.82	30686.0
2021-07-30 04:00:00	ES	Futures	4928.82	4942.61	4925.72	4938.11	25531.0
2021-07-30 05:00:00	ES	Futures	4938.11	4938.95	4930.79	4932.48	16203.0
2021-07-30 06:00:00	ES	Futures	4932.48	4943.18	4930.5	4942.89	19304.0
2021-07-30 07:00:00	ES	Futures	4942.89	4943.18	4934.17	4935.01	23687.0
2021-07-30 08:00:00	ES	Futures	4935.01	4941.49	4929.38	4938.95	35540.0
2021-07-30 09:00:00	ES	Futures	4938.95	4957.54	4933.32	4953.88	176420.0
2021-07-30 10:00:00	ES	Futures	4953.88	4961.48	4944.02	4944.87	176614.0
2021-07-30 11:00:00	ES	Futures	4944.87	4951.9	4939.23	4942.89	137739.0
2021-07-30 12:00:00	ES	Futures	4942.61	4950.5	4941.2	4949.09	61959.0
2021-07-30 13:00:00	ES	Futures	4949.09	4951.34	4944.58	4947.96	62108.0
2021-07-30 14:00:00	ES	Futures	4948.24	4948.81	4935.85	4944.3	111855.0
2021-07-30 15:00:00	ES	Futures	4944.58	4948.53	4938.95	4944.58	251460.0
2021-07-30 16:00:00	ES	Futures	4944.87	4950.78	4943.74	4950.5	83553.0
2021-07-30 00:00:00	NQ	Futures	17199.25	17207.36	17194.32	17199.54	2010.0
2021-07-30 01:00:00	NQ	Futures	17198.09	17200.11	17162.17	17174.91	8304.0
2021-07-30 02:00:00	NQ	Futures	17174.62	17211.12	17174.62	17191.42	7452.0
2021-07-30 03:00:00	NQ	Futures	17192.29	17209.96	17176.94	17198.96	9670.0
2021-07-30 04:00:00	NQ	Futures	17198.96	17248.78	17191.13	17232.85	9215.0
2021-07-30 05:00:00	NQ	Futures	17232.27	17235.75	17213.73	17217.78	4786.0
2021-07-30 06:00:00	NQ	Futures	17217.78	17267.32	17214.89	17266.45	6993.0
2021-07-30 07:00:00	NQ	Futures	17266.74	17268.77	17221.84	17231.98	9350.0
2021-07-30 08:00:00	NQ	Futures	17232.56	17250.23	17202.43	17233.72	14511.0
2021-07-30 09:00:00	NQ	Futures	17234.59	17326.42	17208.8	17320.62	81182.0
2021-07-30 10:00:00	NQ	Futures	17320.91	17357.7	17288.18	17300.92	75010.0
2021-07-30 11:00:00	NQ	Futures	17300.92	17321.49	17276.88	17305.27	54494.0
2021-07-30 12:00:00	NQ	Futures	17304.98	17353.94	17301.21	17353.36	35044.0
2021-07-30 13:00:00	NQ	Futures	17352.78	17356.54	17321.2	17339.74	30707.0
2021-07-30 14:00:00	NQ	Futures	17340.03	17343.8	17294.84	17327.57	34035.0
2021-07-30 15:00:00	NQ	Futures	17327.86	17340.9	17305.85	17328.44	58099.0
2021-07-30 16:00:00	NQ	Futures	17329.89	17348.72	17326.71	17342.06	13317.0
2021-07-30 00:00:00	YM	Futures	38960.8	38972.0	38938.5	38944.1	807.0
2021-07-30 01:00:00	YM	Futures	38942.9	38945.2	38893.8	38899.4	2763.0
2021-07-30 02:00:00	YM	Futures	38899.4	38958.6	38882.6	38909.4	4214.0
2021-07-30 03:00:00	YM	Futures	38909.4	38942.9	38875.9	38926.2	5548.0
2021-07-30 04:00:00	YM	Futures	38928.4	39027.8	38902.7	38980.9	5424.0
2021-07-30 05:00:00	YM	Futures	38978.7	38985.4	38912.8	38927.3	2999.0
2021-07-30 06:00:00	YM	Futures	38926.2	39007.7	38906.1	39004.4	3839.0
2021-07-30 07:00:00	YM	Futures	39003.3	39011.1	38938.5	38947.4	3285.0
2021-07-30 08:00:00	YM	Futures	38946.3	38991.0	38909.4	38977.6	4788.0
2021-07-30 09:00:00	YM	Futures	38977.6	39098.2	38942.9	39050.2	23366.0
2021-07-30 10:00:00	YM	Futures	39049.1	39096.0	38947.4	38970.9	20831.0
2021-07-30 11:00:00	YM	Futures	38972.0	39029.0	38913.9	38948.5	14008.0
2021-07-30 12:00:00	YM	Futures	38947.4	38970.9	38921.7	38942.9	6759.0
2021-07-30 13:00:00	YM	Futures	38942.9	38949.6	38912.8	38929.5	5283.0
2021-07-30 14:00:00	YM	Futures	38931.8	38934.0	38831.2	38913.9	11727.0
2021-07-30 15:00:00	YM	Futures	38915.0	38972.0	38881.5	38917.2	14813.0

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

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