PREVIEW / etf_1hour / 2006-08-31

all etf 1-hour files

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

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-31 04:00:00	SPY	ETF	130.68	130.68	130.67	130.67	200.0
2006-08-31 05:00:00	SPY	ETF	130.6	130.6	130.57	130.57	200.0
2006-08-31 06:00:00	SPY	ETF	130.59	130.59	130.59	130.59	50000.0
2006-08-31 07:00:00	SPY	ETF	130.62	130.74	130.62	130.74	157700.0
2006-08-31 08:00:00	SPY	ETF	130.75	131.02	130.62	130.92	1898000.0
2006-08-31 09:00:00	SPY	ETF	130.91	130.91	130.71	130.81	4390700.0
2006-08-31 10:00:00	SPY	ETF	130.8	130.95	130.58	130.8	7824000.0
2006-08-31 11:00:00	SPY	ETF	130.79	130.88	130.62	130.68	3468500.0
2006-08-31 12:00:00	SPY	ETF	130.67	130.82	130.63	130.73	2809100.0
2006-08-31 13:00:00	SPY	ETF	130.73	130.79	130.63	130.67	1339700.0
2006-08-31 14:00:00	SPY	ETF	130.69	130.93	130.67	130.91	3841200.0
2006-08-31 15:00:00	SPY	ETF	130.91	130.99	130.69	130.69	5814300.0
2006-08-31 16:00:00	SPY	ETF	130.68	130.77	130.61	130.72	1352000.0
2006-08-31 17:00:00	SPY	ETF	130.71	130.71	130.69	130.69	1200.0
2006-08-31 18:00:00	SPY	ETF	130.7	130.74	130.69	130.69	42400.0
2006-08-31 19:00:00	SPY	ETF	130.74	130.75	130.74	130.74	21000.0
2006-08-31 09:00:00	QQQ	ETF	38.94	39.03	38.82	38.93	12440300.0
2006-08-31 10:00:00	QQQ	ETF	38.92	39.02	38.76	38.88	14121000.0
2006-08-31 11:00:00	QQQ	ETF	38.88	38.91	38.76	38.81	6103100.0
2006-08-31 12:00:00	QQQ	ETF	38.81	38.93	38.79	38.88	3958600.0
2006-08-31 13:00:00	QQQ	ETF	38.89	38.89	38.8	38.82	3505800.0
2006-08-31 14:00:00	QQQ	ETF	38.83	38.97	38.82	38.95	4860800.0
2006-08-31 15:00:00	QQQ	ETF	38.94	38.98	38.85	38.86	10512500.0
2006-08-31 07:00:00	IWM	ETF	71.8	71.8	71.8	71.8	2700.0
2006-08-31 08:00:00	IWM	ETF	71.88	72.12	71.78	72.06	417100.0
2006-08-31 09:00:00	IWM	ETF	72.06	72.12	71.86	72.08	6305100.0
2006-08-31 10:00:00	IWM	ETF	72.08	72.24	71.79	71.9	7421100.0
2006-08-31 11:00:00	IWM	ETF	71.9	72.01	71.73	71.79	3820000.0
2006-08-31 12:00:00	IWM	ETF	71.79	71.99	71.74	71.9	2198200.0
2006-08-31 13:00:00	IWM	ETF	71.9	71.96	71.82	71.84	2667500.0
2006-08-31 14:00:00	IWM	ETF	71.85	72.06	71.8	72.03	2054700.0
2006-08-31 15:00:00	IWM	ETF	72.04	72.1	71.64	71.65	6938000.0
2006-08-31 16:00:00	IWM	ETF	71.65	71.86	71.6	71.79	801900.0
2006-08-31 08:00:00	DIA	ETF	113.82	113.97	113.73	113.97	11700.0
2006-08-31 09:00:00	DIA	ETF	113.93	114.02	113.82	113.91	330400.0
2006-08-31 10:00:00	DIA	ETF	113.91	114.08	113.73	113.84	957800.0
2006-08-31 11:00:00	DIA	ETF	113.84	113.91	113.68	113.73	701000.0
2006-08-31 12:00:00	DIA	ETF	113.73	113.91	113.73	113.85	184600.0
2006-08-31 13:00:00	DIA	ETF	113.8499	113.9	113.79	113.82	132400.0
2006-08-31 14:00:00	DIA	ETF	113.81	113.95	113.81	113.95	198300.0
2006-08-31 15:00:00	DIA	ETF	113.95	114.0	113.82	113.82	596300.0
2006-08-31 16:00:00	DIA	ETF	113.82	113.91	113.8	113.87	704600.0
2006-08-31 19:00:00	DIA	ETF	113.9	113.92	113.9	113.92	900.0
2006-08-31 04:00:00	GLD	ETF	61.73	62.4	61.73	62.4	4300.0
2006-08-31 05:00:00	GLD	ETF	62.3	62.3	62.3	62.3	500.0
2006-08-31 06:00:00	GLD	ETF	62.3	62.3	62.3	62.3	700.0
2006-08-31 07:00:00	GLD	ETF	62.2	62.2	61.87	61.9	3600.0
2006-08-31 08:00:00	GLD	ETF	61.9	62.23	61.84	62.1	98900.0
2006-08-31 09:00:00	GLD	ETF	62.11	62.16	61.88	61.94	572700.0
2006-08-31 10:00:00	GLD	ETF	61.91	62.03	61.7274	61.9088	1683400.0

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

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