PREVIEW / etf_1hour / 2023-06-16

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-06-16.parquet
  size:    479 KB
  rows:    17,454

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-06-16 04:00:00	SPY	ETF	440.77	441.58	440.56	441.47	88824.0
2023-06-16 05:00:00	SPY	ETF	441.49	441.61	441.21	441.21	34698.0
2023-06-16 06:00:00	SPY	ETF	441.37	441.37	440.72	440.89	43662.0
2023-06-16 07:00:00	SPY	ETF	440.96	441.59	440.93	441.24	382581.0
2023-06-16 08:00:00	SPY	ETF	441.17	442.28	440.01	442.19	443590.0
2023-06-16 09:00:00	SPY	ETF	442.159	443.25	440.77	441.26	9268934.0
2023-06-16 10:00:00	SPY	ETF	441.3	442.43	440.92	441.53	10315861.0
2023-06-16 11:00:00	SPY	ETF	441.535	442.0	440.335	441.24	8349387.0
2023-06-16 12:00:00	SPY	ETF	441.25	442.38	440.97	442.15	6439852.0
2023-06-16 13:00:00	SPY	ETF	442.15	442.24	440.92	441.32	5217162.0
2023-06-16 14:00:00	SPY	ETF	441.33	441.43	440.06	440.095	6066932.0
2023-06-16 15:00:00	SPY	ETF	440.1	440.35	438.97	439.43	17042491.0
2023-06-16 16:00:00	SPY	ETF	439.41	440.1	439.0	439.7	5981729.0
2023-06-16 17:00:00	SPY	ETF	439.7	439.9301	439.45	439.55	75316.0
2023-06-16 18:00:00	SPY	ETF	439.55	439.65	439.55	439.576	9090.0
2023-06-16 19:00:00	SPY	ETF	439.56	439.66	439.55	439.55	12705.0
2023-06-16 04:00:00	QQQ	ETF	369.88	371.14	369.88	370.86	128925.0
2023-06-16 05:00:00	QQQ	ETF	370.9	371.13	370.58	370.8	73972.0
2023-06-16 06:00:00	QQQ	ETF	370.84	370.87	370.24	370.74	83585.0
2023-06-16 07:00:00	QQQ	ETF	370.71	371.52	370.7	371.07	242640.0
2023-06-16 08:00:00	QQQ	ETF	370.67	371.99	369.34	371.77	549136.0
2023-06-16 09:00:00	QQQ	ETF	371.79	372.85	369.38	370.02	8689159.0
2023-06-16 10:00:00	QQQ	ETF	370.05	371.33	369.64	370.34	6487517.0
2023-06-16 11:00:00	QQQ	ETF	370.34	371.35	369.1301	370.31	4978388.0
2023-06-16 12:00:00	QQQ	ETF	370.3299	371.31	369.98	371.01	3455709.0
2023-06-16 13:00:00	QQQ	ETF	371.01	371.14	369.81	370.3	2987057.0
2023-06-16 14:00:00	QQQ	ETF	370.29	370.4199	368.8	368.85	3599040.0
2023-06-16 15:00:00	QQQ	ETF	368.84	369.1099	367.48	367.88	10801043.0
2023-06-16 16:00:00	QQQ	ETF	367.87	368.8	367.7332	368.49	2853939.0
2023-06-16 17:00:00	QQQ	ETF	368.52	368.6	367.93	368.45	1678056.0
2023-06-16 18:00:00	QQQ	ETF	368.4352	368.49	368.25	368.25	19627.0
2023-06-16 19:00:00	QQQ	ETF	368.2	368.55	368.2	368.37	18309.0
2023-06-16 04:00:00	IWM	ETF	187.38	187.84	187.31	187.75	38483.0
2023-06-16 05:00:00	IWM	ETF	187.75	187.85	187.53	187.57	52146.0
2023-06-16 06:00:00	IWM	ETF	187.58	187.58	187.03	187.06	30784.0
2023-06-16 07:00:00	IWM	ETF	187.21	187.35	187.06	187.1	110760.0
2023-06-16 08:00:00	IWM	ETF	187.24	187.91	186.88	187.71	169778.0
2023-06-16 09:00:00	IWM	ETF	187.67	188.55	186.38	186.53	4653408.0
2023-06-16 10:00:00	IWM	ETF	186.55	187.51	185.885	186.0	4178130.0
2023-06-16 11:00:00	IWM	ETF	186.01	186.235	185.09	185.63	3993389.0
2023-06-16 12:00:00	IWM	ETF	185.63	186.31	185.38	186.2357	2614585.0
2023-06-16 13:00:00	IWM	ETF	186.24	186.3	185.51	185.81	1942403.0
2023-06-16 14:00:00	IWM	ETF	185.8	185.8	185.34	185.52	2182682.0
2023-06-16 15:00:00	IWM	ETF	185.53	186.13	185.195	185.93	6292751.0
2023-06-16 16:00:00	IWM	ETF	185.94	186.58	185.521	186.23	4293207.0
2023-06-16 17:00:00	IWM	ETF	186.23	186.23	185.94	186.04	480415.0
2023-06-16 18:00:00	IWM	ETF	186.04	186.04	185.96	186.0	3203.0
2023-06-16 19:00:00	IWM	ETF	185.97	186.08	185.97	186.0	2929.0
2023-06-16 04:00:00	DIA	ETF	344.04	344.37	343.79	344.36	10922.0
2023-06-16 05:00:00	DIA	ETF	344.41	344.41	344.28	344.34	2800.0

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

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