PREVIEW / etf_1hour / 2024-07-15

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-07-15.parquet
  size:    571 KB
  rows:    21,446

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-07-15 04:00:00	SPY	ETF	560.93	561.9	560.93	561.83	52781.0
2024-07-15 05:00:00	SPY	ETF	561.87	562.06	561.87	561.9	52445.0
2024-07-15 06:00:00	SPY	ETF	561.77	561.95	561.71	561.95	42082.0
2024-07-15 07:00:00	SPY	ETF	561.94	562.51	561.79	561.85	220197.0
2024-07-15 08:00:00	SPY	ETF	561.9417	562.4982	560.41	561.63	158165.0
2024-07-15 09:00:00	SPY	ETF	561.62	562.83	561.39	561.92	3919075.0
2024-07-15 10:00:00	SPY	ETF	561.91	563.79	561.8979	563.64	3673673.0
2024-07-15 11:00:00	SPY	ETF	563.64	564.8371	563.14	563.7799	3489655.0
2024-07-15 12:00:00	SPY	ETF	563.77	563.77	562.14	562.57	2752163.0
2024-07-15 13:00:00	SPY	ETF	562.56	562.58	560.72	561.04	2725781.0
2024-07-15 14:00:00	SPY	ETF	561.09	562.5	560.71	562.275	2136608.0
2024-07-15 15:00:00	SPY	ETF	562.28	562.56	559.63	561.49	8188056.0
2024-07-15 16:00:00	SPY	ETF	561.48	561.89	561.23	561.77	3097191.0
2024-07-15 17:00:00	SPY	ETF	561.77	561.93	561.53	561.82	124855.0
2024-07-15 18:00:00	SPY	ETF	561.83	562.41	561.83	562.19	45123.0
2024-07-15 19:00:00	SPY	ETF	562.2	562.37	562.19	562.22	13663.0
2024-07-15 04:00:00	QQQ	ETF	495.15	497.16	495.15	496.98	66618.0
2024-07-15 05:00:00	QQQ	ETF	497.05	497.14	496.95	497.06	8601.0
2024-07-15 06:00:00	QQQ	ETF	496.9	497.18	496.6	496.96	14049.0
2024-07-15 07:00:00	QQQ	ETF	497.03	497.64	496.81	496.86	127461.0
2024-07-15 08:00:00	QQQ	ETF	497.01	497.62	495.73	496.4001	228989.0
2024-07-15 09:00:00	QQQ	ETF	496.44	497.96	495.92	497.03	3175261.0
2024-07-15 10:00:00	QQQ	ETF	497.07	499.638	496.96	499.37	2541110.0
2024-07-15 11:00:00	QQQ	ETF	499.38	501.01	497.865	498.75	3525363.0
2024-07-15 12:00:00	QQQ	ETF	498.72	498.82	496.39	497.57	3081219.0
2024-07-15 13:00:00	QQQ	ETF	497.58	497.59	495.32	495.59	3041400.0
2024-07-15 14:00:00	QQQ	ETF	495.62	497.15	495.08	496.71	2254752.0
2024-07-15 15:00:00	QQQ	ETF	496.75	497.36	494.09	496.19	4751312.0
2024-07-15 16:00:00	QQQ	ETF	496.19	497.06	496.0	496.92	1103095.0
2024-07-15 17:00:00	QQQ	ETF	496.89	497.08	496.15	496.95	101615.0
2024-07-15 18:00:00	QQQ	ETF	496.98	497.45	496.1101	497.16	76849.0
2024-07-15 19:00:00	QQQ	ETF	497.2	497.37	497.08	497.12	26808.0
2024-07-15 04:00:00	IWM	ETF	214.75	215.65	214.6	215.64	108369.0
2024-07-15 05:00:00	IWM	ETF	215.59	215.76	215.39	215.4	78598.0
2024-07-15 06:00:00	IWM	ETF	215.34	215.47	214.96	215.45	81232.0
2024-07-15 07:00:00	IWM	ETF	215.45	215.62	214.65	214.82	168928.0
2024-07-15 08:00:00	IWM	ETF	215.5	215.59	214.54	214.66	202241.0
2024-07-15 09:00:00	IWM	ETF	214.68	215.785	214.3	215.75	4693232.0
2024-07-15 10:00:00	IWM	ETF	215.74	216.885	215.7	216.595	5828760.0
2024-07-15 11:00:00	IWM	ETF	216.6	218.16	216.59	218.01	4013387.0
2024-07-15 12:00:00	IWM	ETF	218.0	218.08	216.47	216.6	3830866.0
2024-07-15 13:00:00	IWM	ETF	216.61	217.28	216.12	216.8	2763431.0
2024-07-15 14:00:00	IWM	ETF	216.81	217.6471	216.69	217.5	2933767.0
2024-07-15 15:00:00	IWM	ETF	217.5	218.24	216.62	217.13	6669196.0
2024-07-15 16:00:00	IWM	ETF	217.19	217.37	216.6841	217.33	1413272.0
2024-07-15 17:00:00	IWM	ETF	217.38	217.68	217.38	217.56	75147.0
2024-07-15 18:00:00	IWM	ETF	217.55	217.9	217.41	217.73	82365.0
2024-07-15 19:00:00	IWM	ETF	217.71	217.9	217.71	217.82	44891.0
2024-07-15 04:00:00	DIA	ETF	401.45	401.85	401.45	401.85	2320.0
2024-07-15 05:00:00	DIA	ETF	401.98	402.29	401.98	402.01	3500.0

> showing 50 of 21,446 rows — these rows as CSV

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