PREVIEW / futures_1hour / 2021-08-11

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-08-11.parquet
  size:    62 KB
  rows:    1,954

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-08-11 00:00:00	ES	Futures	4985.69	4985.98	4984.85	4985.13	2018.0
2021-08-11 01:00:00	ES	Futures	4985.13	4987.1	4984.85	4985.69	4191.0
2021-08-11 02:00:00	ES	Futures	4985.69	4986.26	4984.29	4986.26	3598.0
2021-08-11 03:00:00	ES	Futures	4986.54	4989.07	4979.22	4981.19	17850.0
2021-08-11 04:00:00	ES	Futures	4981.19	4984.57	4981.19	4983.16	11983.0
2021-08-11 05:00:00	ES	Futures	4983.16	4984.57	4979.22	4984.01	10477.0
2021-08-11 06:00:00	ES	Futures	4984.29	4987.38	4982.88	4987.1	8935.0
2021-08-11 07:00:00	ES	Futures	4986.82	4987.38	4982.88	4984.29	10325.0
2021-08-11 08:00:00	ES	Futures	4984.29	4999.77	4983.72	4997.52	70722.0
2021-08-11 09:00:00	ES	Futures	4997.52	5004.56	4996.39	5000.06	150302.0
2021-08-11 10:00:00	ES	Futures	5000.06	5002.59	4996.68	4997.8	121092.0
2021-08-11 11:00:00	ES	Futures	4997.52	4998.08	4989.64	4991.33	145178.0
2021-08-11 12:00:00	ES	Futures	4991.04	4996.68	4990.76	4996.39	63494.0
2021-08-11 13:00:00	ES	Futures	4996.39	4999.49	4994.99	4997.8	82112.0
2021-08-11 14:00:00	ES	Futures	4997.8	4999.21	4994.99	4998.08	65423.0
2021-08-11 15:00:00	ES	Futures	4998.08	5002.59	4997.8	5002.03	137944.0
2021-08-11 16:00:00	ES	Futures	5002.03	5002.87	5000.9	5002.59	38674.0
2021-08-11 18:00:00	ES	Futures	5000.9	5002.59	5000.06	5000.34	4509.0
2021-08-11 19:00:00	ES	Futures	5000.34	5002.03	4999.77	5000.06	2835.0
2021-08-11 20:00:00	ES	Futures	5000.06	5001.74	4998.65	4999.49	4573.0
2021-08-11 21:00:00	ES	Futures	4999.49	5001.46	4999.49	5000.06	3716.0
2021-08-11 22:00:00	ES	Futures	5000.06	5001.46	4999.77	5001.46	2838.0
2021-08-11 23:00:00	ES	Futures	5001.46	5004.0	5001.18	5003.15	3240.0
2021-08-11 00:00:00	NQ	Futures	17428.67	17432.73	17425.78	17430.7	1306.0
2021-08-11 01:00:00	NQ	Futures	17430.99	17440.84	17421.72	17427.51	2551.0
2021-08-11 02:00:00	NQ	Futures	17427.22	17428.96	17413.32	17422.3	2200.0
2021-08-11 03:00:00	NQ	Futures	17422.3	17429.54	17378.85	17391.3	8639.0
2021-08-11 04:00:00	NQ	Futures	17391.88	17403.47	17379.43	17383.19	6243.0
2021-08-11 05:00:00	NQ	Futures	17383.77	17390.15	17353.36	17373.63	7533.0
2021-08-11 06:00:00	NQ	Futures	17373.34	17408.4	17365.81	17406.37	5726.0
2021-08-11 07:00:00	NQ	Futures	17406.08	17411.29	17390.15	17399.7	4722.0
2021-08-11 08:00:00	NQ	Futures	17399.99	17511.52	17394.2	17485.16	32095.0
2021-08-11 09:00:00	NQ	Futures	17485.74	17518.76	17435.63	17447.5	79696.0
2021-08-11 10:00:00	NQ	Futures	17447.21	17475.6	17391.3	17391.88	80818.0
2021-08-11 11:00:00	NQ	Futures	17392.17	17396.81	17338.0	17360.6	79155.0
2021-08-11 12:00:00	NQ	Futures	17360.89	17398.26	17354.22	17384.64	38372.0
2021-08-11 13:00:00	NQ	Futures	17384.64	17418.24	17369.58	17383.19	35308.0
2021-08-11 14:00:00	NQ	Futures	17382.9	17405.5	17373.92	17396.52	26548.0
2021-08-11 15:00:00	NQ	Futures	17396.81	17414.48	17388.12	17406.08	41593.0
2021-08-11 16:00:00	NQ	Futures	17406.66	17407.53	17388.41	17390.72	8261.0
2021-08-11 18:00:00	NQ	Futures	17390.72	17390.72	17375.66	17379.14	2304.0
2021-08-11 19:00:00	NQ	Futures	17378.56	17382.61	17369.58	17375.95	1804.0
2021-08-11 20:00:00	NQ	Futures	17375.95	17386.67	17371.03	17380.88	2231.0
2021-08-11 21:00:00	NQ	Futures	17380.88	17391.59	17380.01	17383.77	2089.0
2021-08-11 22:00:00	NQ	Futures	17383.77	17390.72	17382.03	17384.06	1428.0
2021-08-11 23:00:00	NQ	Futures	17384.35	17393.33	17383.77	17392.17	1417.0
2021-08-11 00:00:00	YM	Futures	39258.0	39260.2	39244.6	39246.8	555.0
2021-08-11 01:00:00	YM	Futures	39245.7	39260.2	39242.4	39251.3	869.0
2021-08-11 02:00:00	YM	Futures	39251.3	39268.1	39236.8	39268.1	1112.0
2021-08-11 03:00:00	YM	Futures	39266.9	39292.6	39222.2	39246.8	3776.0

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

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