PREVIEW / etf_1hour / 2004-07-20

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-07-20.parquet
  size:    25 KB
  rows:    702

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-07-20 08:00:00	SPY	ETF	110.42	110.54	110.42	110.5	37200.0
2004-07-20 09:00:00	SPY	ETF	110.53	110.64	110.38	110.52	4160400.0
2004-07-20 10:00:00	SPY	ETF	110.53	110.75	110.25	110.74	5483900.0
2004-07-20 11:00:00	SPY	ETF	110.75	110.77	110.52	110.65	3130200.0
2004-07-20 12:00:00	SPY	ETF	110.64	110.88	110.59	110.77	4271600.0
2004-07-20 13:00:00	SPY	ETF	110.77	110.95	110.67	110.89	3973000.0
2004-07-20 14:00:00	SPY	ETF	110.89	111.31	110.75	110.88	12741400.0
2004-07-20 15:00:00	SPY	ETF	110.88	111.25	110.87	111.24	5986400.0
2004-07-20 16:00:00	SPY	ETF	111.25	111.9	111.21	111.69	2593000.0
2004-07-20 17:00:00	SPY	ETF	111.69	111.9	111.6	111.8	526300.0
2004-07-20 18:00:00	SPY	ETF	111.8	111.9	111.5	111.85	308900.0
2004-07-20 19:00:00	SPY	ETF	111.85	111.85	111.81	111.84	6700.0
2004-07-20 08:00:00	QQQ	ETF	34.72	34.78	34.72	34.76	348000.0
2004-07-20 09:00:00	QQQ	ETF	34.76	34.89	34.71	34.85	14871100.0
2004-07-20 10:00:00	QQQ	ETF	34.86	34.95	34.75	34.94	11636500.0
2004-07-20 11:00:00	QQQ	ETF	34.94	34.98	34.84	34.94	9113100.0
2004-07-20 12:00:00	QQQ	ETF	34.95	35.07	34.89	35.02	10468500.0
2004-07-20 13:00:00	QQQ	ETF	35.024	35.11	34.98	35.08	8790000.0
2004-07-20 14:00:00	QQQ	ETF	35.08	35.2	35.01	35.06	19989200.0
2004-07-20 15:00:00	QQQ	ETF	35.06	35.29	35.03	35.264	19931000.0
2004-07-20 16:00:00	QQQ	ETF	35.27	35.58	35.17	35.49	14406300.0
2004-07-20 17:00:00	QQQ	ETF	35.49	35.73	35.43	35.68	1698000.0
2004-07-20 18:00:00	QQQ	ETF	35.63	35.68	35.42	35.65	2236400.0
2004-07-20 19:00:00	QQQ	ETF	35.66	35.72	35.61	35.65	97100.0
2004-07-20 09:00:00	IWM	ETF	55.335	55.585	55.22	55.49	1345600.0
2004-07-20 10:00:00	IWM	ETF	55.47	55.57	55.295	55.57	699200.0
2004-07-20 11:00:00	IWM	ETF	55.57	55.595	55.47	55.585	1053000.0
2004-07-20 12:00:00	IWM	ETF	55.58	55.775	55.525	55.72	949200.0
2004-07-20 13:00:00	IWM	ETF	55.73	55.885	55.655	55.87	841800.0
2004-07-20 14:00:00	IWM	ETF	55.865	56.04	55.765	55.865	1634600.0
2004-07-20 15:00:00	IWM	ETF	55.89	56.295	55.885	56.275	2256200.0
2004-07-20 16:00:00	IWM	ETF	56.275	56.475	56.095	56.225	472200.0
2004-07-20 18:00:00	IWM	ETF	56.085	56.465	56.055	56.3	172000.0
2004-07-20 08:00:00	DIA	ETF	101.11	101.2	101.11	101.2	2300.0
2004-07-20 09:00:00	DIA	ETF	101.2	101.25	100.99	101.13	421200.0
2004-07-20 10:00:00	DIA	ETF	101.13	101.29	100.86	101.28	992900.0
2004-07-20 11:00:00	DIA	ETF	101.3	101.3	101.08	101.19	386800.0
2004-07-20 12:00:00	DIA	ETF	101.17	101.34	101.15	101.27	162000.0
2004-07-20 13:00:00	DIA	ETF	101.23	101.36	101.18	101.28	299900.0
2004-07-20 14:00:00	DIA	ETF	101.27	101.69	101.17	101.28	921500.0
2004-07-20 15:00:00	DIA	ETF	101.29	101.65	101.29	101.65	981200.0
2004-07-20 16:00:00	DIA	ETF	101.64	102.15	101.59	102.0	389700.0
2004-07-20 17:00:00	DIA	ETF	101.85	102.15	101.85	102.12	3200.0
2004-07-20 18:00:00	DIA	ETF	102.12	102.15	101.87	102.1	25700.0
2004-07-20 19:00:00	DIA	ETF	102.1	102.1	102.0	102.0	3300.0
2004-07-20 09:00:00	TLT	ETF	85.31	85.34	85.2	85.25	28300.0
2004-07-20 10:00:00	TLT	ETF	85.23	85.26	85.18	85.24	31000.0
2004-07-20 11:00:00	TLT	ETF	85.2	85.26	85.17	85.26	270300.0
2004-07-20 12:00:00	TLT	ETF	85.26	85.31	85.2	85.3	159100.0
2004-07-20 13:00:00	TLT	ETF	85.3	85.34	85.25	85.26	115500.0

> showing 50 of 702 rows — these rows as CSV

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