PREVIEW / etf_1hour / 2021-09-23

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-09-23.parquet
  size:    424 KB
  rows:    14,858

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-23 04:00:00	SPY	ETF	439.02	441.02	439.02	440.96	45421.0
2021-09-23 05:00:00	SPY	ETF	441.01	441.87	440.81	441.0	97150.0
2021-09-23 06:00:00	SPY	ETF	441.0	441.15	439.49	440.18	272430.0
2021-09-23 07:00:00	SPY	ETF	440.15	440.73	439.87	440.18	213584.0
2021-09-23 08:00:00	SPY	ETF	440.18	440.75	438.98	439.94	480705.0
2021-09-23 09:00:00	SPY	ETF	439.97	442.82	438.96	442.2	10191318.0
2021-09-23 10:00:00	SPY	ETF	442.21	443.92	442.21	443.7001	10359315.0
2021-09-23 11:00:00	SPY	ETF	443.7001	443.77	442.81	443.7301	6167117.0
2021-09-23 12:00:00	SPY	ETF	443.74	444.13	443.28	443.75	5523768.0
2021-09-23 13:00:00	SPY	ETF	443.74	444.89	443.73	444.855	4795315.0
2021-09-23 14:00:00	SPY	ETF	444.861	444.87	443.925	444.2	5203825.0
2021-09-23 15:00:00	SPY	ETF	444.2	444.27	443.03	443.08	14886215.0
2021-09-23 16:00:00	SPY	ETF	443.14	443.65	442.94	443.3	3548274.0
2021-09-23 17:00:00	SPY	ETF	443.28	443.43	443.15	443.3	112372.0
2021-09-23 18:00:00	SPY	ETF	443.31	443.65	443.18	443.58	77139.0
2021-09-23 19:00:00	SPY	ETF	443.65	443.78	443.4	443.52	64767.0
2021-09-23 04:00:00	QQQ	ETF	371.47	372.26	371.47	372.26	44590.0
2021-09-23 05:00:00	QQQ	ETF	372.26	373.0	372.15	372.41	84152.0
2021-09-23 06:00:00	QQQ	ETF	372.46	372.6	371.28	371.71	175772.0
2021-09-23 07:00:00	QQQ	ETF	371.74	372.0	371.25	371.47	202889.0
2021-09-23 08:00:00	QQQ	ETF	371.49	372.4404	370.07	370.7296	411449.0
2021-09-23 09:00:00	QQQ	ETF	370.66	372.83	369.94	372.32	6037765.0
2021-09-23 10:00:00	QQQ	ETF	372.3567	373.83	372.35	373.53	5940849.0
2021-09-23 11:00:00	QQQ	ETF	373.5299	373.55	372.08	373.23	4812000.0
2021-09-23 12:00:00	QQQ	ETF	373.24	373.32	372.35	372.919	3251311.0
2021-09-23 13:00:00	QQQ	ETF	372.92	374.04	372.87	374.0	2686713.0
2021-09-23 14:00:00	QQQ	ETF	374.0	374.01	373.32	373.6357	3163414.0
2021-09-23 15:00:00	QQQ	ETF	373.65	373.7	372.82	372.91	5887086.0
2021-09-23 16:00:00	QQQ	ETF	372.93	373.32	372.62	372.84	2452021.0
2021-09-23 17:00:00	QQQ	ETF	372.98	373.08	372.88	373.01	916109.0
2021-09-23 18:00:00	QQQ	ETF	373.01	373.18	372.9	373.15	30172.0
2021-09-23 19:00:00	QQQ	ETF	373.19	373.32	372.85	373.02	38218.0
2021-09-23 04:00:00	IWM	ETF	223.0	223.38	223.0	223.24	21362.0
2021-09-23 05:00:00	IWM	ETF	223.3	223.84	223.28	223.39	21417.0
2021-09-23 06:00:00	IWM	ETF	223.41	223.53	222.25	222.55	86792.0
2021-09-23 07:00:00	IWM	ETF	222.55	222.93	222.46	222.62	86232.0
2021-09-23 08:00:00	IWM	ETF	222.68	223.4896	222.27	222.5	102596.0
2021-09-23 09:00:00	IWM	ETF	222.46	223.64	221.56	223.42	3904939.0
2021-09-23 10:00:00	IWM	ETF	223.43	223.795	222.95	223.7	2492164.0
2021-09-23 11:00:00	IWM	ETF	223.69	224.39	223.57	224.39	2453281.0
2021-09-23 12:00:00	IWM	ETF	224.39	224.72	224.01	224.54	1727054.0
2021-09-23 13:00:00	IWM	ETF	224.535	225.61	224.525	225.46	2013058.0
2021-09-23 14:00:00	IWM	ETF	225.46	225.645	225.0	225.17	3101345.0
2021-09-23 15:00:00	IWM	ETF	225.17	225.26	224.58	224.82	4522509.0
2021-09-23 16:00:00	IWM	ETF	224.82	225.07	224.7	224.95	1199553.0
2021-09-23 17:00:00	IWM	ETF	224.81	225.08	224.7	224.84	78503.0
2021-09-23 18:00:00	IWM	ETF	224.84	225.11	224.81	225.01	51277.0
2021-09-23 19:00:00	IWM	ETF	225.05	225.13	224.91	224.97	57999.0
2021-09-23 04:00:00	DIA	ETF	344.75	344.84	344.69	344.84	2124.0
2021-09-23 05:00:00	DIA	ETF	344.78	345.27	344.73	344.86	8200.0

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

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