PREVIEW / etf_1hour / 2023-03-28

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-03-28.parquet
  size:    456 KB
  rows:    16,516

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-03-28 04:00:00	SPY	ETF	396.65	396.7	396.11	396.22	48170.0
2023-03-28 05:00:00	SPY	ETF	396.3	396.4	395.78	395.93	21568.0
2023-03-28 06:00:00	SPY	ETF	395.9	396.05	395.56	395.78	60846.0
2023-03-28 07:00:00	SPY	ETF	395.79	396.53	395.75	396.22	151714.0
2023-03-28 08:00:00	SPY	ETF	396.42	397.9	395.32	395.52	444929.0
2023-03-28 09:00:00	SPY	ETF	395.5	396.03	394.97	395.4906	5184696.0
2023-03-28 10:00:00	SPY	ETF	395.4906	396.49	394.55	394.8099	8302042.0
2023-03-28 11:00:00	SPY	ETF	394.8	396.21	394.74	396.04	5574877.0
2023-03-28 12:00:00	SPY	ETF	396.06	396.1494	395.105	395.37	3780200.0
2023-03-28 13:00:00	SPY	ETF	395.37	395.5	393.69	393.845	6335693.0
2023-03-28 14:00:00	SPY	ETF	393.84	394.98	393.73	394.82	5901070.0
2023-03-28 15:00:00	SPY	ETF	394.83	395.72	394.34	395.65	10755724.0
2023-03-28 16:00:00	SPY	ETF	395.65	396.2499	395.6	396.18	2923138.0
2023-03-28 17:00:00	SPY	ETF	396.19	396.31	396.17	396.27	74946.0
2023-03-28 18:00:00	SPY	ETF	396.26	396.41	396.15	396.27	153434.0
2023-03-28 19:00:00	SPY	ETF	396.28	396.7	396.28	396.61	56008.0
2023-03-28 04:00:00	QQQ	ETF	307.88	308.79	307.62	307.9	49499.0
2023-03-28 05:00:00	QQQ	ETF	308.02	308.2	307.76	307.96	36398.0
2023-03-28 06:00:00	QQQ	ETF	307.92	308.08	307.62	307.92	28767.0
2023-03-28 07:00:00	QQQ	ETF	307.94	308.68	307.8	308.52	127695.0
2023-03-28 08:00:00	QQQ	ETF	308.0399	309.25	307.6396	308.09	320494.0
2023-03-28 09:00:00	QQQ	ETF	308.04	308.24	305.94	306.19	6538192.0
2023-03-28 10:00:00	QQQ	ETF	306.17	307.11	305.15	305.3101	6509186.0
2023-03-28 11:00:00	QQQ	ETF	305.31	306.9	305.25	306.6559	4636516.0
2023-03-28 12:00:00	QQQ	ETF	306.66	306.77	305.4747	305.94	3159987.0
2023-03-28 13:00:00	QQQ	ETF	305.95	306.23	304.774	304.9	3797033.0
2023-03-28 14:00:00	QQQ	ETF	304.89	306.12	304.815	305.93	3107013.0
2023-03-28 15:00:00	QQQ	ETF	305.94	307.16	305.77	307.11	6091381.0
2023-03-28 16:00:00	QQQ	ETF	307.11	307.63	307.1	307.49	2914576.0
2023-03-28 17:00:00	QQQ	ETF	307.49	307.52	307.3899	307.39	58626.0
2023-03-28 18:00:00	QQQ	ETF	307.44	307.689	307.37	307.42	68828.0
2023-03-28 19:00:00	QQQ	ETF	307.4	307.7999	307.39	307.76	31201.0
2023-03-28 04:00:00	IWM	ETF	174.01	174.23	173.69	173.86	54401.0
2023-03-28 05:00:00	IWM	ETF	173.85	173.86	173.49	173.58	6385.0
2023-03-28 06:00:00	IWM	ETF	173.41	173.45	173.09	173.24	45356.0
2023-03-28 07:00:00	IWM	ETF	173.28	173.8	173.26	173.46	71480.0
2023-03-28 08:00:00	IWM	ETF	173.31	174.59	172.86	173.13	203872.0
2023-03-28 09:00:00	IWM	ETF	173.18	174.36	172.69	173.92	3502743.0
2023-03-28 10:00:00	IWM	ETF	173.95	174.505	173.255	173.67	3177148.0
2023-03-28 11:00:00	IWM	ETF	173.655	174.2491	173.58	174.1094	1856800.0
2023-03-28 12:00:00	IWM	ETF	174.11	174.17	173.64	173.78	1274396.0
2023-03-28 13:00:00	IWM	ETF	173.79	173.815	172.73	172.8025	1971815.0
2023-03-28 14:00:00	IWM	ETF	172.77	173.47	172.744	173.405	1936843.0
2023-03-28 15:00:00	IWM	ETF	173.405	173.76	173.005	173.47	3786588.0
2023-03-28 16:00:00	IWM	ETF	173.45	173.86	173.45	173.77	3986874.0
2023-03-28 17:00:00	IWM	ETF	173.81	173.94	173.8	173.92	5702.0
2023-03-28 18:00:00	IWM	ETF	173.81	173.95	173.71	173.86	23062.0
2023-03-28 19:00:00	IWM	ETF	173.83	174.1	173.83	174.05	24156.0
2023-03-28 04:00:00	DIA	ETF	324.9	324.9	324.66	324.66	500.0
2023-03-28 06:00:00	DIA	ETF	324.19	324.19	323.92	323.92	300.0

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

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