PREVIEW / etf_1hour / 2008-12-29

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-12-29.parquet
  size:    127 KB
  rows:    3,919

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
2008-12-29 04:00:00	SPY	ETF	87.26	87.45	87.26	87.45	1720.0
2008-12-29 05:00:00	SPY	ETF	87.5	87.5	87.4	87.44	3541.0
2008-12-29 06:00:00	SPY	ETF	87.44	87.55	87.39	87.39	8385.0
2008-12-29 07:00:00	SPY	ETF	87.38	87.45	87.17	87.31	83668.0
2008-12-29 08:00:00	SPY	ETF	87.29	87.58	87.09	87.1	1277036.0
2008-12-29 09:00:00	SPY	ETF	87.11	87.33	86.85	86.965	8926483.0
2008-12-29 10:00:00	SPY	ETF	86.97	86.97	86.12	86.14	18120971.0
2008-12-29 11:00:00	SPY	ETF	86.15	86.27	85.98	86.23	14781927.0
2008-12-29 12:00:00	SPY	ETF	86.24	86.38	85.75	85.75	14248576.0
2008-12-29 13:00:00	SPY	ETF	85.7599	86.16	85.6	86.11	13296248.0
2008-12-29 14:00:00	SPY	ETF	86.11	86.31	85.78	86.2025	12687470.0
2008-12-29 15:00:00	SPY	ETF	86.21	86.92	86.11	86.89	29239708.0
2008-12-29 16:00:00	SPY	ETF	86.9	87.38	86.25	87.3	12376901.0
2008-12-29 17:00:00	SPY	ETF	87.31	87.33	87.25	87.31	311234.0
2008-12-29 18:00:00	SPY	ETF	87.3	87.39	87.22	87.24	272132.0
2008-12-29 19:00:00	SPY	ETF	87.26	87.5	87.26	87.39	139333.0
2008-12-29 05:00:00	QQQ	ETF	29.4	29.4	29.4	29.4	10000.0
2008-12-29 06:00:00	QQQ	ETF	29.38	29.42	29.38	29.42	1366.0
2008-12-29 07:00:00	QQQ	ETF	29.38	29.4	29.28	29.29	36180.0
2008-12-29 08:00:00	QQQ	ETF	29.3	29.31	29.22	29.22	116327.0
2008-12-29 09:00:00	QQQ	ETF	29.22	29.27	29.04	29.06	3326020.0
2008-12-29 10:00:00	QQQ	ETF	29.05	29.06	28.59	28.6499	8773233.0
2008-12-29 11:00:00	QQQ	ETF	28.64	28.72	28.57	28.6879	4085695.0
2008-12-29 12:00:00	QQQ	ETF	28.69	28.75	28.541	28.55	3547853.0
2008-12-29 13:00:00	QQQ	ETF	28.55	28.66	28.46	28.62	5816646.0
2008-12-29 14:00:00	QQQ	ETF	28.62	28.65	28.5	28.64	7079317.0
2008-12-29 15:00:00	QQQ	ETF	28.64	29.1383	28.61	28.82	15871425.0
2008-12-29 16:00:00	QQQ	ETF	28.83	29.05	28.6907	28.94	1609591.0
2008-12-29 17:00:00	QQQ	ETF	28.94	28.97	28.93	28.93	21195.0
2008-12-29 18:00:00	QQQ	ETF	28.93	28.96	28.93	28.93	23587.0
2008-12-29 19:00:00	QQQ	ETF	28.96	29.01	28.95	29.01	29722.0
2008-12-29 06:00:00	IWM	ETF	47.55	47.55	47.49	47.49	200.0
2008-12-29 07:00:00	IWM	ETF	47.48	47.54	47.42	47.47	9527.0
2008-12-29 08:00:00	IWM	ETF	48.1	48.1	47.39	47.48	143668.0
2008-12-29 09:00:00	IWM	ETF	47.41	47.58	46.97	47.06	3677024.0
2008-12-29 10:00:00	IWM	ETF	47.05	47.05	46.38	46.49	5956585.0
2008-12-29 11:00:00	IWM	ETF	46.49	46.56	46.27	46.33	4901703.0
2008-12-29 12:00:00	IWM	ETF	46.33	46.44	46.12	46.13	4306102.0
2008-12-29 13:00:00	IWM	ETF	46.12	46.25	45.99	46.22	3595285.0
2008-12-29 14:00:00	IWM	ETF	46.21	46.3	45.9101	46.21	4323598.0
2008-12-29 15:00:00	IWM	ETF	46.22	46.62	46.16	46.61	9460039.0
2008-12-29 16:00:00	IWM	ETF	46.62	46.99	46.4584	46.91	3607844.0
2008-12-29 17:00:00	IWM	ETF	46.9	46.94	46.9	46.94	7011.0
2008-12-29 18:00:00	IWM	ETF	46.81	46.81	46.77	46.77	900.0
2008-12-29 19:00:00	IWM	ETF	46.82	46.82	46.8	46.8	2480.0
2008-12-29 06:00:00	DIA	ETF	85.38	85.38	85.37	85.37	200.0
2008-12-29 07:00:00	DIA	ETF	85.27	85.27	85.14	85.23	2100.0
2008-12-29 08:00:00	DIA	ETF	85.19	85.24	85.02	85.12	54021.0
2008-12-29 09:00:00	DIA	ETF	85.07	85.278	84.91	85.001	672593.0
2008-12-29 10:00:00	DIA	ETF	84.99	85.02	84.24	84.27	1317742.0

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

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