PREVIEW / etf_1hour / 2006-05-05

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-05-05.parquet
  size:    42 KB
  rows:    1,310

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
2006-05-05 04:00:00	SPY	ETF	131.54	131.54	131.54	131.54	200.0
2006-05-05 06:00:00	SPY	ETF	131.6	131.6	131.6	131.6	2000.0
2006-05-05 07:00:00	SPY	ETF	131.62	131.63	131.6	131.62	37100.0
2006-05-05 08:00:00	SPY	ETF	131.64	132.05	131.57	131.9	2527000.0
2006-05-05 09:00:00	SPY	ETF	131.89	132.31	131.88	132.13	13351400.0
2006-05-05 10:00:00	SPY	ETF	132.14	132.17	131.85	132.13	10263900.0
2006-05-05 11:00:00	SPY	ETF	132.14	132.45	132.02	132.33	10354600.0
2006-05-05 12:00:00	SPY	ETF	132.33	132.48	132.24	132.25	6145100.0
2006-05-05 13:00:00	SPY	ETF	132.25	132.48	132.2	132.42	4078200.0
2006-05-05 14:00:00	SPY	ETF	132.43	132.8	132.34	132.67	6550700.0
2006-05-05 15:00:00	SPY	ETF	132.67	132.74	132.53	132.7	6650100.0
2006-05-05 16:00:00	SPY	ETF	132.69	132.7	132.5	132.62	878400.0
2006-05-05 17:00:00	SPY	ETF	132.64	132.65	132.55	132.65	2300.0
2006-05-05 18:00:00	SPY	ETF	132.58	132.58	132.51	132.51	1200.0
2006-05-05 19:00:00	SPY	ETF	132.52	132.52	132.5	132.5	3700.0
2006-05-05 09:00:00	QQQ	ETF	42.11	42.21	42.03	42.11	14085600.0
2006-05-05 10:00:00	QQQ	ETF	42.1	42.11	41.94	42.06	17059100.0
2006-05-05 11:00:00	QQQ	ETF	42.06	42.13	42.02	42.06	6717200.0
2006-05-05 12:00:00	QQQ	ETF	42.07	42.11	42.01	42.02	6085800.0
2006-05-05 13:00:00	QQQ	ETF	42.02	42.1	41.97	42.08	6452200.0
2006-05-05 14:00:00	QQQ	ETF	42.08	42.14	42.03	42.09	10072700.0
2006-05-05 15:00:00	QQQ	ETF	42.1	42.16	42.08	42.14	10433100.0
2006-05-05 07:00:00	IWM	ETF	77.2	77.2	77.2	77.2	5000.0
2006-05-05 08:00:00	IWM	ETF	77.26	77.55	77.16	77.45	354000.0
2006-05-05 09:00:00	IWM	ETF	77.46	77.8	77.45	77.7	9748400.0
2006-05-05 10:00:00	IWM	ETF	77.71	77.72	77.32	77.49	5219300.0
2006-05-05 11:00:00	IWM	ETF	77.49	77.78	77.38	77.71	4756000.0
2006-05-05 12:00:00	IWM	ETF	77.7	77.81	77.64	77.67	4503800.0
2006-05-05 13:00:00	IWM	ETF	77.67	77.85	77.61	77.81	2968500.0
2006-05-05 14:00:00	IWM	ETF	77.8	78.02	77.73	77.91	4573500.0
2006-05-05 15:00:00	IWM	ETF	77.91	77.93	77.75	77.78	4365200.0
2006-05-05 16:00:00	IWM	ETF	77.78	77.78	77.34	77.65	327600.0
2006-05-05 17:00:00	IWM	ETF	77.65	77.65	77.65	77.65	100.0
2006-05-05 19:00:00	IWM	ETF	77.52	77.52	77.52	77.52	100.0
2006-05-05 07:00:00	DIA	ETF	114.57	114.57	114.57	114.57	100.0
2006-05-05 08:00:00	DIA	ETF	114.54	114.84	114.51	114.74	147300.0
2006-05-05 09:00:00	DIA	ETF	114.74	115.13	114.71	115.04	694700.0
2006-05-05 10:00:00	DIA	ETF	115.03	115.19	114.9	115.17	851200.0
2006-05-05 11:00:00	DIA	ETF	115.18	115.53	115.15	115.44	1999700.0
2006-05-05 12:00:00	DIA	ETF	115.45	115.56	115.36	115.37	482800.0
2006-05-05 13:00:00	DIA	ETF	115.35	115.55	115.3	115.49	644300.0
2006-05-05 14:00:00	DIA	ETF	115.49	115.83	115.42	115.68	1014700.0
2006-05-05 15:00:00	DIA	ETF	115.68	115.77	115.61	115.72	801800.0
2006-05-05 16:00:00	DIA	ETF	115.72	115.74	115.63	115.73	51200.0
2006-05-05 17:00:00	DIA	ETF	115.66	115.66	115.66	115.66	200.0
2006-05-05 19:00:00	DIA	ETF	115.63	115.63	115.63	115.63	100.0
2006-05-05 08:00:00	GLD	ETF	67.58	68.0	67.27	67.59	432000.0
2006-05-05 09:00:00	GLD	ETF	67.55	67.82	67.18	67.49	1783000.0
2006-05-05 10:00:00	GLD	ETF	67.5	67.68	67.06	67.5518	2024200.0
2006-05-05 11:00:00	GLD	ETF	67.61	67.79	67.36	67.58	1154300.0

> showing 50 of 1,310 rows — these rows as CSV

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