PREVIEW / etf_1hour / 2006-11-03

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-11-03.parquet
  size:    55 KB
  rows:    1,762

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-11-03 06:00:00	SPY	ETF	136.98	137.0	136.98	137.0	20000.0
2006-11-03 07:00:00	SPY	ETF	136.95	136.96	136.9	136.96	114200.0
2006-11-03 08:00:00	SPY	ETF	136.93	137.24	136.7	137.16	6209400.0
2006-11-03 09:00:00	SPY	ETF	137.18	137.39	136.91	137.04	12959500.0
2006-11-03 10:00:00	SPY	ETF	137.03	137.23	136.69	136.89	14942500.0
2006-11-03 11:00:00	SPY	ETF	136.88	137.08	136.33	136.54	8138500.0
2006-11-03 12:00:00	SPY	ETF	136.52	136.6	136.33	136.39	4224600.0
2006-11-03 13:00:00	SPY	ETF	136.39	136.62	136.2	136.529	6820800.0
2006-11-03 14:00:00	SPY	ETF	136.53	136.83	136.38	136.65	7325400.0
2006-11-03 15:00:00	SPY	ETF	136.66	136.79	136.46	136.6	8053300.0
2006-11-03 16:00:00	SPY	ETF	136.59	136.6	136.42	136.46	843800.0
2006-11-03 17:00:00	SPY	ETF	136.46	136.46	136.41	136.44	7900.0
2006-11-03 09:00:00	QQQ	ETF	42.1	42.19	41.95	42.0	13858400.0
2006-11-03 10:00:00	QQQ	ETF	42.0	42.12	41.79	41.87	18630800.0
2006-11-03 11:00:00	QQQ	ETF	41.86	42.7	41.62	41.71	15708500.0
2006-11-03 12:00:00	QQQ	ETF	41.71	41.74	41.64	41.67	5918900.0
2006-11-03 13:00:00	QQQ	ETF	41.67	41.83	41.61	41.8	9210200.0
2006-11-03 14:00:00	QQQ	ETF	41.8	41.93	41.73	41.88	10217400.0
2006-11-03 15:00:00	QQQ	ETF	41.87	41.94	41.78	41.92	13000000.0
2006-11-03 08:00:00	IWM	ETF	74.68	74.8	74.39	74.65	1148800.0
2006-11-03 09:00:00	IWM	ETF	74.72	75.24	74.71	74.93	6884400.0
2006-11-03 10:00:00	IWM	ETF	74.93	75.09	74.54	74.71	7132700.0
2006-11-03 11:00:00	IWM	ETF	74.72	74.75	74.24	74.37	6790400.0
2006-11-03 12:00:00	IWM	ETF	74.38	74.51	74.21	74.34	4989300.0
2006-11-03 13:00:00	IWM	ETF	74.33	74.7	74.22	74.69	6474700.0
2006-11-03 14:00:00	IWM	ETF	74.68	74.91	74.45	74.75	6341900.0
2006-11-03 15:00:00	IWM	ETF	74.74	74.89	74.57	74.86	6932400.0
2006-11-03 16:00:00	IWM	ETF	74.87	74.88	74.76	74.79	536400.0
2006-11-03 17:00:00	IWM	ETF	74.82	74.82	74.82	74.82	721700.0
2006-11-03 08:00:00	DIA	ETF	120.17	120.38	120.0	120.38	176400.0
2006-11-03 09:00:00	DIA	ETF	120.38	120.62	120.16	120.27	889700.0
2006-11-03 10:00:00	DIA	ETF	120.27	120.46	120.03	120.17	1321500.0
2006-11-03 11:00:00	DIA	ETF	120.18	120.2	119.62	119.78	921600.0
2006-11-03 12:00:00	DIA	ETF	119.79	119.84	119.63	119.74	1249600.0
2006-11-03 13:00:00	DIA	ETF	119.73	119.87	119.6	119.78	442500.0
2006-11-03 14:00:00	DIA	ETF	119.77	120.0	119.64	119.86	641400.0
2006-11-03 15:00:00	DIA	ETF	119.85	119.93	119.66	119.87	1144300.0
2006-11-03 16:00:00	DIA	ETF	119.88	119.89	119.74	119.8	31100.0
2006-11-03 17:00:00	DIA	ETF	119.8	119.83	119.75	119.75	3500.0
2006-11-03 05:00:00	GLD	ETF	62.25	62.25	62.25	62.25	400.0
2006-11-03 07:00:00	GLD	ETF	62.03	62.09	62.03	62.09	200.0
2006-11-03 08:00:00	GLD	ETF	62.08	62.12	61.31	61.35	739800.0
2006-11-03 09:00:00	GLD	ETF	61.34	62.07	61.34	61.88	1334000.0
2006-11-03 10:00:00	GLD	ETF	61.88	62.16	61.73	62.04	1063500.0
2006-11-03 11:00:00	GLD	ETF	62.03	62.25	61.92	62.24	916700.0
2006-11-03 12:00:00	GLD	ETF	62.23	62.5	62.22	62.39	779300.0
2006-11-03 13:00:00	GLD	ETF	62.38	62.48	62.21	62.36	537400.0
2006-11-03 14:00:00	GLD	ETF	62.37	62.37	62.2	62.228	352800.0
2006-11-03 15:00:00	GLD	ETF	62.22	62.41	62.16	62.39	822800.0
2006-11-03 16:00:00	GLD	ETF	62.35	62.38	62.3	62.3	1400.0

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

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