PREVIEW / etf_1hour / 2022-11-16

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-11-16.parquet
  size:    463 KB
  rows:    16,897

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-16 04:00:00	SPY	ETF	398.52	399.5	398.52	399.26	44443.0
2022-11-16 05:00:00	SPY	ETF	399.3	400.03	398.96	399.08	48170.0
2022-11-16 06:00:00	SPY	ETF	399.12	399.2	398.1	398.27	151567.0
2022-11-16 07:00:00	SPY	ETF	398.35	398.66	397.87	398.58	238435.0
2022-11-16 08:00:00	SPY	ETF	398.2498	399.9604	396.5	396.99	1092659.0
2022-11-16 09:00:00	SPY	ETF	396.99	397.78	395.73	396.35	6106542.0
2022-11-16 10:00:00	SPY	ETF	396.32	397.1818	395.185	395.53	6911051.0
2022-11-16 11:00:00	SPY	ETF	395.5	396.95	395.42	396.5	4690122.0
2022-11-16 12:00:00	SPY	ETF	396.52	397.65	395.7209	396.71	4376190.0
2022-11-16 13:00:00	SPY	ETF	396.685	396.91	395.13	395.3	4104837.0
2022-11-16 14:00:00	SPY	ETF	395.26	396.22	394.93	396.18	5434172.0
2022-11-16 15:00:00	SPY	ETF	396.15	396.27	394.79	395.51	14261464.0
2022-11-16 16:00:00	SPY	ETF	395.51	396.71	395.2512	396.04	5627657.0
2022-11-16 17:00:00	SPY	ETF	396.01	396.31	395.89	396.3	115238.0
2022-11-16 18:00:00	SPY	ETF	396.28	396.44	396.05	396.2	74951.0
2022-11-16 19:00:00	SPY	ETF	396.25	396.8	396.0201	396.4	53073.0
2022-11-16 04:00:00	QQQ	ETF	289.39	290.07	289.39	289.9	31807.0
2022-11-16 05:00:00	QQQ	ETF	289.93	290.56	289.51	289.55	52408.0
2022-11-16 06:00:00	QQQ	ETF	289.5	289.5	288.85	289.11	82656.0
2022-11-16 07:00:00	QQQ	ETF	289.08	289.43	288.57	289.42	155125.0
2022-11-16 08:00:00	QQQ	ETF	288.9032	290.4604	287.5	287.62	1059413.0
2022-11-16 09:00:00	QQQ	ETF	287.6	288.25	285.62	286.44	6729925.0
2022-11-16 10:00:00	QQQ	ETF	286.43	286.77	284.6	284.79	5857523.0
2022-11-16 11:00:00	QQQ	ETF	284.8	286.695	284.72	286.06	4329827.0
2022-11-16 12:00:00	QQQ	ETF	286.07	287.57	285.54	286.6848	3595852.0
2022-11-16 13:00:00	QQQ	ETF	286.65	287.06	285.33	285.485	3096809.0
2022-11-16 14:00:00	QQQ	ETF	285.47	286.209	285.19	286.0516	3087267.0
2022-11-16 15:00:00	QQQ	ETF	286.04	286.15	284.7201	285.4	5702153.0
2022-11-16 16:00:00	QQQ	ETF	285.43	286.93	285.34	286.21	2785913.0
2022-11-16 17:00:00	QQQ	ETF	286.22	286.3	285.44	286.3	435732.0
2022-11-16 18:00:00	QQQ	ETF	286.11	286.459	286.05	286.38	126911.0
2022-11-16 19:00:00	QQQ	ETF	286.35	286.52	286.25	286.47	60869.0
2022-11-16 04:00:00	IWM	ETF	187.55	188.22	187.55	188.2	22644.0
2022-11-16 05:00:00	IWM	ETF	188.23	188.54	188.06	188.1	9149.0
2022-11-16 06:00:00	IWM	ETF	188.13	188.13	187.48	187.48	128127.0
2022-11-16 07:00:00	IWM	ETF	187.37	187.63	187.25	187.56	105630.0
2022-11-16 08:00:00	IWM	ETF	187.35	188.39	186.58	186.89	212479.0
2022-11-16 09:00:00	IWM	ETF	187.01	187.14	184.59	184.63	4853349.0
2022-11-16 10:00:00	IWM	ETF	184.63	185.1	183.94	184.08	3470689.0
2022-11-16 11:00:00	IWM	ETF	184.07	184.99	184.025	184.66	1659193.0
2022-11-16 12:00:00	IWM	ETF	184.66	185.39	184.18	184.81	1672357.0
2022-11-16 13:00:00	IWM	ETF	184.8	184.98	183.89	183.97	1523698.0
2022-11-16 14:00:00	IWM	ETF	183.97	184.58	183.82	184.56	1351042.0
2022-11-16 15:00:00	IWM	ETF	184.55	184.6	183.71	184.22	4439275.0
2022-11-16 16:00:00	IWM	ETF	184.25	184.65	184.13	184.3	633712.0
2022-11-16 17:00:00	IWM	ETF	184.32	184.49	184.16	184.3	5619.0
2022-11-16 18:00:00	IWM	ETF	184.44	184.55	184.35	184.37	28144.0
2022-11-16 19:00:00	IWM	ETF	184.42	184.57	184.37	184.54	25360.0
2022-11-16 04:00:00	DIA	ETF	336.89	336.89	336.55	336.88	1154.0
2022-11-16 05:00:00	DIA	ETF	337.28	337.3	336.77	336.77	1200.0

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

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