PREVIEW / etf_1hour / 2005-11-29

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-11-29.parquet
  size:    35 KB
  rows:    1,070

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
2005-11-29 06:00:00	SPY	ETF	126.52	126.53	126.52	126.53	50000.0
2005-11-29 07:00:00	SPY	ETF	126.48	126.63	126.48	126.63	244000.0
2005-11-29 08:00:00	SPY	ETF	126.62	126.75	126.37	126.65	1158000.0
2005-11-29 09:00:00	SPY	ETF	126.65	126.81	126.06	126.77	5600200.0
2005-11-29 10:00:00	SPY	ETF	126.78	126.98	126.45	126.54	11840800.0
2005-11-29 11:00:00	SPY	ETF	126.53	126.72	126.41	126.7	5523000.0
2005-11-29 12:00:00	SPY	ETF	126.68	126.72	126.42	126.43	3633500.0
2005-11-29 13:00:00	SPY	ETF	126.43	126.75	126.14	126.32	7126200.0
2005-11-29 14:00:00	SPY	ETF	126.32	126.61	126.11	126.48	7960400.0
2005-11-29 15:00:00	SPY	ETF	126.47	126.5	126.09	126.12	5613700.0
2005-11-29 16:00:00	SPY	ETF	126.09	126.21	126.07	126.2	1882500.0
2005-11-29 17:00:00	SPY	ETF	126.19	126.2	126.11	126.11	125900.0
2005-11-29 18:00:00	SPY	ETF	126.15	126.16	126.12	126.16	10600.0
2005-11-29 19:00:00	SPY	ETF	126.19	126.24	126.19	126.22	4600.0
2005-11-29 09:00:00	QQQ	ETF	41.76	41.77	41.66	41.75	8093000.0
2005-11-29 10:00:00	QQQ	ETF	41.74	41.85	41.53	41.57	20703000.0
2005-11-29 11:00:00	QQQ	ETF	41.58	41.79	41.53	41.67	10380700.0
2005-11-29 12:00:00	QQQ	ETF	41.67	41.69	41.52	41.52	3600400.0
2005-11-29 13:00:00	QQQ	ETF	41.52	41.58	41.34	41.45	10575800.0
2005-11-29 14:00:00	QQQ	ETF	41.45	41.54	41.36	41.49	8863100.0
2005-11-29 15:00:00	QQQ	ETF	41.48	41.5	41.34	41.35	9364900.0
2005-11-29 08:00:00	IWM	ETF	67.09	67.23	67.03	67.19	325100.0
2005-11-29 09:00:00	IWM	ETF	67.17	67.32	67.06	67.31	2784300.0
2005-11-29 10:00:00	IWM	ETF	67.29	67.57	67.05	67.1	4381200.0
2005-11-29 11:00:00	IWM	ETF	67.1	67.37	67.03	67.33	2560900.0
2005-11-29 12:00:00	IWM	ETF	67.33	67.4	67.17	67.27	3034700.0
2005-11-29 13:00:00	IWM	ETF	67.27	67.29	66.85	67.02	3602400.0
2005-11-29 14:00:00	IWM	ETF	67.04	67.28	66.8521	67.23	2131900.0
2005-11-29 15:00:00	IWM	ETF	67.22	67.22	66.94	67.06	3188300.0
2005-11-29 16:00:00	IWM	ETF	67.05	67.19	67.05	67.19	756400.0
2005-11-29 17:00:00	IWM	ETF	67.22	67.22	67.19	67.19	4100.0
2005-11-29 18:00:00	IWM	ETF	67.17	67.17	67.17	67.17	100.0
2005-11-29 19:00:00	IWM	ETF	67.1	67.1	67.1	67.1	100.0
2005-11-29 07:00:00	DIA	ETF	109.23	109.29	109.23	109.29	1500.0
2005-11-29 08:00:00	DIA	ETF	109.29	109.4	109.29	109.36	9200.0
2005-11-29 09:00:00	DIA	ETF	109.33	109.47	109.27	109.46	923400.0
2005-11-29 10:00:00	DIA	ETF	109.47	109.59	109.23	109.25	1246200.0
2005-11-29 11:00:00	DIA	ETF	109.25	109.42	109.15	109.381	781800.0
2005-11-29 12:00:00	DIA	ETF	109.33	109.36	109.19	109.21	335100.0
2005-11-29 13:00:00	DIA	ETF	109.22	109.25	108.8901	109.01	993300.0
2005-11-29 14:00:00	DIA	ETF	109.02	109.3	108.87	109.22	884200.0
2005-11-29 15:00:00	DIA	ETF	109.2	109.22	108.88	108.88	703300.0
2005-11-29 16:00:00	DIA	ETF	108.91	108.95	108.85	108.93	27200.0
2005-11-29 17:00:00	DIA	ETF	108.6	108.6	108.6	108.6	100.0
2005-11-29 19:00:00	DIA	ETF	108.94	108.94	108.94	108.94	1000.0
2005-11-29 07:00:00	GLD	ETF	49.45	49.45	49.45	49.45	1000.0
2005-11-29 08:00:00	GLD	ETF	49.55	49.6	49.38	49.49	51900.0
2005-11-29 09:00:00	GLD	ETF	49.48	49.59	49.38	49.54	332000.0
2005-11-29 10:00:00	GLD	ETF	49.52	49.57	49.4	49.56	452400.0
2005-11-29 11:00:00	GLD	ETF	49.55	49.65	49.46	49.64	223000.0

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

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