PREVIEW / etf_1hour / 2021-09-27

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-09-27.parquet
  size:    421 KB
  rows:    14,873

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-09-27 04:00:00	SPY	ETF	445.02	445.23	444.96	445.2	18478.0
2021-09-27 05:00:00	SPY	ETF	445.3	445.53	444.28	444.28	25045.0
2021-09-27 06:00:00	SPY	ETF	444.28	444.46	443.55	443.58	41700.0
2021-09-27 07:00:00	SPY	ETF	443.58	443.78	443.2	443.52	80778.0
2021-09-27 08:00:00	SPY	ETF	443.44	446.14	442.19	442.96	698695.0
2021-09-27 09:00:00	SPY	ETF	442.96	443.29	441.9	442.9	7308832.0
2021-09-27 10:00:00	SPY	ETF	442.89	444.05	442.44	443.18	6806109.0
2021-09-27 11:00:00	SPY	ETF	443.17	443.83	442.31	442.74	5043431.0
2021-09-27 12:00:00	SPY	ETF	442.74	443.31	442.07	442.32	4095738.0
2021-09-27 13:00:00	SPY	ETF	442.31	443.43	442.14	443.4	3629964.0
2021-09-27 14:00:00	SPY	ETF	443.4	443.72	443.13	443.22	3272426.0
2021-09-27 15:00:00	SPY	ETF	443.21	443.68	442.32	442.68	12117203.0
2021-09-27 16:00:00	SPY	ETF	442.67	442.71	442.23	442.31	3301994.0
2021-09-27 17:00:00	SPY	ETF	442.36	442.64	442.2	442.32	142559.0
2021-09-27 18:00:00	SPY	ETF	442.33	442.64	441.93	441.95	98016.0
2021-09-27 19:00:00	SPY	ETF	442.03	442.65	442.01	442.33	40291.0
2021-09-27 04:00:00	QQQ	ETF	373.8	373.93	373.53	373.61	20384.0
2021-09-27 05:00:00	QQQ	ETF	373.63	373.86	372.25	372.33	64493.0
2021-09-27 06:00:00	QQQ	ETF	372.22	372.65	371.13	371.47	352072.0
2021-09-27 07:00:00	QQQ	ETF	371.5	371.77	371.0	371.34	322936.0
2021-09-27 08:00:00	QQQ	ETF	371.3	374.84	369.48	370.5	1134878.0
2021-09-27 09:00:00	QQQ	ETF	370.5	370.89	367.73	368.66	6830479.0
2021-09-27 10:00:00	QQQ	ETF	368.68	370.7	368.14	369.99	6057399.0
2021-09-27 11:00:00	QQQ	ETF	369.98	371.07	368.78	369.34	4403035.0
2021-09-27 12:00:00	QQQ	ETF	369.32	369.85	368.6	369.08	2956488.0
2021-09-27 13:00:00	QQQ	ETF	369.05	370.56	368.92	370.5299	2674998.0
2021-09-27 14:00:00	QQQ	ETF	370.533	371.0	370.35	370.48	2129288.0
2021-09-27 15:00:00	QQQ	ETF	370.48	371.2516	369.98	370.35	5106770.0
2021-09-27 16:00:00	QQQ	ETF	370.35	370.35	369.82	369.82	1267272.0
2021-09-27 17:00:00	QQQ	ETF	369.82	370.35	369.78	369.88	85757.0
2021-09-27 18:00:00	QQQ	ETF	369.88	370.12	369.43	369.45	63999.0
2021-09-27 19:00:00	QQQ	ETF	369.46	370.0	369.46	369.7399	50777.0
2021-09-27 04:00:00	IWM	ETF	223.99	224.26	223.95	224.24	24663.0
2021-09-27 05:00:00	IWM	ETF	224.25	224.45	223.88	223.88	19464.0
2021-09-27 06:00:00	IWM	ETF	223.75	224.09	223.49	223.5	35709.0
2021-09-27 07:00:00	IWM	ETF	223.55	223.75	223.4	223.51	53607.0
2021-09-27 08:00:00	IWM	ETF	223.54	224.75	222.88	223.49	216159.0
2021-09-27 09:00:00	IWM	ETF	223.46	225.63	223.25	225.18	4446869.0
2021-09-27 10:00:00	IWM	ETF	225.17	226.86	224.63	226.85	4193341.0
2021-09-27 11:00:00	IWM	ETF	226.85	227.34	226.58	227.03	2694916.0
2021-09-27 12:00:00	IWM	ETF	227.05	227.09	226.45	226.5	1687458.0
2021-09-27 13:00:00	IWM	ETF	226.49	226.89	226.34	226.8	1303342.0
2021-09-27 14:00:00	IWM	ETF	226.785	227.675	226.785	227.19	2020457.0
2021-09-27 15:00:00	IWM	ETF	227.19	227.27	226.25	226.3598	5162237.0
2021-09-27 16:00:00	IWM	ETF	226.44	226.46	226.01	226.35	1290558.0
2021-09-27 17:00:00	IWM	ETF	226.1	226.44	226.1	226.4	190759.0
2021-09-27 18:00:00	IWM	ETF	226.35	226.48	226.12	226.21	44586.0
2021-09-27 19:00:00	IWM	ETF	226.27	226.6	226.2	226.5	69348.0
2021-09-27 04:00:00	DIA	ETF	349.27	349.28	349.1	349.28	3529.0
2021-09-27 05:00:00	DIA	ETF	349.56	349.56	349.1	349.1	1200.0

> showing 50 of 14,873 rows — these rows as CSV

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