PREVIEW / etf_1hour / 2023-04-27

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-04-27.parquet
  size:    471 KB
  rows:    16,888

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-27 04:00:00	SPY	ETF	406.06	406.7	406.06	406.65	21789.0
2023-04-27 05:00:00	SPY	ETF	406.63	406.72	406.45	406.45	20198.0
2023-04-27 06:00:00	SPY	ETF	406.56	406.82	406.35	406.8	40584.0
2023-04-27 07:00:00	SPY	ETF	406.83	407.11	406.4	406.91	255658.0
2023-04-27 08:00:00	SPY	ETF	406.88	407.57	405.73	406.98	791484.0
2023-04-27 09:00:00	SPY	ETF	407.02	407.85	406.74	407.56	7802761.0
2023-04-27 10:00:00	SPY	ETF	407.56	408.57	407.43	407.699	9722009.0
2023-04-27 11:00:00	SPY	ETF	407.71	409.21	407.45	409.17	6884251.0
2023-04-27 12:00:00	SPY	ETF	409.17	409.85	409.16	409.755	5766554.0
2023-04-27 13:00:00	SPY	ETF	409.76	411.149	409.57	410.77	6489535.0
2023-04-27 14:00:00	SPY	ETF	410.78	412.5	410.74	412.47	9804793.0
2023-04-27 15:00:00	SPY	ETF	412.48	412.69	412.07	412.4	18184273.0
2023-04-27 16:00:00	SPY	ETF	412.39	413.57	410.4774	412.8	5907202.0
2023-04-27 17:00:00	SPY	ETF	412.79	412.99	411.8	411.87	674633.0
2023-04-27 18:00:00	SPY	ETF	411.94	412.24	411.68	411.88	198472.0
2023-04-27 19:00:00	SPY	ETF	411.94	412.21	411.81	411.86	79262.0
2023-04-27 04:00:00	QQQ	ETF	314.86	314.93	313.9	314.56	48375.0
2023-04-27 05:00:00	QQQ	ETF	314.69	314.8	314.41	314.41	24565.0
2023-04-27 06:00:00	QQQ	ETF	314.46	314.72	314.11	314.65	42372.0
2023-04-27 07:00:00	QQQ	ETF	314.64	315.05	314.51	314.92	187476.0
2023-04-27 08:00:00	QQQ	ETF	314.61	315.85	312.103	315.28	752133.0
2023-04-27 09:00:00	QQQ	ETF	315.26	316.24	315.05	315.3	6172626.0
2023-04-27 10:00:00	QQQ	ETF	315.3	317.585	315.11	316.84	7819296.0
2023-04-27 11:00:00	QQQ	ETF	316.85	318.31	316.765	318.03	5353417.0
2023-04-27 12:00:00	QQQ	ETF	318.05	318.97	318.02	318.925	3199523.0
2023-04-27 13:00:00	QQQ	ETF	318.93	320.0	318.71	319.62	3828689.0
2023-04-27 14:00:00	QQQ	ETF	319.63	320.5	319.625	320.47	4918136.0
2023-04-27 15:00:00	QQQ	ETF	320.47	320.86	320.195	320.4	11044679.0
2023-04-27 16:00:00	QQQ	ETF	320.39	322.8	319.65	321.08	4110305.0
2023-04-27 17:00:00	QQQ	ETF	321.05	321.79	319.52	319.61	1046693.0
2023-04-27 18:00:00	QQQ	ETF	319.76	320.2192	319.4	319.65	761031.0
2023-04-27 19:00:00	QQQ	ETF	319.67	320.15	319.67	319.85	186688.0
2023-04-27 04:00:00	IWM	ETF	171.88	172.1	171.8	172.1	20550.0
2023-04-27 05:00:00	IWM	ETF	171.92	171.95	171.9	171.95	2615.0
2023-04-27 06:00:00	IWM	ETF	171.89	172.0	171.72	172.0	26109.0
2023-04-27 07:00:00	IWM	ETF	172.0	172.16	171.87	172.07	206096.0
2023-04-27 08:00:00	IWM	ETF	172.0701	172.34	171.5	172.34	223206.0
2023-04-27 09:00:00	IWM	ETF	172.35	172.53	171.52	172.42	3869422.0
2023-04-27 10:00:00	IWM	ETF	172.43	172.62	171.265	171.515	4098714.0
2023-04-27 11:00:00	IWM	ETF	171.52	172.54	170.94	172.49	3634365.0
2023-04-27 12:00:00	IWM	ETF	172.49	173.03	172.47	172.63	2807712.0
2023-04-27 13:00:00	IWM	ETF	172.64	173.54	172.525	173.31	2066813.0
2023-04-27 14:00:00	IWM	ETF	173.31	173.73	173.21	173.72	2583467.0
2023-04-27 15:00:00	IWM	ETF	173.71	173.855	173.435	173.66	5080606.0
2023-04-27 16:00:00	IWM	ETF	173.68	173.8	173.21	173.48	1323452.0
2023-04-27 17:00:00	IWM	ETF	173.46	173.68	173.17	173.28	429401.0
2023-04-27 18:00:00	IWM	ETF	173.41	173.57	173.36	173.48	41832.0
2023-04-27 19:00:00	IWM	ETF	173.5	173.6	173.4	173.44	16941.0
2023-04-27 04:00:00	DIA	ETF	333.91	334.0	333.9	334.0	1100.0
2023-04-27 06:00:00	DIA	ETF	334.16	335.1	334.16	334.9	4280.0

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

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