PREVIEW / etf_1hour / 2021-12-30

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-12-30.parquet
  size:    438 KB
  rows:    15,741

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-12-30 04:00:00	SPY	ETF	477.85	478.28	477.7	478.06	21911.0
2021-12-30 05:00:00	SPY	ETF	478.08	478.14	477.7	477.92	20283.0
2021-12-30 06:00:00	SPY	ETF	477.96	478.53	477.89	478.4	21423.0
2021-12-30 07:00:00	SPY	ETF	478.34	478.47	478.14	478.14	77811.0
2021-12-30 08:00:00	SPY	ETF	478.14	478.47	477.53	478.14	312023.0
2021-12-30 09:00:00	SPY	ETF	478.15	478.96	477.69	478.21	3918391.0
2021-12-30 10:00:00	SPY	ETF	478.21	479.0	477.95	478.155	4362876.0
2021-12-30 11:00:00	SPY	ETF	478.15	478.43	478.02	478.24	3140842.0
2021-12-30 12:00:00	SPY	ETF	478.24	478.4	477.79	478.3275	3093085.0
2021-12-30 13:00:00	SPY	ETF	478.325	478.365	477.91	478.24	2245275.0
2021-12-30 14:00:00	SPY	ETF	478.24	478.31	477.75	478.15	2992705.0
2021-12-30 15:00:00	SPY	ETF	478.15	478.15	475.67	476.14	11553946.0
2021-12-30 16:00:00	SPY	ETF	476.14	476.47	475.92	476.23	2427710.0
2021-12-30 17:00:00	SPY	ETF	476.28	476.31	476.1	476.2	3413349.0
2021-12-30 18:00:00	SPY	ETF	476.23	476.53	476.14	476.28	56756.0
2021-12-30 19:00:00	SPY	ETF	476.25	476.32	474.1	474.53	166571.0
2021-12-30 04:00:00	QQQ	ETF	401.82	402.82	401.82	402.71	23047.0
2021-12-30 05:00:00	QQQ	ETF	402.62	402.62	402.27	402.49	8623.0
2021-12-30 06:00:00	QQQ	ETF	402.5	402.75	402.15	402.74	12368.0
2021-12-30 07:00:00	QQQ	ETF	402.66	402.88	402.449	402.45	67231.0
2021-12-30 08:00:00	QQQ	ETF	402.4899	402.8396	401.1	402.09	224121.0
2021-12-30 09:00:00	QQQ	ETF	402.1	402.33	400.69	401.9101	3410312.0
2021-12-30 10:00:00	QQQ	ETF	401.92	403.5699	401.89	402.62	2936712.0
2021-12-30 11:00:00	QQQ	ETF	402.61	403.19	402.4114	403.0	1576409.0
2021-12-30 12:00:00	QQQ	ETF	403.0	403.37	402.68	403.06	1647854.0
2021-12-30 13:00:00	QQQ	ETF	403.06	403.13	402.66	402.8	1070836.0
2021-12-30 14:00:00	QQQ	ETF	402.78	402.8	402.055	402.51	1541337.0
2021-12-30 15:00:00	QQQ	ETF	402.52	402.52	399.75	400.14	4887792.0
2021-12-30 16:00:00	QQQ	ETF	400.15	400.5	400.0723	400.22	644576.0
2021-12-30 17:00:00	QQQ	ETF	400.21	400.22	400.01	400.2099	21355.0
2021-12-30 18:00:00	QQQ	ETF	400.32	400.55	400.23	400.42	88924.0
2021-12-30 19:00:00	QQQ	ETF	400.34	400.34	398.49	398.98	91695.0
2021-12-30 04:00:00	IWM	ETF	222.45	222.79	222.42	222.53	19780.0
2021-12-30 05:00:00	IWM	ETF	222.58	222.6	222.38	222.6	21510.0
2021-12-30 06:00:00	IWM	ETF	222.54	223.1	222.54	223.1	12343.0
2021-12-30 07:00:00	IWM	ETF	223.05	223.14	222.78	222.8	22912.0
2021-12-30 08:00:00	IWM	ETF	222.8	223.22	222.26	223.15	64173.0
2021-12-30 09:00:00	IWM	ETF	223.07	225.17	222.7	224.96	3729598.0
2021-12-30 10:00:00	IWM	ETF	224.96	225.43	224.45	224.8	2771180.0
2021-12-30 11:00:00	IWM	ETF	224.8	225.145	224.38	225.13	1474364.0
2021-12-30 12:00:00	IWM	ETF	225.125	225.16	224.4	225.095	1136683.0
2021-12-30 13:00:00	IWM	ETF	225.065	225.2	224.855	224.9	1142178.0
2021-12-30 14:00:00	IWM	ETF	224.89	225.23	224.48	224.95	1336234.0
2021-12-30 15:00:00	IWM	ETF	224.95	224.96	222.71	222.89	3854526.0
2021-12-30 16:00:00	IWM	ETF	222.93	223.12	222.59	222.78	534006.0
2021-12-30 17:00:00	IWM	ETF	222.79	222.87	222.56	222.61	19539.0
2021-12-30 18:00:00	IWM	ETF	222.78	222.99	222.69	222.71	23161.0
2021-12-30 19:00:00	IWM	ETF	222.73	222.79	221.49	221.72	46385.0
2021-12-30 04:00:00	DIA	ETF	365.01	365.01	364.98	364.98	725.0
2021-12-30 05:00:00	DIA	ETF	364.86	364.92	364.86	364.92	800.0

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

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