PREVIEW / futures_1hour / 2021-03-26

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-03-26.parquet
  size:    52 KB
  rows:    1,545

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-26 00:00:00	ES	Futures	4398.29	4400.54	4397.45	4399.98	3574.0
2021-03-26 01:00:00	ES	Futures	4399.98	4406.16	4398.57	4405.6	7732.0
2021-03-26 02:00:00	ES	Futures	4405.32	4407.28	4402.23	4402.51	8187.0
2021-03-26 03:00:00	ES	Futures	4402.51	4404.48	4396.89	4399.7	12378.0
2021-03-26 04:00:00	ES	Futures	4399.7	4403.91	4395.77	4398.01	23940.0
2021-03-26 05:00:00	ES	Futures	4397.73	4399.98	4393.24	4396.61	11819.0
2021-03-26 06:00:00	ES	Futures	4396.61	4398.57	4390.71	4394.08	15848.0
2021-03-26 07:00:00	ES	Futures	4393.8	4397.17	4388.74	4394.92	23806.0
2021-03-26 08:00:00	ES	Futures	4394.92	4399.14	4387.62	4394.64	42005.0
2021-03-26 09:00:00	ES	Futures	4394.36	4403.63	4392.67	4401.95	182169.0
2021-03-26 10:00:00	ES	Futures	4401.95	4414.03	4399.7	4405.04	236841.0
2021-03-26 11:00:00	ES	Futures	4405.04	4409.53	4394.36	4408.69	208433.0
2021-03-26 12:00:00	ES	Futures	4408.41	4421.05	4404.76	4415.71	158226.0
2021-03-26 13:00:00	ES	Futures	4415.71	4421.33	4402.79	4409.81	151685.0
2021-03-26 14:00:00	ES	Futures	4409.53	4413.19	4390.71	4412.62	296746.0
2021-03-26 15:00:00	ES	Futures	4412.62	4459.55	4407.85	4453.93	366723.0
2021-03-26 16:00:00	ES	Futures	4453.93	4457.86	4451.68	4453.08	125954.0
2021-03-26 00:00:00	NQ	Futures	14852.84	14868.48	14850.82	14862.69	2910.0
2021-03-26 01:00:00	NQ	Futures	14864.14	14904.95	14859.79	14901.77	4569.0
2021-03-26 02:00:00	NQ	Futures	14901.48	14915.95	14887.87	14892.22	5126.0
2021-03-26 03:00:00	NQ	Futures	14892.8	14901.48	14836.63	14849.66	8553.0
2021-03-26 04:00:00	NQ	Futures	14849.66	14862.11	14825.92	14830.55	9764.0
2021-03-26 05:00:00	NQ	Futures	14830.55	14844.45	14808.26	14839.53	7504.0
2021-03-26 06:00:00	NQ	Futures	14839.24	14854.87	14793.79	14795.24	9163.0
2021-03-26 07:00:00	NQ	Futures	14794.95	14808.84	14721.41	14749.78	19847.0
2021-03-26 08:00:00	NQ	Futures	14750.07	14770.92	14678.86	14756.73	26216.0
2021-03-26 09:00:00	NQ	Futures	14756.15	14856.61	14750.36	14832.0	66339.0
2021-03-26 10:00:00	NQ	Futures	14831.42	14896.56	14795.52	14840.4	81281.0
2021-03-26 11:00:00	NQ	Futures	14840.4	14867.32	14773.23	14867.32	67438.0
2021-03-26 12:00:00	NQ	Futures	14867.32	14894.53	14827.95	14854.58	51408.0
2021-03-26 13:00:00	NQ	Futures	14854.58	14905.82	14800.16	14821.58	47530.0
2021-03-26 14:00:00	NQ	Futures	14821.0	14836.92	14707.52	14811.45	82704.0
2021-03-26 15:00:00	NQ	Futures	14811.74	15024.81	14800.45	15009.17	76960.0
2021-03-26 16:00:00	NQ	Futures	15009.75	15040.44	14975.3	15006.28	21369.0
2021-03-26 00:00:00	YM	Futures	36296.0	36311.6	36288.2	36307.1	773.0
2021-03-26 01:00:00	YM	Futures	36309.4	36345.0	36293.8	36340.6	1614.0
2021-03-26 02:00:00	YM	Futures	36340.6	36355.0	36321.6	36322.7	1770.0
2021-03-26 03:00:00	YM	Futures	36323.8	36341.7	36294.9	36321.6	2630.0
2021-03-26 04:00:00	YM	Futures	36320.5	36366.2	36306.0	36329.4	4641.0
2021-03-26 05:00:00	YM	Futures	36328.3	36342.8	36277.1	36298.2	2902.0
2021-03-26 06:00:00	YM	Futures	36296.0	36317.2	36268.2	36311.6	2711.0
2021-03-26 07:00:00	YM	Futures	36310.5	36377.3	36307.1	36367.3	4798.0
2021-03-26 08:00:00	YM	Futures	36368.4	36399.6	36340.6	36343.9	5407.0
2021-03-26 09:00:00	YM	Futures	36342.8	36398.5	36293.8	36356.1	23219.0
2021-03-26 10:00:00	YM	Futures	36356.1	36472.0	36347.2	36371.7	25562.0
2021-03-26 11:00:00	YM	Futures	36374.0	36411.8	36303.8	36367.3	19052.0
2021-03-26 12:00:00	YM	Futures	36367.3	36485.3	36337.2	36448.6	14279.0
2021-03-26 13:00:00	YM	Futures	36448.6	36497.6	36340.6	36411.8	12281.0
2021-03-26 14:00:00	YM	Futures	36411.8	36423.0	36258.1	36419.6	22008.0
2021-03-26 15:00:00	YM	Futures	36419.6	36729.3	36370.6	36690.3	24610.0

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

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