PREVIEW / etf_1hour / 2006-10-13

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-10-13.parquet
  size:    53 KB
  rows:    1,718

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
2006-10-13 06:00:00	SPY	ETF	136.35	136.35	136.23	136.23	11000.0
2006-10-13 07:00:00	SPY	ETF	136.24	136.25	136.18	136.23	446800.0
2006-10-13 08:00:00	SPY	ETF	136.22	136.31	136.08	136.12	1672700.0
2006-10-13 09:00:00	SPY	ETF	136.13	136.33	136.11	136.16	5870500.0
2006-10-13 10:00:00	SPY	ETF	136.16	136.29	136.04	136.22	9591100.0
2006-10-13 11:00:00	SPY	ETF	136.21	136.27	136.08	136.22	5437400.0
2006-10-13 12:00:00	SPY	ETF	136.22	136.51	136.2	136.46	5730200.0
2006-10-13 13:00:00	SPY	ETF	136.45	136.68	136.25	136.65	5420000.0
2006-10-13 14:00:00	SPY	ETF	136.63	136.71	136.23	136.3	7266300.0
2006-10-13 15:00:00	SPY	ETF	136.3	136.58	136.29	136.56	6351700.0
2006-10-13 16:00:00	SPY	ETF	136.58	136.61	136.52	136.57	5202500.0
2006-10-13 17:00:00	SPY	ETF	136.56	136.6	136.52	136.52	18400.0
2006-10-13 18:00:00	SPY	ETF	136.58	136.58	136.58	136.58	1300.0
2006-10-13 19:00:00	SPY	ETF	136.58	136.58	136.58	136.58	200.0
2006-10-13 09:00:00	QQQ	ETF	42.22	42.36	42.14	42.26	10865400.0
2006-10-13 10:00:00	QQQ	ETF	42.27	42.38	42.21	42.33	13597400.0
2006-10-13 11:00:00	QQQ	ETF	42.33	42.35	42.24	42.3	9280400.0
2006-10-13 12:00:00	QQQ	ETF	42.3	42.43	42.28	42.4	5227600.0
2006-10-13 13:00:00	QQQ	ETF	42.4	42.52	42.38	42.46	8815700.0
2006-10-13 14:00:00	QQQ	ETF	42.46	42.5	42.32	42.37	9820500.0
2006-10-13 15:00:00	QQQ	ETF	42.36	42.46	42.35	42.42	11438700.0
2006-10-13 07:00:00	IWM	ETF	75.0	75.0	75.0	75.0	700.0
2006-10-13 08:00:00	IWM	ETF	75.25	75.3	75.18	75.22	79900.0
2006-10-13 09:00:00	IWM	ETF	75.24	75.51	75.13	75.37	5733500.0
2006-10-13 10:00:00	IWM	ETF	75.37	75.79	75.31	75.68	10701600.0
2006-10-13 11:00:00	IWM	ETF	75.68	75.71	75.46	75.57	7851900.0
2006-10-13 12:00:00	IWM	ETF	75.57	75.81	75.52	75.77	3634500.0
2006-10-13 13:00:00	IWM	ETF	75.77	75.9	75.64	75.79	3879500.0
2006-10-13 14:00:00	IWM	ETF	75.8	75.86	75.55	75.65	5482400.0
2006-10-13 15:00:00	IWM	ETF	75.65	75.82	75.64	75.79	6735800.0
2006-10-13 16:00:00	IWM	ETF	75.8	75.96	75.4	75.9	789000.0
2006-10-13 08:00:00	DIA	ETF	119.42	119.45	119.33	119.33	50100.0
2006-10-13 09:00:00	DIA	ETF	119.33	119.44	119.24	119.28	866000.0
2006-10-13 10:00:00	DIA	ETF	119.27	119.39	119.15	119.21	809100.0
2006-10-13 11:00:00	DIA	ETF	119.2	119.25	119.07	119.19	496000.0
2006-10-13 12:00:00	DIA	ETF	119.19	119.4	119.16	119.36	341200.0
2006-10-13 13:00:00	DIA	ETF	119.36	119.51	119.27	119.46	954400.0
2006-10-13 14:00:00	DIA	ETF	119.46	119.53	119.26	119.31	578100.0
2006-10-13 15:00:00	DIA	ETF	119.32	119.57	119.32	119.56	873400.0
2006-10-13 16:00:00	DIA	ETF	119.58	119.68	119.57	119.63	262300.0
2006-10-13 07:00:00	GLD	ETF	57.96	57.96	57.96	57.96	1000.0
2006-10-13 08:00:00	GLD	ETF	58.02	58.49	57.96	58.25	130200.0
2006-10-13 09:00:00	GLD	ETF	58.18	58.32	57.98	58.04	697700.0
2006-10-13 10:00:00	GLD	ETF	58.0499	58.32	57.94	58.25	660700.0
2006-10-13 11:00:00	GLD	ETF	58.26	58.44	58.13	58.33	369800.0
2006-10-13 12:00:00	GLD	ETF	58.375	58.58	58.15	58.49	368600.0
2006-10-13 13:00:00	GLD	ETF	58.5099	58.57	58.4	58.53	187800.0
2006-10-13 14:00:00	GLD	ETF	58.49	58.54	58.41	58.42	209800.0
2006-10-13 15:00:00	GLD	ETF	58.44	58.6	58.43	58.58	427400.0
2006-10-13 16:00:00	GLD	ETF	58.53	58.55	58.5	58.55	3100.0

> showing 50 of 1,718 rows — these rows as CSV

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