PREVIEW / etf_1hour / 2005-12-07

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-12-07.parquet
  size:    37 KB
  rows:    1,161

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-12-07 04:00:00	SPY	ETF	126.85	126.85	126.85	126.85	5000.0
2005-12-07 07:00:00	SPY	ETF	126.87	126.87	126.75	126.75	62600.0
2005-12-07 08:00:00	SPY	ETF	126.75	126.88	126.7	126.82	458100.0
2005-12-07 09:00:00	SPY	ETF	126.82	126.87	126.48	126.65	9935700.0
2005-12-07 10:00:00	SPY	ETF	126.65	126.85	126.39	126.4	10525300.0
2005-12-07 11:00:00	SPY	ETF	126.4	126.71	126.29	126.45	6547400.0
2005-12-07 12:00:00	SPY	ETF	126.44	126.57	126.29	126.48	4405500.0
2005-12-07 13:00:00	SPY	ETF	126.49	126.52	125.95	125.99	9703300.0
2005-12-07 14:00:00	SPY	ETF	125.99	126.08	125.71	125.8	14043000.0
2005-12-07 15:00:00	SPY	ETF	125.8	126.21	125.68	126.15	8995000.0
2005-12-07 16:00:00	SPY	ETF	126.14	126.19	126.06	126.17	510400.0
2005-12-07 17:00:00	SPY	ETF	126.17	126.17	126.08	126.15	90600.0
2005-12-07 18:00:00	SPY	ETF	126.14	126.18	126.12	126.17	10700.0
2005-12-07 19:00:00	SPY	ETF	126.12	126.12	126.07	126.08	3000.0
2005-12-07 09:00:00	QQQ	ETF	42.0	42.03	41.86	41.95	9079300.0
2005-12-07 10:00:00	QQQ	ETF	41.96	42.01	41.81	41.82	12330000.0
2005-12-07 11:00:00	QQQ	ETF	41.81	41.9	41.77	41.83	12233300.0
2005-12-07 12:00:00	QQQ	ETF	41.83	41.91	41.8	41.88	5660100.0
2005-12-07 13:00:00	QQQ	ETF	41.88	41.88	41.69	41.7	9371900.0
2005-12-07 14:00:00	QQQ	ETF	41.7	41.77	41.63	41.71	11034700.0
2005-12-07 15:00:00	QQQ	ETF	41.7	41.86	41.66	41.85	12729700.0
2005-12-07 07:00:00	IWM	ETF	68.48	68.48	68.45	68.45	1500.0
2005-12-07 08:00:00	IWM	ETF	68.45	68.51	68.35	68.42	377900.0
2005-12-07 09:00:00	IWM	ETF	68.42	68.57	68.13	68.36	2647200.0
2005-12-07 10:00:00	IWM	ETF	68.35	68.51	68.06	68.07	4300900.0
2005-12-07 11:00:00	IWM	ETF	68.07	68.25	67.96	68.15	4151200.0
2005-12-07 12:00:00	IWM	ETF	68.15	68.35	68.04	68.25	1641400.0
2005-12-07 13:00:00	IWM	ETF	68.25	68.32	67.84	67.86	2120500.0
2005-12-07 14:00:00	IWM	ETF	67.86	68.0	67.75	67.8588	2096400.0
2005-12-07 15:00:00	IWM	ETF	67.86	68.09	67.76	68.07	3955800.0
2005-12-07 16:00:00	IWM	ETF	68.08	68.468	68.02	68.15	1200600.0
2005-12-07 17:00:00	IWM	ETF	68.19	68.19	68.18	68.18	2500.0
2005-12-07 18:00:00	IWM	ETF	68.13	68.13	68.13	68.13	3200.0
2005-12-07 08:00:00	DIA	ETF	108.6	108.72	108.59	108.72	12200.0
2005-12-07 09:00:00	DIA	ETF	108.72	108.74	108.25	108.42	882900.0
2005-12-07 10:00:00	DIA	ETF	108.41	108.73	108.34	108.37	1732000.0
2005-12-07 11:00:00	DIA	ETF	108.36	108.6	108.3	108.5	1136100.0
2005-12-07 12:00:00	DIA	ETF	108.5	108.54	108.35	108.48	477400.0
2005-12-07 13:00:00	DIA	ETF	108.48	108.49	107.87	107.94	1502400.0
2005-12-07 14:00:00	DIA	ETF	107.94	107.94	107.69	107.75	1519400.0
2005-12-07 15:00:00	DIA	ETF	107.75	108.21	107.7	108.17	1111600.0
2005-12-07 16:00:00	DIA	ETF	108.15	108.2	108.09	108.14	153200.0
2005-12-07 17:00:00	DIA	ETF	108.11	108.11	108.11	108.11	200.0
2005-12-07 18:00:00	DIA	ETF	108.12	108.12	108.12	108.12	300.0
2005-12-07 19:00:00	DIA	ETF	108.11	108.11	108.11	108.11	300.0
2005-12-07 08:00:00	GLD	ETF	50.94	51.18	50.94	51.1	13900.0
2005-12-07 09:00:00	GLD	ETF	51.17	51.3274	51.17	51.28	574600.0
2005-12-07 10:00:00	GLD	ETF	51.2773	51.5	51.27	51.39	599200.0
2005-12-07 11:00:00	GLD	ETF	51.36	51.4	51.2	51.28	267800.0
2005-12-07 12:00:00	GLD	ETF	51.28	51.3773	51.1	51.3	261900.0

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

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