PREVIEW / etf_1hour / 2021-06-04

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-06-04.parquet
  size:    403 KB
  rows:    13,996

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
2021-06-04 04:00:00	SPY	ETF	418.91	419.22	418.64	418.78	3395.0
2021-06-04 05:00:00	SPY	ETF	418.7	419.03	418.64	419.03	7481.0
2021-06-04 06:00:00	SPY	ETF	418.8	418.87	418.46	418.77	86627.0
2021-06-04 07:00:00	SPY	ETF	418.84	419.31	418.84	419.2	71573.0
2021-06-04 08:00:00	SPY	ETF	419.2599	420.76	418.7304	420.44	1127697.0
2021-06-04 09:00:00	SPY	ETF	420.56	421.5	420.42	421.25	5134670.0
2021-06-04 10:00:00	SPY	ETF	421.25	421.87	421.23	421.715	6067929.0
2021-06-04 11:00:00	SPY	ETF	421.72	422.02	421.46	421.585	3360071.0
2021-06-04 12:00:00	SPY	ETF	421.5899	421.895	421.47	421.88	1874287.0
2021-06-04 13:00:00	SPY	ETF	421.88	422.21	421.77	422.155	2322694.0
2021-06-04 14:00:00	SPY	ETF	422.155	422.65	422.15	422.4901	4085909.0
2021-06-04 15:00:00	SPY	ETF	422.495	422.92	422.34	422.57	11683863.0
2021-06-04 16:00:00	SPY	ETF	422.57	422.6	422.21	422.47	4205054.0
2021-06-04 17:00:00	SPY	ETF	422.48	422.69	422.41	422.52	532515.0
2021-06-04 18:00:00	SPY	ETF	422.52	422.6	422.5	422.56	23511.0
2021-06-04 19:00:00	SPY	ETF	422.56	422.68	422.56	422.62	5027.0
2021-06-04 04:00:00	QQQ	ETF	329.79	330.29	329.72	329.82	46207.0
2021-06-04 05:00:00	QQQ	ETF	329.9	330.19	329.71	330.16	32034.0
2021-06-04 06:00:00	QQQ	ETF	330.05	330.09	329.23	330.0	37863.0
2021-06-04 07:00:00	QQQ	ETF	330.07	330.54	330.07	330.47	110292.0
2021-06-04 08:00:00	QQQ	ETF	330.29	331.83	329.5404	331.56	1489048.0
2021-06-04 09:00:00	QQQ	ETF	331.6	334.1401	331.43	333.9999	5321916.0
2021-06-04 10:00:00	QQQ	ETF	334.01	335.41	334.01	334.88	6563068.0
2021-06-04 11:00:00	QQQ	ETF	334.89	335.72	334.7799	335.3618	2675605.0
2021-06-04 12:00:00	QQQ	ETF	335.38	335.65	335.15	335.48	1627232.0
2021-06-04 13:00:00	QQQ	ETF	335.48	335.9	335.33	335.83	1701541.0
2021-06-04 14:00:00	QQQ	ETF	335.83	336.05	335.7594	335.8487	2010491.0
2021-06-04 15:00:00	QQQ	ETF	335.84	336.0582	335.3913	335.68	5655770.0
2021-06-04 16:00:00	QQQ	ETF	335.65	335.73	335.4	335.59	965626.0
2021-06-04 17:00:00	QQQ	ETF	335.65	335.71	335.58	335.6	14951.0
2021-06-04 18:00:00	QQQ	ETF	335.61	335.7	335.55	335.7	6705.0
2021-06-04 19:00:00	QQQ	ETF	335.7	335.8	335.6501	335.8	13378.0
2021-06-04 04:00:00	IWM	ETF	226.55	226.71	226.2	226.2	9080.0
2021-06-04 05:00:00	IWM	ETF	226.6	226.76	226.39	226.76	4167.0
2021-06-04 06:00:00	IWM	ETF	226.59	226.59	225.98	226.23	11409.0
2021-06-04 07:00:00	IWM	ETF	226.42	226.92	226.42	226.75	25656.0
2021-06-04 08:00:00	IWM	ETF	226.6204	227.71	226.2704	227.46	141425.0
2021-06-04 09:00:00	IWM	ETF	227.54	228.055	226.85	227.09	2986194.0
2021-06-04 10:00:00	IWM	ETF	227.115	227.29	226.21	226.97	2973709.0
2021-06-04 11:00:00	IWM	ETF	226.95	227.12	226.575	226.68	1500024.0
2021-06-04 12:00:00	IWM	ETF	226.69	227.29	226.585	227.28	971360.0
2021-06-04 13:00:00	IWM	ETF	227.28	227.63	227.15	227.44	1134704.0
2021-06-04 14:00:00	IWM	ETF	227.44	227.52	226.885	227.0	1243856.0
2021-06-04 15:00:00	IWM	ETF	227.0	227.64	226.94	227.39	2545910.0
2021-06-04 16:00:00	IWM	ETF	227.4	227.43	227.02	227.05	620273.0
2021-06-04 17:00:00	IWM	ETF	227.29	227.42	227.14	227.3	224156.0
2021-06-04 18:00:00	IWM	ETF	227.2	227.2	227.2	227.2	100.0
2021-06-04 19:00:00	IWM	ETF	227.3	227.3	227.06	227.06	8546.0
2021-06-04 04:00:00	DIA	ETF	346.12	346.12	345.67	345.67	1125.0
2021-06-04 05:00:00	DIA	ETF	345.68	345.83	345.64	345.83	300.0

> showing 50 of 13,996 rows — these rows as CSV

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