PREVIEW / etf_1hour / 2020-11-27

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-11-27.parquet
  size:    249 KB
  rows:    8,237

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-27 04:00:00	SPY	ETF	363.6	363.74	363.16	363.19	24731.0
2020-11-27 05:00:00	SPY	ETF	363.35	363.39	363.02	363.23	39153.0
2020-11-27 06:00:00	SPY	ETF	363.28	363.49	363.2	363.38	7464.0
2020-11-27 07:00:00	SPY	ETF	363.38	363.7	363.36	363.67	194448.0
2020-11-27 08:00:00	SPY	ETF	363.4399	364.07	362.71	363.85	181484.0
2020-11-27 09:00:00	SPY	ETF	363.83	364.15	363.52	363.677	4132377.0
2020-11-27 10:00:00	SPY	ETF	363.68	364.18	363.6	364.0	7247764.0
2020-11-27 11:00:00	SPY	ETF	363.98	364.13	363.18	363.41	4462542.0
2020-11-27 12:00:00	SPY	ETF	363.41	363.72	362.58	363.65	7699444.0
2020-11-27 13:00:00	SPY	ETF	363.64	364.03	363.37	363.97	1378336.0
2020-11-27 14:00:00	SPY	ETF	363.96	363.98	363.54	363.5999	193925.0
2020-11-27 15:00:00	SPY	ETF	363.62	363.86	363.6	363.79	13598.0
2020-11-27 16:00:00	SPY	ETF	363.75	363.82	363.44	363.65	43948.0
2020-11-27 04:00:00	QQQ	ETF	297.45	297.67	297.34	297.41	24155.0
2020-11-27 05:00:00	QQQ	ETF	297.34	297.4	297.17	297.38	10238.0
2020-11-27 06:00:00	QQQ	ETF	297.43	297.52	297.36	297.45	85600.0
2020-11-27 07:00:00	QQQ	ETF	297.45	297.67	297.34	297.58	80360.0
2020-11-27 08:00:00	QQQ	ETF	297.45	298.52	297.09	298.31	233622.0
2020-11-27 09:00:00	QQQ	ETF	298.3	298.89	297.9	298.735	2274955.0
2020-11-27 10:00:00	QQQ	ETF	298.75	300.17	298.5568	299.89	3304347.0
2020-11-27 11:00:00	QQQ	ETF	299.87	299.99	298.62	298.835	2435902.0
2020-11-27 12:00:00	QQQ	ETF	298.83	299.19	298.35	299.02	3129729.0
2020-11-27 13:00:00	QQQ	ETF	299.0	299.35	298.89	299.19	665889.0
2020-11-27 14:00:00	QQQ	ETF	299.24	299.34	298.88	298.9501	51723.0
2020-11-27 15:00:00	QQQ	ETF	298.96	299.3	298.89	299.29	19775.0
2020-11-27 16:00:00	QQQ	ETF	299.15	299.15	299.0	299.06	5019.0
2020-11-27 04:00:00	IWM	ETF	183.2	183.57	183.2	183.32	6383.0
2020-11-27 05:00:00	IWM	ETF	183.37	183.42	183.2	183.32	16072.0
2020-11-27 06:00:00	IWM	ETF	183.35	183.56	183.35	183.4	10992.0
2020-11-27 07:00:00	IWM	ETF	183.4	183.68	183.35	183.68	36909.0
2020-11-27 08:00:00	IWM	ETF	183.72	183.93	183.19	183.81	66706.0
2020-11-27 09:00:00	IWM	ETF	183.8	184.235	183.65	183.865	1888664.0
2020-11-27 10:00:00	IWM	ETF	183.87	183.995	183.22	183.38	2693412.0
2020-11-27 11:00:00	IWM	ETF	183.36	184.23	183.28	184.2	1662177.0
2020-11-27 12:00:00	IWM	ETF	184.2	184.49	183.73	184.37	2333389.0
2020-11-27 13:00:00	IWM	ETF	184.38	184.64	184.24	184.46	679293.0
2020-11-27 14:00:00	IWM	ETF	184.43	184.455	184.43	184.44	17867.0
2020-11-27 15:00:00	IWM	ETF	184.44	184.66	184.43	184.66	1943.0
2020-11-27 16:00:00	IWM	ETF	184.45	184.45	184.43	184.43	3674.0
2020-11-27 04:00:00	DIA	ETF	299.3	299.3	299.15	299.15	970.0
2020-11-27 05:00:00	DIA	ETF	299.35	299.35	299.18	299.2	1890.0
2020-11-27 06:00:00	DIA	ETF	299.35	299.38	299.35	299.36	595.0
2020-11-27 07:00:00	DIA	ETF	299.35	299.42	299.25	299.41	6492.0
2020-11-27 08:00:00	DIA	ETF	299.2801	299.63	299.1	299.46	10343.0
2020-11-27 09:00:00	DIA	ETF	299.55	300.2	299.13	299.24	284508.0
2020-11-27 10:00:00	DIA	ETF	299.24	299.64	299.05	299.285	183926.0
2020-11-27 11:00:00	DIA	ETF	299.25	299.4594	298.7	298.96	194253.0
2020-11-27 12:00:00	DIA	ETF	298.99	299.31	298.1701	299.23	606199.0
2020-11-27 13:00:00	DIA	ETF	299.24	299.4	299.07	299.23	30900.0
2020-11-27 14:00:00	DIA	ETF	299.39	299.39	299.15	299.15	586.0

> showing 50 of 8,237 rows — these rows as CSV

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