PREVIEW / etf_1hour / 2004-09-10

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-09-10.parquet
  size:    24 KB
  rows:    661

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-09-10 08:00:00	SPY	ETF	112.43	112.65	112.4	112.54	107400.0
2004-09-10 09:00:00	SPY	ETF	112.54	112.56	112.09	112.29	4137500.0
2004-09-10 10:00:00	SPY	ETF	112.28	112.67	112.18	112.3	4819100.0
2004-09-10 11:00:00	SPY	ETF	112.32	112.62	112.23	112.49	2264400.0
2004-09-10 12:00:00	SPY	ETF	112.48	112.61	112.42	112.51	1379000.0
2004-09-10 13:00:00	SPY	ETF	112.51	112.74	112.46	112.54	2448600.0
2004-09-10 14:00:00	SPY	ETF	112.54	113.09	112.49	113.0	5369300.0
2004-09-10 15:00:00	SPY	ETF	113.0	113.27	112.97	113.0908	5318200.0
2004-09-10 16:00:00	SPY	ETF	113.1	113.17	113.02	113.02	1166700.0
2004-09-10 17:00:00	SPY	ETF	113.03	113.14	113.01	113.09	12600.0
2004-09-10 18:00:00	SPY	ETF	113.18	113.18	113.1	113.16	1000.0
2004-09-10 19:00:00	SPY	ETF	113.06	113.06	113.06	113.06	200.0
2004-09-10 08:00:00	QQQ	ETF	34.6	34.69	34.57	34.6	461900.0
2004-09-10 09:00:00	QQQ	ETF	34.6	34.719	34.48	34.67	13149800.0
2004-09-10 10:00:00	QQQ	ETF	34.67	34.9	34.609	34.764	24674800.0
2004-09-10 11:00:00	QQQ	ETF	34.764	34.88	34.73	34.8	8389200.0
2004-09-10 12:00:00	QQQ	ETF	34.79	34.88	34.77	34.82	8365400.0
2004-09-10 13:00:00	QQQ	ETF	34.82	34.92	34.78	34.799	7091700.0
2004-09-10 14:00:00	QQQ	ETF	34.79	35.1	34.78	35.05	18208100.0
2004-09-10 15:00:00	QQQ	ETF	35.04	35.19	35.03	35.127	17402200.0
2004-09-10 16:00:00	QQQ	ETF	35.121	35.175	35.08	35.13	5861000.0
2004-09-10 17:00:00	QQQ	ETF	35.13	35.15	35.11	35.14	63800.0
2004-09-10 18:00:00	QQQ	ETF	35.12	35.12	35.11	35.12	16700.0
2004-09-10 19:00:00	QQQ	ETF	35.12	35.15	35.12	35.15	18600.0
2004-09-10 08:00:00	IWM	ETF	56.56	56.56	56.56	56.56	1000.0
2004-09-10 09:00:00	IWM	ETF	56.575	56.575	56.075	56.32	1241800.0
2004-09-10 10:00:00	IWM	ETF	56.3	56.75	56.24	56.535	3964600.0
2004-09-10 11:00:00	IWM	ETF	56.535	56.7	56.47	56.59	880000.0
2004-09-10 12:00:00	IWM	ETF	56.585	56.73	56.565	56.67	593000.0
2004-09-10 13:00:00	IWM	ETF	56.675	56.815	56.59	56.595	908800.0
2004-09-10 14:00:00	IWM	ETF	56.6	56.925	56.595	56.84	1048400.0
2004-09-10 15:00:00	IWM	ETF	56.85	56.96	56.78	56.89	1787600.0
2004-09-10 16:00:00	IWM	ETF	56.875	56.92	56.835	56.86	631000.0
2004-09-10 08:00:00	DIA	ETF	102.9	103.04	102.9	102.98	15800.0
2004-09-10 09:00:00	DIA	ETF	102.98	102.98	102.57	102.64	411600.0
2004-09-10 10:00:00	DIA	ETF	102.63	102.89	102.56	102.66	658200.0
2004-09-10 11:00:00	DIA	ETF	102.65	102.86	102.56	102.75	445200.0
2004-09-10 12:00:00	DIA	ETF	102.76	102.82	102.72	102.73	173100.0
2004-09-10 13:00:00	DIA	ETF	102.73	102.89	102.69	102.72	174700.0
2004-09-10 14:00:00	DIA	ETF	102.71	103.23	102.7	103.15	768800.0
2004-09-10 15:00:00	DIA	ETF	103.15	103.38	103.12	103.28	878000.0
2004-09-10 16:00:00	DIA	ETF	103.28	103.33	103.15	103.15	63300.0
2004-09-10 17:00:00	DIA	ETF	103.24	103.24	103.24	103.24	3000.0
2004-09-10 08:00:00	TLT	ETF	87.02	87.55	87.02	87.55	5200.0
2004-09-10 09:00:00	TLT	ETF	87.38	87.53	87.33	87.38	258400.0
2004-09-10 10:00:00	TLT	ETF	87.35	87.38	87.19	87.33	294700.0
2004-09-10 11:00:00	TLT	ETF	87.35	87.4	87.06	87.22	33300.0
2004-09-10 12:00:00	TLT	ETF	87.26	87.31	87.25	87.26	7800.0
2004-09-10 13:00:00	TLT	ETF	87.26	87.41	87.24	87.35	21800.0
2004-09-10 14:00:00	TLT	ETF	87.35	87.35	87.16	87.17	26800.0

> showing 50 of 661 rows — these rows as CSV

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