PREVIEW / etf_1hour / 2023-07-17

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-07-17.parquet
  size:    485 KB
  rows:    17,604

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-07-17 04:00:00	SPY	ETF	449.22	449.33	448.92	448.92	24967.0
2023-07-17 05:00:00	SPY	ETF	448.93	449.09	448.43	448.47	21764.0
2023-07-17 06:00:00	SPY	ETF	448.51	448.65	448.38	448.38	78305.0
2023-07-17 07:00:00	SPY	ETF	448.39	448.8	448.35	448.45	116511.0
2023-07-17 08:00:00	SPY	ETF	448.45	449.1	448.25	448.72	181279.0
2023-07-17 09:00:00	SPY	ETF	448.74	449.8	448.72	449.64	4222820.0
2023-07-17 10:00:00	SPY	ETF	449.64	450.141	449.6	449.96	5163840.0
2023-07-17 11:00:00	SPY	ETF	449.97	450.74	449.77	450.67	4972895.0
2023-07-17 12:00:00	SPY	ETF	450.69	450.73	450.04	450.6	3388483.0
2023-07-17 13:00:00	SPY	ETF	450.598	450.86	450.285	450.79	2471541.0
2023-07-17 14:00:00	SPY	ETF	450.8	451.13	450.645	450.89	3164176.0
2023-07-17 15:00:00	SPY	ETF	450.89	451.93	450.6	450.855	12511173.0
2023-07-17 16:00:00	SPY	ETF	450.84	451.5	450.32	450.41	2254868.0
2023-07-17 17:00:00	SPY	ETF	450.41	450.54	450.39	450.54	53100.0
2023-07-17 18:00:00	SPY	ETF	450.5	450.62	450.31	450.37	51261.0
2023-07-17 19:00:00	SPY	ETF	450.4	450.47	450.28	450.29	37721.0
2023-07-17 04:00:00	QQQ	ETF	379.51	379.77	379.4	379.4	80161.0
2023-07-17 05:00:00	QQQ	ETF	379.38	379.38	378.79	378.8	44130.0
2023-07-17 06:00:00	QQQ	ETF	378.91	379.05	378.58	378.76	86136.0
2023-07-17 07:00:00	QQQ	ETF	378.75	379.19	378.75	378.81	89128.0
2023-07-17 08:00:00	QQQ	ETF	379.0	379.5	378.53	379.29	170672.0
2023-07-17 09:00:00	QQQ	ETF	379.32	381.0801	379.18	380.07	6046638.0
2023-07-17 10:00:00	QQQ	ETF	380.065	380.85	379.82	380.44	4549019.0
2023-07-17 11:00:00	QQQ	ETF	380.47	381.77	380.09	381.68	3657217.0
2023-07-17 12:00:00	QQQ	ETF	381.68	381.7201	380.56	381.41	2330271.0
2023-07-17 13:00:00	QQQ	ETF	381.42	382.03	381.02	381.9905	2010941.0
2023-07-17 14:00:00	QQQ	ETF	381.99	382.38	381.71	382.14	2569018.0
2023-07-17 15:00:00	QQQ	ETF	382.15	383.5	382.075	382.6	7381081.0
2023-07-17 16:00:00	QQQ	ETF	382.6	382.61	382.06	382.2	970402.0
2023-07-17 17:00:00	QQQ	ETF	382.24	382.61	382.12	382.38	652831.0
2023-07-17 18:00:00	QQQ	ETF	382.38	382.38	381.96	381.9996	56284.0
2023-07-17 19:00:00	QQQ	ETF	382.0	382.1901	381.95	381.98	32770.0
2023-07-17 04:00:00	IWM	ETF	191.61	191.71	191.31	191.4	10057.0
2023-07-17 05:00:00	IWM	ETF	191.43	191.63	191.02	191.1	6217.0
2023-07-17 06:00:00	IWM	ETF	191.14	191.28	191.1	191.12	100282.0
2023-07-17 07:00:00	IWM	ETF	191.11	191.42	191.09	191.2	66258.0
2023-07-17 08:00:00	IWM	ETF	191.2	191.55	191.12	191.49	100875.0
2023-07-17 09:00:00	IWM	ETF	191.56	193.16	191.14	192.96	3491440.0
2023-07-17 10:00:00	IWM	ETF	192.96	193.45	192.62	193.26	2680383.0
2023-07-17 11:00:00	IWM	ETF	193.24	193.85	193.1	193.7	1722201.0
2023-07-17 12:00:00	IWM	ETF	193.7	194.195	193.69	193.98	1604849.0
2023-07-17 13:00:00	IWM	ETF	193.99	194.36	193.8005	194.11	1193131.0
2023-07-17 14:00:00	IWM	ETF	194.12	194.34	193.89	194.045	907040.0
2023-07-17 15:00:00	IWM	ETF	194.05	194.14	193.51	193.6	4486838.0
2023-07-17 16:00:00	IWM	ETF	193.58	193.62	193.24	193.25	821598.0
2023-07-17 17:00:00	IWM	ETF	193.26	193.54	193.26	193.44	38644.0
2023-07-17 18:00:00	IWM	ETF	193.42	193.45	193.24	193.36	21169.0
2023-07-17 19:00:00	IWM	ETF	193.4	193.43	193.22	193.26	26703.0
2023-07-17 04:00:00	DIA	ETF	344.6	344.6	344.6	344.6	450.0
2023-07-17 05:00:00	DIA	ETF	344.6	344.6	344.6	344.6	200.0

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

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