PREVIEW / etf_1hour / 2023-03-17

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-03-17.parquet
  size:    461 KB
  rows:    16,971

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-17 04:00:00	SPY	ETF	395.02	395.98	394.77	394.95	126753.0
2023-03-17 05:00:00	SPY	ETF	394.93	395.64	394.62	394.92	96555.0
2023-03-17 06:00:00	SPY	ETF	394.9	394.94	393.95	394.04	158743.0
2023-03-17 07:00:00	SPY	ETF	394.12	394.22	393.02	393.61	597865.0
2023-03-17 08:00:00	SPY	ETF	393.21	395.4204	390.83	391.45	1657898.0
2023-03-17 09:00:00	SPY	ETF	391.47	394.17	391.47	392.8	12546568.0
2023-03-17 10:00:00	SPY	ETF	392.83	394.4	389.44	390.23	17933428.0
2023-03-17 11:00:00	SPY	ETF	390.23	390.985	388.56	389.5799	11074162.0
2023-03-17 12:00:00	SPY	ETF	389.59	391.78	389.51	390.37	9208000.0
2023-03-17 13:00:00	SPY	ETF	390.374	391.61	390.196	391.0088	6958563.0
2023-03-17 14:00:00	SPY	ETF	391.03	391.46	388.55	389.65	9924198.0
2023-03-17 15:00:00	SPY	ETF	389.64	390.87	389.2	390.11	18359930.0
2023-03-17 16:00:00	SPY	ETF	390.12	390.83	389.99	390.12	7079663.0
2023-03-17 17:00:00	SPY	ETF	390.18	391.2	389.91	391.07	1356833.0
2023-03-17 18:00:00	SPY	ETF	391.15	391.3	389.99	390.98	388541.0
2023-03-17 19:00:00	SPY	ETF	390.98	391.19	390.24	391.1	54862.0
2023-03-17 04:00:00	QQQ	ETF	307.45	307.89	306.98	307.14	278011.0
2023-03-17 05:00:00	QQQ	ETF	307.38	307.52	306.7	307.2	94650.0
2023-03-17 06:00:00	QQQ	ETF	307.21	307.34	306.75	307.02	41923.0
2023-03-17 07:00:00	QQQ	ETF	307.03	307.41	306.5	307.33	246724.0
2023-03-17 08:00:00	QQQ	ETF	307.03	308.03	305.52	305.91	935134.0
2023-03-17 09:00:00	QQQ	ETF	305.92	308.03	305.9	307.6301	7305751.0
2023-03-17 10:00:00	QQQ	ETF	307.68	309.15	304.23	305.16	11717939.0
2023-03-17 11:00:00	QQQ	ETF	305.15	305.72	303.37	304.45	6108727.0
2023-03-17 12:00:00	QQQ	ETF	304.47	306.07	304.22	305.01	5369984.0
2023-03-17 13:00:00	QQQ	ETF	305.0	306.41	304.95	306.05	5164761.0
2023-03-17 14:00:00	QQQ	ETF	306.06	306.53	303.73	304.625	5684908.0
2023-03-17 15:00:00	QQQ	ETF	304.66	305.77	304.23	305.33	10711410.0
2023-03-17 16:00:00	QQQ	ETF	305.32	305.9	305.25	305.33	1533678.0
2023-03-17 17:00:00	QQQ	ETF	305.27	305.75	305.21	305.7	129684.0
2023-03-17 18:00:00	QQQ	ETF	305.68	305.79	305.36	305.77	3290307.0
2023-03-17 19:00:00	QQQ	ETF	305.7	305.77	305.02	305.5	35762.0
2023-03-17 04:00:00	IWM	ETF	175.84	176.92	175.84	176.36	24900.0
2023-03-17 05:00:00	IWM	ETF	176.4	176.79	175.98	176.11	15490.0
2023-03-17 06:00:00	IWM	ETF	176.09	176.09	175.28	175.52	34641.0
2023-03-17 07:00:00	IWM	ETF	175.5	175.59	174.6	174.83	98928.0
2023-03-17 08:00:00	IWM	ETF	175.46	175.8	173.03	173.27	310892.0
2023-03-17 09:00:00	IWM	ETF	173.31	174.76	173.08	173.7	4386853.0
2023-03-17 10:00:00	IWM	ETF	173.71	174.54	171.72	171.98	6661355.0
2023-03-17 11:00:00	IWM	ETF	171.97	172.37	171.0301	171.81	5176874.0
2023-03-17 12:00:00	IWM	ETF	171.82	172.95	171.505	171.72	4260233.0
2023-03-17 13:00:00	IWM	ETF	171.73	172.4116	171.575	171.9199	4102440.0
2023-03-17 14:00:00	IWM	ETF	171.92	172.275	170.86	171.33	4802126.0
2023-03-17 15:00:00	IWM	ETF	171.35	172.025	171.05	171.34	12412958.0
2023-03-17 16:00:00	IWM	ETF	171.23	173.0333	171.23	171.8	1997426.0
2023-03-17 17:00:00	IWM	ETF	171.69	195.0	171.23	171.93	967279.0
2023-03-17 18:00:00	IWM	ETF	171.81	171.94	171.23	171.73	1084336.0
2023-03-17 19:00:00	IWM	ETF	171.85	171.92	171.35	171.36	24480.0
2023-03-17 04:00:00	DIA	ETF	323.1	323.1	322.43	322.43	2800.0
2023-03-17 05:00:00	DIA	ETF	322.7	322.87	322.42	322.44	3800.0

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

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