PREVIEW / etf_1hour / 2021-10-27

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-10-27.parquet
  size:    429 KB
  rows:    15,007

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-27 04:00:00	SPY	ETF	456.77	456.9	456.03	456.04	27214.0
2021-10-27 05:00:00	SPY	ETF	456.01	456.01	455.37	455.46	26905.0
2021-10-27 06:00:00	SPY	ETF	455.58	456.07	455.21	455.51	37583.0
2021-10-27 07:00:00	SPY	ETF	455.51	456.13	455.43	455.53	99008.0
2021-10-27 08:00:00	SPY	ETF	455.9199	456.69	455.48	456.41	420885.0
2021-10-27 09:00:00	SPY	ETF	456.42	457.0583	455.33	457.03	5188819.0
2021-10-27 10:00:00	SPY	ETF	457.03	457.16	455.54	455.73	6673995.0
2021-10-27 11:00:00	SPY	ETF	455.73	456.44	455.61	455.91	3683140.0
2021-10-27 12:00:00	SPY	ETF	455.94	456.5	455.78	456.1946	2286083.0
2021-10-27 13:00:00	SPY	ETF	456.19	456.97	456.11	456.96	2614455.0
2021-10-27 14:00:00	SPY	ETF	456.96	457.13	456.185	456.2	3518003.0
2021-10-27 15:00:00	SPY	ETF	456.19	456.29	453.86	453.9	15968824.0
2021-10-27 16:00:00	SPY	ETF	453.91	454.32	453.8281	454.3	19089733.0
2021-10-27 17:00:00	SPY	ETF	454.2	454.37	454.2	454.3	65655.0
2021-10-27 18:00:00	SPY	ETF	454.34	454.71	453.94	454.67	101837.0
2021-10-27 19:00:00	SPY	ETF	454.7	454.94	454.56	454.85	58154.0
2021-10-27 04:00:00	QQQ	ETF	379.73	379.93	379.1	379.16	57849.0
2021-10-27 05:00:00	QQQ	ETF	379.0	379.12	378.31	378.37	51175.0
2021-10-27 06:00:00	QQQ	ETF	378.35	378.77	378.09	378.28	94171.0
2021-10-27 07:00:00	QQQ	ETF	378.28	378.78	378.22	378.24	260484.0
2021-10-27 08:00:00	QQQ	ETF	378.42	379.97	378.22	379.45	452077.0
2021-10-27 09:00:00	QQQ	ETF	379.46	381.41	379.31	381.32	4664363.0
2021-10-27 10:00:00	QQQ	ETF	381.32	381.76	379.37	380.75	5772365.0
2021-10-27 11:00:00	QQQ	ETF	380.76	381.83	380.6101	381.62	3099941.0
2021-10-27 12:00:00	QQQ	ETF	381.625	382.38	381.535	382.17	2395488.0
2021-10-27 13:00:00	QQQ	ETF	382.169	383.15	382.085	382.98	2654415.0
2021-10-27 14:00:00	QQQ	ETF	382.985	383.1	382.29	382.29	2080349.0
2021-10-27 15:00:00	QQQ	ETF	382.27	382.4223	379.89	379.95	9797436.0
2021-10-27 16:00:00	QQQ	ETF	379.92	380.345	379.86	380.15	1023330.0
2021-10-27 17:00:00	QQQ	ETF	380.15	380.22	380.0	380.15	3438098.0
2021-10-27 18:00:00	QQQ	ETF	380.15	380.7	380.15	380.69	114013.0
2021-10-27 19:00:00	QQQ	ETF	380.69	381.02	380.58	380.95	104029.0
2021-10-27 04:00:00	IWM	ETF	227.53	227.62	226.9	226.9	16635.0
2021-10-27 05:00:00	IWM	ETF	226.8	226.85	226.35	226.73	22469.0
2021-10-27 06:00:00	IWM	ETF	226.85	227.08	226.66	226.87	16800.0
2021-10-27 07:00:00	IWM	ETF	226.97	227.15	226.94	226.94	44865.0
2021-10-27 08:00:00	IWM	ETF	226.97	227.66	226.7	227.37	106038.0
2021-10-27 09:00:00	IWM	ETF	227.35	227.46	225.775	227.15	3047211.0
2021-10-27 10:00:00	IWM	ETF	227.15	227.37	225.17	225.62	4217945.0
2021-10-27 11:00:00	IWM	ETF	225.61	226.3	225.51	225.73	2918571.0
2021-10-27 12:00:00	IWM	ETF	225.73	225.84	225.04	225.41	1304333.0
2021-10-27 13:00:00	IWM	ETF	225.39	225.8	225.22	225.61	1377329.0
2021-10-27 14:00:00	IWM	ETF	225.61	225.76	225.0494	225.12	1282907.0
2021-10-27 15:00:00	IWM	ETF	225.14	225.15	223.5	223.57	6013683.0
2021-10-27 16:00:00	IWM	ETF	223.56	223.94	223.55	223.85	1499489.0
2021-10-27 17:00:00	IWM	ETF	223.94	224.08	223.65	224.05	52408.0
2021-10-27 18:00:00	IWM	ETF	224.0	224.35	223.99	224.34	72084.0
2021-10-27 19:00:00	IWM	ETF	224.31	224.5	224.25	224.45	33608.0
2021-10-27 04:00:00	DIA	ETF	358.1	358.16	357.6	357.6	1130.0
2021-10-27 05:00:00	DIA	ETF	357.45	357.45	357.17	357.32	5942.0

> showing 50 of 15,007 rows — these rows as CSV

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