PREVIEW / etf_1hour / 2022-09-16

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-09-16.parquet
  size:    453 KB
  rows:    16,687

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-09-16 04:00:00	SPY	ETF	385.5	386.5	384.55	384.9	82631.0
2022-09-16 05:00:00	SPY	ETF	384.82	385.29	384.67	385.04	32707.0
2022-09-16 06:00:00	SPY	ETF	384.91	386.1	384.64	385.94	114954.0
2022-09-16 07:00:00	SPY	ETF	386.04	386.05	385.17	385.45	336330.0
2022-09-16 08:00:00	SPY	ETF	385.8801	386.42	383.14	383.25	935881.0
2022-09-16 09:00:00	SPY	ETF	383.25	384.68	382.12	382.6099	11265935.0
2022-09-16 10:00:00	SPY	ETF	382.54	385.89	382.52	383.5	12225418.0
2022-09-16 11:00:00	SPY	ETF	383.55	384.68	382.85	384.286	6089634.0
2022-09-16 12:00:00	SPY	ETF	384.27	384.36	382.11	383.52	5299377.0
2022-09-16 13:00:00	SPY	ETF	383.49	383.87	382.455	382.795	5559713.0
2022-09-16 14:00:00	SPY	ETF	382.81	385.23	382.665	384.87	7499698.0
2022-09-16 15:00:00	SPY	ETF	384.86	386.25	384.16	385.64	15646958.0
2022-09-16 16:00:00	SPY	ETF	385.64	387.0	385.45	386.91	5492158.0
2022-09-16 17:00:00	SPY	ETF	386.87	387.14	385.56	387.1	465939.0
2022-09-16 18:00:00	SPY	ETF	387.1	388.0	387.02	387.12	217385.0
2022-09-16 19:00:00	SPY	ETF	387.13	387.45	387.0	387.4	50815.0
2022-09-16 04:00:00	QQQ	ETF	288.37	288.5	287.41	287.82	168088.0
2022-09-16 05:00:00	QQQ	ETF	287.68	288.13	287.6	287.78	75128.0
2022-09-16 06:00:00	QQQ	ETF	287.8	288.96	287.52	288.85	130344.0
2022-09-16 07:00:00	QQQ	ETF	288.86	288.86	287.98	288.37	237118.0
2022-09-16 08:00:00	QQQ	ETF	288.65	291.318	286.92	287.03	896345.0
2022-09-16 09:00:00	QQQ	ETF	287.05	287.8	285.64	285.99	8716627.0
2022-09-16 10:00:00	QQQ	ETF	285.99	288.89	285.93	286.48	10766523.0
2022-09-16 11:00:00	QQQ	ETF	286.495	287.72	286.0	287.578	4588034.0
2022-09-16 12:00:00	QQQ	ETF	287.58	287.6701	285.62	287.17	4567742.0
2022-09-16 13:00:00	QQQ	ETF	287.17	287.41	286.23	286.51	3400529.0
2022-09-16 14:00:00	QQQ	ETF	286.52	288.68	286.42	288.35	4562820.0
2022-09-16 15:00:00	QQQ	ETF	288.31	289.72	287.85	289.22	10026636.0
2022-09-16 16:00:00	QQQ	ETF	289.22	290.0	288.7	290.0	4658241.0
2022-09-16 17:00:00	QQQ	ETF	290.02	290.33	289.32	290.0	637096.0
2022-09-16 18:00:00	QQQ	ETF	289.98	290.44	289.32	290.15	712182.0
2022-09-16 19:00:00	QQQ	ETF	290.16	290.65	289.32	290.5	136299.0
2022-09-16 04:00:00	IWM	ETF	180.18	180.28	179.83	180.02	42949.0
2022-09-16 05:00:00	IWM	ETF	180.01	180.2	179.86	180.01	5854.0
2022-09-16 06:00:00	IWM	ETF	179.98	180.58	179.93	180.55	29447.0
2022-09-16 07:00:00	IWM	ETF	180.491	180.5	180.11	180.31	60408.0
2022-09-16 08:00:00	IWM	ETF	180.4904	180.4904	178.79	178.91	146855.0
2022-09-16 09:00:00	IWM	ETF	178.82	179.68	177.35	177.41	4207157.0
2022-09-16 10:00:00	IWM	ETF	177.43	179.38	177.4	178.49	3509868.0
2022-09-16 11:00:00	IWM	ETF	178.48	179.005	177.88	178.4	2049886.0
2022-09-16 12:00:00	IWM	ETF	178.43	178.45	176.91	177.76	2517925.0
2022-09-16 13:00:00	IWM	ETF	177.74	177.85	177.11	177.275	2171201.0
2022-09-16 14:00:00	IWM	ETF	177.275	178.23	177.23	178.04	2458888.0
2022-09-16 15:00:00	IWM	ETF	178.02	179.05	177.705	178.85	5671499.0
2022-09-16 16:00:00	IWM	ETF	178.86	179.38	178.5575	179.35	3546567.0
2022-09-16 17:00:00	IWM	ETF	179.38	191.0	178.99	179.35	1636576.0
2022-09-16 18:00:00	IWM	ETF	179.34	179.43	178.99	179.39	12215.0
2022-09-16 19:00:00	IWM	ETF	179.38	179.76	179.33	179.76	24301.0
2022-09-16 04:00:00	DIA	ETF	307.47	307.47	307.12	307.12	900.0
2022-09-16 05:00:00	DIA	ETF	307.22	307.27	307.12	307.12	2200.0

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

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