PREVIEW / etf_1hour / 2004-01-06

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-01-06.parquet
  size:    24 KB
  rows:    649

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-01-06 08:00:00	SPY	ETF	112.25	112.29	112.15	112.17	28000.0
2004-01-06 09:00:00	SPY	ETF	112.22	112.33	112.1	112.33	2662800.0
2004-01-06 10:00:00	SPY	ETF	112.31	112.43	112.1	112.4	4999200.0
2004-01-06 11:00:00	SPY	ETF	112.4	112.46	112.23	112.26	1655400.0
2004-01-06 12:00:00	SPY	ETF	112.25	112.49	112.17	112.34	1409900.0
2004-01-06 13:00:00	SPY	ETF	112.34	112.49	112.22	112.37	1504300.0
2004-01-06 14:00:00	SPY	ETF	112.38	112.6	112.28	112.51	2731800.0
2004-01-06 15:00:00	SPY	ETF	112.52	112.73	112.5	112.62	3141500.0
2004-01-06 16:00:00	SPY	ETF	112.63	112.66	112.362	112.6	1882300.0
2004-01-06 17:00:00	SPY	ETF	112.6	112.62	112.57	112.62	17400.0
2004-01-06 18:00:00	SPY	ETF	112.59	112.61	112.55	112.55	18800.0
2004-01-06 19:00:00	SPY	ETF	112.55	112.6	112.54	112.55	2400.0
2004-01-06 08:00:00	QQQ	ETF	37.11	37.13	37.06	37.08	43700.0
2004-01-06 09:00:00	QQQ	ETF	37.08	37.16	37.05	37.104	5685200.0
2004-01-06 10:00:00	QQQ	ETF	37.11	37.19	36.95	37.18	9825700.0
2004-01-06 11:00:00	QQQ	ETF	37.18	37.21	37.07	37.104	6181400.0
2004-01-06 12:00:00	QQQ	ETF	37.106	37.25	37.07	37.15	8626400.0
2004-01-06 13:00:00	QQQ	ETF	37.151	37.242	37.08	37.235	6556200.0
2004-01-06 14:00:00	QQQ	ETF	37.24	37.32	37.16	37.28	8436700.0
2004-01-06 15:00:00	QQQ	ETF	37.28	37.42	37.27	37.33	10216600.0
2004-01-06 16:00:00	QQQ	ETF	37.32	37.35	37.295	37.33	2053400.0
2004-01-06 17:00:00	QQQ	ETF	37.333	37.34	37.31	37.34	27700.0
2004-01-06 18:00:00	QQQ	ETF	37.34	37.34	37.33	37.34	31700.0
2004-01-06 19:00:00	QQQ	ETF	37.32	37.34	37.32	37.34	6500.0
2004-01-06 09:00:00	IWM	ETF	56.685	56.8	56.56	56.71	797200.0
2004-01-06 10:00:00	IWM	ETF	56.71	56.95	56.5	56.95	1468800.0
2004-01-06 11:00:00	IWM	ETF	56.965	56.9975	56.7	56.74	1597800.0
2004-01-06 12:00:00	IWM	ETF	56.7	56.875	56.675	56.715	649200.0
2004-01-06 13:00:00	IWM	ETF	56.745	56.925	56.745	56.885	478200.0
2004-01-06 14:00:00	IWM	ETF	56.895	56.96	56.78	56.95	266400.0
2004-01-06 15:00:00	IWM	ETF	56.93	57.065	56.76	56.76	573800.0
2004-01-06 16:00:00	IWM	ETF	56.7935	56.7935	56.575	56.6565	190000.0
2004-01-06 08:00:00	DIA	ETF	105.43	105.45	105.32	105.34	4600.0
2004-01-06 09:00:00	DIA	ETF	105.4	105.417	105.2	105.39	1617300.0
2004-01-06 10:00:00	DIA	ETF	105.35	105.411	105.17	105.38	1911500.0
2004-01-06 11:00:00	DIA	ETF	105.38	105.43	105.18	105.2	1110000.0
2004-01-06 12:00:00	DIA	ETF	105.2	105.4	105.14	105.31	392000.0
2004-01-06 13:00:00	DIA	ETF	105.31	105.449	105.2	105.35	483400.0
2004-01-06 14:00:00	DIA	ETF	105.35	105.56	105.27	105.5	741200.0
2004-01-06 15:00:00	DIA	ETF	105.49	105.66	105.45	105.52	1037800.0
2004-01-06 16:00:00	DIA	ETF	105.58	105.599	105.48	105.551	259700.0
2004-01-06 17:00:00	DIA	ETF	105.54	105.54	105.54	105.54	200.0
2004-01-06 19:00:00	DIA	ETF	105.5	105.5	105.5	105.5	100.0
2004-01-06 09:00:00	TLT	ETF	84.54	84.64	84.5	84.54	216100.0
2004-01-06 10:00:00	TLT	ETF	84.6	85.07	84.6	85.02	144900.0
2004-01-06 11:00:00	TLT	ETF	84.94	85.13	84.9	85.12	60600.0
2004-01-06 12:00:00	TLT	ETF	85.08	85.34	85.01	85.32	71000.0
2004-01-06 13:00:00	TLT	ETF	85.34	85.39	85.15	85.21	94800.0
2004-01-06 14:00:00	TLT	ETF	85.2	85.26	85.08	85.12	61100.0
2004-01-06 15:00:00	TLT	ETF	85.22	85.25	85.1	85.14	23500.0

> showing 50 of 649 rows — these rows as CSV

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