PREVIEW / etf_1hour / 2021-12-10

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-12-10.parquet
  size:    427 KB
  rows:    14,988

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-10 04:00:00	SPY	ETF	467.57	467.69	467.23	467.64	20804.0
2021-12-10 05:00:00	SPY	ETF	467.68	467.72	467.48	467.7	18270.0
2021-12-10 06:00:00	SPY	ETF	467.72	468.5	467.7	468.35	59508.0
2021-12-10 07:00:00	SPY	ETF	468.33	468.38	467.7	467.83	125986.0
2021-12-10 08:00:00	SPY	ETF	468.17	470.2	466.33	469.72	1507926.0
2021-12-10 09:00:00	SPY	ETF	469.77	470.08	468.15	468.39	7606089.0
2021-12-10 10:00:00	SPY	ETF	468.41	469.555	467.36	468.01	8212429.0
2021-12-10 11:00:00	SPY	ETF	467.98	468.94	466.51	468.71	6454289.0
2021-12-10 12:00:00	SPY	ETF	468.71	469.0	467.941	468.87	3627927.0
2021-12-10 13:00:00	SPY	ETF	468.87	469.41	468.67	469.25	3684229.0
2021-12-10 14:00:00	SPY	ETF	469.24	469.58	468.52	468.65	4490401.0
2021-12-10 15:00:00	SPY	ETF	468.65	470.9	468.38	470.71	15070279.0
2021-12-10 16:00:00	SPY	ETF	470.7	470.86	470.45	470.78	3750869.0
2021-12-10 17:00:00	SPY	ETF	470.76	470.81	470.0	470.12	254868.0
2021-12-10 18:00:00	SPY	ETF	470.15	470.74	470.1	470.44	53167.0
2021-12-10 19:00:00	SPY	ETF	470.4	471.0	470.4	471.0	152401.0
2021-12-10 04:00:00	QQQ	ETF	394.97	395.01	394.33	395.0	20394.0
2021-12-10 05:00:00	QQQ	ETF	395.06	395.06	394.63	395.04	6312.0
2021-12-10 06:00:00	QQQ	ETF	394.97	395.68	394.96	395.37	17707.0
2021-12-10 07:00:00	QQQ	ETF	395.42	395.43	394.4	394.65	127850.0
2021-12-10 08:00:00	QQQ	ETF	395.22	397.67	393.63	397.07	1407525.0
2021-12-10 09:00:00	QQQ	ETF	397.1	398.06	395.0	395.43	9586563.0
2021-12-10 10:00:00	QQQ	ETF	395.4	397.68	394.086	395.14	8743441.0
2021-12-10 11:00:00	QQQ	ETF	395.07	396.5362	393.36	396.16	6363464.0
2021-12-10 12:00:00	QQQ	ETF	396.19	396.52	395.13	396.395	3826126.0
2021-12-10 13:00:00	QQQ	ETF	396.4	396.94	395.97	396.58	3376795.0
2021-12-10 14:00:00	QQQ	ETF	396.585	396.8	395.68	395.87	2803257.0
2021-12-10 15:00:00	QQQ	ETF	395.87	398.28	395.53	398.06	4203313.0
2021-12-10 16:00:00	QQQ	ETF	398.06	398.06	393.7009	397.93	1781238.0
2021-12-10 17:00:00	QQQ	ETF	398.0	398.1	397.5	397.69	74244.0
2021-12-10 18:00:00	QQQ	ETF	397.6	397.75	397.51	397.55	11342.0
2021-12-10 19:00:00	QQQ	ETF	397.65	397.86	397.65	397.8	13977.0
2021-12-10 04:00:00	IWM	ETF	220.93	221.38	220.93	221.22	19721.0
2021-12-10 05:00:00	IWM	ETF	221.11	221.27	221.0	221.14	18142.0
2021-12-10 06:00:00	IWM	ETF	221.31	221.79	221.25	221.79	55445.0
2021-12-10 07:00:00	IWM	ETF	221.56	221.61	221.19	221.32	20052.0
2021-12-10 08:00:00	IWM	ETF	221.52	223.06	220.43	222.63	725342.0
2021-12-10 09:00:00	IWM	ETF	222.65	222.85	219.9	220.07	4043547.0
2021-12-10 10:00:00	IWM	ETF	220.05	221.695	219.76	220.08	3689304.0
2021-12-10 11:00:00	IWM	ETF	220.07	220.1	218.32	219.68	5054091.0
2021-12-10 12:00:00	IWM	ETF	219.72	220.05	219.11	219.54	2219522.0
2021-12-10 13:00:00	IWM	ETF	219.52	220.025	219.42	219.62	1638458.0
2021-12-10 14:00:00	IWM	ETF	219.62	219.83	219.13	219.18	1389282.0
2021-12-10 15:00:00	IWM	ETF	219.18	220.02	219.0	219.91	3648706.0
2021-12-10 16:00:00	IWM	ETF	219.91	219.95	219.62	219.71	2327101.0
2021-12-10 17:00:00	IWM	ETF	219.8	219.91	219.37	219.7	98264.0
2021-12-10 18:00:00	IWM	ETF	219.48	219.79	219.48	219.54	4947.0
2021-12-10 19:00:00	IWM	ETF	219.8	219.89	219.74	219.89	2804.0
2021-12-10 04:00:00	DIA	ETF	358.71	358.71	358.38	358.38	371.0
2021-12-10 05:00:00	DIA	ETF	358.57	358.57	358.57	358.57	500.0

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

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