PREVIEW / etf_1hour / 2006-04-10

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-04-10.parquet
  size:    40 KB
  rows:    1,253

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-04-10 04:00:00	SPY	ETF	129.6	129.6	129.6	129.6	5000.0
2006-04-10 05:00:00	SPY	ETF	129.65	129.65	129.6	129.62	300.0
2006-04-10 07:00:00	SPY	ETF	129.57	129.63	129.55	129.63	56300.0
2006-04-10 08:00:00	SPY	ETF	129.63	129.79	129.51	129.75	503200.0
2006-04-10 09:00:00	SPY	ETF	129.74	129.77	129.53	129.61	4883200.0
2006-04-10 10:00:00	SPY	ETF	129.64	129.91	129.53	129.58	7259700.0
2006-04-10 11:00:00	SPY	ETF	129.58	130.08	129.56	130.03	5962400.0
2006-04-10 12:00:00	SPY	ETF	130.03	130.08	129.77	129.82	3255100.0
2006-04-10 13:00:00	SPY	ETF	129.84	129.87	129.43	129.5	5077600.0
2006-04-10 14:00:00	SPY	ETF	129.51	129.65	129.27	129.41	7413000.0
2006-04-10 15:00:00	SPY	ETF	129.41	129.72	129.39	129.6	5654400.0
2006-04-10 16:00:00	SPY	ETF	129.61	129.83	129.6	129.79	711800.0
2006-04-10 17:00:00	SPY	ETF	129.79	129.84	129.64	129.75	73400.0
2006-04-10 18:00:00	SPY	ETF	129.75	129.75	129.72	129.75	30100.0
2006-04-10 19:00:00	SPY	ETF	129.73	129.77	129.72	129.77	3500.0
2006-04-10 09:00:00	QQQ	ETF	42.4	42.43	42.28	42.31	10696300.0
2006-04-10 10:00:00	QQQ	ETF	42.32	42.5	42.28	42.29	11163700.0
2006-04-10 11:00:00	QQQ	ETF	42.29	42.42	42.27	42.38	6414600.0
2006-04-10 12:00:00	QQQ	ETF	42.39	42.45	42.31	42.35	4578200.0
2006-04-10 13:00:00	QQQ	ETF	42.35	42.36	42.15	42.18	7917500.0
2006-04-10 14:00:00	QQQ	ETF	42.18	42.23	42.09	42.15	8036600.0
2006-04-10 15:00:00	QQQ	ETF	42.15	42.3	42.14	42.26	8681500.0
2006-04-10 08:00:00	IWM	ETF	75.1	75.1	75.0	75.09	16200.0
2006-04-10 09:00:00	IWM	ETF	75.05	75.17	74.8	74.96	5363300.0
2006-04-10 10:00:00	IWM	ETF	74.97	75.22	74.85	74.88	5766700.0
2006-04-10 11:00:00	IWM	ETF	74.88	75.28	74.8	75.28	2344400.0
2006-04-10 12:00:00	IWM	ETF	75.27	75.46	75.23	75.26	3878100.0
2006-04-10 13:00:00	IWM	ETF	75.27	75.29	74.7	74.75	4640900.0
2006-04-10 14:00:00	IWM	ETF	74.74	74.85	74.53	74.59	5653100.0
2006-04-10 15:00:00	IWM	ETF	74.59	74.75	74.51	74.71	7679500.0
2006-04-10 16:00:00	IWM	ETF	74.71	74.94	74.6	74.79	1619000.0
2006-04-10 17:00:00	IWM	ETF	74.93	75.1	74.93	75.1	14200.0
2006-04-10 18:00:00	IWM	ETF	75.1	75.1	74.9	74.9	7400.0
2006-04-10 08:00:00	DIA	ETF	111.31	111.47	111.31	111.47	22100.0
2006-04-10 09:00:00	DIA	ETF	111.46	111.55	111.23	111.33	409600.0
2006-04-10 10:00:00	DIA	ETF	111.34	111.6	111.33	111.4	1048500.0
2006-04-10 11:00:00	DIA	ETF	111.43	111.84	111.42	111.77	908400.0
2006-04-10 12:00:00	DIA	ETF	111.79	111.83	111.55	111.5876	349100.0
2006-04-10 13:00:00	DIA	ETF	111.6	111.62	111.27	111.34	721700.0
2006-04-10 14:00:00	DIA	ETF	111.35	111.43	111.17	111.27	1632600.0
2006-04-10 15:00:00	DIA	ETF	111.27	111.49	111.27	111.39	772600.0
2006-04-10 16:00:00	DIA	ETF	111.4	111.69	111.39	111.62	52500.0
2006-04-10 17:00:00	DIA	ETF	111.6	111.75	111.6	111.75	1100.0
2006-04-10 08:00:00	GLD	ETF	59.2	59.45	59.0	59.39	49200.0
2006-04-10 09:00:00	GLD	ETF	59.43	59.55	59.38	59.4	588700.0
2006-04-10 10:00:00	GLD	ETF	59.4	59.48	58.95	59.0222	600200.0
2006-04-10 11:00:00	GLD	ETF	59.03	59.24	59.02	59.07	299400.0
2006-04-10 12:00:00	GLD	ETF	59.0674	59.36	59.05	59.34	415900.0
2006-04-10 13:00:00	GLD	ETF	59.35	59.5	59.2992	59.43	367100.0
2006-04-10 14:00:00	GLD	ETF	59.43	59.63	59.41	59.53	521200.0

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

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