PREVIEW / etf_1hour / 2004-04-20

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-04-20.parquet
  size:    26 KB
  rows:    717

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-04-20 08:00:00	SPY	ETF	114.15	114.3	114.14	114.19	77500.0
2004-04-20 09:00:00	SPY	ETF	114.2	114.28	113.96	114.25	4725400.0
2004-04-20 10:00:00	SPY	ETF	114.27	114.32	113.9	113.95	5691800.0
2004-04-20 11:00:00	SPY	ETF	113.94	113.99	113.67	113.67	3827600.0
2004-04-20 12:00:00	SPY	ETF	113.68	113.9	113.65	113.78	2084700.0
2004-04-20 13:00:00	SPY	ETF	113.78	113.98	113.71	113.93	1538300.0
2004-04-20 14:00:00	SPY	ETF	113.93	113.96	113.24	113.25	7502400.0
2004-04-20 15:00:00	SPY	ETF	113.25	113.45	112.11	112.13	18505700.0
2004-04-20 16:00:00	SPY	ETF	112.14	112.2	111.78	112.15	4671100.0
2004-04-20 17:00:00	SPY	ETF	112.15	112.2	111.8662	112.11	1153800.0
2004-04-20 18:00:00	SPY	ETF	112.12	112.15	112.09	112.09	25800.0
2004-04-20 19:00:00	SPY	ETF	112.14	112.16	112.09	112.09	11100.0
2004-04-20 08:00:00	QQQ	ETF	36.66	36.68	36.64	36.64	458100.0
2004-04-20 09:00:00	QQQ	ETF	36.64	36.76	36.56	36.74	13917100.0
2004-04-20 10:00:00	QQQ	ETF	36.736	36.79	36.63	36.643	14981400.0
2004-04-20 11:00:00	QQQ	ETF	36.644	36.67	36.47	36.474	11759700.0
2004-04-20 12:00:00	QQQ	ETF	36.475	36.53	36.41	36.45	10583200.0
2004-04-20 13:00:00	QQQ	ETF	36.449	36.58	36.393	36.57	5814300.0
2004-04-20 14:00:00	QQQ	ETF	36.57	36.58	36.177	36.22	16622400.0
2004-04-20 15:00:00	QQQ	ETF	36.217	36.271	35.73	35.75	31820600.0
2004-04-20 16:00:00	QQQ	ETF	35.75	35.88	35.63	35.88	7988000.0
2004-04-20 17:00:00	QQQ	ETF	35.85	35.93	35.84	35.87	378200.0
2004-04-20 18:00:00	QQQ	ETF	35.87	35.95	35.83	35.95	220300.0
2004-04-20 19:00:00	QQQ	ETF	35.95	35.96	35.88	35.88	152700.0
2004-04-20 09:00:00	IWM	ETF	58.665	59.045	58.665	59.02	3207400.0
2004-04-20 10:00:00	IWM	ETF	59.02	59.115	58.815	58.815	1337200.0
2004-04-20 11:00:00	IWM	ETF	58.83	58.84	58.57	58.585	1772800.0
2004-04-20 12:00:00	IWM	ETF	58.585	58.72	58.575	58.645	1064400.0
2004-04-20 13:00:00	IWM	ETF	58.645	58.74	58.6	58.725	693200.0
2004-04-20 14:00:00	IWM	ETF	58.725	58.725	57.955	57.955	1531400.0
2004-04-20 15:00:00	IWM	ETF	57.94	58.1	57.28	57.29	5134800.0
2004-04-20 16:00:00	IWM	ETF	57.33	57.38	57.135	57.35	866000.0
2004-04-20 17:00:00	IWM	ETF	57.325	57.35	57.265	57.265	363200.0
2004-04-20 18:00:00	IWM	ETF	57.35	57.35	57.34	57.35	6200.0
2004-04-20 19:00:00	IWM	ETF	57.345	57.345	57.345	57.345	1000.0
2004-04-20 08:00:00	DIA	ETF	104.83	104.86	104.8	104.82	14800.0
2004-04-20 09:00:00	DIA	ETF	104.77	104.96	104.68	104.92	604100.0
2004-04-20 10:00:00	DIA	ETF	104.93	104.99	104.62	104.69	657500.0
2004-04-20 11:00:00	DIA	ETF	104.63	104.69	104.49	104.5	834900.0
2004-04-20 12:00:00	DIA	ETF	104.52	104.7	104.5	104.64	159000.0
2004-04-20 13:00:00	DIA	ETF	104.63	104.78	104.58	104.75	551200.0
2004-04-20 14:00:00	DIA	ETF	104.75	104.76	104.17	104.22	775200.0
2004-04-20 15:00:00	DIA	ETF	104.22	104.4	103.24	103.24	1823500.0
2004-04-20 16:00:00	DIA	ETF	103.24	103.28	102.85	103.19	266200.0
2004-04-20 17:00:00	DIA	ETF	103.29	103.29	103.12	103.15	14200.0
2004-04-20 18:00:00	DIA	ETF	103.18	103.18	103.17	103.17	300.0
2004-04-20 19:00:00	DIA	ETF	103.22	103.24	103.17	103.17	1300.0
2004-04-20 08:00:00	TLT	ETF	84.26	84.26	84.26	84.26	100.0
2004-04-20 09:00:00	TLT	ETF	84.27	84.27	84.13	84.13	190800.0
2004-04-20 10:00:00	TLT	ETF	84.12	84.22	84.12	84.15	150200.0

> showing 50 of 717 rows — these rows as CSV

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