PREVIEW / futures_1hour / 2021-01-14

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-01-14.parquet
  size:    62 KB
  rows:    1,910

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-01-14 00:00:00	ES	Futures	4281.29	4281.29	4272.87	4278.2	10648.0
2021-01-14 01:00:00	ES	Futures	4278.48	4281.85	4277.92	4278.2	4654.0
2021-01-14 02:00:00	ES	Futures	4278.2	4279.6	4273.71	4278.48	5780.0
2021-01-14 03:00:00	ES	Futures	4278.48	4282.69	4274.55	4281.0	11650.0
2021-01-14 04:00:00	ES	Futures	4281.0	4282.69	4279.04	4279.6	12270.0
2021-01-14 05:00:00	ES	Futures	4279.88	4279.88	4271.18	4275.11	12456.0
2021-01-14 06:00:00	ES	Futures	4275.11	4276.51	4270.9	4276.23	10967.0
2021-01-14 07:00:00	ES	Futures	4276.51	4277.08	4273.71	4276.23	9507.0
2021-01-14 08:00:00	ES	Futures	4276.23	4277.92	4273.15	4276.79	22453.0
2021-01-14 09:00:00	ES	Futures	4276.79	4281.57	4273.71	4280.44	133093.0
2021-01-14 10:00:00	ES	Futures	4280.16	4284.09	4275.39	4279.88	156893.0
2021-01-14 11:00:00	ES	Futures	4279.88	4281.29	4273.71	4275.95	90349.0
2021-01-14 12:00:00	ES	Futures	4275.95	4280.44	4269.5	4279.04	99775.0
2021-01-14 13:00:00	ES	Futures	4279.04	4279.88	4272.58	4274.27	61413.0
2021-01-14 14:00:00	ES	Futures	4274.27	4277.64	4267.81	4270.62	79276.0
2021-01-14 15:00:00	ES	Futures	4270.62	4272.58	4250.69	4255.18	294349.0
2021-01-14 16:00:00	ES	Futures	4255.18	4259.39	4252.1	4254.62	47523.0
2021-01-14 18:00:00	ES	Futures	4258.27	4263.6	4257.15	4260.52	9834.0
2021-01-14 19:00:00	ES	Futures	4260.52	4261.92	4249.57	4252.66	19371.0
2021-01-14 20:00:00	ES	Futures	4252.66	4255.18	4240.59	4246.48	19566.0
2021-01-14 21:00:00	ES	Futures	4246.48	4252.94	4244.8	4252.66	7814.0
2021-01-14 22:00:00	ES	Futures	4252.66	4253.22	4239.19	4240.59	10598.0
2021-01-14 23:00:00	ES	Futures	4240.31	4244.52	4238.62	4241.71	9464.0
2021-01-14 00:00:00	NQ	Futures	14998.75	15019.87	14977.91	15009.17	3831.0
2021-01-14 01:00:00	NQ	Futures	15009.74	15016.4	14989.77	14999.9	2580.0
2021-01-14 02:00:00	NQ	Futures	15000.77	15008.88	14973.85	15004.53	3210.0
2021-01-14 03:00:00	NQ	Futures	15004.53	15029.72	14992.96	15019.01	4663.0
2021-01-14 04:00:00	NQ	Futures	15019.01	15029.14	14994.98	14995.85	4456.0
2021-01-14 05:00:00	NQ	Futures	14995.85	14997.88	14960.83	14984.27	6831.0
2021-01-14 06:00:00	NQ	Futures	14984.56	15007.72	14963.72	15007.14	5975.0
2021-01-14 07:00:00	NQ	Futures	15007.72	15026.82	14999.9	15019.87	6733.0
2021-01-14 08:00:00	NQ	Futures	15020.16	15038.4	15007.72	15030.0	7853.0
2021-01-14 09:00:00	NQ	Futures	15030.0	15067.92	15014.38	15042.45	64990.0
2021-01-14 10:00:00	NQ	Futures	15042.74	15083.84	15027.98	15066.76	58785.0
2021-01-14 11:00:00	NQ	Futures	15066.18	15077.76	15013.51	15025.08	42529.0
2021-01-14 12:00:00	NQ	Futures	15024.79	15032.9	14973.56	15028.85	44184.0
2021-01-14 13:00:00	NQ	Futures	15028.56	15030.29	14984.56	14986.88	30585.0
2021-01-14 14:00:00	NQ	Futures	14986.88	15009.45	14976.75	14991.51	23042.0
2021-01-14 15:00:00	NQ	Futures	14991.51	14998.17	14912.78	14932.47	67808.0
2021-01-14 16:00:00	NQ	Futures	14931.6	14943.75	14920.6	14934.49	10004.0
2021-01-14 18:00:00	NQ	Futures	14945.2	14967.2	14944.91	14955.91	2849.0
2021-01-14 19:00:00	NQ	Futures	14955.04	14961.41	14919.73	14934.2	5248.0
2021-01-14 20:00:00	NQ	Futures	14934.49	14947.52	14898.89	14920.02	5907.0
2021-01-14 21:00:00	NQ	Futures	14919.44	14947.81	14914.52	14946.65	2915.0
2021-01-14 22:00:00	NQ	Futures	14946.94	14953.02	14913.94	14919.15	4242.0
2021-01-14 23:00:00	NQ	Futures	14919.44	14923.2	14904.68	14911.63	3609.0
2021-01-14 00:00:00	YM	Futures	34478.2	34478.2	34400.6	34432.7	2876.0
2021-01-14 01:00:00	YM	Futures	34432.7	34462.7	34431.6	34444.9	1011.0
2021-01-14 02:00:00	YM	Futures	34444.9	34454.9	34406.1	34441.6	1996.0
2021-01-14 03:00:00	YM	Futures	34440.5	34472.7	34413.9	34452.7	3521.0

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

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