PREVIEW / etf_1hour / 2020-09-24

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-09-24.parquet
  size:    373 KB
  rows:    12,851

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
2020-09-24 04:00:00	SPY	ETF	323.0	323.17	321.95	322.37	32705.0
2020-09-24 05:00:00	SPY	ETF	322.2	322.77	321.87	322.48	41046.0
2020-09-24 06:00:00	SPY	ETF	322.64	323.62	322.64	323.32	92978.0
2020-09-24 07:00:00	SPY	ETF	323.26	323.35	321.88	321.96	536514.0
2020-09-24 08:00:00	SPY	ETF	321.99	323.4304	320.18	320.7	1464211.0
2020-09-24 09:00:00	SPY	ETF	320.71	322.84	319.8	322.19	11027068.0
2020-09-24 10:00:00	SPY	ETF	322.19	324.6476	321.24	323.15	12773426.0
2020-09-24 11:00:00	SPY	ETF	323.16	324.54	321.87	324.52	6935209.0
2020-09-24 12:00:00	SPY	ETF	324.515	325.31	323.51	325.09	6996091.0
2020-09-24 13:00:00	SPY	ETF	325.095	326.797	325.0	325.78	6946389.0
2020-09-24 14:00:00	SPY	ETF	325.79	326.07	322.86	322.9599	8698829.0
2020-09-24 15:00:00	SPY	ETF	322.96	324.28	321.85	323.52	15964448.0
2020-09-24 16:00:00	SPY	ETF	323.53	324.33	323.31	324.01	2644694.0
2020-09-24 17:00:00	SPY	ETF	324.17	324.3	323.94	324.2	36548.0
2020-09-24 18:00:00	SPY	ETF	324.3	325.0	324.3	324.62	98396.0
2020-09-24 19:00:00	SPY	ETF	324.61	325.44	324.6	325.35	133042.0
2020-09-24 04:00:00	QQQ	ETF	264.07	264.08	262.65	262.92	23418.0
2020-09-24 05:00:00	QQQ	ETF	262.75	263.0	262.3	262.85	13998.0
2020-09-24 06:00:00	QQQ	ETF	262.95	264.16	262.95	263.9	154342.0
2020-09-24 07:00:00	QQQ	ETF	263.84	263.849	262.43	262.48	353634.0
2020-09-24 08:00:00	QQQ	ETF	262.5	264.02	260.3	260.81	1025581.0
2020-09-24 09:00:00	QQQ	ETF	260.81	265.345	260.24	264.455	7047070.0
2020-09-24 10:00:00	QQQ	ETF	264.49	266.89	262.94	265.79	11483843.0
2020-09-24 11:00:00	QQQ	ETF	265.78	267.48	264.1	267.2413	5376039.0
2020-09-24 12:00:00	QQQ	ETF	267.28	267.975	265.68	267.215	4777084.0
2020-09-24 13:00:00	QQQ	ETF	267.19	268.7	267.005	267.47	4242659.0
2020-09-24 14:00:00	QQQ	ETF	267.48	267.7	264.91	264.98	5472152.0
2020-09-24 15:00:00	QQQ	ETF	264.99	266.4	263.69	265.42	8696212.0
2020-09-24 16:00:00	QQQ	ETF	265.42	266.38	265.26	266.2	1277599.0
2020-09-24 17:00:00	QQQ	ETF	266.0	266.27	265.92	266.18	16907.0
2020-09-24 18:00:00	QQQ	ETF	266.26	267.02	266.26	266.64	66976.0
2020-09-24 19:00:00	QQQ	ETF	266.68	267.36	266.55	267.22	77782.0
2020-09-24 04:00:00	IWM	ETF	144.57	144.62	144.2	144.6	9861.0
2020-09-24 05:00:00	IWM	ETF	144.4	144.66	144.38	144.62	4043.0
2020-09-24 06:00:00	IWM	ETF	144.71	145.09	144.71	144.92	40849.0
2020-09-24 07:00:00	IWM	ETF	144.92	144.92	144.16	144.16	53408.0
2020-09-24 08:00:00	IWM	ETF	144.7701	144.8004	143.37	143.75	337043.0
2020-09-24 09:00:00	IWM	ETF	143.66	144.2	142.09	143.25	4028343.0
2020-09-24 10:00:00	IWM	ETF	143.25	144.82	142.56	143.76	5869486.0
2020-09-24 11:00:00	IWM	ETF	143.76	144.75	142.91	144.74	2451838.0
2020-09-24 12:00:00	IWM	ETF	144.74	145.48	144.44	145.405	2209745.0
2020-09-24 13:00:00	IWM	ETF	145.41	146.53	145.31	145.65	4555988.0
2020-09-24 14:00:00	IWM	ETF	145.65	145.83	144.0	144.065	2426646.0
2020-09-24 15:00:00	IWM	ETF	144.07	144.585	143.44	144.06	3843550.0
2020-09-24 16:00:00	IWM	ETF	144.07	144.48	143.9	144.37	1206780.0
2020-09-24 17:00:00	IWM	ETF	144.49	144.52	144.18	144.52	8088.0
2020-09-24 18:00:00	IWM	ETF	144.55	144.84	144.55	144.79	12110.0
2020-09-24 19:00:00	IWM	ETF	144.76	145.16	144.76	145.12	12834.0
2020-09-24 04:00:00	DIA	ETF	267.86	267.86	267.53	267.53	625.0
2020-09-24 05:00:00	DIA	ETF	267.39	267.64	267.39	267.59	2961.0

> showing 50 of 12,851 rows — these rows as CSV

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