PREVIEW / etf_1hour / 2023-01-19

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-01-19.parquet
  size:    465 KB
  rows:    17,070

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-01-19 04:00:00	SPY	ETF	390.22	390.62	389.82	389.95	82672.0
2023-01-19 05:00:00	SPY	ETF	389.96	390.26	389.37	389.64	155412.0
2023-01-19 06:00:00	SPY	ETF	389.66	389.66	388.71	388.95	315227.0
2023-01-19 07:00:00	SPY	ETF	389.0	389.02	388.17	388.34	360897.0
2023-01-19 08:00:00	SPY	ETF	388.85	391.19	387.83	388.93	909040.0
2023-01-19 09:00:00	SPY	ETF	388.94	390.43	388.5	389.28	7566809.0
2023-01-19 10:00:00	SPY	ETF	389.28	389.88	387.56	387.936	8837466.0
2023-01-19 11:00:00	SPY	ETF	387.94	389.06	387.26	387.8277	6563847.0
2023-01-19 12:00:00	SPY	ETF	387.8201	389.0374	387.81	388.6	5146402.0
2023-01-19 13:00:00	SPY	ETF	388.5835	390.61	388.53	389.81	8790572.0
2023-01-19 14:00:00	SPY	ETF	389.8	391.08	389.25	390.467	8284003.0
2023-01-19 15:00:00	SPY	ETF	390.4723	390.895	388.5	388.68	15045878.0
2023-01-19 16:00:00	SPY	ETF	388.68	389.76	388.56	389.14	5604522.0
2023-01-19 17:00:00	SPY	ETF	389.04	389.39	388.87	389.34	96142.0
2023-01-19 18:00:00	SPY	ETF	389.37	389.52	388.64	388.95	114631.0
2023-01-19 19:00:00	SPY	ETF	388.88	389.55	388.64	389.38	147493.0
2023-01-19 04:00:00	QQQ	ETF	277.08	277.54	276.65	276.71	45731.0
2023-01-19 05:00:00	QQQ	ETF	276.78	276.91	276.17	276.39	56619.0
2023-01-19 06:00:00	QQQ	ETF	276.23	276.27	275.5	275.71	179648.0
2023-01-19 07:00:00	QQQ	ETF	275.74	275.8	275.07	275.23	263614.0
2023-01-19 08:00:00	QQQ	ETF	275.59	278.088	274.8	275.84	618342.0
2023-01-19 09:00:00	QQQ	ETF	275.78	277.225	274.85	275.98	6397105.0
2023-01-19 10:00:00	QQQ	ETF	275.99	276.5	274.2	274.535	5796238.0
2023-01-19 11:00:00	QQQ	ETF	274.54	275.67	273.89	274.39	4005838.0
2023-01-19 12:00:00	QQQ	ETF	274.39	275.4	274.37	275.01	2343065.0
2023-01-19 13:00:00	QQQ	ETF	275.02	276.72	274.91	275.995	3686168.0
2023-01-19 14:00:00	QQQ	ETF	275.99	277.375	275.57	276.7	3442837.0
2023-01-19 15:00:00	QQQ	ETF	276.7	277.08	274.895	275.09	5553499.0
2023-01-19 16:00:00	QQQ	ETF	275.1	276.45	274.9	275.93	1691531.0
2023-01-19 17:00:00	QQQ	ETF	275.95	276.11	275.15	276.05	66755.0
2023-01-19 18:00:00	QQQ	ETF	276.08	276.2	275.66	275.77	54765.0
2023-01-19 19:00:00	QQQ	ETF	275.69	276.18	275.15	276.07	357400.0
2023-01-19 04:00:00	IWM	ETF	183.31	183.45	183.01	183.06	18001.0
2023-01-19 05:00:00	IWM	ETF	183.06	183.3	182.76	183.06	8654.0
2023-01-19 06:00:00	IWM	ETF	182.99	183.03	182.51	182.63	20135.0
2023-01-19 07:00:00	IWM	ETF	182.67	182.68	181.96	182.09	48418.0
2023-01-19 08:00:00	IWM	ETF	182.555	182.79	181.77	182.72	145397.0
2023-01-19 09:00:00	IWM	ETF	182.69	183.1	181.74	182.1	2924361.0
2023-01-19 10:00:00	IWM	ETF	182.11	182.46	180.78	181.07	2453890.0
2023-01-19 11:00:00	IWM	ETF	181.07	181.81	180.81	181.32	1960301.0
2023-01-19 12:00:00	IWM	ETF	181.31	182.125	181.3	181.71	1490710.0
2023-01-19 13:00:00	IWM	ETF	181.72	182.9	181.635	182.36	2287220.0
2023-01-19 14:00:00	IWM	ETF	182.35	182.975	181.99	182.53	2467295.0
2023-01-19 15:00:00	IWM	ETF	182.54	182.77	181.96	182.03	3181162.0
2023-01-19 16:00:00	IWM	ETF	182.04	182.42	181.85	181.93	1107154.0
2023-01-19 17:00:00	IWM	ETF	181.86	182.19	181.86	182.11	20670.0
2023-01-19 18:00:00	IWM	ETF	182.18	182.24	181.83	181.89	37876.0
2023-01-19 19:00:00	IWM	ETF	181.81	182.27	181.81	182.27	114567.0
2023-01-19 04:00:00	DIA	ETF	331.89	331.89	331.66	331.67	1319.0
2023-01-19 05:00:00	DIA	ETF	331.34	331.34	331.24	331.24	2000.0

> showing 50 of 17,070 rows — these rows as CSV

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