PREVIEW / etf_1hour / 2004-08-10

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-08-10.parquet
  size:    24 KB
  rows:    678

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-08-10 08:00:00	SPY	ETF	107.23	107.34	107.2	107.32	64900.0
2004-08-10 09:00:00	SPY	ETF	107.31	107.47	107.26	107.36	3978300.0
2004-08-10 10:00:00	SPY	ETF	107.35	107.78	107.33	107.77	6898600.0
2004-08-10 11:00:00	SPY	ETF	107.77	107.9	107.71	107.75	3996800.0
2004-08-10 12:00:00	SPY	ETF	107.77	107.83	107.7	107.82	2350600.0
2004-08-10 13:00:00	SPY	ETF	107.81	107.86	107.71	107.8	2879400.0
2004-08-10 14:00:00	SPY	ETF	107.81	107.95	107.35	107.84	15303600.0
2004-08-10 15:00:00	SPY	ETF	107.83	108.4	107.77	108.37	11337900.0
2004-08-10 16:00:00	SPY	ETF	108.36	108.43	107.93	108.02	5316700.0
2004-08-10 17:00:00	SPY	ETF	108.05	108.07	107.7	107.88	816900.0
2004-08-10 18:00:00	SPY	ETF	107.9	107.95	107.9	107.93	2900.0
2004-08-10 19:00:00	SPY	ETF	107.93	107.94	107.92	107.94	2000.0
2004-08-10 08:00:00	QQQ	ETF	32.94	32.96	32.93	32.95	97200.0
2004-08-10 09:00:00	QQQ	ETF	32.95	33.02	32.93	32.97	9085300.0
2004-08-10 10:00:00	QQQ	ETF	32.96	33.145	32.922	33.14	13131000.0
2004-08-10 11:00:00	QQQ	ETF	33.138	33.22	33.09	33.17	10594400.0
2004-08-10 12:00:00	QQQ	ETF	33.17	33.21	33.13	33.19	5399000.0
2004-08-10 13:00:00	QQQ	ETF	33.19	33.22	33.14	33.19	3469700.0
2004-08-10 14:00:00	QQQ	ETF	33.18	33.21	32.97	33.14	24119600.0
2004-08-10 15:00:00	QQQ	ETF	33.15	33.43	33.12	33.42	23253400.0
2004-08-10 16:00:00	QQQ	ETF	33.414	33.47	33.061	33.12	11870100.0
2004-08-10 17:00:00	QQQ	ETF	33.13	33.13	32.93	33.0	2870900.0
2004-08-10 18:00:00	QQQ	ETF	33.02	33.05	33.0	33.02	88500.0
2004-08-10 19:00:00	QQQ	ETF	33.03	33.04	33.01	33.03	32600.0
2004-08-10 08:00:00	IWM	ETF	51.83	51.83	51.83	51.83	3000.0
2004-08-10 09:00:00	IWM	ETF	51.83	52.105	51.725	52.025	1755600.0
2004-08-10 10:00:00	IWM	ETF	52.0	52.51	51.99	52.5	3205800.0
2004-08-10 11:00:00	IWM	ETF	52.505	52.62	52.385	52.46	1956600.0
2004-08-10 12:00:00	IWM	ETF	52.435	52.535	52.39	52.52	360400.0
2004-08-10 13:00:00	IWM	ETF	52.52	52.535	52.42	52.475	213600.0
2004-08-10 14:00:00	IWM	ETF	52.475	52.61	52.15	52.33	3631600.0
2004-08-10 15:00:00	IWM	ETF	52.355	52.865	52.29	52.83	4095800.0
2004-08-10 16:00:00	IWM	ETF	52.805	52.835	52.375	52.45	935600.0
2004-08-10 17:00:00	IWM	ETF	52.45	52.45	52.265	52.265	67000.0
2004-08-10 08:00:00	DIA	ETF	98.61	98.67	98.61	98.67	2200.0
2004-08-10 09:00:00	DIA	ETF	98.68	98.81	98.62	98.72	435700.0
2004-08-10 10:00:00	DIA	ETF	98.7	99.08	98.69	99.08	959200.0
2004-08-10 11:00:00	DIA	ETF	99.07	99.2	99.02	99.06	700900.0
2004-08-10 12:00:00	DIA	ETF	99.07	99.12	99.0	99.09	199200.0
2004-08-10 13:00:00	DIA	ETF	99.1	99.16	99.02	99.08	187800.0
2004-08-10 14:00:00	DIA	ETF	99.07	99.22	98.7	99.1	1960900.0
2004-08-10 15:00:00	DIA	ETF	99.1	99.68	99.06	99.65	1560400.0
2004-08-10 16:00:00	DIA	ETF	99.63	99.72	99.39	99.46	203300.0
2004-08-10 17:00:00	DIA	ETF	99.33	99.33	99.3	99.3	1200.0
2004-08-10 18:00:00	DIA	ETF	99.29	99.3	99.29	99.3	200.0
2004-08-10 09:00:00	TLT	ETF	86.34	86.39	86.26	86.3	28700.0
2004-08-10 10:00:00	TLT	ETF	86.36	86.44	86.32	86.42	20100.0
2004-08-10 11:00:00	TLT	ETF	86.44	86.44	86.31	86.31	24400.0
2004-08-10 12:00:00	TLT	ETF	86.34	86.34	86.25	86.29	38100.0
2004-08-10 13:00:00	TLT	ETF	86.3	86.37	86.29	86.32	57100.0

> showing 50 of 678 rows — these rows as CSV

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