PREVIEW / etf_1hour / 2008-01-29

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-01-29.parquet
  size:    97 KB
  rows:    3,260

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-01-29 04:00:00	SPY	ETF	135.29	135.29	135.29	135.29	100.0
2008-01-29 05:00:00	SPY	ETF	135.41	135.66	135.41	135.66	200.0
2008-01-29 06:00:00	SPY	ETF	135.89	135.89	135.56	135.72	34000.0
2008-01-29 07:00:00	SPY	ETF	135.57	135.8	135.44	135.59	560200.0
2008-01-29 08:00:00	SPY	ETF	135.59	136.35	135.07	136.11	6864700.0
2008-01-29 09:00:00	SPY	ETF	136.12	136.36	135.2	135.24	22923515.0
2008-01-29 10:00:00	SPY	ETF	135.25	135.98	134.88	135.73	29902658.0
2008-01-29 11:00:00	SPY	ETF	135.73	136.32	135.7	136.03	17053344.0
2008-01-29 12:00:00	SPY	ETF	136.02	136.0599	135.32	135.5374	15645825.0
2008-01-29 13:00:00	SPY	ETF	135.53	135.95	135.35	135.57	18474666.0
2008-01-29 14:00:00	SPY	ETF	135.5699	135.96	135.38	135.85	15643502.0
2008-01-29 15:00:00	SPY	ETF	135.86	136.45	135.84	136.07	30238821.0
2008-01-29 16:00:00	SPY	ETF	135.98	136.22	135.3169	135.91	5186660.0
2008-01-29 17:00:00	SPY	ETF	135.91	135.97	135.32	135.9	4208300.0
2008-01-29 18:00:00	SPY	ETF	135.9	135.94	135.81	135.81	117400.0
2008-01-29 19:00:00	SPY	ETF	135.82	135.85	135.69	135.74	42100.0
2008-01-29 06:00:00	QQQ	ETF	44.52	44.54	44.52	44.54	25000.0
2008-01-29 07:00:00	QQQ	ETF	44.4	44.48	44.35	44.35	151518.0
2008-01-29 08:00:00	QQQ	ETF	44.41	44.69	44.22	44.65	2687271.0
2008-01-29 09:00:00	QQQ	ETF	44.65	44.72	44.21	44.22	24955616.0
2008-01-29 10:00:00	QQQ	ETF	44.22	44.47	44.04	44.295	29810601.0
2008-01-29 11:00:00	QQQ	ETF	44.29	44.49	44.29	44.43	13220929.0
2008-01-29 12:00:00	QQQ	ETF	44.42	44.43	44.12	44.2101	18079591.0
2008-01-29 13:00:00	QQQ	ETF	44.2199	44.38	44.15	44.27	10130247.0
2008-01-29 14:00:00	QQQ	ETF	44.28	44.44	44.18	44.39	15767284.0
2008-01-29 15:00:00	QQQ	ETF	44.3905	44.55	44.35	44.44	20678391.0
2008-01-29 16:00:00	QQQ	ETF	44.41	44.49	44.26	44.31	2381619.0
2008-01-29 17:00:00	QQQ	ETF	44.31	44.34	44.29	44.33	586368.0
2008-01-29 18:00:00	QQQ	ETF	44.31	44.34	44.29	44.32	21314.0
2008-01-29 19:00:00	QQQ	ETF	44.32	44.32	44.27	44.28	24233.0
2008-01-29 07:00:00	IWM	ETF	70.05	70.15	70.04	70.15	16400.0
2008-01-29 08:00:00	IWM	ETF	70.15	70.45	70.15	70.4	1401200.0
2008-01-29 09:00:00	IWM	ETF	70.43	70.55	69.24	69.33	18162433.0
2008-01-29 10:00:00	IWM	ETF	69.33	69.96	69.12	69.77	17397411.0
2008-01-29 11:00:00	IWM	ETF	69.77	70.25	69.75	70.1	7513732.0
2008-01-29 12:00:00	IWM	ETF	70.1	70.11	69.52	69.8	9120084.0
2008-01-29 13:00:00	IWM	ETF	69.81	70.09	69.71	69.91	4591568.0
2008-01-29 14:00:00	IWM	ETF	69.92	70.15	69.81	70.08	5533211.0
2008-01-29 15:00:00	IWM	ETF	70.08	70.36	70.04	70.3	10087969.0
2008-01-29 16:00:00	IWM	ETF	70.27	70.32	69.91	70.2	1384800.0
2008-01-29 17:00:00	IWM	ETF	70.1	70.1	70.1	70.1	112900.0
2008-01-29 18:00:00	IWM	ETF	70.2	70.2	70.07	70.07	8900.0
2008-01-29 19:00:00	IWM	ETF	70.13	70.16	70.13	70.16	10000.0
2008-01-29 04:00:00	DIA	ETF	123.52	123.52	123.52	123.52	100.0
2008-01-29 07:00:00	DIA	ETF	123.81	123.95	123.81	123.85	27600.0
2008-01-29 08:00:00	DIA	ETF	123.86	124.39	123.81	124.39	576200.0
2008-01-29 09:00:00	DIA	ETF	124.23	124.45	123.68	123.73	1734594.0
2008-01-29 10:00:00	DIA	ETF	123.73	124.38	123.34	124.17	4385349.0
2008-01-29 11:00:00	DIA	ETF	124.2	124.64	124.2	124.52	1336055.0
2008-01-29 12:00:00	DIA	ETF	124.51	124.52	123.97	124.07	855220.0

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

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