PREVIEW / futures_1hour / 2021-03-29

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-03-29.parquet
  size:    63 KB
  rows:    1,921

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-03-29 00:00:00	ES	Futures	4434.82	4435.94	4429.2	4431.73	8676.0
2021-03-29 01:00:00	ES	Futures	4431.73	4432.57	4415.43	4424.7	27013.0
2021-03-29 02:00:00	ES	Futures	4424.7	4433.98	4420.21	4430.89	17170.0
2021-03-29 03:00:00	ES	Futures	4430.89	4441.0	4428.92	4432.57	26153.0
2021-03-29 04:00:00	ES	Futures	4432.57	4432.57	4422.74	4428.08	17877.0
2021-03-29 05:00:00	ES	Futures	4428.08	4438.47	4426.67	4437.63	11708.0
2021-03-29 06:00:00	ES	Futures	4437.63	4441.56	4435.66	4438.47	11977.0
2021-03-29 07:00:00	ES	Futures	4438.19	4443.81	4435.38	4436.51	20307.0
2021-03-29 08:00:00	ES	Futures	4436.51	4439.03	4430.32	4432.57	22735.0
2021-03-29 09:00:00	ES	Futures	4432.85	4451.4	4429.76	4433.42	226929.0
2021-03-29 10:00:00	ES	Futures	4433.7	4436.79	4420.77	4423.02	372895.0
2021-03-29 11:00:00	ES	Futures	4423.02	4442.13	4418.8	4439.6	255443.0
2021-03-29 12:00:00	ES	Futures	4439.6	4453.36	4427.23	4452.8	168713.0
2021-03-29 13:00:00	ES	Futures	4452.8	4462.07	4448.87	4450.55	174294.0
2021-03-29 14:00:00	ES	Futures	4450.55	4454.77	4442.13	4448.59	181565.0
2021-03-29 15:00:00	ES	Futures	4448.87	4463.2	4445.5	4452.52	285327.0
2021-03-29 16:00:00	ES	Futures	4452.8	4456.17	4450.27	4453.93	47272.0
2021-03-29 18:00:00	ES	Futures	4456.45	4460.11	4454.77	4456.17	5295.0
2021-03-29 19:00:00	ES	Futures	4456.45	4458.7	4453.08	4457.3	5449.0
2021-03-29 20:00:00	ES	Futures	4457.58	4457.58	4447.18	4448.87	10971.0
2021-03-29 21:00:00	ES	Futures	4448.87	4449.43	4444.93	4447.46	9330.0
2021-03-29 22:00:00	ES	Futures	4447.18	4453.36	4446.06	4448.03	9391.0
2021-03-29 23:00:00	ES	Futures	4448.03	4456.45	4447.46	4455.61	6500.0
2021-03-29 00:00:00	NQ	Futures	14929.56	14934.77	14886.14	14909.59	6362.0
2021-03-29 01:00:00	NQ	Futures	14909.59	14916.24	14830.84	14873.11	11676.0
2021-03-29 02:00:00	NQ	Futures	14873.69	14931.88	14854.0	14917.4	8597.0
2021-03-29 03:00:00	NQ	Futures	14915.67	14959.96	14909.01	14937.96	11106.0
2021-03-29 04:00:00	NQ	Futures	14937.67	14945.48	14881.79	14918.27	10218.0
2021-03-29 05:00:00	NQ	Futures	14917.69	14984.85	14912.19	14978.2	7499.0
2021-03-29 06:00:00	NQ	Futures	14977.33	14999.91	14961.41	14989.49	6587.0
2021-03-29 07:00:00	NQ	Futures	14988.91	15018.44	14988.91	14997.88	10217.0
2021-03-29 08:00:00	NQ	Futures	14996.72	15003.38	14949.25	14955.04	11143.0
2021-03-29 09:00:00	NQ	Futures	14955.62	15028.28	14882.66	14884.98	75850.0
2021-03-29 10:00:00	NQ	Futures	14885.56	14945.77	14840.11	14896.85	93129.0
2021-03-29 11:00:00	NQ	Futures	14897.72	14958.8	14857.48	14937.09	63606.0
2021-03-29 12:00:00	NQ	Futures	14936.8	15019.88	14885.56	15016.12	49278.0
2021-03-29 13:00:00	NQ	Futures	15016.7	15057.23	14991.22	14999.91	47511.0
2021-03-29 14:00:00	NQ	Futures	15000.49	15007.44	14921.17	14943.17	52000.0
2021-03-29 15:00:00	NQ	Futures	14944.04	15020.46	14943.75	15003.09	55613.0
2021-03-29 16:00:00	NQ	Futures	15002.51	15028.57	14999.04	15012.36	8136.0
2021-03-29 18:00:00	NQ	Futures	15024.81	15035.23	15017.86	15022.78	2167.0
2021-03-29 19:00:00	NQ	Futures	15023.36	15033.2	15010.62	15028.86	2736.0
2021-03-29 20:00:00	NQ	Futures	15028.86	15028.86	14983.7	14990.93	5583.0
2021-03-29 21:00:00	NQ	Futures	14990.93	14992.09	14955.91	14971.54	5058.0
2021-03-29 22:00:00	NQ	Futures	14970.38	14981.96	14946.93	14948.96	4660.0
2021-03-29 23:00:00	NQ	Futures	14948.96	14988.91	14943.75	14983.12	4138.0
2021-03-29 00:00:00	YM	Futures	36597.8	36603.4	36564.4	36582.3	1333.0
2021-03-29 01:00:00	YM	Futures	36582.3	36586.7	36473.1	36532.1	4508.0
2021-03-29 02:00:00	YM	Futures	36532.1	36571.1	36487.6	36551.1	3020.0
2021-03-29 03:00:00	YM	Futures	36552.2	36639.1	36529.9	36553.3	8207.0

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

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