PREVIEW / etf_1hour / 2023-09-18

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-09-18.parquet
  size:    473 KB
  rows:    17,250

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
2023-09-18 04:00:00	SPY	ETF	444.0	444.18	443.85	443.85	22197.0
2023-09-18 05:00:00	SPY	ETF	443.85	444.04	443.69	443.81	15767.0
2023-09-18 06:00:00	SPY	ETF	443.78	444.01	443.62	443.85	22412.0
2023-09-18 07:00:00	SPY	ETF	443.85	443.94	442.35	442.63	139666.0
2023-09-18 08:00:00	SPY	ETF	442.61	444.28	442.39	443.08	426478.0
2023-09-18 09:00:00	SPY	ETF	443.12	443.76	442.56	443.04	4690658.0
2023-09-18 10:00:00	SPY	ETF	443.02	443.86	442.7101	443.67	6312873.0
2023-09-18 11:00:00	SPY	ETF	443.67	444.79	443.27	444.63	5704110.0
2023-09-18 12:00:00	SPY	ETF	444.64	444.97	444.28	444.4607	3977616.0
2023-09-18 13:00:00	SPY	ETF	444.47	444.79	444.155	444.31	3050531.0
2023-09-18 14:00:00	SPY	ETF	444.31	444.52	443.175	443.54	4812410.0
2023-09-18 15:00:00	SPY	ETF	443.53	443.73	443.175	443.64	10373152.0
2023-09-18 16:00:00	SPY	ETF	443.63	444.0	437.18	443.76	3443938.0
2023-09-18 17:00:00	SPY	ETF	443.73	443.7899	443.63	443.7899	38584.0
2023-09-18 18:00:00	SPY	ETF	443.78	443.99	443.78	443.95	39508.0
2023-09-18 19:00:00	SPY	ETF	443.95	443.95	443.84	443.9	15305.0
2023-09-18 04:00:00	QQQ	ETF	370.81	371.03	370.65	370.7	41556.0
2023-09-18 05:00:00	QQQ	ETF	370.76	371.0	370.72	370.75	19132.0
2023-09-18 06:00:00	QQQ	ETF	370.68	370.89	370.46	370.7	56748.0
2023-09-18 07:00:00	QQQ	ETF	370.63	370.75	368.74	368.96	206687.0
2023-09-18 08:00:00	QQQ	ETF	370.72	371.0	368.77	369.47	352354.0
2023-09-18 09:00:00	QQQ	ETF	369.5	371.2	369.03	370.5407	5059635.0
2023-09-18 10:00:00	QQQ	ETF	370.53	371.32	369.5	370.34	4978753.0
2023-09-18 11:00:00	QQQ	ETF	370.32	371.59	370.05	371.48	3085212.0
2023-09-18 12:00:00	QQQ	ETF	371.48	371.79	370.965	371.19	2136071.0
2023-09-18 13:00:00	QQQ	ETF	371.19	371.69	370.92	371.2	1683072.0
2023-09-18 14:00:00	QQQ	ETF	371.2	371.545	369.85	370.21	2479584.0
2023-09-18 15:00:00	QQQ	ETF	370.21	370.76	370.02	370.66	4773885.0
2023-09-18 16:00:00	QQQ	ETF	370.66	371.08	370.6	370.93	1451233.0
2023-09-18 17:00:00	QQQ	ETF	370.91	370.99	370.86	370.95	49703.0
2023-09-18 18:00:00	QQQ	ETF	370.95	371.07	370.93	370.96	24484.0
2023-09-18 19:00:00	QQQ	ETF	371.0	371.0	370.84	370.92	35064.0
2023-09-18 04:00:00	IWM	ETF	183.96	183.97	183.83	183.88	24863.0
2023-09-18 05:00:00	IWM	ETF	183.86	183.91	183.6	183.68	2259.0
2023-09-18 06:00:00	IWM	ETF	183.77	184.0	183.65	183.89	8206.0
2023-09-18 07:00:00	IWM	ETF	183.96	183.96	183.37	183.52	43909.0
2023-09-18 08:00:00	IWM	ETF	183.42	184.03	183.42	183.92	84007.0
2023-09-18 09:00:00	IWM	ETF	183.95	184.05	182.51	182.895	2496714.0
2023-09-18 10:00:00	IWM	ETF	182.89	183.47	182.8502	183.05	2732822.0
2023-09-18 11:00:00	IWM	ETF	183.04	183.29	182.88	183.23	1479354.0
2023-09-18 12:00:00	IWM	ETF	183.22	183.26	182.88	183.03	1009418.0
2023-09-18 13:00:00	IWM	ETF	183.03	183.17	182.845	182.87	933939.0
2023-09-18 14:00:00	IWM	ETF	182.88	182.98	182.65	182.795	1533687.0
2023-09-18 15:00:00	IWM	ETF	182.79	183.01	182.37	182.38	3322374.0
2023-09-18 16:00:00	IWM	ETF	182.39	182.56	182.39	182.55	1677092.0
2023-09-18 17:00:00	IWM	ETF	182.55	182.68	182.52	182.64	19145.0
2023-09-18 18:00:00	IWM	ETF	182.58	182.67	182.57	182.64	5813.0
2023-09-18 19:00:00	IWM	ETF	182.68	182.68	182.6	182.6	19137.0
2023-09-18 04:00:00	DIA	ETF	346.47	346.47	346.47	346.47	189.0
2023-09-18 06:00:00	DIA	ETF	346.36	346.36	346.36	346.36	450.0

> showing 50 of 17,250 rows — these rows as CSV

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