PREVIEW / etf_1hour / 2021-09-13

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-09-13.parquet
  size:    416 KB
  rows:    14,614

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-13 04:00:00	SPY	ETF	447.0	447.7	447.0	447.36	182093.0
2021-09-13 05:00:00	SPY	ETF	447.43	447.56	447.35	447.52	21731.0
2021-09-13 06:00:00	SPY	ETF	447.55	448.29	447.55	448.1	152256.0
2021-09-13 07:00:00	SPY	ETF	448.07	448.1	447.68	447.94	230987.0
2021-09-13 08:00:00	SPY	ETF	448.0001	448.45	445.774	448.39	622307.0
2021-09-13 09:00:00	SPY	ETF	448.4	448.92	446.77	447.22	8609377.0
2021-09-13 10:00:00	SPY	ETF	447.2	447.45	445.47	446.69	10697943.0
2021-09-13 11:00:00	SPY	ETF	446.71	446.87	444.87	445.4	7680345.0
2021-09-13 12:00:00	SPY	ETF	445.39	446.19	445.11	446.07	5105479.0
2021-09-13 13:00:00	SPY	ETF	446.07	446.36	444.71	444.92	4489044.0
2021-09-13 14:00:00	SPY	ETF	444.94	445.3	444.14	444.87	5964949.0
2021-09-13 15:00:00	SPY	ETF	444.86	446.58	444.11	446.5599	17124246.0
2021-09-13 16:00:00	SPY	ETF	446.55	447.32	446.1667	447.23	3081452.0
2021-09-13 17:00:00	SPY	ETF	447.22	447.22	447.14	447.17	73342.0
2021-09-13 18:00:00	SPY	ETF	447.17	447.44	446.58	447.31	102505.0
2021-09-13 19:00:00	SPY	ETF	447.36	447.44	447.1	447.22	52135.0
2021-09-13 04:00:00	QQQ	ETF	377.0	378.07	377.0	377.89	36157.0
2021-09-13 05:00:00	QQQ	ETF	377.87	378.0	377.85	377.97	11782.0
2021-09-13 06:00:00	QQQ	ETF	377.95	378.48	377.95	378.44	42854.0
2021-09-13 07:00:00	QQQ	ETF	378.44	378.5	378.13	378.35	95105.0
2021-09-13 08:00:00	QQQ	ETF	378.3899	378.77	375.95	378.73	252846.0
2021-09-13 09:00:00	QQQ	ETF	378.78	379.43	376.29	376.54	6251413.0
2021-09-13 10:00:00	QQQ	ETF	376.535	378.0	374.57	376.07	10074547.0
2021-09-13 11:00:00	QQQ	ETF	376.08	376.45	374.275	374.7982	4269993.0
2021-09-13 12:00:00	QQQ	ETF	374.815	376.5699	374.55	376.45	3056162.0
2021-09-13 13:00:00	QQQ	ETF	376.45	376.67	374.922	375.14	2726045.0
2021-09-13 14:00:00	QQQ	ETF	375.16	375.53	374.35	374.99	2851866.0
2021-09-13 15:00:00	QQQ	ETF	374.97	376.36	374.22	376.36	5412741.0
2021-09-13 16:00:00	QQQ	ETF	376.34	376.82	376.31	376.69	675060.0
2021-09-13 17:00:00	QQQ	ETF	376.61	376.85	376.33	376.6	81522.0
2021-09-13 18:00:00	QQQ	ETF	376.64	376.8	376.46	376.7	236892.0
2021-09-13 19:00:00	QQQ	ETF	376.7	376.83	376.58	376.65	22594.0
2021-09-13 04:00:00	IWM	ETF	223.31	223.46	223.17	223.18	18968.0
2021-09-13 05:00:00	IWM	ETF	223.26	223.3	223.08	223.3	2413.0
2021-09-13 06:00:00	IWM	ETF	223.35	223.73	223.31	223.5	23501.0
2021-09-13 07:00:00	IWM	ETF	223.47	223.48	223.11	223.2	96410.0
2021-09-13 08:00:00	IWM	ETF	223.4304	223.6104	221.86	223.3	60297.0
2021-09-13 09:00:00	IWM	ETF	223.3	223.5	221.135	221.62	3567317.0
2021-09-13 10:00:00	IWM	ETF	221.61	222.97	220.25	222.84	6680647.0
2021-09-13 11:00:00	IWM	ETF	222.87	223.08	221.3333	222.67	4181668.0
2021-09-13 12:00:00	IWM	ETF	222.64	223.38	222.44	223.14	2871181.0
2021-09-13 13:00:00	IWM	ETF	223.14	223.3199	222.24	222.51	1972713.0
2021-09-13 14:00:00	IWM	ETF	222.53	222.87	221.935	222.63	2709977.0
2021-09-13 15:00:00	IWM	ETF	222.62	223.08	221.72	222.9	5509193.0
2021-09-13 16:00:00	IWM	ETF	222.9	223.32	222.85	223.25	1127206.0
2021-09-13 17:00:00	IWM	ETF	223.29	223.34	222.88	223.21	30574.0
2021-09-13 18:00:00	IWM	ETF	223.18	223.59	222.88	223.48	22831.0
2021-09-13 19:00:00	IWM	ETF	223.5	223.63	223.24	223.47	8383.0
2021-09-13 04:00:00	DIA	ETF	348.34	348.45	348.01	348.01	12499.0
2021-09-13 05:00:00	DIA	ETF	348.11	348.3	348.11	348.27	800.0

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

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