PREVIEW / etf_1hour / 2004-01-16

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-01-16.parquet
  size:    23 KB
  rows:    651

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-16 08:00:00	SPY	ETF	113.97	114.17	113.91	114.14	22500.0
2004-01-16 09:00:00	SPY	ETF	114.12	114.19	113.78	113.8	5242100.0
2004-01-16 10:00:00	SPY	ETF	113.8	114.12	113.63	113.75	7139600.0
2004-01-16 11:00:00	SPY	ETF	113.76	113.96	113.66	113.93	3464500.0
2004-01-16 12:00:00	SPY	ETF	113.93	114.04	113.83	114.01	1505900.0
2004-01-16 13:00:00	SPY	ETF	113.99	114.11	113.91	114.01	2265300.0
2004-01-16 14:00:00	SPY	ETF	114.01	114.31	113.87	114.04	3132300.0
2004-01-16 15:00:00	SPY	ETF	114.04	114.27	114.01	114.25	3173700.0
2004-01-16 16:00:00	SPY	ETF	114.24	114.31	114.04	114.04	2161900.0
2004-01-16 17:00:00	SPY	ETF	114.05	114.16	113.92	114.15	17300.0
2004-01-16 18:00:00	SPY	ETF	114.14	114.16	114.14	114.16	2200.0
2004-01-16 19:00:00	SPY	ETF	114.11	114.17	114.11	114.17	200.0
2004-01-16 08:00:00	QQQ	ETF	38.38	38.42	38.34	38.39	61000.0
2004-01-16 09:00:00	QQQ	ETF	38.38	38.47	38.24	38.24	12236800.0
2004-01-16 10:00:00	QQQ	ETF	38.24	38.446	38.18	38.27	14606200.0
2004-01-16 11:00:00	QQQ	ETF	38.28	38.4	38.23	38.36	6288400.0
2004-01-16 12:00:00	QQQ	ETF	38.35	38.44	38.307	38.4	5255300.0
2004-01-16 13:00:00	QQQ	ETF	38.39	38.48	38.35	38.42	6466000.0
2004-01-16 14:00:00	QQQ	ETF	38.43	38.57	38.37	38.45	12417000.0
2004-01-16 15:00:00	QQQ	ETF	38.45	38.63	38.41	38.57	12557200.0
2004-01-16 16:00:00	QQQ	ETF	38.57	38.64	38.523	38.56	4834900.0
2004-01-16 17:00:00	QQQ	ETF	38.56	38.64	38.52	38.54	113300.0
2004-01-16 18:00:00	QQQ	ETF	38.539	38.6	38.539	38.59	9300.0
2004-01-16 19:00:00	QQQ	ETF	38.59	38.6	38.53	38.59	15900.0
2004-01-16 09:00:00	IWM	ETF	58.835	58.935	58.605	58.705	939400.0
2004-01-16 10:00:00	IWM	ETF	58.625	58.795	58.56	58.65	1065800.0
2004-01-16 11:00:00	IWM	ETF	58.65	58.8	58.605	58.77	693000.0
2004-01-16 12:00:00	IWM	ETF	58.775	58.88	58.741	58.83	137600.0
2004-01-16 13:00:00	IWM	ETF	58.84	58.88	58.8	58.825	132200.0
2004-01-16 14:00:00	IWM	ETF	58.825	59.06	58.81	58.83	626800.0
2004-01-16 15:00:00	IWM	ETF	58.82	58.98	58.765	58.769	2244200.0
2004-01-16 16:00:00	IWM	ETF	58.7735	59.21	58.7	58.875	548000.0
2004-01-16 17:00:00	IWM	ETF	58.87	58.87	58.705	58.705	5000.0
2004-01-16 08:00:00	DIA	ETF	106.09	106.2	106.02	106.19	10000.0
2004-01-16 09:00:00	DIA	ETF	106.17	106.17	105.72	105.75	1246600.0
2004-01-16 10:00:00	DIA	ETF	105.75	106.0	105.51	105.65	1683900.0
2004-01-16 11:00:00	DIA	ETF	105.654	105.82	105.56	105.77	673700.0
2004-01-16 12:00:00	DIA	ETF	105.77	105.9	105.7	105.83	950300.0
2004-01-16 13:00:00	DIA	ETF	105.82	105.93	105.7	105.78	309100.0
2004-01-16 14:00:00	DIA	ETF	105.75	106.03	105.69	105.77	1365500.0
2004-01-16 15:00:00	DIA	ETF	105.76	106.09	105.76	106.09	1562100.0
2004-01-16 16:00:00	DIA	ETF	106.1	106.16	106.03	106.1	701900.0
2004-01-16 17:00:00	DIA	ETF	106.1	106.12	106.07	106.08	11100.0
2004-01-16 18:00:00	DIA	ETF	106.14	106.14	106.14	106.14	100.0
2004-01-16 19:00:00	DIA	ETF	106.14	106.14	106.14	106.14	200.0
2004-01-16 09:00:00	TLT	ETF	88.73	88.8	88.3	88.5	158600.0
2004-01-16 10:00:00	TLT	ETF	88.52	88.68	88.15	88.21	213500.0
2004-01-16 11:00:00	TLT	ETF	88.27	88.38	88.0	88.01	112300.0
2004-01-16 12:00:00	TLT	ETF	88.0	88.0	87.76	88.0	110400.0
2004-01-16 13:00:00	TLT	ETF	88.0	88.0	87.88	87.92	47000.0

> showing 50 of 651 rows — these rows as CSV

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