PREVIEW / etf_1hour / 2022-11-18

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-11-18.parquet
  size:    456 KB
  rows:    16,590

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
2022-11-18 04:00:00	SPY	ETF	394.49	396.2	394.38	395.42	61090.0
2022-11-18 05:00:00	SPY	ETF	395.36	396.92	395.22	396.82	45411.0
2022-11-18 06:00:00	SPY	ETF	396.98	397.01	396.42	396.72	117366.0
2022-11-18 07:00:00	SPY	ETF	396.64	397.52	396.59	396.95	289615.0
2022-11-18 08:00:00	SPY	ETF	397.32	398.07	393.3	397.8	551360.0
2022-11-18 09:00:00	SPY	ETF	397.8	398.09	395.56	395.785	7389673.0
2022-11-18 10:00:00	SPY	ETF	395.82	395.9899	394.25	394.58	8119034.0
2022-11-18 11:00:00	SPY	ETF	394.59	395.99	394.05	395.14	5455211.0
2022-11-18 12:00:00	SPY	ETF	395.12	395.31	393.04	393.835	5014395.0
2022-11-18 13:00:00	SPY	ETF	393.83	394.86	393.38	393.89	4629568.0
2022-11-18 14:00:00	SPY	ETF	393.8818	394.815	393.82	394.7	4807385.0
2022-11-18 15:00:00	SPY	ETF	394.71	397.01	394.64	396.09	17709368.0
2022-11-18 16:00:00	SPY	ETF	396.08	396.21	395.39	396.03	6518103.0
2022-11-18 17:00:00	SPY	ETF	396.04	396.33	395.8	395.95	125872.0
2022-11-18 18:00:00	SPY	ETF	395.89	396.25	395.75	396.06	70152.0
2022-11-18 19:00:00	SPY	ETF	396.03	396.25	395.8	396.25	61969.0
2022-11-18 04:00:00	QQQ	ETF	285.01	286.41	284.94	285.86	75934.0
2022-11-18 05:00:00	QQQ	ETF	285.72	287.31	285.59	287.17	58789.0
2022-11-18 06:00:00	QQQ	ETF	287.31	287.4	286.76	287.08	51226.0
2022-11-18 07:00:00	QQQ	ETF	286.96	287.81	286.91	287.21	279698.0
2022-11-18 08:00:00	QQQ	ETF	287.4401	287.96	284.1	287.77	391135.0
2022-11-18 09:00:00	QQQ	ETF	287.74	288.0	285.43	285.861	5354536.0
2022-11-18 10:00:00	QQQ	ETF	285.88	285.97	283.51	283.905	6021113.0
2022-11-18 11:00:00	QQQ	ETF	283.92	284.98	283.26	284.12	3756011.0
2022-11-18 12:00:00	QQQ	ETF	284.12	284.3399	282.3211	282.95	3613317.0
2022-11-18 13:00:00	QQQ	ETF	282.95	284.02	282.8211	283.22	3508556.0
2022-11-18 14:00:00	QQQ	ETF	283.22	283.94	283.06	283.81	2771938.0
2022-11-18 15:00:00	QQQ	ETF	283.83	285.6	283.76	284.78	7694077.0
2022-11-18 16:00:00	QQQ	ETF	284.795	285.1	284.58	284.83	3263365.0
2022-11-18 17:00:00	QQQ	ETF	284.93	284.95	284.68	284.74	47673.0
2022-11-18 18:00:00	QQQ	ETF	284.74	284.82	284.53	284.55	197063.0
2022-11-18 19:00:00	QQQ	ETF	284.55	284.8	284.41	284.65	31087.0
2022-11-18 04:00:00	IWM	ETF	182.74	183.69	182.73	183.2	17372.0
2022-11-18 05:00:00	IWM	ETF	183.18	183.88	183.08	183.84	5771.0
2022-11-18 06:00:00	IWM	ETF	183.91	183.91	183.62	183.83	76589.0
2022-11-18 07:00:00	IWM	ETF	183.8	184.36	183.75	184.09	28988.0
2022-11-18 08:00:00	IWM	ETF	184.21	184.85	182.35	184.69	234739.0
2022-11-18 09:00:00	IWM	ETF	184.69	185.31	183.58	184.32	3106537.0
2022-11-18 10:00:00	IWM	ETF	184.32	184.78	183.55	183.81	2289698.0
2022-11-18 11:00:00	IWM	ETF	183.8	184.29	183.33	183.57	1157649.0
2022-11-18 12:00:00	IWM	ETF	183.565	183.715	182.57	183.155	1804089.0
2022-11-18 13:00:00	IWM	ETF	183.15	183.375	182.66	182.94	1046892.0
2022-11-18 14:00:00	IWM	ETF	182.94	183.33	182.745	183.13	1164792.0
2022-11-18 15:00:00	IWM	ETF	183.12	184.02	183.095	183.72	3101644.0
2022-11-18 16:00:00	IWM	ETF	183.72	183.85	183.27	183.68	1561991.0
2022-11-18 17:00:00	IWM	ETF	183.68	183.79	183.56	183.58	8401.0
2022-11-18 18:00:00	IWM	ETF	183.67	183.72	183.38	183.62	599462.0
2022-11-18 19:00:00	IWM	ETF	183.64	183.69	183.05	183.52	18024.0
2022-11-18 04:00:00	DIA	ETF	335.6	336.47	335.59	336.27	2790.0
2022-11-18 05:00:00	DIA	ETF	336.49	336.5	336.49	336.49	1300.0

> showing 50 of 16,590 rows — these rows as CSV

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