PREVIEW / etf_1hour / 2020-12-14

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-12-14.parquet
  size:    399 KB
  rows:    13,709

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
2020-12-14 04:00:00	SPY	ETF	368.0	368.44	368.0	368.32	41511.0
2020-12-14 05:00:00	SPY	ETF	368.25	368.55	368.2	368.53	70199.0
2020-12-14 06:00:00	SPY	ETF	368.39	369.03	368.39	369.03	47105.0
2020-12-14 07:00:00	SPY	ETF	368.96	369.19	368.8	369.16	94662.0
2020-12-14 08:00:00	SPY	ETF	368.85	369.21	368.01	368.76	279901.0
2020-12-14 09:00:00	SPY	ETF	368.77	369.6	368.37	369.52	5738948.0
2020-12-14 10:00:00	SPY	ETF	369.52	369.8	368.02	368.03	9159537.0
2020-12-14 11:00:00	SPY	ETF	368.04	368.5	367.12	367.7619	6934778.0
2020-12-14 12:00:00	SPY	ETF	367.79	367.88	366.61	366.86	4084388.0
2020-12-14 13:00:00	SPY	ETF	366.88	367.1999	366.3	366.84	5362448.0
2020-12-14 14:00:00	SPY	ETF	366.87	367.05	365.68	366.6462	5419694.0
2020-12-14 15:00:00	SPY	ETF	366.63	366.7	364.47	364.61	17952002.0
2020-12-14 16:00:00	SPY	ETF	364.58	365.21	364.58	365.14	11505230.0
2020-12-14 17:00:00	SPY	ETF	365.29	365.29	364.9	365.07	466300.0
2020-12-14 18:00:00	SPY	ETF	365.08	365.64	364.91	365.37	181295.0
2020-12-14 19:00:00	SPY	ETF	365.45	365.65	365.21	365.61	79344.0
2020-12-14 04:00:00	QQQ	ETF	302.85	302.99	302.69	302.98	38831.0
2020-12-14 05:00:00	QQQ	ETF	302.94	303.12	302.83	303.01	14272.0
2020-12-14 06:00:00	QQQ	ETF	302.98	303.77	302.98	303.62	23642.0
2020-12-14 07:00:00	QQQ	ETF	303.59	303.78	303.51	303.77	95566.0
2020-12-14 08:00:00	QQQ	ETF	303.63	303.8	301.85	303.15	572224.0
2020-12-14 09:00:00	QQQ	ETF	303.14	305.4	303.01	305.39	3697935.0
2020-12-14 10:00:00	QQQ	ETF	305.4	305.96	304.99	305.0	3331718.0
2020-12-14 11:00:00	QQQ	ETF	304.99	306.05	304.825	305.755	3002505.0
2020-12-14 12:00:00	QQQ	ETF	305.79	305.846	304.54	304.83	1696216.0
2020-12-14 13:00:00	QQQ	ETF	304.84	305.35	304.0709	305.258	2073479.0
2020-12-14 14:00:00	QQQ	ETF	305.26	305.4659	304.4	305.2724	1780903.0
2020-12-14 15:00:00	QQQ	ETF	305.27	305.47	303.64	303.83	3927253.0
2020-12-14 16:00:00	QQQ	ETF	303.83	304.4	303.76	304.08	1401308.0
2020-12-14 17:00:00	QQQ	ETF	304.05	304.42	304.05	304.1	10306.0
2020-12-14 18:00:00	QQQ	ETF	304.05	304.47	303.99	304.34	60568.0
2020-12-14 19:00:00	QQQ	ETF	304.47	304.47	304.14	304.34	36004.0
2020-12-14 04:00:00	IWM	ETF	191.0	191.37	190.51	191.24	17418.0
2020-12-14 05:00:00	IWM	ETF	191.24	191.48	191.24	191.46	11700.0
2020-12-14 06:00:00	IWM	ETF	191.37	192.05	191.37	191.96	41834.0
2020-12-14 07:00:00	IWM	ETF	191.9	192.1	191.72	192.08	86583.0
2020-12-14 08:00:00	IWM	ETF	191.85	192.14	190.86	191.93	168518.0
2020-12-14 09:00:00	IWM	ETF	191.94	192.89	191.54	192.59	2700822.0
2020-12-14 10:00:00	IWM	ETF	192.58	193.12	191.48	191.53	3720872.0
2020-12-14 11:00:00	IWM	ETF	191.53	192.21	191.41	191.7	2437266.0
2020-12-14 12:00:00	IWM	ETF	191.7	192.1	191.23	191.32	1895107.0
2020-12-14 13:00:00	IWM	ETF	191.32	191.42	190.605	190.86	2260977.0
2020-12-14 14:00:00	IWM	ETF	190.86	191.22	190.22	191.13	1499332.0
2020-12-14 15:00:00	IWM	ETF	191.13	191.39	189.88	189.93	3599366.0
2020-12-14 16:00:00	IWM	ETF	189.93	192.1	189.9	190.13	5187234.0
2020-12-14 17:00:00	IWM	ETF	190.17	190.24	189.94	189.95	12074.0
2020-12-14 18:00:00	IWM	ETF	190.1	190.6	189.93	190.39	33673.0
2020-12-14 19:00:00	IWM	ETF	190.52	190.64	190.32	190.53	11273.0
2020-12-14 04:00:00	DIA	ETF	302.83	302.98	302.68	302.94	2406.0
2020-12-14 05:00:00	DIA	ETF	302.85	303.09	302.84	303.09	1000.0

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

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