PREVIEW / etf_1hour / 2021-10-14

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-10-14.parquet
  size:    426 KB
  rows:    14,976

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-10-14 04:00:00	SPY	ETF	436.65	438.15	436.65	437.95	68782.0
2021-10-14 05:00:00	SPY	ETF	438.02	438.3	437.96	438.08	44054.0
2021-10-14 06:00:00	SPY	ETF	438.09	438.2	437.74	438.01	69356.0
2021-10-14 07:00:00	SPY	ETF	437.93	439.0	437.87	438.93	232681.0
2021-10-14 08:00:00	SPY	ETF	437.948	439.45	436.16	439.04	760348.0
2021-10-14 09:00:00	SPY	ETF	439.06	439.86	438.58	439.57	8313893.0
2021-10-14 10:00:00	SPY	ETF	439.58	441.24	439.58	441.21	8390209.0
2021-10-14 11:00:00	SPY	ETF	441.21	441.77	440.79	441.75	5092055.0
2021-10-14 12:00:00	SPY	ETF	441.75	442.16	441.69	442.1	4099657.0
2021-10-14 13:00:00	SPY	ETF	442.11	442.43	441.59	442.28	4195186.0
2021-10-14 14:00:00	SPY	ETF	442.2701	442.59	442.02	442.49	4864138.0
2021-10-14 15:00:00	SPY	ETF	442.5	442.66	441.64	442.47	13786262.0
2021-10-14 16:00:00	SPY	ETF	442.46	443.46	442.36	443.06	3935559.0
2021-10-14 17:00:00	SPY	ETF	443.08	443.11	442.91	442.92	104033.0
2021-10-14 18:00:00	SPY	ETF	442.91	443.28	442.5	443.16	56807.0
2021-10-14 19:00:00	SPY	ETF	443.19	443.35	443.14	443.2	56366.0
2021-10-14 04:00:00	QQQ	ETF	362.12	363.1	362.12	362.96	37672.0
2021-10-14 05:00:00	QQQ	ETF	363.06	363.13	362.8	362.84	29460.0
2021-10-14 06:00:00	QQQ	ETF	362.85	362.9	362.52	362.59	35086.0
2021-10-14 07:00:00	QQQ	ETF	362.52	363.6	362.52	363.5	205840.0
2021-10-14 08:00:00	QQQ	ETF	362.57	364.3699	360.27	363.72	471591.0
2021-10-14 09:00:00	QQQ	ETF	363.75	364.61	363.01	364.33	5546375.0
2021-10-14 10:00:00	QQQ	ETF	364.34	365.61	364.17	365.26	5168439.0
2021-10-14 11:00:00	QQQ	ETF	365.27	366.12	365.025	366.12	4124879.0
2021-10-14 12:00:00	QQQ	ETF	366.11	366.73	366.04	366.6	3438913.0
2021-10-14 13:00:00	QQQ	ETF	366.6	366.66	366.085	366.52	3197201.0
2021-10-14 14:00:00	QQQ	ETF	366.52	366.73	366.26	366.63	2428926.0
2021-10-14 15:00:00	QQQ	ETF	366.63	366.85	365.97	366.6	7910381.0
2021-10-14 16:00:00	QQQ	ETF	366.6	367.41	366.53	367.28	1253997.0
2021-10-14 17:00:00	QQQ	ETF	367.29	367.3	366.63	367.249	84229.0
2021-10-14 18:00:00	QQQ	ETF	367.13	367.39	367.05	367.23	62708.0
2021-10-14 19:00:00	QQQ	ETF	367.26	367.55	367.23	367.42	65886.0
2021-10-14 04:00:00	IWM	ETF	224.01	224.27	223.92	224.18	21768.0
2021-10-14 05:00:00	IWM	ETF	224.19	224.52	224.19	224.44	7105.0
2021-10-14 06:00:00	IWM	ETF	224.51	224.51	224.18	224.28	10191.0
2021-10-14 07:00:00	IWM	ETF	224.25	224.72	224.15	224.68	63932.0
2021-10-14 08:00:00	IWM	ETF	224.5	225.26	223.18	224.95	204038.0
2021-10-14 09:00:00	IWM	ETF	224.96	225.5299	224.32	225.295	2496453.0
2021-10-14 10:00:00	IWM	ETF	225.295	225.75	225.1	225.63	2145192.0
2021-10-14 11:00:00	IWM	ETF	225.61	225.74	225.035	225.58	1258817.0
2021-10-14 12:00:00	IWM	ETF	225.58	225.99	225.445	225.955	958256.0
2021-10-14 13:00:00	IWM	ETF	225.96	226.0	225.35	225.57	1218290.0
2021-10-14 14:00:00	IWM	ETF	225.56	225.92	225.45	225.84	820124.0
2021-10-14 15:00:00	IWM	ETF	225.85	225.95	225.035	225.78	3260859.0
2021-10-14 16:00:00	IWM	ETF	225.77	226.23	225.65	226.13	1017978.0
2021-10-14 17:00:00	IWM	ETF	226.02	226.22	225.87	226.06	37600.0
2021-10-14 18:00:00	IWM	ETF	226.06	226.3	225.87	226.2	21737.0
2021-10-14 19:00:00	IWM	ETF	226.23	226.41	226.22	226.28	11274.0
2021-10-14 04:00:00	DIA	ETF	345.33	345.78	345.33	345.75	1345.0
2021-10-14 05:00:00	DIA	ETF	345.74	345.74	345.69	345.69	400.0

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

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