PREVIEW / futures_1hour / 2021-08-18

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-08-18.parquet
  size:    64 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-08-18 00:00:00	ES	Futures	5008.78	5010.76	5008.5	5009.07	3714.0
2021-08-18 01:00:00	ES	Futures	5008.78	5010.76	5008.22	5008.78	4098.0
2021-08-18 02:00:00	ES	Futures	5009.07	5009.63	5005.69	5006.81	7124.0
2021-08-18 03:00:00	ES	Futures	5007.1	5009.35	4998.08	4999.21	18087.0
2021-08-18 04:00:00	ES	Futures	4999.21	5004.56	4996.39	5000.06	13598.0
2021-08-18 05:00:00	ES	Futures	5000.06	5002.31	4997.52	4997.8	12413.0
2021-08-18 06:00:00	ES	Futures	4998.08	5004.84	4995.55	5003.72	14798.0
2021-08-18 07:00:00	ES	Futures	5004.0	5005.12	4999.49	5000.62	10628.0
2021-08-18 08:00:00	ES	Futures	5000.62	5003.15	4994.99	4996.39	22424.0
2021-08-18 09:00:00	ES	Futures	4996.11	5006.25	4989.92	5005.69	150785.0
2021-08-18 10:00:00	ES	Futures	5005.97	5011.88	5000.62	5002.31	182961.0
2021-08-18 11:00:00	ES	Futures	5002.59	5003.15	4994.99	4997.52	127894.0
2021-08-18 12:00:00	ES	Futures	4997.52	5001.46	4993.02	4997.8	78995.0
2021-08-18 13:00:00	ES	Futures	4997.8	4998.65	4991.89	4996.96	58355.0
2021-08-18 14:00:00	ES	Futures	4997.24	5007.1	4978.66	4991.89	283116.0
2021-08-18 15:00:00	ES	Futures	4991.61	4991.89	4947.4	4950.78	370622.0
2021-08-18 16:00:00	ES	Futures	4950.5	4953.31	4935.01	4942.89	101575.0
2021-08-18 18:00:00	ES	Futures	4944.3	4949.65	4943.18	4949.37	10834.0
2021-08-18 19:00:00	ES	Futures	4949.37	4949.65	4944.02	4946.27	9235.0
2021-08-18 20:00:00	ES	Futures	4945.99	4953.59	4945.99	4951.62	13739.0
2021-08-18 21:00:00	ES	Futures	4951.62	4955.28	4947.96	4949.09	10270.0
2021-08-18 22:00:00	ES	Futures	4949.09	4949.93	4942.33	4947.4	14253.0
2021-08-18 23:00:00	ES	Futures	4947.4	4950.78	4945.15	4946.55	6830.0
2021-08-18 00:00:00	NQ	Futures	17396.23	17406.08	17394.78	17396.52	2517.0
2021-08-18 01:00:00	NQ	Futures	17396.52	17404.92	17393.91	17398.84	1940.0
2021-08-18 02:00:00	NQ	Futures	17398.84	17407.53	17387.25	17391.59	3420.0
2021-08-18 03:00:00	NQ	Futures	17392.17	17404.34	17360.89	17365.23	7107.0
2021-08-18 04:00:00	NQ	Futures	17364.94	17384.93	17355.96	17366.97	6379.0
2021-08-18 05:00:00	NQ	Futures	17366.68	17386.38	17363.78	17372.19	4822.0
2021-08-18 06:00:00	NQ	Futures	17373.34	17413.61	17363.78	17401.73	7539.0
2021-08-18 07:00:00	NQ	Futures	17402.02	17413.61	17383.77	17384.35	5581.0
2021-08-18 08:00:00	NQ	Futures	17384.93	17393.62	17351.33	17359.15	10303.0
2021-08-18 09:00:00	NQ	Futures	17358.57	17422.59	17340.32	17408.11	77946.0
2021-08-18 10:00:00	NQ	Futures	17408.11	17424.04	17363.49	17380.3	72391.0
2021-08-18 11:00:00	NQ	Futures	17380.59	17383.48	17331.92	17356.83	59798.0
2021-08-18 12:00:00	NQ	Futures	17357.12	17376.82	17346.69	17369.0	32671.0
2021-08-18 13:00:00	NQ	Futures	17369.29	17373.05	17343.51	17357.41	21877.0
2021-08-18 14:00:00	NQ	Futures	17357.99	17415.06	17293.97	17367.55	98181.0
2021-08-18 15:00:00	NQ	Futures	17367.55	17367.55	17198.09	17214.31	103279.0
2021-08-18 16:00:00	NQ	Futures	17214.02	17218.94	17156.66	17194.9	23646.0
2021-08-18 18:00:00	NQ	Futures	17195.48	17215.76	17189.69	17214.31	5559.0
2021-08-18 19:00:00	NQ	Futures	17214.02	17215.18	17192.58	17201.85	4628.0
2021-08-18 20:00:00	NQ	Futures	17202.14	17226.77	17200.98	17225.32	5201.0
2021-08-18 21:00:00	NQ	Futures	17225.03	17235.75	17212.28	17213.15	5161.0
2021-08-18 22:00:00	NQ	Futures	17212.86	17215.76	17187.37	17207.65	6777.0
2021-08-18 23:00:00	NQ	Futures	17208.52	17218.07	17198.67	17204.46	3787.0
2021-08-18 00:00:00	YM	Futures	39404.4	39417.8	39399.9	39405.5	814.0
2021-08-18 01:00:00	YM	Futures	39404.4	39423.4	39401.0	39403.2	1266.0
2021-08-18 02:00:00	YM	Futures	39404.4	39415.5	39367.5	39379.8	1617.0
2021-08-18 03:00:00	YM	Futures	39380.9	39398.8	39299.3	39318.3	3033.0

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

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