PREVIEW / etf_1hour / 2009-12-22

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-12-22.parquet
  size:    148 KB
  rows:    4,645

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
2009-12-22 04:00:00	SPY	ETF	111.48	111.55	111.48	111.55	200.0
2009-12-22 05:00:00	SPY	ETF	111.68	111.68	111.6	111.64	3000.0
2009-12-22 06:00:00	SPY	ETF	111.6	111.6	111.6	111.6	3600.0
2009-12-22 07:00:00	SPY	ETF	111.63	111.82	111.61	111.66	198419.0
2009-12-22 08:00:00	SPY	ETF	111.66	111.75	111.19	111.52	2433886.0
2009-12-22 09:00:00	SPY	ETF	111.54	111.85	111.46	111.65	12805038.0
2009-12-22 10:00:00	SPY	ETF	111.65	111.97	111.57	111.62	20025914.0
2009-12-22 11:00:00	SPY	ETF	111.62	111.72	111.425	111.6	10464534.0
2009-12-22 12:00:00	SPY	ETF	111.59	111.79	111.56	111.75	6074576.0
2009-12-22 13:00:00	SPY	ETF	111.76	111.89	111.71	111.83	11377374.0
2009-12-22 14:00:00	SPY	ETF	111.83	111.85	111.6	111.7	7030592.0
2009-12-22 15:00:00	SPY	ETF	111.71	111.76	111.6	111.72	15310659.0
2009-12-22 16:00:00	SPY	ETF	111.73	111.87	111.63	111.73	4043792.0
2009-12-22 17:00:00	SPY	ETF	111.73	111.75	111.69	111.7	104858.0
2009-12-22 18:00:00	SPY	ETF	111.7	111.72	111.7	111.72	8725.0
2009-12-22 19:00:00	SPY	ETF	111.73	111.81	111.71	111.77	26519.0
2009-12-22 05:00:00	QQQ	ETF	45.2	45.2	45.17	45.19	3520.0
2009-12-22 07:00:00	QQQ	ETF	45.15	45.22	45.15	45.15	156597.0
2009-12-22 08:00:00	QQQ	ETF	45.15	45.19	44.93	45.11	1738001.0
2009-12-22 09:00:00	QQQ	ETF	45.11	45.25	45.03	45.17	9292479.0
2009-12-22 10:00:00	QQQ	ETF	45.17	45.28	45.12	45.15	10542126.0
2009-12-22 11:00:00	QQQ	ETF	45.14	45.17	45.05	45.13	4252945.0
2009-12-22 12:00:00	QQQ	ETF	45.131	45.225	45.11	45.2074	3039596.0
2009-12-22 13:00:00	QQQ	ETF	45.205	45.29	45.19	45.24	7000260.0
2009-12-22 14:00:00	QQQ	ETF	45.235	45.24	45.17	45.2	3775980.0
2009-12-22 15:00:00	QQQ	ETF	45.205	45.26	45.16	45.22	7197673.0
2009-12-22 16:00:00	QQQ	ETF	45.22	45.31	44.9619	45.28	4246278.0
2009-12-22 17:00:00	QQQ	ETF	45.28	45.31	45.28	45.28	42971.0
2009-12-22 18:00:00	QQQ	ETF	45.28	45.29	45.26	45.29	16330.0
2009-12-22 19:00:00	QQQ	ETF	45.29	45.31	45.28	45.29	27596.0
2009-12-22 07:00:00	IWM	ETF	62.25	62.29	62.24	62.29	23267.0
2009-12-22 08:00:00	IWM	ETF	62.17	62.33	61.96	62.06	257590.0
2009-12-22 09:00:00	IWM	ETF	62.07	62.36	61.92	62.32	3746475.0
2009-12-22 10:00:00	IWM	ETF	62.25	62.47	62.19	62.28	6553137.0
2009-12-22 11:00:00	IWM	ETF	62.28	62.31	62.15	62.24	4894979.0
2009-12-22 12:00:00	IWM	ETF	62.245	62.41	62.245	62.41	3364806.0
2009-12-22 13:00:00	IWM	ETF	62.4	62.61	62.36	62.56	4574234.0
2009-12-22 14:00:00	IWM	ETF	62.55	62.6	62.485	62.5585	2661156.0
2009-12-22 15:00:00	IWM	ETF	62.55	62.65	62.3	62.54	8320139.0
2009-12-22 16:00:00	IWM	ETF	62.54	62.65	62.2471	62.65	2087712.0
2009-12-22 17:00:00	IWM	ETF	62.66	62.74	62.65	62.66	16282.0
2009-12-22 18:00:00	IWM	ETF	62.64	62.64	62.63	62.63	600.0
2009-12-22 19:00:00	IWM	ETF	62.63	62.65	62.63	62.63	1065.0
2009-12-22 07:00:00	DIA	ETF	104.22	104.32	104.21	104.32	4600.0
2009-12-22 08:00:00	DIA	ETF	104.25	104.29	103.63	104.13	375729.0
2009-12-22 09:00:00	DIA	ETF	104.17	104.46	104.05	104.28	1034368.0
2009-12-22 10:00:00	DIA	ETF	104.3	104.61	104.22	104.407	1221055.0
2009-12-22 11:00:00	DIA	ETF	104.4	104.48	104.25	104.37	764344.0
2009-12-22 12:00:00	DIA	ETF	104.39	104.51	104.35	104.48	357124.0
2009-12-22 13:00:00	DIA	ETF	104.48	104.57	104.451	104.53	736503.0

> showing 50 of 4,645 rows — these rows as CSV

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