PREVIEW / etf_1hour / 2023-04-20

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-04-20.parquet
  size:    461 KB
  rows:    16,708

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-04-20 04:00:00	SPY	ETF	411.55	411.64	411.0	411.21	48119.0
2023-04-20 05:00:00	SPY	ETF	411.18	411.58	411.13	411.47	22133.0
2023-04-20 06:00:00	SPY	ETF	411.47	411.75	411.27	411.75	144467.0
2023-04-20 07:00:00	SPY	ETF	411.75	411.97	411.25	411.25	266774.0
2023-04-20 08:00:00	SPY	ETF	411.62	413.48	410.87	411.54	566568.0
2023-04-20 09:00:00	SPY	ETF	411.59	412.32	411.08	411.66	6993535.0
2023-04-20 10:00:00	SPY	ETF	411.65	412.87	411.36	412.7199	7213612.0
2023-04-20 11:00:00	SPY	ETF	412.72	412.84	411.81	412.3178	5190337.0
2023-04-20 12:00:00	SPY	ETF	412.315	413.32	411.83	413.24	4586077.0
2023-04-20 13:00:00	SPY	ETF	413.26	413.7	413.1	413.23	5629289.0
2023-04-20 14:00:00	SPY	ETF	413.22	413.25	411.14	411.6301	9389314.0
2023-04-20 15:00:00	SPY	ETF	411.64	411.95	410.27	411.88	17527419.0
2023-04-20 16:00:00	SPY	ETF	411.87	412.36	411.79	411.93	3245128.0
2023-04-20 17:00:00	SPY	ETF	411.97	412.03	411.81	411.86	59023.0
2023-04-20 18:00:00	SPY	ETF	411.86	411.93	411.71	411.8	43180.0
2023-04-20 19:00:00	SPY	ETF	411.98	412.01	411.62	411.75	61138.0
2023-04-20 04:00:00	QQQ	ETF	317.0	317.0	315.07	315.29	83256.0
2023-04-20 05:00:00	QQQ	ETF	315.26	315.64	315.16	315.59	41071.0
2023-04-20 06:00:00	QQQ	ETF	315.59	316.05	315.51	316.03	45630.0
2023-04-20 07:00:00	QQQ	ETF	316.0	316.19	315.62	315.63	196490.0
2023-04-20 08:00:00	QQQ	ETF	316.12	318.949	315.27	316.1	577074.0
2023-04-20 09:00:00	QQQ	ETF	316.11	317.48	315.57	317.26	5521621.0
2023-04-20 10:00:00	QQQ	ETF	317.25	318.23	317.06	317.57	5615492.0
2023-04-20 11:00:00	QQQ	ETF	317.59	318.08	316.68	317.755	4272286.0
2023-04-20 12:00:00	QQQ	ETF	317.77	318.7	317.19	318.651	3671661.0
2023-04-20 13:00:00	QQQ	ETF	318.66	319.27	318.45	318.54	4034335.0
2023-04-20 14:00:00	QQQ	ETF	318.54	318.57	316.07	316.62	8142297.0
2023-04-20 15:00:00	QQQ	ETF	316.62	316.82	314.97	316.31	10586829.0
2023-04-20 16:00:00	QQQ	ETF	316.3	316.8	316.25	316.62	2473195.0
2023-04-20 17:00:00	QQQ	ETF	316.62	316.64	316.28	316.53	36438.0
2023-04-20 18:00:00	QQQ	ETF	316.56	316.56	316.31	316.48	41667.0
2023-04-20 19:00:00	QQQ	ETF	316.49	316.68	316.31	316.46	75676.0
2023-04-20 04:00:00	IWM	ETF	176.72	176.82	176.52	176.65	17463.0
2023-04-20 05:00:00	IWM	ETF	176.75	176.86	176.65	176.8	4963.0
2023-04-20 06:00:00	IWM	ETF	176.88	176.97	176.59	176.91	8940.0
2023-04-20 07:00:00	IWM	ETF	176.94	177.07	176.56	176.62	52023.0
2023-04-20 08:00:00	IWM	ETF	176.88	177.1	176.39	176.92	103223.0
2023-04-20 09:00:00	IWM	ETF	176.94	177.39	176.52	177.37	2477670.0
2023-04-20 10:00:00	IWM	ETF	177.36	178.43	177.27	178.11	2296458.0
2023-04-20 11:00:00	IWM	ETF	178.12	178.19	176.9685	177.25	2051945.0
2023-04-20 12:00:00	IWM	ETF	177.27	177.78	176.97	177.75	1025855.0
2023-04-20 13:00:00	IWM	ETF	177.75	178.03	177.65	177.72	1027296.0
2023-04-20 14:00:00	IWM	ETF	177.71	177.75	176.89	177.155	2131649.0
2023-04-20 15:00:00	IWM	ETF	177.16	177.51	176.58	177.34	3990529.0
2023-04-20 16:00:00	IWM	ETF	177.33	177.61	177.27	177.319	822896.0
2023-04-20 17:00:00	IWM	ETF	177.231	177.35	177.19	177.23	2134.0
2023-04-20 18:00:00	IWM	ETF	177.33	177.36	177.15	177.2	11780.0
2023-04-20 19:00:00	IWM	ETF	177.15	177.33	177.08	177.17	6894.0
2023-04-20 04:00:00	DIA	ETF	337.33	337.33	337.29	337.29	400.0
2023-04-20 05:00:00	DIA	ETF	337.68	337.68	337.68	337.68	200.0

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

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