PREVIEW / etf_1hour / 2009-01-12

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-01-12.parquet
  size:    126 KB
  rows:    3,855

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-01-12 04:00:00	SPY	ETF	88.85	88.85	88.85	88.85	1000.0
2009-01-12 05:00:00	SPY	ETF	88.67	88.79	88.61	88.79	2400.0
2009-01-12 06:00:00	SPY	ETF	88.74	88.85	88.65	88.78	49200.0
2009-01-12 07:00:00	SPY	ETF	88.8	88.92	88.67	88.67	197859.0
2009-01-12 08:00:00	SPY	ETF	88.69	88.86	88.56	88.75	1028714.0
2009-01-12 09:00:00	SPY	ETF	88.75	88.91	88.08	88.3908	26606128.0
2009-01-12 10:00:00	SPY	ETF	88.39	88.4	87.76	88.02	32347215.0
2009-01-12 11:00:00	SPY	ETF	88.02	88.1	87.44	87.44	28425207.0
2009-01-12 12:00:00	SPY	ETF	87.44	87.76	87.35	87.49	21064762.0
2009-01-12 13:00:00	SPY	ETF	87.49	87.8	87.4	87.5	19046238.0
2009-01-12 14:00:00	SPY	ETF	87.5	87.505	86.68	86.87	35575495.0
2009-01-12 15:00:00	SPY	ETF	86.87	88.55	86.41	87.0	65350272.0
2009-01-12 16:00:00	SPY	ETF	86.95	88.0	86.93	87.37	13310350.0
2009-01-12 17:00:00	SPY	ETF	87.36	89.0598	87.3	87.33	2724578.0
2009-01-12 18:00:00	SPY	ETF	87.35	87.54	87.34	87.43	263381.0
2009-01-12 19:00:00	SPY	ETF	87.45	87.51	87.38	87.47	85143.0
2009-01-12 07:00:00	QQQ	ETF	30.1	30.12	30.05	30.05	13004.0
2009-01-12 08:00:00	QQQ	ETF	30.06	30.15	29.98	30.07	239069.0
2009-01-12 09:00:00	QQQ	ETF	30.05	30.15	29.79	29.95	9040829.0
2009-01-12 10:00:00	QQQ	ETF	29.95	29.98	29.69	29.78	13861102.0
2009-01-12 11:00:00	QQQ	ETF	29.77	29.8	29.4701	29.491	11469116.0
2009-01-12 12:00:00	QQQ	ETF	29.49	29.62	29.44	29.52	8363863.0
2009-01-12 13:00:00	QQQ	ETF	29.53	29.62	29.49	29.52	6729878.0
2009-01-12 14:00:00	QQQ	ETF	29.51	29.51	29.2	29.42	19295423.0
2009-01-12 15:00:00	QQQ	ETF	29.42	29.63	29.3	29.52	29676576.0
2009-01-12 16:00:00	QQQ	ETF	29.53	29.75	29.51	29.74	2110392.0
2009-01-12 17:00:00	QQQ	ETF	29.71	29.72	29.67	29.69	59740.0
2009-01-12 18:00:00	QQQ	ETF	29.7	29.75	29.7	29.7	36780.0
2009-01-12 19:00:00	QQQ	ETF	29.72	29.74	29.7	29.74	38150.0
2009-01-12 07:00:00	IWM	ETF	47.84	47.9	47.8	47.82	9733.0
2009-01-12 08:00:00	IWM	ETF	47.78	47.9	47.7	47.86	97000.0
2009-01-12 09:00:00	IWM	ETF	47.86	48.11	47.3	47.64	6814118.0
2009-01-12 10:00:00	IWM	ETF	47.63	47.73	47.36	47.63	7089904.0
2009-01-12 11:00:00	IWM	ETF	47.63	47.7	47.27	47.29	5510431.0
2009-01-12 12:00:00	IWM	ETF	47.29	47.53	47.2	47.32	3425274.0
2009-01-12 13:00:00	IWM	ETF	47.33	47.55	47.31	47.39	2684041.0
2009-01-12 14:00:00	IWM	ETF	47.38	47.38	46.569	46.71	9002913.0
2009-01-12 15:00:00	IWM	ETF	46.71	47.04	46.5	46.75	13806663.0
2009-01-12 16:00:00	IWM	ETF	46.75	48.0264	46.69	46.86	2412093.0
2009-01-12 17:00:00	IWM	ETF	46.89	46.91	46.86	46.88	14896.0
2009-01-12 19:00:00	IWM	ETF	46.88	46.9	46.75	46.75	900.0
2009-01-12 06:00:00	DIA	ETF	85.73	85.73	85.66	85.66	1300.0
2009-01-12 07:00:00	DIA	ETF	85.73	85.75	85.55	85.55	8200.0
2009-01-12 08:00:00	DIA	ETF	85.55	85.78	85.55	85.69	37648.0
2009-01-12 09:00:00	DIA	ETF	85.69	86.02	85.38	85.69	2384146.0
2009-01-12 10:00:00	DIA	ETF	85.69	85.7	85.18	85.49	3629926.0
2009-01-12 11:00:00	DIA	ETF	85.49	85.56	85.05	85.06	2625679.0
2009-01-12 12:00:00	DIA	ETF	85.05	85.4	85.0	85.16	2151663.0
2009-01-12 13:00:00	DIA	ETF	85.16	85.4	85.07	85.14	2431982.0
2009-01-12 14:00:00	DIA	ETF	85.13	85.13	84.46	84.61	3046055.0

> showing 50 of 3,855 rows — these rows as CSV

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