PREVIEW / etf_1hour / 2020-11-30

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-11-30.parquet
  size:    408 KB
  rows:    13,983

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-11-30 04:00:00	SPY	ETF	362.18	362.44	361.92	362.25	24222.0
2020-11-30 05:00:00	SPY	ETF	362.29	362.39	362.04	362.34	33075.0
2020-11-30 06:00:00	SPY	ETF	362.2	362.42	361.43	362.03	30817.0
2020-11-30 07:00:00	SPY	ETF	362.12	363.21	362.05	362.738	314528.0
2020-11-30 08:00:00	SPY	ETF	362.7	363.2	360.85	362.83	318229.0
2020-11-30 09:00:00	SPY	ETF	362.81	363.46	361.89	362.27	4171229.0
2020-11-30 10:00:00	SPY	ETF	362.27	362.59	359.17	360.9	10860750.0
2020-11-30 11:00:00	SPY	ETF	360.89	361.105	359.52	360.34	6933924.0
2020-11-30 12:00:00	SPY	ETF	360.33	361.37	360.0801	361.308	5572320.0
2020-11-30 13:00:00	SPY	ETF	361.292	361.53	360.9148	361.03	5589476.0
2020-11-30 14:00:00	SPY	ETF	361.0222	362.15	360.66	362.15	10272604.0
2020-11-30 15:00:00	SPY	ETF	362.15	362.4	361.13	362.0	23523944.0
2020-11-30 16:00:00	SPY	ETF	362.0	363.21	361.9264	363.13	10857881.0
2020-11-30 17:00:00	SPY	ETF	363.17	363.17	362.61	362.8	1100624.0
2020-11-30 18:00:00	SPY	ETF	362.8	363.86	362.51	363.76	426914.0
2020-11-30 19:00:00	SPY	ETF	363.81	364.4	363.71	364.33	181797.0
2020-11-30 04:00:00	QQQ	ETF	298.95	299.04	298.53	298.92	46827.0
2020-11-30 05:00:00	QQQ	ETF	298.86	299.18	298.71	299.07	27594.0
2020-11-30 06:00:00	QQQ	ETF	299.08	299.21	298.58	298.94	20570.0
2020-11-30 07:00:00	QQQ	ETF	298.96	300.08	298.88	299.68	156047.0
2020-11-30 08:00:00	QQQ	ETF	299.66	300.02	297.41	299.39	236826.0
2020-11-30 09:00:00	QQQ	ETF	299.35	299.97	298.14	298.85	2536273.0
2020-11-30 10:00:00	QQQ	ETF	298.86	299.145	294.78	296.71	4441477.0
2020-11-30 11:00:00	QQQ	ETF	296.72	297.65	295.96	297.41	2732059.0
2020-11-30 12:00:00	QQQ	ETF	297.3788	298.08	297.05	297.93	1489402.0
2020-11-30 13:00:00	QQQ	ETF	297.93	298.78	297.7597	298.4347	1972258.0
2020-11-30 14:00:00	QQQ	ETF	298.45	299.81	298.23	299.7697	1979506.0
2020-11-30 15:00:00	QQQ	ETF	299.77	299.89	298.53	299.36	4278783.0
2020-11-30 16:00:00	QQQ	ETF	299.37	300.42	299.19	300.4	1438131.0
2020-11-30 17:00:00	QQQ	ETF	300.42	300.56	299.43	300.54	189208.0
2020-11-30 18:00:00	QQQ	ETF	300.57	301.21	300.32	301.15	220005.0
2020-11-30 19:00:00	QQQ	ETF	301.12	301.56	301.07	301.55	137876.0
2020-11-30 04:00:00	IWM	ETF	183.29	183.51	182.93	183.28	9896.0
2020-11-30 05:00:00	IWM	ETF	183.29	183.35	183.18	183.3	3566.0
2020-11-30 06:00:00	IWM	ETF	183.29	183.29	182.68	183.08	22098.0
2020-11-30 07:00:00	IWM	ETF	183.15	183.75	183.15	183.67	192192.0
2020-11-30 08:00:00	IWM	ETF	183.67	183.81	182.55	183.75	148205.0
2020-11-30 09:00:00	IWM	ETF	183.75	184.32	182.88	183.06	2338256.0
2020-11-30 10:00:00	IWM	ETF	183.055	183.14	180.32	181.69	4031020.0
2020-11-30 11:00:00	IWM	ETF	181.73	182.25	181.57	181.86	2138339.0
2020-11-30 12:00:00	IWM	ETF	181.85	182.035	181.25	181.76	1169106.0
2020-11-30 13:00:00	IWM	ETF	181.77	182.13	181.47	181.72	1224935.0
2020-11-30 14:00:00	IWM	ETF	181.72	181.875	181.269	181.82	2125063.0
2020-11-30 15:00:00	IWM	ETF	181.83	182.175	180.68	181.05	5388867.0
2020-11-30 16:00:00	IWM	ETF	181.03	181.99	181.02	181.95	3659965.0
2020-11-30 17:00:00	IWM	ETF	181.11	182.04	181.11	181.75	107972.0
2020-11-30 18:00:00	IWM	ETF	181.71	182.35	181.55	182.28	43259.0
2020-11-30 19:00:00	IWM	ETF	182.31	182.63	182.21	182.62	36527.0
2020-11-30 04:00:00	DIA	ETF	297.77	297.77	297.42	297.42	1100.0
2020-11-30 05:00:00	DIA	ETF	297.48	297.48	297.48	297.48	200.0

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

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