PREVIEW / etf_1hour / 2004-10-21

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-10-21.parquet
  size:    26 KB
  rows:    743

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-10-21 08:00:00	SPY	ETF	110.53	110.86	110.46	110.84	439700.0
2004-10-21 09:00:00	SPY	ETF	110.86	110.99	110.58	110.87	5286000.0
2004-10-21 10:00:00	SPY	ETF	110.88	111.22	110.54	111.18	6979800.0
2004-10-21 11:00:00	SPY	ETF	111.17	111.29	110.95	111.01	5326200.0
2004-10-21 12:00:00	SPY	ETF	110.99	111.16	110.32	110.49	8830600.0
2004-10-21 13:00:00	SPY	ETF	110.49	110.6	110.21	110.35	3372900.0
2004-10-21 14:00:00	SPY	ETF	110.36	111.17	110.36	111.12	7318200.0
2004-10-21 15:00:00	SPY	ETF	111.12	111.32	110.94	111.04	9119700.0
2004-10-21 16:00:00	SPY	ETF	111.06	111.24	110.75	110.99	4371900.0
2004-10-21 17:00:00	SPY	ETF	110.92	111.0	110.87	110.99	39700.0
2004-10-21 18:00:00	SPY	ETF	110.98	111.0	110.96	110.98	13800.0
2004-10-21 19:00:00	SPY	ETF	111.04	111.08	111.04	111.08	13900.0
2004-10-21 08:00:00	QQQ	ETF	36.11	36.33	36.11	36.31	310900.0
2004-10-21 09:00:00	QQQ	ETF	36.32	36.34	36.15	36.25	12985500.0
2004-10-21 10:00:00	QQQ	ETF	36.25	36.411	36.11	36.4	19477800.0
2004-10-21 11:00:00	QQQ	ETF	36.4	36.46	36.28	36.31	10882400.0
2004-10-21 12:00:00	QQQ	ETF	36.3	36.4	36.16	36.23	16336400.0
2004-10-21 13:00:00	QQQ	ETF	36.233	36.3	36.15	36.236	8194700.0
2004-10-21 14:00:00	QQQ	ETF	36.24	36.64	36.24	36.64	21812900.0
2004-10-21 15:00:00	QQQ	ETF	36.64	36.77	36.56	36.64	20270800.0
2004-10-21 16:00:00	QQQ	ETF	36.63	36.68	36.34	36.46	8475200.0
2004-10-21 17:00:00	QQQ	ETF	36.46	36.52	36.4	36.52	1019700.0
2004-10-21 18:00:00	QQQ	ETF	36.479	36.6	36.479	36.58	597700.0
2004-10-21 19:00:00	QQQ	ETF	36.54	36.58	36.54	36.58	2300.0
2004-10-21 08:00:00	IWM	ETF	56.86	56.9	56.86	56.9	18000.0
2004-10-21 09:00:00	IWM	ETF	56.835	56.9	56.565	56.8	876800.0
2004-10-21 10:00:00	IWM	ETF	56.79	57.2	56.64	57.175	2030000.0
2004-10-21 11:00:00	IWM	ETF	57.2	57.3	57.115	57.135	1666200.0
2004-10-21 12:00:00	IWM	ETF	57.14	57.2	56.93	57.02	1696000.0
2004-10-21 13:00:00	IWM	ETF	57.025	57.1	56.94	57.025	751000.0
2004-10-21 14:00:00	IWM	ETF	57.04	57.45	57.04	57.45	904600.0
2004-10-21 15:00:00	IWM	ETF	57.46	57.575	57.42	57.5	1794000.0
2004-10-21 16:00:00	IWM	ETF	57.49	57.535	57.36	57.39	306800.0
2004-10-21 17:00:00	IWM	ETF	57.43	57.855	57.38	57.48	38200.0
2004-10-21 18:00:00	IWM	ETF	57.47	57.48	57.47	57.48	2600.0
2004-10-21 08:00:00	DIA	ETF	98.75	99.19	98.69	99.18	32700.0
2004-10-21 09:00:00	DIA	ETF	99.19	99.2	98.66	98.92	2274700.0
2004-10-21 10:00:00	DIA	ETF	98.91	99.2	98.6	99.2	1345300.0
2004-10-21 11:00:00	DIA	ETF	99.15	99.25	98.95	99.0	887700.0
2004-10-21 12:00:00	DIA	ETF	99.0	99.13	98.29	98.43	1701300.0
2004-10-21 13:00:00	DIA	ETF	98.42	98.55	98.2	98.33	1412200.0
2004-10-21 14:00:00	DIA	ETF	98.34	99.03	98.34	98.93	1934800.0
2004-10-21 15:00:00	DIA	ETF	98.95	99.1	98.72	98.79	1430200.0
2004-10-21 16:00:00	DIA	ETF	98.76	98.97	98.65	98.84	1130900.0
2004-10-21 17:00:00	DIA	ETF	98.86	98.86	98.7	98.85	1200.0
2004-10-21 18:00:00	DIA	ETF	98.86	98.88	98.7	98.8	4500.0
2004-10-21 08:00:00	TLT	ETF	89.75	89.82	89.58	89.61	17400.0
2004-10-21 09:00:00	TLT	ETF	89.4	89.56	89.4	89.52	485000.0
2004-10-21 10:00:00	TLT	ETF	89.55	89.75	89.51	89.62	70200.0
2004-10-21 11:00:00	TLT	ETF	89.62	89.78	89.59	89.73	436200.0

> showing 50 of 743 rows — these rows as CSV

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