PREVIEW / etf_1hour / 2004-01-21

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-01-21.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-21 08:00:00	SPY	ETF	114.21	114.27	114.09	114.16	14800.0
2004-01-21 09:00:00	SPY	ETF	114.17	114.2	113.83	114.02	2245200.0
2004-01-21 10:00:00	SPY	ETF	114.02	114.1	113.72	113.93	4767600.0
2004-01-21 11:00:00	SPY	ETF	113.92	114.28	113.85	114.16	2665600.0
2004-01-21 12:00:00	SPY	ETF	114.14	114.56	114.1	114.53	3165800.0
2004-01-21 13:00:00	SPY	ETF	114.52	114.83	114.36	114.78	3662700.0
2004-01-21 14:00:00	SPY	ETF	114.78	115.2	114.72	115.12	3325200.0
2004-01-21 15:00:00	SPY	ETF	115.1	115.3	114.78	115.07	6357100.0
2004-01-21 16:00:00	SPY	ETF	115.06	115.18	114.95	115.18	1226300.0
2004-01-21 17:00:00	SPY	ETF	115.18	115.21	115.11	115.2	7700.0
2004-01-21 18:00:00	SPY	ETF	115.2	115.22	115.13	115.13	17700.0
2004-01-21 19:00:00	SPY	ETF	115.12	115.12	115.1	115.12	1400.0
2004-01-21 08:00:00	QQQ	ETF	38.41	38.44	38.35	38.39	141000.0
2004-01-21 09:00:00	QQQ	ETF	38.39	38.42	38.18	38.26	12794400.0
2004-01-21 10:00:00	QQQ	ETF	38.24	38.25	38.0	38.11	16806100.0
2004-01-21 11:00:00	QQQ	ETF	38.113	38.25	38.04	38.14	11394600.0
2004-01-21 12:00:00	QQQ	ETF	38.14	38.295	38.1	38.26	8417100.0
2004-01-21 13:00:00	QQQ	ETF	38.27	38.36	38.16	38.32	9314900.0
2004-01-21 14:00:00	QQQ	ETF	38.32	38.66	38.29	38.539	16900600.0
2004-01-21 15:00:00	QQQ	ETF	38.56	38.65	38.3	38.411	21191700.0
2004-01-21 16:00:00	QQQ	ETF	38.4	38.55	38.314	38.52	5793900.0
2004-01-21 17:00:00	QQQ	ETF	38.53	38.57	38.52	38.53	547700.0
2004-01-21 18:00:00	QQQ	ETF	38.55	38.56	38.52	38.52	39200.0
2004-01-21 19:00:00	QQQ	ETF	38.52	38.56	38.51	38.52	22100.0
2004-01-21 09:00:00	IWM	ETF	59.45	59.45	59.055	59.1065	1372400.0
2004-01-21 10:00:00	IWM	ETF	59.12	59.135	58.855	59.09	1048200.0
2004-01-21 11:00:00	IWM	ETF	59.075	59.225	59.0	59.175	676000.0
2004-01-21 12:00:00	IWM	ETF	59.175	59.405	59.15	59.375	639000.0
2004-01-21 13:00:00	IWM	ETF	59.375	59.475	59.25	59.46	693200.0
2004-01-21 14:00:00	IWM	ETF	59.45	59.685	59.443	59.595	617600.0
2004-01-21 15:00:00	IWM	ETF	59.565	59.6805	59.255	59.35	1591000.0
2004-01-21 16:00:00	IWM	ETF	59.33	59.515	59.33	59.35	163800.0
2004-01-21 08:00:00	DIA	ETF	105.51	105.61	105.49	105.54	3500.0
2004-01-21 09:00:00	DIA	ETF	105.56	105.56	105.131	105.36	1517100.0
2004-01-21 10:00:00	DIA	ETF	105.36	105.46	105.03	105.34	1020000.0
2004-01-21 11:00:00	DIA	ETF	105.29	105.61	105.23	105.52	843100.0
2004-01-21 12:00:00	DIA	ETF	105.51	105.96	105.47	105.93	828900.0
2004-01-21 13:00:00	DIA	ETF	105.9	106.3	105.8	106.22	1683000.0
2004-01-21 14:00:00	DIA	ETF	106.24	106.55	106.12	106.49	778900.0
2004-01-21 15:00:00	DIA	ETF	106.48	106.64	106.17	106.352	2098300.0
2004-01-21 16:00:00	DIA	ETF	106.352	106.425	106.3	106.415	168400.0
2004-01-21 17:00:00	DIA	ETF	106.47	106.5	106.45	106.5	2300.0
2004-01-21 18:00:00	DIA	ETF	106.5	106.58	106.5	106.54	12400.0
2004-01-21 09:00:00	TLT	ETF	87.75	87.8	87.6	87.65	45100.0
2004-01-21 10:00:00	TLT	ETF	87.6	87.75	87.44	87.59	149700.0
2004-01-21 11:00:00	TLT	ETF	87.53	87.59	87.49	87.52	243000.0
2004-01-21 12:00:00	TLT	ETF	87.52	87.64	87.48	87.61	26700.0
2004-01-21 13:00:00	TLT	ETF	87.6	87.7	87.59	87.7	66700.0
2004-01-21 14:00:00	TLT	ETF	87.67	87.77	87.65	87.68	13200.0
2004-01-21 15:00:00	TLT	ETF	87.75	87.81	87.69	87.81	21400.0

> showing 50 of 649 rows — these rows as CSV

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