PREVIEW / etf_1hour / 2006-03-14

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-03-14.parquet
  size:    41 KB
  rows:    1,236

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-03-14 07:00:00	SPY	ETF	129.29	129.29	128.55	128.63	56100.0
2006-03-14 08:00:00	SPY	ETF	128.63	128.82	128.53	128.73	1398700.0
2006-03-14 09:00:00	SPY	ETF	128.73	129.23	128.61	129.21	8159000.0
2006-03-14 10:00:00	SPY	ETF	129.21	129.27	128.92	129.06	9932700.0
2006-03-14 11:00:00	SPY	ETF	129.07	129.48	129.01	129.38	7976200.0
2006-03-14 12:00:00	SPY	ETF	129.38	129.48	129.25	129.39	4159000.0
2006-03-14 13:00:00	SPY	ETF	129.41	129.88	129.38	129.79	12357300.0
2006-03-14 14:00:00	SPY	ETF	129.79	130.12	129.72	130.08	7687800.0
2006-03-14 15:00:00	SPY	ETF	130.08	130.23	130.07	130.12	8190300.0
2006-03-14 16:00:00	SPY	ETF	130.12	130.2	128.8903	130.15	5414000.0
2006-03-14 17:00:00	SPY	ETF	130.21	130.23	129.77	130.15	79000.0
2006-03-14 18:00:00	SPY	ETF	130.17	130.2	130.17	130.19	2300.0
2006-03-14 19:00:00	SPY	ETF	130.15	130.16	130.12	130.12	3800.0
2006-03-14 09:00:00	QQQ	ETF	40.65	41.03	40.64	41.02	21879000.0
2006-03-14 10:00:00	QQQ	ETF	41.02	41.04	40.76	40.87	14678300.0
2006-03-14 11:00:00	QQQ	ETF	40.87	41.03	40.85	41.0	9249100.0
2006-03-14 12:00:00	QQQ	ETF	41.01	41.05	40.91	40.99	8552200.0
2006-03-14 13:00:00	QQQ	ETF	40.99	41.26	40.98	41.2	20815300.0
2006-03-14 14:00:00	QQQ	ETF	41.19	41.33	41.15	41.31	12977300.0
2006-03-14 15:00:00	QQQ	ETF	41.31	41.42	41.28	41.36	17561800.0
2006-03-14 08:00:00	IWM	ETF	72.3	72.39	72.21	72.25	615700.0
2006-03-14 09:00:00	IWM	ETF	72.25	72.56	72.02	72.48	7619500.0
2006-03-14 10:00:00	IWM	ETF	72.48	72.52	72.01	72.26	6384200.0
2006-03-14 11:00:00	IWM	ETF	72.25	72.87	72.22	72.85	5601100.0
2006-03-14 12:00:00	IWM	ETF	72.86	72.93	72.73	72.85	2055600.0
2006-03-14 13:00:00	IWM	ETF	72.85	73.15	72.85	73.03	5358100.0
2006-03-14 14:00:00	IWM	ETF	73.03	73.24	72.97	73.11	4906500.0
2006-03-14 15:00:00	IWM	ETF	73.1	73.24	73.09	73.2	4538800.0
2006-03-14 16:00:00	IWM	ETF	73.19	73.28	72.88	73.24	512700.0
2006-03-14 17:00:00	IWM	ETF	73.22	73.22	73.21	73.22	6600.0
2006-03-14 18:00:00	IWM	ETF	73.22	73.22	73.21	73.21	100300.0
2006-03-14 19:00:00	IWM	ETF	73.21	73.21	73.21	73.21	2000.0
2006-03-14 08:00:00	DIA	ETF	110.83	110.94	110.83	110.87	148300.0
2006-03-14 09:00:00	DIA	ETF	110.87	111.17	110.75	111.17	760000.0
2006-03-14 10:00:00	DIA	ETF	111.17	111.2	110.91	111.04	566000.0
2006-03-14 11:00:00	DIA	ETF	111.04	111.3	110.99	111.25	593000.0
2006-03-14 12:00:00	DIA	ETF	111.25	111.31	111.17	111.22	317400.0
2006-03-14 13:00:00	DIA	ETF	111.24	111.55	111.22	111.5	908900.0
2006-03-14 14:00:00	DIA	ETF	111.49	111.74	111.46	111.67	697500.0
2006-03-14 15:00:00	DIA	ETF	111.69	111.76	111.6	111.61	908800.0
2006-03-14 16:00:00	DIA	ETF	111.6	111.68	111.57	111.64	21600.0
2006-03-14 08:00:00	GLD	ETF	54.19	54.23	54.07	54.07	23200.0
2006-03-14 09:00:00	GLD	ETF	54.23	54.38	54.17	54.35	272100.0
2006-03-14 10:00:00	GLD	ETF	54.34	54.63	54.22	54.62	603000.0
2006-03-14 11:00:00	GLD	ETF	54.63	54.7	54.5	54.7	387200.0
2006-03-14 12:00:00	GLD	ETF	54.69	55.0	54.65	54.81	534300.0
2006-03-14 13:00:00	GLD	ETF	54.81	54.98	54.79	54.98	326800.0
2006-03-14 14:00:00	GLD	ETF	54.98	55.0	54.92	54.95	177300.0
2006-03-14 15:00:00	GLD	ETF	54.96	54.97	54.89	54.94	326800.0
2006-03-14 16:00:00	GLD	ETF	54.88	54.88	54.88	54.88	700.0

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

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