PREVIEW / etf_1hour / 2006-08-14

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-08-14.parquet
  size:    49 KB
  rows:    1,562

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-08-14 06:00:00	SPY	ETF	127.74	127.75	127.73	127.74	250800.0
2006-08-14 07:00:00	SPY	ETF	127.75	127.79	127.65	127.65	102500.0
2006-08-14 08:00:00	SPY	ETF	127.68	127.77	127.01	127.68	1234400.0
2006-08-14 09:00:00	SPY	ETF	127.67	127.77	127.46	127.52	8157900.0
2006-08-14 10:00:00	SPY	ETF	127.52	127.59	127.38	127.56	5725200.0
2006-08-14 11:00:00	SPY	ETF	127.55	128.09	127.54	128.03	10991000.0
2006-08-14 12:00:00	SPY	ETF	128.02	128.16	127.93	127.94	5069900.0
2006-08-14 13:00:00	SPY	ETF	127.94	127.99	127.73	127.75	3379200.0
2006-08-14 14:00:00	SPY	ETF	127.76	127.85	127.17	127.24	9124400.0
2006-08-14 15:00:00	SPY	ETF	127.24	127.24	126.92	127.04	11160600.0
2006-08-14 16:00:00	SPY	ETF	127.08	127.2	127.05	127.12	690100.0
2006-08-14 17:00:00	SPY	ETF	127.11	127.16	127.1	127.1	225000.0
2006-08-14 18:00:00	SPY	ETF	127.12	127.19	127.1	127.18	205500.0
2006-08-14 09:00:00	QQQ	ETF	36.86	36.94	36.81	36.86	12636200.0
2006-08-14 10:00:00	QQQ	ETF	36.85	36.91	36.74	36.89	10567400.0
2006-08-14 11:00:00	QQQ	ETF	36.89	37.24	36.89	37.22	25014300.0
2006-08-14 12:00:00	QQQ	ETF	37.22	37.27	37.15	37.16	7169000.0
2006-08-14 13:00:00	QQQ	ETF	37.16	37.19	37.05	37.06	8798000.0
2006-08-14 14:00:00	QQQ	ETF	37.06	37.11	36.87	36.89	19656100.0
2006-08-14 15:00:00	QQQ	ETF	36.9	36.9	36.7	36.76	20259800.0
2006-08-14 08:00:00	IWM	ETF	68.1	68.25	67.6	68.13	577900.0
2006-08-14 09:00:00	IWM	ETF	68.18	68.26	67.91	68.05	5954700.0
2006-08-14 10:00:00	IWM	ETF	68.05	68.28	67.94	68.25	5770600.0
2006-08-14 11:00:00	IWM	ETF	68.25	68.82	68.24	68.76	7784400.0
2006-08-14 12:00:00	IWM	ETF	68.76	68.8	68.62	68.63	2162500.0
2006-08-14 13:00:00	IWM	ETF	68.62	68.64	68.32	68.37	5118800.0
2006-08-14 14:00:00	IWM	ETF	68.36	68.42	67.81	67.86	6023700.0
2006-08-14 15:00:00	IWM	ETF	67.86	67.95	67.68	67.8	8195300.0
2006-08-14 16:00:00	IWM	ETF	67.8	68.03	67.8	67.96	478600.0
2006-08-14 17:00:00	IWM	ETF	67.97	67.98	67.97	67.98	3700.0
2006-08-14 18:00:00	IWM	ETF	67.99	67.99	67.99	67.99	200.0
2006-08-14 07:00:00	DIA	ETF	111.58	111.58	111.58	111.58	400.0
2006-08-14 08:00:00	DIA	ETF	111.59	111.62	111.53	111.6	5000.0
2006-08-14 09:00:00	DIA	ETF	111.62	111.72	111.5	111.608	613000.0
2006-08-14 10:00:00	DIA	ETF	111.62	111.79	111.6	111.701	1053700.0
2006-08-14 11:00:00	DIA	ETF	111.7	112.12	111.7	112.06	1008800.0
2006-08-14 12:00:00	DIA	ETF	112.07	112.13	111.92	111.93	934200.0
2006-08-14 13:00:00	DIA	ETF	111.93	111.99	111.76	111.78	985400.0
2006-08-14 14:00:00	DIA	ETF	111.79	111.84	111.21	111.25	799000.0
2006-08-14 15:00:00	DIA	ETF	111.25	111.25	110.89	111.08	2317900.0
2006-08-14 16:00:00	DIA	ETF	111.0925	111.22	111.09	111.2	218700.0
2006-08-14 07:00:00	GLD	ETF	62.21	62.21	62.1	62.1	12500.0
2006-08-14 08:00:00	GLD	ETF	62.1	62.35	61.98	62.35	215300.0
2006-08-14 09:00:00	GLD	ETF	62.32	62.53	62.14	62.17	686700.0
2006-08-14 10:00:00	GLD	ETF	62.2	62.56	62.02	62.32	769200.0
2006-08-14 11:00:00	GLD	ETF	62.32	62.5	62.18	62.37	415500.0
2006-08-14 12:00:00	GLD	ETF	62.41	62.89	62.32	62.71	421800.0
2006-08-14 13:00:00	GLD	ETF	62.72	62.9	62.26	62.27	454400.0
2006-08-14 14:00:00	GLD	ETF	62.3	62.36	62.19	62.22	167300.0
2006-08-14 15:00:00	GLD	ETF	62.23	62.25	62.15	62.22	328500.0

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

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