PREVIEW / futures_1hour / 2023-03-28

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-03-28.parquet
  size:    67 KB
  rows:    2,070

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
2023-03-28 00:00:00	ES	Futures	4452.91	4453.46	4450.97	4451.8	2966.0
2023-03-28 01:00:00	ES	Futures	4451.8	4453.19	4449.3	4452.35	4835.0
2023-03-28 02:00:00	ES	Futures	4452.63	4459.84	4452.35	4458.18	9468.0
2023-03-28 03:00:00	ES	Futures	4458.18	4464.0	4447.08	4448.75	22271.0
2023-03-28 04:00:00	ES	Futures	4448.47	4451.24	4443.2	4445.14	15397.0
2023-03-28 05:00:00	ES	Futures	4444.87	4447.36	4440.43	4441.54	11281.0
2023-03-28 06:00:00	ES	Futures	4441.26	4443.2	4437.1	4440.15	14269.0
2023-03-28 07:00:00	ES	Futures	4440.15	4448.47	4439.04	4444.59	14291.0
2023-03-28 08:00:00	ES	Futures	4444.31	4446.81	4434.33	4437.38	27740.0
2023-03-28 09:00:00	ES	Futures	4437.65	4442.92	4431.0	4436.82	141669.0
2023-03-28 10:00:00	ES	Futures	4436.54	4448.19	4426.28	4428.78	195101.0
2023-03-28 11:00:00	ES	Futures	4428.78	4444.87	4428.22	4442.92	128569.0
2023-03-28 12:00:00	ES	Futures	4443.2	4444.31	4432.38	4435.44	92024.0
2023-03-28 13:00:00	ES	Futures	4435.71	4437.1	4416.3	4417.96	133395.0
2023-03-28 14:00:00	ES	Futures	4417.96	4431.0	4416.58	4429.06	108443.0
2023-03-28 15:00:00	ES	Futures	4429.33	4439.87	4424.34	4439.04	192247.0
2023-03-28 16:00:00	ES	Futures	4439.04	4445.97	4438.49	4444.87	47242.0
2023-03-28 18:00:00	ES	Futures	4444.87	4447.36	4444.31	4445.42	4524.0
2023-03-28 19:00:00	ES	Futures	4445.7	4450.69	4445.42	4449.86	5211.0
2023-03-28 20:00:00	ES	Futures	4450.14	4455.68	4449.3	4454.85	10071.0
2023-03-28 21:00:00	ES	Futures	4454.85	4458.18	4454.3	4455.68	10046.0
2023-03-28 22:00:00	ES	Futures	4455.68	4457.9	4454.57	4456.24	6648.0
2023-03-28 23:00:00	ES	Futures	4456.24	4457.9	4454.3	4457.9	5178.0
2023-03-28 00:00:00	NQ	Futures	14425.65	14429.59	14414.11	14417.77	2602.0
2023-03-28 01:00:00	NQ	Futures	14417.2	14426.21	14406.22	14422.27	3120.0
2023-03-28 02:00:00	NQ	Futures	14422.55	14443.67	14418.33	14438.32	4756.0
2023-03-28 03:00:00	NQ	Futures	14438.88	14453.24	14366.81	14373.56	12990.0
2023-03-28 04:00:00	NQ	Futures	14373.56	14383.42	14360.61	14376.38	8668.0
2023-03-28 05:00:00	NQ	Futures	14375.82	14390.46	14368.5	14376.1	5882.0
2023-03-28 06:00:00	NQ	Futures	14375.25	14385.39	14362.02	14376.38	5444.0
2023-03-28 07:00:00	NQ	Futures	14376.66	14411.57	14369.62	14401.72	6942.0
2023-03-28 08:00:00	NQ	Futures	14402.28	14410.73	14367.09	14384.26	12909.0
2023-03-28 09:00:00	NQ	Futures	14383.42	14391.02	14283.47	14293.88	75587.0
2023-03-28 10:00:00	NQ	Futures	14294.17	14338.09	14246.58	14253.9	85543.0
2023-03-28 11:00:00	NQ	Futures	14253.62	14327.67	14251.09	14316.69	57229.0
2023-03-28 12:00:00	NQ	Futures	14316.97	14322.04	14261.79	14284.03	45471.0
2023-03-28 13:00:00	NQ	Futures	14284.31	14297.54	14228.84	14235.04	55744.0
2023-03-28 14:00:00	NQ	Futures	14235.04	14291.91	14231.1	14282.62	46078.0
2023-03-28 15:00:00	NQ	Futures	14283.47	14342.03	14276.71	14339.5	71690.0
2023-03-28 16:00:00	NQ	Futures	14339.78	14364.27	14339.5	14356.95	15388.0
2023-03-28 18:00:00	NQ	Futures	14354.14	14365.96	14350.48	14352.73	2582.0
2023-03-28 19:00:00	NQ	Futures	14353.01	14371.87	14350.19	14369.9	2740.0
2023-03-28 20:00:00	NQ	Futures	14370.47	14393.55	14368.78	14391.3	5000.0
2023-03-28 21:00:00	NQ	Futures	14391.3	14406.22	14385.11	14394.4	4631.0
2023-03-28 22:00:00	NQ	Futures	14394.96	14397.5	14380.32	14383.42	3640.0
2023-03-28 23:00:00	NQ	Futures	14383.7	14387.92	14373.28	14385.95	2841.0
2023-03-28 00:00:00	YM	Futures	36124.8	36127.0	36116.0	36123.7	654.0
2023-03-28 01:00:00	YM	Futures	36122.6	36137.0	36111.5	36137.0	1398.0
2023-03-28 02:00:00	YM	Futures	36137.0	36203.3	36137.0	36184.5	3091.0
2023-03-28 03:00:00	YM	Futures	36184.5	36236.4	36153.5	36166.8	4331.0

> showing 50 of 2,070 rows — these rows as CSV

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