PREVIEW / etf_1hour / 2023-05-15

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-05-15.parquet
  size:    461 KB
  rows:    16,856

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-05-15 04:00:00	SPY	ETF	413.18	413.5	412.34	412.95	108139.0
2023-05-15 05:00:00	SPY	ETF	412.96	413.28	412.94	413.0	33959.0
2023-05-15 06:00:00	SPY	ETF	413.1	413.35	412.88	413.28	35113.0
2023-05-15 07:00:00	SPY	ETF	413.28	413.36	413.02	413.14	204282.0
2023-05-15 08:00:00	SPY	ETF	413.22	413.4504	411.05	412.43	414736.0
2023-05-15 09:00:00	SPY	ETF	412.36	412.5	410.78	410.84	4930193.0
2023-05-15 10:00:00	SPY	ETF	410.85	411.98	410.23	411.4213	7733438.0
2023-05-15 11:00:00	SPY	ETF	411.435	412.21	411.36	411.98	5030013.0
2023-05-15 12:00:00	SPY	ETF	411.99	412.8	411.69	412.76	4067748.0
2023-05-15 13:00:00	SPY	ETF	412.77	413.43	411.57	412.3	6357388.0
2023-05-15 14:00:00	SPY	ETF	412.31	412.8	412.13	412.43	4249249.0
2023-05-15 15:00:00	SPY	ETF	412.43	413.03	412.37	413.01	7877345.0
2023-05-15 16:00:00	SPY	ETF	413.01	413.02	412.67	412.73	2053050.0
2023-05-15 17:00:00	SPY	ETF	412.65	413.01	412.65	412.75	57973.0
2023-05-15 18:00:00	SPY	ETF	412.74	412.9	412.6	412.7	48101.0
2023-05-15 19:00:00	SPY	ETF	412.69	412.77	412.52	412.56	45043.0
2023-05-15 04:00:00	QQQ	ETF	326.04	326.12	325.73	325.82	33976.0
2023-05-15 05:00:00	QQQ	ETF	325.9	326.25	325.77	325.88	88257.0
2023-05-15 06:00:00	QQQ	ETF	325.87	326.0	325.6	325.92	130383.0
2023-05-15 07:00:00	QQQ	ETF	325.9	326.1	325.67	325.84	141179.0
2023-05-15 08:00:00	QQQ	ETF	325.94	326.1604	324.88	325.73	357412.0
2023-05-15 09:00:00	QQQ	ETF	325.66	325.86	324.52	324.56	3717601.0
2023-05-15 10:00:00	QQQ	ETF	324.57	325.37	323.96	324.76	4352936.0
2023-05-15 11:00:00	QQQ	ETF	324.755	326.29	324.72	326.25	3445269.0
2023-05-15 12:00:00	QQQ	ETF	326.26	326.42	325.73	326.4051	2182255.0
2023-05-15 13:00:00	QQQ	ETF	326.41	327.03	325.57	326.35	3885721.0
2023-05-15 14:00:00	QQQ	ETF	326.36	326.69	326.18	326.31	2580466.0
2023-05-15 15:00:00	QQQ	ETF	326.305	326.9	326.19	326.86	4323410.0
2023-05-15 16:00:00	QQQ	ETF	326.88	326.9	326.58	326.63	843497.0
2023-05-15 17:00:00	QQQ	ETF	326.63	326.68	326.57	326.6291	36314.0
2023-05-15 18:00:00	QQQ	ETF	326.61	326.73	326.5	326.52	33842.0
2023-05-15 19:00:00	QQQ	ETF	326.52	326.66	326.48	326.57	75533.0
2023-05-15 04:00:00	IWM	ETF	173.77	174.04	173.53	173.56	10100.0
2023-05-15 05:00:00	IWM	ETF	173.58	173.81	173.58	173.71	5900.0
2023-05-15 06:00:00	IWM	ETF	173.83	174.06	173.65	174.06	6871.0
2023-05-15 07:00:00	IWM	ETF	174.02	174.02	173.74	173.77	62018.0
2023-05-15 08:00:00	IWM	ETF	173.76	174.0104	172.8	173.29	142441.0
2023-05-15 09:00:00	IWM	ETF	173.16	173.835	172.82	173.69	2388162.0
2023-05-15 10:00:00	IWM	ETF	173.7	174.335	173.34	174.06	2870205.0
2023-05-15 11:00:00	IWM	ETF	174.06	174.52	174.02	174.36	2105529.0
2023-05-15 12:00:00	IWM	ETF	174.35	175.23	174.165	175.145	2008875.0
2023-05-15 13:00:00	IWM	ETF	175.145	175.71	174.635	174.91	2713934.0
2023-05-15 14:00:00	IWM	ETF	174.92	175.03	174.59	174.765	1419866.0
2023-05-15 15:00:00	IWM	ETF	174.765	174.95	174.72	174.87	3257533.0
2023-05-15 16:00:00	IWM	ETF	174.83	174.94	174.749	174.75	1164263.0
2023-05-15 17:00:00	IWM	ETF	174.8	174.88	174.8	174.84	95329.0
2023-05-15 18:00:00	IWM	ETF	174.81	174.89	174.73	174.73	17446.0
2023-05-15 19:00:00	IWM	ETF	174.79	174.81	174.66	174.68	25338.0
2023-05-15 04:00:00	DIA	ETF	334.32	334.35	334.32	334.35	985.0
2023-05-15 07:00:00	DIA	ETF	334.52	334.55	334.4	334.46	7900.0

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

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