PREVIEW / etf_1hour / 2005-12-02

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-12-02.parquet
  size:    36 KB
  rows:    1,138

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-02 07:00:00	SPY	ETF	126.78	126.88	126.76	126.78	51100.0
2005-12-02 08:00:00	SPY	ETF	126.77	127.02	126.75	126.91	1368200.0
2005-12-02 09:00:00	SPY	ETF	126.91	126.95	126.61	126.66	7076600.0
2005-12-02 10:00:00	SPY	ETF	126.67	127.08	126.65	126.74	9160900.0
2005-12-02 11:00:00	SPY	ETF	126.74	126.95	126.65	126.8588	5910600.0
2005-12-02 12:00:00	SPY	ETF	126.85	126.95	126.5	126.56	6255000.0
2005-12-02 13:00:00	SPY	ETF	126.56	126.76	126.51	126.75	3288800.0
2005-12-02 14:00:00	SPY	ETF	126.74	126.87	126.61	126.73	2870900.0
2005-12-02 15:00:00	SPY	ETF	126.73	127.03	126.66	126.87	6455900.0
2005-12-02 16:00:00	SPY	ETF	126.86	126.9	126.79	126.88	2693200.0
2005-12-02 17:00:00	SPY	ETF	126.85	126.85	126.75	126.83	23600.0
2005-12-02 18:00:00	SPY	ETF	126.83	126.84	126.83	126.84	1700.0
2005-12-02 09:00:00	QQQ	ETF	41.93	42.0	41.87	41.92	11268600.0
2005-12-02 10:00:00	QQQ	ETF	41.92	42.13	41.91	41.98	21327800.0
2005-12-02 11:00:00	QQQ	ETF	41.98	42.08	41.95	42.01	6840000.0
2005-12-02 12:00:00	QQQ	ETF	42.0	42.05	41.9	41.94	5877200.0
2005-12-02 13:00:00	QQQ	ETF	41.94	42.01	41.91	42.01	4636300.0
2005-12-02 14:00:00	QQQ	ETF	42.01	42.05	41.96	41.97	4597900.0
2005-12-02 15:00:00	QQQ	ETF	41.96	42.12	41.95	42.11	9926600.0
2005-12-02 07:00:00	IWM	ETF	68.68	68.68	68.67	68.67	24400.0
2005-12-02 08:00:00	IWM	ETF	68.67	68.76	68.67	68.75	39200.0
2005-12-02 09:00:00	IWM	ETF	68.71	68.72	68.38	68.42	3309500.0
2005-12-02 10:00:00	IWM	ETF	68.42	68.8	68.41	68.49	3978600.0
2005-12-02 11:00:00	IWM	ETF	68.5	68.68	68.39	68.58	3039800.0
2005-12-02 12:00:00	IWM	ETF	68.58	68.64	68.12	68.22	5476900.0
2005-12-02 13:00:00	IWM	ETF	68.22	68.61	68.14	68.39	1311300.0
2005-12-02 14:00:00	IWM	ETF	68.4	68.52	68.25	68.38	1186600.0
2005-12-02 15:00:00	IWM	ETF	68.39	68.81	68.33	68.75	3174000.0
2005-12-02 16:00:00	IWM	ETF	68.75	68.81	68.52	68.77	693700.0
2005-12-02 08:00:00	DIA	ETF	109.16	109.28	109.15	109.28	57300.0
2005-12-02 09:00:00	DIA	ETF	109.18	109.18	108.9	108.96	418400.0
2005-12-02 10:00:00	DIA	ETF	108.96	109.26	108.96	109.0	852900.0
2005-12-02 11:00:00	DIA	ETF	108.99	109.1	108.92	108.94	940500.0
2005-12-02 12:00:00	DIA	ETF	108.95	109.02	108.65	108.69	1228700.0
2005-12-02 13:00:00	DIA	ETF	108.69	108.84	108.66	108.83	329300.0
2005-12-02 14:00:00	DIA	ETF	108.83	108.93	108.72	108.77	285600.0
2005-12-02 15:00:00	DIA	ETF	108.77	108.97	108.65	108.8	885100.0
2005-12-02 16:00:00	DIA	ETF	108.8	108.87	108.76	108.87	117700.0
2005-12-02 17:00:00	DIA	ETF	108.82	108.82	108.82	108.82	100.0
2005-12-02 18:00:00	DIA	ETF	108.72	108.72	108.72	108.72	200.0
2005-12-02 19:00:00	DIA	ETF	108.83	108.83	108.83	108.83	100.0
2005-12-02 07:00:00	GLD	ETF	50.25	50.25	50.25	50.25	2000.0
2005-12-02 08:00:00	GLD	ETF	50.15	50.16	49.9	50.05	8000.0
2005-12-02 09:00:00	GLD	ETF	50.06	50.06	49.86	49.939	267800.0
2005-12-02 10:00:00	GLD	ETF	49.94	50.29	49.89	50.05	343300.0
2005-12-02 11:00:00	GLD	ETF	50.0402	50.32	50.03	50.2	209300.0
2005-12-02 12:00:00	GLD	ETF	50.2	50.34	50.18	50.22	122200.0
2005-12-02 13:00:00	GLD	ETF	50.22	50.22	50.05	50.1999	130500.0
2005-12-02 14:00:00	GLD	ETF	50.19	50.22	50.12	50.19	164100.0
2005-12-02 15:00:00	GLD	ETF	50.18	50.31	50.14	50.3	354000.0

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

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