PREVIEW / etf_1hour / 2006-11-22

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-11-22.parquet
  size:    57 KB
  rows:    1,798

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-22 07:00:00	SPY	ETF	140.9	140.95	140.82	140.86	36300.0
2006-11-22 08:00:00	SPY	ETF	140.95	140.95	140.68	140.69	1142700.0
2006-11-22 09:00:00	SPY	ETF	140.7	141.16	140.65	140.89	8353200.0
2006-11-22 10:00:00	SPY	ETF	140.89	140.94	140.5	140.58	14228400.0
2006-11-22 11:00:00	SPY	ETF	140.58	140.78	140.58	140.66	4153800.0
2006-11-22 12:00:00	SPY	ETF	140.66	140.75	140.59	140.6725	2826700.0
2006-11-22 13:00:00	SPY	ETF	140.68	140.74	140.65	140.69	1657800.0
2006-11-22 14:00:00	SPY	ETF	140.69	140.95	140.67	140.8699	4433500.0
2006-11-22 15:00:00	SPY	ETF	140.87	140.95	140.79	140.92	3934100.0
2006-11-22 16:00:00	SPY	ETF	140.93	141.0	140.8	140.81	2270900.0
2006-11-22 17:00:00	SPY	ETF	140.81	140.85	140.77	140.78	29000.0
2006-11-22 18:00:00	SPY	ETF	140.84	140.84	140.78	140.78	3400.0
2006-11-22 19:00:00	SPY	ETF	140.83	140.83	140.83	140.83	100.0
2006-11-22 09:00:00	QQQ	ETF	44.58	44.7	44.46	44.51	15573700.0
2006-11-22 10:00:00	QQQ	ETF	44.51	44.54	44.26	44.46	18089800.0
2006-11-22 11:00:00	QQQ	ETF	44.46	44.64	44.46	44.59	5886500.0
2006-11-22 12:00:00	QQQ	ETF	44.59	44.62	44.41	44.59	2944800.0
2006-11-22 13:00:00	QQQ	ETF	44.59	44.63	44.56	44.61	1748700.0
2006-11-22 14:00:00	QQQ	ETF	44.61	44.74	44.6	44.71	4660700.0
2006-11-22 15:00:00	QQQ	ETF	44.71	44.75	44.7	44.73	6905700.0
2006-11-22 07:00:00	IWM	ETF	79.0	79.0	79.0	79.0	200.0
2006-11-22 08:00:00	IWM	ETF	79.01	79.09	78.94	78.95	200700.0
2006-11-22 09:00:00	IWM	ETF	78.95	79.11	78.85	79.0	4485300.0
2006-11-22 10:00:00	IWM	ETF	78.99	79.04	78.56	78.78	6152700.0
2006-11-22 11:00:00	IWM	ETF	78.78	78.88	78.63	78.66	7253300.0
2006-11-22 12:00:00	IWM	ETF	78.65	78.77	78.62	78.7	4245900.0
2006-11-22 13:00:00	IWM	ETF	78.7	78.84	78.69	78.8	1498700.0
2006-11-22 14:00:00	IWM	ETF	78.8	78.93	78.69	78.89	4604800.0
2006-11-22 15:00:00	IWM	ETF	78.89	78.94	78.8	78.918	2619300.0
2006-11-22 16:00:00	IWM	ETF	78.92	79.01	78.8	78.88	1634300.0
2006-11-22 17:00:00	IWM	ETF	78.92	78.92	78.92	78.92	100.0
2006-11-22 19:00:00	IWM	ETF	78.9	78.9	78.9	78.9	1000.0
2006-11-22 07:00:00	DIA	ETF	123.29	123.31	123.29	123.31	400.0
2006-11-22 08:00:00	DIA	ETF	123.31	123.33	123.26	123.26	3500.0
2006-11-22 09:00:00	DIA	ETF	123.18	123.51	123.15	123.21	974900.0
2006-11-22 10:00:00	DIA	ETF	123.2	123.27	122.93	123.02	1099700.0
2006-11-22 11:00:00	DIA	ETF	123.02	123.2	123.02	123.06	374900.0
2006-11-22 12:00:00	DIA	ETF	123.06	123.11	122.99	123.09	199800.0
2006-11-22 13:00:00	DIA	ETF	123.08	123.13	123.02	123.04	381200.0
2006-11-22 14:00:00	DIA	ETF	123.0399	123.18	123.0	123.13	535500.0
2006-11-22 15:00:00	DIA	ETF	123.13	123.21	123.07	123.19	335500.0
2006-11-22 16:00:00	DIA	ETF	123.2	123.35	123.12	123.12	12900.0
2006-11-22 07:00:00	GLD	ETF	62.44	62.48	62.39	62.48	6000.0
2006-11-22 08:00:00	GLD	ETF	62.4	62.89	62.4	62.75	179600.0
2006-11-22 09:00:00	GLD	ETF	62.76	62.82	62.6	62.7654	797600.0
2006-11-22 10:00:00	GLD	ETF	62.78	63.07	62.41	62.46	1687200.0
2006-11-22 11:00:00	GLD	ETF	62.46	62.59	62.4	62.44	1003900.0
2006-11-22 12:00:00	GLD	ETF	62.44	62.5	62.25	62.37	372400.0
2006-11-22 13:00:00	GLD	ETF	62.4	62.72	62.3418	62.59	300200.0
2006-11-22 14:00:00	GLD	ETF	62.649	62.66	62.45	62.5099	239000.0

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

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