PREVIEW / etf_1hour / 2006-08-25

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-08-25.parquet
  size:    48 KB
  rows:    1,568

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-25 07:00:00	SPY	ETF	129.77	129.85	129.69	129.73	146400.0
2006-08-25 08:00:00	SPY	ETF	129.74	129.82	129.71	129.76	659500.0
2006-08-25 09:00:00	SPY	ETF	129.74	129.94	129.55	129.88	6081000.0
2006-08-25 10:00:00	SPY	ETF	129.88	130.25	129.77	129.86	14655100.0
2006-08-25 11:00:00	SPY	ETF	129.86	129.9	129.61	129.7688	6160600.0
2006-08-25 12:00:00	SPY	ETF	129.77	129.88	129.68	129.79	1937300.0
2006-08-25 13:00:00	SPY	ETF	129.8	129.87	129.7	129.85	1651800.0
2006-08-25 14:00:00	SPY	ETF	129.85	130.0	129.71	129.93	3121500.0
2006-08-25 15:00:00	SPY	ETF	129.93	130.11	129.78	129.84	5600500.0
2006-08-25 16:00:00	SPY	ETF	129.84	129.96	129.8	129.83	687800.0
2006-08-25 17:00:00	SPY	ETF	129.81	129.82	129.76	129.76	27100.0
2006-08-25 18:00:00	SPY	ETF	129.82	129.85	129.82	129.85	1400.0
2006-08-25 09:00:00	QQQ	ETF	38.17	38.36	38.06	38.32	11274100.0
2006-08-25 10:00:00	QQQ	ETF	38.32	38.64	38.26	38.31	26044900.0
2006-08-25 11:00:00	QQQ	ETF	38.32	38.39	38.24	38.32	9205200.0
2006-08-25 12:00:00	QQQ	ETF	38.31	38.39	38.28	38.35	4580400.0
2006-08-25 13:00:00	QQQ	ETF	38.35	38.4	38.29	38.38	3583600.0
2006-08-25 14:00:00	QQQ	ETF	38.38	38.43	38.31	38.39	6827400.0
2006-08-25 15:00:00	QQQ	ETF	38.4	38.45	38.3	38.32	9369100.0
2006-08-25 08:00:00	IWM	ETF	69.49	69.54	69.4	69.46	104500.0
2006-08-25 09:00:00	IWM	ETF	69.46	69.95	69.23	69.89	3208300.0
2006-08-25 10:00:00	IWM	ETF	69.9	70.09	69.5	69.54	8282400.0
2006-08-25 11:00:00	IWM	ETF	69.53	69.57	69.26	69.42	2989900.0
2006-08-25 12:00:00	IWM	ETF	69.43	69.55	69.3	69.4	1429300.0
2006-08-25 13:00:00	IWM	ETF	69.39	69.52	69.32	69.46	1115700.0
2006-08-25 14:00:00	IWM	ETF	69.46	69.64	69.35	69.59	1797000.0
2006-08-25 15:00:00	IWM	ETF	69.59	69.74	69.49	69.49	2920600.0
2006-08-25 16:00:00	IWM	ETF	69.49	69.6	69.48	69.59	298800.0
2006-08-25 08:00:00	DIA	ETF	112.94	112.95	112.84	112.86	2500.0
2006-08-25 09:00:00	DIA	ETF	112.83	112.97	112.52	112.94	641700.0
2006-08-25 10:00:00	DIA	ETF	112.93	113.15	112.79	112.82	1146700.0
2006-08-25 11:00:00	DIA	ETF	112.82	112.85	112.65	112.78	700100.0
2006-08-25 12:00:00	DIA	ETF	112.78	112.84	112.67	112.77	169200.0
2006-08-25 13:00:00	DIA	ETF	112.77	112.85	112.71	112.82	276100.0
2006-08-25 14:00:00	DIA	ETF	112.83	112.97	112.7	112.86	275600.0
2006-08-25 15:00:00	DIA	ETF	112.86	112.99	112.78	112.83	312700.0
2006-08-25 16:00:00	DIA	ETF	112.83	112.9	112.81	112.84	10200.0
2006-08-25 19:00:00	DIA	ETF	112.9	112.9	112.9	112.9	100.0
2006-08-25 08:00:00	GLD	ETF	61.85	61.96	61.58	61.95	57700.0
2006-08-25 09:00:00	GLD	ETF	61.95	62.06	61.6252	61.76	321600.0
2006-08-25 10:00:00	GLD	ETF	61.75	61.8	61.58	61.64	360800.0
2006-08-25 11:00:00	GLD	ETF	61.64	62.0	61.62	61.89	466700.0
2006-08-25 12:00:00	GLD	ETF	61.89	61.92	61.75	61.77	237800.0
2006-08-25 13:00:00	GLD	ETF	61.78	61.91	61.73	61.87	217300.0
2006-08-25 14:00:00	GLD	ETF	61.87	61.8974	61.78	61.8	206700.0
2006-08-25 15:00:00	GLD	ETF	61.8	61.84	61.72	61.75	253400.0
2006-08-25 16:00:00	GLD	ETF	61.79	61.84	61.78	61.78	2500.0
2006-08-25 09:00:00	TLT	ETF	87.24	87.28	87.2	87.2	49000.0
2006-08-25 10:00:00	TLT	ETF	87.24	87.45	87.24	87.44	79100.0
2006-08-25 11:00:00	TLT	ETF	87.45	87.5	87.43	87.44	69200.0

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

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