PREVIEW / etf_1hour / 2024-04-17

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-04-17.parquet
  size:    530 KB
  rows:    19,958

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
2024-04-17 04:00:00	SPY	ETF	504.15	505.48	504.15	505.24	36076.0
2024-04-17 05:00:00	SPY	ETF	505.15	505.5	504.56	505.35	30154.0
2024-04-17 06:00:00	SPY	ETF	505.49	506.02	505.33	505.54	150230.0
2024-04-17 07:00:00	SPY	ETF	505.56	505.75	504.9	505.07	265364.0
2024-04-17 08:00:00	SPY	ETF	505.62	506.05	502.25	505.36	397317.0
2024-04-17 09:00:00	SPY	ETF	505.35	506.32	505.0	505.29	5897805.0
2024-04-17 10:00:00	SPY	ETF	505.295	505.355	502.19	502.9	7509195.0
2024-04-17 11:00:00	SPY	ETF	502.91	504.01	501.01	501.73	7064543.0
2024-04-17 12:00:00	SPY	ETF	501.71	501.79	499.12	499.89	9140821.0
2024-04-17 13:00:00	SPY	ETF	499.91	502.56	499.69	502.4	7408580.0
2024-04-17 14:00:00	SPY	ETF	502.41	504.03	501.3	501.59	7269641.0
2024-04-17 15:00:00	SPY	ETF	501.59	501.82	500.36	500.5	12757444.0
2024-04-17 16:00:00	SPY	ETF	500.49	500.65	500.05	500.57	2596157.0
2024-04-17 17:00:00	SPY	ETF	500.62	500.89	500.62	500.72	113367.0
2024-04-17 18:00:00	SPY	ETF	500.72	500.99	500.72	500.91	50307.0
2024-04-17 19:00:00	SPY	ETF	500.92	501.09	500.73	501.06	55650.0
2024-04-17 04:00:00	QQQ	ETF	431.28	432.25	430.87	431.93	82197.0
2024-04-17 05:00:00	QQQ	ETF	431.99	432.4	431.39	432.4	53354.0
2024-04-17 06:00:00	QQQ	ETF	432.41	432.72	432.07	432.17	72601.0
2024-04-17 07:00:00	QQQ	ETF	432.27	432.6	431.85	431.92	162807.0
2024-04-17 08:00:00	QQQ	ETF	432.39	432.64	429.0	432.47	288539.0
2024-04-17 09:00:00	QQQ	ETF	432.41	433.33	431.11	431.52	4032476.0
2024-04-17 10:00:00	QQQ	ETF	431.57	431.6	428.46	429.36	5766067.0
2024-04-17 11:00:00	QQQ	ETF	429.37	430.53	427.5401	428.04	5076171.0
2024-04-17 12:00:00	QQQ	ETF	428.04	428.11	424.9	425.51	6481827.0
2024-04-17 13:00:00	QQQ	ETF	425.56	428.05	425.39	427.9099	5812624.0
2024-04-17 14:00:00	QQQ	ETF	427.91	429.25	426.585	427.0	4574396.0
2024-04-17 15:00:00	QQQ	ETF	426.99	427.25	425.68	425.8	8322637.0
2024-04-17 16:00:00	QQQ	ETF	425.8	426.8	425.48	426.03	2928114.0
2024-04-17 17:00:00	QQQ	ETF	426.03	426.25	426.03	426.18	54897.0
2024-04-17 18:00:00	QQQ	ETF	426.18	426.54	425.84	426.43	83021.0
2024-04-17 19:00:00	QQQ	ETF	426.42	426.67	426.3	426.59	184619.0
2024-04-17 04:00:00	IWM	ETF	195.49	196.27	195.49	196.27	12755.0
2024-04-17 05:00:00	IWM	ETF	196.22	196.66	195.97	196.63	27823.0
2024-04-17 06:00:00	IWM	ETF	196.64	196.78	196.25	196.35	18486.0
2024-04-17 07:00:00	IWM	ETF	196.27	196.38	195.87	195.93	54155.0
2024-04-17 08:00:00	IWM	ETF	196.2811	196.7104	194.42	195.69	158021.0
2024-04-17 09:00:00	IWM	ETF	195.65	196.68	195.61	196.12	2507545.0
2024-04-17 10:00:00	IWM	ETF	196.13	196.14	194.3795	194.75	3741759.0
2024-04-17 11:00:00	IWM	ETF	194.76	195.32	193.78	194.4	3256504.0
2024-04-17 12:00:00	IWM	ETF	194.39	194.39	193.08	193.37	3743408.0
2024-04-17 13:00:00	IWM	ETF	193.38	194.88	193.32	194.82	4098751.0
2024-04-17 14:00:00	IWM	ETF	194.83	195.21	193.82	194.02	2764029.0
2024-04-17 15:00:00	IWM	ETF	194.02	194.02	192.99	193.05	6052955.0
2024-04-17 16:00:00	IWM	ETF	193.06	193.18	192.8	193.09	2366116.0
2024-04-17 17:00:00	IWM	ETF	193.06	193.25	192.87	193.0252	109073.0
2024-04-17 18:00:00	IWM	ETF	193.12	193.41	193.0	193.41	137216.0
2024-04-17 19:00:00	IWM	ETF	193.41	193.48	193.28	193.29	129608.0
2024-04-17 04:00:00	DIA	ETF	378.72	379.7	378.72	379.7	605.0
2024-04-17 05:00:00	DIA	ETF	379.34	379.34	379.12	379.24	1512.0

> showing 50 of 19,958 rows — these rows as CSV

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