PREVIEW / futures_1hour / 2020-11-06

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-11-06.parquet
  size:    53 KB
  rows:    1,540

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
2020-11-06 00:00:00	ES	Futures	3896.11	3905.08	3894.43	3903.12	9229.0
2020-11-06 01:00:00	ES	Futures	3903.4	3909.56	3898.64	3903.4	8396.0
2020-11-06 02:00:00	ES	Futures	3903.4	3914.88	3901.16	3910.96	15402.0
2020-11-06 03:00:00	ES	Futures	3910.96	3923.84	3898.36	3900.04	32607.0
2020-11-06 04:00:00	ES	Futures	3900.04	3900.6	3877.63	3879.87	40299.0
2020-11-06 05:00:00	ES	Futures	3880.15	3898.36	3872.87	3893.59	34099.0
2020-11-06 06:00:00	ES	Futures	3893.59	3902.28	3891.63	3897.8	18893.0
2020-11-06 07:00:00	ES	Futures	3897.8	3905.92	3885.47	3887.43	24211.0
2020-11-06 08:00:00	ES	Futures	3887.71	3925.52	3882.67	3921.6	77122.0
2020-11-06 09:00:00	ES	Futures	3921.6	3942.61	3894.99	3902.0	233032.0
2020-11-06 10:00:00	ES	Futures	3902.28	3927.49	3899.2	3909.0	179710.0
2020-11-06 11:00:00	ES	Futures	3909.0	3931.69	3906.48	3925.8	189254.0
2020-11-06 12:00:00	ES	Futures	3926.08	3930.57	3915.72	3923.0	149830.0
2020-11-06 13:00:00	ES	Futures	3923.0	3931.13	3922.44	3927.2	74266.0
2020-11-06 14:00:00	ES	Futures	3926.92	3930.57	3919.08	3921.32	82429.0
2020-11-06 15:00:00	ES	Futures	3921.32	3938.97	3912.64	3923.28	238826.0
2020-11-06 16:00:00	ES	Futures	3923.28	3933.37	3921.88	3932.53	52306.0
2020-11-06 00:00:00	NQ	Futures	13810.55	13864.39	13806.21	13853.97	5938.0
2020-11-06 01:00:00	NQ	Futures	13856.58	13866.71	13813.74	13846.16	4923.0
2020-11-06 02:00:00	NQ	Futures	13846.16	13893.34	13830.53	13866.13	7602.0
2020-11-06 03:00:00	NQ	Futures	13866.71	13926.92	13834.29	13841.24	10411.0
2020-11-06 04:00:00	NQ	Futures	13841.52	13855.71	13779.87	13784.79	10759.0
2020-11-06 05:00:00	NQ	Futures	13785.66	13834.87	13741.95	13825.31	12036.0
2020-11-06 06:00:00	NQ	Futures	13825.03	13870.18	13821.26	13843.26	7923.0
2020-11-06 07:00:00	NQ	Futures	13842.1	13883.5	13805.05	13822.71	9598.0
2020-11-06 08:00:00	NQ	Futures	13823.87	13922.87	13799.84	13919.39	25904.0
2020-11-06 09:00:00	NQ	Futures	13919.68	13979.31	13759.32	13777.26	86085.0
2020-11-06 10:00:00	NQ	Futures	13777.26	13921.42	13764.82	13860.92	66960.0
2020-11-06 11:00:00	NQ	Futures	13860.63	13974.68	13849.63	13950.65	60598.0
2020-11-06 12:00:00	NQ	Futures	13951.52	13983.65	13925.18	13968.02	48728.0
2020-11-06 13:00:00	NQ	Futures	13968.31	14009.42	13963.97	13991.18	41201.0
2020-11-06 14:00:00	NQ	Futures	13990.6	14012.6	13948.34	13965.71	41018.0
2020-11-06 15:00:00	NQ	Futures	13964.84	14020.71	13928.65	13987.13	51073.0
2020-11-06 16:00:00	NQ	Futures	13987.71	14007.97	13980.18	14003.92	10129.0
2020-11-06 00:00:00	YM	Futures	31103.3	31153.0	31083.4	31133.1	3068.0
2020-11-06 01:00:00	YM	Futures	31134.2	31182.9	31102.2	31127.6	2363.0
2020-11-06 02:00:00	YM	Futures	31130.9	31228.2	31125.4	31222.7	4348.0
2020-11-06 03:00:00	YM	Futures	31222.7	31304.5	31106.6	31122.1	10283.0
2020-11-06 04:00:00	YM	Futures	31122.1	31124.3	30954.0	30978.4	9663.0
2020-11-06 05:00:00	YM	Futures	30979.5	31123.2	30919.8	31087.8	9042.0
2020-11-06 06:00:00	YM	Futures	31090.0	31155.2	31055.7	31114.3	5583.0
2020-11-06 07:00:00	YM	Futures	31113.2	31169.6	31017.0	31020.4	5311.0
2020-11-06 08:00:00	YM	Futures	31020.4	31334.4	30975.0	31296.8	15146.0
2020-11-06 09:00:00	YM	Futures	31300.1	31462.6	31045.8	31107.7	38859.0
2020-11-06 10:00:00	YM	Futures	31107.7	31279.1	31072.3	31138.7	20628.0
2020-11-06 11:00:00	YM	Futures	31138.7	31293.5	31121.0	31244.8	18130.0
2020-11-06 12:00:00	YM	Futures	31245.9	31283.5	31140.9	31187.3	11555.0
2020-11-06 13:00:00	YM	Futures	31188.4	31245.9	31185.1	31207.2	5999.0
2020-11-06 14:00:00	YM	Futures	31208.3	31248.1	31154.1	31188.4	6213.0
2020-11-06 15:00:00	YM	Futures	31186.2	31324.4	31116.6	31196.2	15868.0

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

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