PREVIEW / etf_1hour / 2004-12-30

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-12-30.parquet
  size:    26 KB
  rows:    779

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
2004-12-30 08:00:00	SPY	ETF	121.33	121.49	121.33	121.44	17800.0
2004-12-30 09:00:00	SPY	ETF	121.44	121.49	121.29	121.36	2308800.0
2004-12-30 10:00:00	SPY	ETF	121.36	121.56	121.28	121.4	4016700.0
2004-12-30 11:00:00	SPY	ETF	121.41	121.41	121.29	121.39	3213300.0
2004-12-30 12:00:00	SPY	ETF	121.39	121.43	121.33	121.4	1277000.0
2004-12-30 13:00:00	SPY	ETF	121.4	121.55	121.37	121.51	1750800.0
2004-12-30 14:00:00	SPY	ETF	121.51	121.57	121.47	121.53	1468300.0
2004-12-30 15:00:00	SPY	ETF	121.53	121.55	121.21	121.23	3543100.0
2004-12-30 16:00:00	SPY	ETF	121.24	121.48	121.04	121.24	1384300.0
2004-12-30 17:00:00	SPY	ETF	121.24	121.24	121.19	121.2	17300.0
2004-12-30 18:00:00	SPY	ETF	121.21	121.22	121.19	121.2	2600.0
2004-12-30 19:00:00	SPY	ETF	121.23	121.23	121.23	121.23	400.0
2004-12-30 08:00:00	QQQ	ETF	40.06	40.15	40.05	40.071	677588.0
2004-12-30 09:00:00	QQQ	ETF	40.09	40.11	40.02	40.068	4123471.0
2004-12-30 10:00:00	QQQ	ETF	40.07	40.123	39.995	40.02	9168577.0
2004-12-30 11:00:00	QQQ	ETF	40.02	40.02	39.93	39.997	6787523.0
2004-12-30 12:00:00	QQQ	ETF	39.996	40.011	39.97	39.992	2516847.0
2004-12-30 13:00:00	QQQ	ETF	39.99	40.09	39.98	40.077	2858267.0
2004-12-30 14:00:00	QQQ	ETF	40.071	40.085	40.03	40.07	4029003.0
2004-12-30 15:00:00	QQQ	ETF	40.07	40.08	39.95	39.95	7585145.0
2004-12-30 16:00:00	QQQ	ETF	39.97	40.05	39.882	40.02	2154453.0
2004-12-30 17:00:00	QQQ	ETF	40.013	40.02	39.99	39.99	20560.0
2004-12-30 18:00:00	QQQ	ETF	39.98	40.01	39.98	40.01	10700.0
2004-12-30 08:00:00	IWM	ETF	65.08	65.09	65.08	65.09	2400.0
2004-12-30 09:00:00	IWM	ETF	65.12	65.175	65.05	65.135	1048000.0
2004-12-30 10:00:00	IWM	ETF	65.135	65.2	65.05	65.11	655200.0
2004-12-30 11:00:00	IWM	ETF	65.105	65.105	64.945	64.975	1487000.0
2004-12-30 12:00:00	IWM	ETF	64.975	65.025	64.955	65.005	913800.0
2004-12-30 13:00:00	IWM	ETF	65.005	65.055	64.995	65.03	1009600.0
2004-12-30 14:00:00	IWM	ETF	65.045	65.06	64.99	65.035	1000800.0
2004-12-30 15:00:00	IWM	ETF	65.035	65.145	64.945	64.95	1265200.0
2004-12-30 16:00:00	IWM	ETF	64.94	65.035	64.79	64.85	439000.0
2004-12-30 17:00:00	IWM	ETF	64.935	64.935	64.935	64.935	200.0
2004-12-30 18:00:00	IWM	ETF	64.915	64.915	64.915	64.915	2800.0
2004-12-30 19:00:00	IWM	ETF	64.915	64.915	64.915	64.915	200.0
2004-12-30 08:00:00	DIA	ETF	108.23	108.32	108.23	108.3	2600.0
2004-12-30 09:00:00	DIA	ETF	108.25	108.41	108.17	108.29	520800.0
2004-12-30 10:00:00	DIA	ETF	108.29	108.37	108.19	108.24	462300.0
2004-12-30 11:00:00	DIA	ETF	108.24	108.26	108.15	108.2	135000.0
2004-12-30 12:00:00	DIA	ETF	108.2	108.22	108.16	108.19	205000.0
2004-12-30 13:00:00	DIA	ETF	108.19	108.27	108.17	108.25	202500.0
2004-12-30 14:00:00	DIA	ETF	108.25	108.29	108.2	108.21	376200.0
2004-12-30 15:00:00	DIA	ETF	108.21	108.23	107.94	107.94	757200.0
2004-12-30 16:00:00	DIA	ETF	107.93	108.0	107.77	107.91	108500.0
2004-12-30 09:00:00	GLD	ETF	43.5	43.61	43.49	43.58	437900.0
2004-12-30 10:00:00	GLD	ETF	43.56	43.85	43.55	43.83	256300.0
2004-12-30 11:00:00	GLD	ETF	43.83	43.87	43.75	43.79	129500.0
2004-12-30 12:00:00	GLD	ETF	43.78	43.8	43.7	43.75	52000.0
2004-12-30 13:00:00	GLD	ETF	43.76	43.83	43.76	43.83	62700.0
2004-12-30 14:00:00	GLD	ETF	43.82	43.88	43.75	43.78	56700.0

> showing 50 of 779 rows — these rows as CSV

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