PREVIEW / etf_1hour / 2004-07-13

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-07-13.parquet
  size:    23 KB
  rows:    650

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-13 08:00:00	SPY	ETF	111.89	111.96	111.84	111.94	17700.0
2004-07-13 09:00:00	SPY	ETF	111.95	112.0	111.83	111.97	2510500.0
2004-07-13 10:00:00	SPY	ETF	111.96	112.02	111.74	111.8	3716600.0
2004-07-13 11:00:00	SPY	ETF	111.8	111.87	111.65	111.7	2642100.0
2004-07-13 12:00:00	SPY	ETF	111.71	111.95	111.63	111.89	2816200.0
2004-07-13 13:00:00	SPY	ETF	111.89	111.93	111.66	111.86	3566100.0
2004-07-13 14:00:00	SPY	ETF	111.86	112.0	111.79	111.84	2650000.0
2004-07-13 15:00:00	SPY	ETF	111.85	112.0	111.82	111.89	3551200.0
2004-07-13 16:00:00	SPY	ETF	111.89	112.15	111.34	111.45	2412300.0
2004-07-13 17:00:00	SPY	ETF	111.45	111.52	111.4	111.48	92700.0
2004-07-13 18:00:00	SPY	ETF	111.48	111.48	111.45	111.45	2300.0
2004-07-13 19:00:00	SPY	ETF	111.52	111.53	111.51	111.51	1700.0
2004-07-13 08:00:00	QQQ	ETF	35.65	35.72	35.65	35.71	101500.0
2004-07-13 09:00:00	QQQ	ETF	35.71	35.81	35.67	35.78	7235900.0
2004-07-13 10:00:00	QQQ	ETF	35.78	35.796	35.62	35.65	9910000.0
2004-07-13 11:00:00	QQQ	ETF	35.649	35.67	35.52	35.55	6948800.0
2004-07-13 12:00:00	QQQ	ETF	35.561	35.7	35.51	35.651	5522600.0
2004-07-13 13:00:00	QQQ	ETF	35.654	35.673	35.43	35.541	12584100.0
2004-07-13 14:00:00	QQQ	ETF	35.54	35.64	35.49	35.51	10014600.0
2004-07-13 15:00:00	QQQ	ETF	35.52	35.58	35.46	35.53	12423700.0
2004-07-13 16:00:00	QQQ	ETF	35.539	35.8	35.19	35.284	7130300.0
2004-07-13 17:00:00	QQQ	ETF	35.28	35.29	35.247	35.28	1048500.0
2004-07-13 18:00:00	QQQ	ETF	35.27	35.3	35.25	35.3	117900.0
2004-07-13 19:00:00	QQQ	ETF	35.28	35.33	35.28	35.3	8400.0
2004-07-13 09:00:00	IWM	ETF	56.175	56.35	56.135	56.295	809800.0
2004-07-13 10:00:00	IWM	ETF	56.305	56.39	56.165	56.25	1493400.0
2004-07-13 11:00:00	IWM	ETF	56.26	56.295	56.045	56.095	915200.0
2004-07-13 12:00:00	IWM	ETF	56.095	56.22	56.05	56.185	553200.0
2004-07-13 13:00:00	IWM	ETF	56.2	56.22	56.045	56.165	300400.0
2004-07-13 14:00:00	IWM	ETF	56.165	56.31	56.095	56.115	506600.0
2004-07-13 15:00:00	IWM	ETF	56.115	56.185	56.04	56.08	1106800.0
2004-07-13 16:00:00	IWM	ETF	56.08	56.16	55.775	55.8	682000.0
2004-07-13 17:00:00	IWM	ETF	55.795	55.795	55.775	55.775	7000.0
2004-07-13 08:00:00	DIA	ETF	102.66	102.77	102.65	102.76	14200.0
2004-07-13 09:00:00	DIA	ETF	102.75	102.79	102.64	102.72	168500.0
2004-07-13 10:00:00	DIA	ETF	102.69	102.74	102.52	102.61	391200.0
2004-07-13 11:00:00	DIA	ETF	102.61	102.7	102.53	102.6	418700.0
2004-07-13 12:00:00	DIA	ETF	102.58	102.73	102.54	102.68	174600.0
2004-07-13 13:00:00	DIA	ETF	102.67	102.75	102.5	102.69	332800.0
2004-07-13 14:00:00	DIA	ETF	102.7	102.76	102.57	102.6	383300.0
2004-07-13 15:00:00	DIA	ETF	102.61	102.74	102.61	102.69	585000.0
2004-07-13 16:00:00	DIA	ETF	102.67	102.7	102.2	102.26	110700.0
2004-07-13 17:00:00	DIA	ETF	102.22	102.33	102.22	102.33	800.0
2004-07-13 09:00:00	TLT	ETF	84.2	84.22	84.03	84.08	13600.0
2004-07-13 10:00:00	TLT	ETF	84.08	84.18	84.07	84.13	69300.0
2004-07-13 11:00:00	TLT	ETF	84.1	84.1	83.95	84.04	55300.0
2004-07-13 12:00:00	TLT	ETF	84.02	84.13	84.02	84.07	19000.0
2004-07-13 13:00:00	TLT	ETF	84.07	84.08	84.05	84.05	26200.0
2004-07-13 14:00:00	TLT	ETF	84.07	84.27	84.07	84.23	59900.0
2004-07-13 15:00:00	TLT	ETF	84.22	84.27	84.21	84.25	12900.0

> showing 50 of 650 rows — these rows as CSV

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