PREVIEW / futures_1hour / 2021-10-05

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-10-05.parquet
  size:    65 KB
  rows:    1,997

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-10-05 00:00:00	ES	Futures	4851.23	4851.51	4843.33	4848.69	7534.0
2021-10-05 01:00:00	ES	Futures	4848.41	4851.23	4843.89	4846.15	8047.0
2021-10-05 02:00:00	ES	Futures	4846.43	4848.41	4835.43	4846.43	14124.0
2021-10-05 03:00:00	ES	Futures	4846.15	4856.03	4839.66	4840.22	37471.0
2021-10-05 04:00:00	ES	Futures	4840.22	4858.57	4839.38	4858.57	23906.0
2021-10-05 05:00:00	ES	Futures	4858.57	4865.34	4857.44	4864.78	22715.0
2021-10-05 06:00:00	ES	Futures	4865.06	4865.34	4857.16	4861.11	19540.0
2021-10-05 07:00:00	ES	Futures	4861.11	4870.7	4859.7	4866.19	27772.0
2021-10-05 08:00:00	ES	Futures	4866.19	4867.88	4863.08	4867.32	24374.0
2021-10-05 09:00:00	ES	Futures	4867.6	4878.89	4852.36	4873.53	228860.0
2021-10-05 10:00:00	ES	Futures	4873.24	4910.5	4872.4	4910.21	284404.0
2021-10-05 11:00:00	ES	Futures	4909.93	4918.12	4902.31	4911.06	165006.0
2021-10-05 12:00:00	ES	Futures	4911.06	4918.12	4903.16	4910.5	109085.0
2021-10-05 13:00:00	ES	Futures	4910.5	4918.96	4905.7	4916.14	107712.0
2021-10-05 14:00:00	ES	Futures	4916.14	4921.5	4911.91	4915.58	101215.0
2021-10-05 15:00:00	ES	Futures	4915.58	4919.81	4891.02	4893.56	252994.0
2021-10-05 16:00:00	ES	Futures	4893.56	4896.67	4889.05	4894.69	72875.0
2021-10-05 18:00:00	ES	Futures	4892.43	4898.64	4892.43	4897.23	5167.0
2021-10-05 19:00:00	ES	Futures	4897.23	4897.51	4884.53	4885.94	9917.0
2021-10-05 20:00:00	ES	Futures	4885.94	4896.95	4884.53	4893.28	12613.0
2021-10-05 21:00:00	ES	Futures	4893.28	4894.69	4861.39	4870.99	32421.0
2021-10-05 22:00:00	ES	Futures	4870.7	4874.09	4862.24	4867.32	17994.0
2021-10-05 23:00:00	ES	Futures	4867.32	4875.22	4863.93	4873.24	10827.0
2021-10-05 00:00:00	NQ	Futures	16827.36	16827.36	16787.37	16811.71	4098.0
2021-10-05 01:00:00	NQ	Futures	16809.39	16820.99	16786.79	16799.25	5541.0
2021-10-05 02:00:00	NQ	Futures	16800.12	16811.42	16754.33	16803.02	8012.0
2021-10-05 03:00:00	NQ	Futures	16801.86	16854.03	16771.14	16773.46	14939.0
2021-10-05 04:00:00	NQ	Futures	16773.46	16846.78	16769.4	16843.59	8645.0
2021-10-05 05:00:00	NQ	Futures	16843.88	16866.78	16839.54	16858.08	7007.0
2021-10-05 06:00:00	NQ	Futures	16858.08	16861.27	16810.26	16825.91	7769.0
2021-10-05 07:00:00	NQ	Futures	16825.91	16856.92	16803.02	16833.74	10222.0
2021-10-05 08:00:00	NQ	Futures	16833.45	16848.52	16816.35	16830.84	9100.0
2021-10-05 09:00:00	NQ	Futures	16830.55	16922.42	16804.18	16903.3	97655.0
2021-10-05 10:00:00	NQ	Futures	16903.3	17017.48	16897.21	17015.74	91465.0
2021-10-05 11:00:00	NQ	Futures	17015.17	17055.16	16998.94	17040.38	61513.0
2021-10-05 12:00:00	NQ	Futures	17040.38	17079.5	17026.18	17067.33	42263.0
2021-10-05 13:00:00	NQ	Futures	17067.04	17094.57	17045.6	17086.75	36461.0
2021-10-05 14:00:00	NQ	Futures	17087.04	17104.72	17067.33	17080.08	32884.0
2021-10-05 15:00:00	NQ	Futures	17079.79	17096.31	16984.44	16993.14	69200.0
2021-10-05 16:00:00	NQ	Futures	16991.98	17003.28	16977.78	16996.62	13810.0
2021-10-05 18:00:00	NQ	Futures	16997.2	17011.98	16992.85	17009.37	2842.0
2021-10-05 19:00:00	NQ	Futures	17009.95	17011.11	16964.45	16968.5	5076.0
2021-10-05 20:00:00	NQ	Futures	16969.66	17004.15	16965.61	16987.92	6354.0
2021-10-05 21:00:00	NQ	Futures	16987.92	16994.3	16879.82	16903.01	14762.0
2021-10-05 22:00:00	NQ	Futures	16903.59	16920.97	16873.44	16891.7	9080.0
2021-10-05 23:00:00	NQ	Futures	16891.99	16920.39	16877.5	16913.73	5957.0
2021-10-05 00:00:00	YM	Futures	37993.2	38001.0	37941.6	37976.3	1445.0
2021-10-05 01:00:00	YM	Futures	37975.2	38002.1	37945.0	37959.5	1858.0
2021-10-05 02:00:00	YM	Futures	37961.8	37985.3	37884.4	37962.9	3269.0
2021-10-05 03:00:00	YM	Futures	37961.8	38034.6	37909.1	37929.3	6688.0

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

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