PREVIEW / futures_1hour / 2021-02-25

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-02-25.parquet
  size:    68 KB
  rows:    1,973

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-02-25 00:00:00	ES	Futures	4413.2	4416.57	4412.64	4412.92	7211.0
2021-02-25 01:00:00	ES	Futures	4412.92	4416.0	4410.39	4415.44	6334.0
2021-02-25 02:00:00	ES	Futures	4415.16	4415.72	4405.06	4408.43	13129.0
2021-02-25 03:00:00	ES	Futures	4408.43	4410.11	4398.6	4401.69	30335.0
2021-02-25 04:00:00	ES	Futures	4401.69	4402.81	4394.67	4399.73	24033.0
2021-02-25 05:00:00	ES	Futures	4399.73	4404.5	4394.39	4403.94	17797.0
2021-02-25 06:00:00	ES	Futures	4403.94	4406.18	4385.41	4391.03	36013.0
2021-02-25 07:00:00	ES	Futures	4391.31	4396.08	4384.57	4389.34	31380.0
2021-02-25 08:00:00	ES	Futures	4389.34	4395.52	4383.45	4389.34	44020.0
2021-02-25 09:00:00	ES	Futures	4389.34	4402.81	4382.04	4392.99	181200.0
2021-02-25 10:00:00	ES	Futures	4392.99	4393.27	4354.54	4370.54	418889.0
2021-02-25 11:00:00	ES	Futures	4370.54	4377.83	4337.42	4340.51	308184.0
2021-02-25 12:00:00	ES	Futures	4340.51	4346.68	4299.53	4302.05	430595.0
2021-02-25 13:00:00	ES	Futures	4302.05	4325.35	4288.86	4315.25	383977.0
2021-02-25 14:00:00	ES	Futures	4315.25	4343.87	4310.76	4315.53	235692.0
2021-02-25 15:00:00	ES	Futures	4315.25	4321.42	4277.64	4295.88	490495.0
2021-02-25 16:00:00	ES	Futures	4295.88	4311.88	4287.74	4290.83	84444.0
2021-02-25 18:00:00	ES	Futures	4292.23	4304.86	4281.0	4289.14	24970.0
2021-02-25 19:00:00	ES	Futures	4289.42	4295.88	4271.74	4293.63	49308.0
2021-02-25 20:00:00	ES	Futures	4293.35	4306.55	4289.42	4301.77	40614.0
2021-02-25 21:00:00	ES	Futures	4301.49	4315.53	4300.93	4304.58	29941.0
2021-02-25 22:00:00	ES	Futures	4304.3	4309.91	4292.79	4297.56	22320.0
2021-02-25 23:00:00	ES	Futures	4297.84	4301.49	4280.44	4284.37	17887.0
2021-02-25 00:00:00	NQ	Futures	15431.16	15452.58	15430.58	15441.29	4581.0
2021-02-25 01:00:00	NQ	Futures	15441.58	15460.1	15426.53	15456.92	4148.0
2021-02-25 02:00:00	NQ	Futures	15458.08	15458.66	15375.88	15390.06	7443.0
2021-02-25 03:00:00	NQ	Futures	15390.93	15400.48	15309.02	15337.67	17930.0
2021-02-25 04:00:00	NQ	Futures	15338.54	15339.41	15265.02	15297.44	16102.0
2021-02-25 05:00:00	NQ	Futures	15296.28	15349.25	15271.68	15347.22	9274.0
2021-02-25 06:00:00	NQ	Futures	15347.8	15361.7	15219.58	15252.29	20422.0
2021-02-25 07:00:00	NQ	Futures	15251.71	15291.07	15234.92	15254.89	16758.0
2021-02-25 08:00:00	NQ	Futures	15254.03	15309.02	15227.4	15282.68	21897.0
2021-02-25 09:00:00	NQ	Futures	15282.68	15386.3	15230.29	15304.97	79720.0
2021-02-25 10:00:00	NQ	Futures	15305.26	15308.73	15115.68	15202.8	127174.0
2021-02-25 11:00:00	NQ	Futures	15202.22	15245.92	15032.32	15038.11	96004.0
2021-02-25 12:00:00	NQ	Futures	15037.53	15069.95	14858.08	14878.34	112329.0
2021-02-25 13:00:00	NQ	Futures	14878.34	15006.85	14819.3	14945.2	91495.0
2021-02-25 14:00:00	NQ	Futures	14944.04	15073.71	14927.83	14943.75	66140.0
2021-02-25 15:00:00	NQ	Futures	14943.17	14964.88	14777.33	14849.4	113479.0
2021-02-25 16:00:00	NQ	Futures	14849.11	14911.63	14794.12	14805.11	19366.0
2021-02-25 18:00:00	NQ	Futures	14821.9	14875.45	14768.94	14794.69	12893.0
2021-02-25 19:00:00	NQ	Futures	14793.25	14823.06	14706.71	14787.75	23559.0
2021-02-25 20:00:00	NQ	Futures	14788.62	14840.43	14753.6	14820.17	16619.0
2021-02-25 21:00:00	NQ	Futures	14821.32	14896.29	14807.14	14829.72	14909.0
2021-02-25 22:00:00	NQ	Futures	14831.16	14863.0	14778.78	14806.56	9093.0
2021-02-25 23:00:00	NQ	Futures	14807.43	14826.82	14729.86	14753.02	9367.0
2021-02-25 00:00:00	YM	Futures	35507.6	35529.7	35498.7	35500.9	1659.0
2021-02-25 01:00:00	YM	Futures	35499.8	35512.0	35483.2	35505.3	1797.0
2021-02-25 02:00:00	YM	Futures	35505.3	35507.6	35443.2	35484.3	3329.0
2021-02-25 03:00:00	YM	Futures	35483.2	35493.1	35429.9	35443.2	6846.0

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

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