PREVIEW / etf_1hour / 2006-08-16

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-08-16.parquet
  size:    51 KB
  rows:    1,635

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-16 07:00:00	SPY	ETF	128.69	128.71	128.62	128.71	171500.0
2006-08-16 08:00:00	SPY	ETF	128.68	129.34	128.63	129.31	4093800.0
2006-08-16 09:00:00	SPY	ETF	129.32	129.4	129.12	129.12	8947400.0
2006-08-16 10:00:00	SPY	ETF	129.12	129.46	129.04	129.36	10726100.0
2006-08-16 11:00:00	SPY	ETF	129.34	129.46	129.18	129.34	5966100.0
2006-08-16 12:00:00	SPY	ETF	129.34	129.6	129.24	129.39	8591000.0
2006-08-16 13:00:00	SPY	ETF	129.39	129.54	129.25	129.45	6732500.0
2006-08-16 14:00:00	SPY	ETF	129.44	129.73	129.35	129.66	7749800.0
2006-08-16 15:00:00	SPY	ETF	129.66	129.89	129.65	129.75	12915300.0
2006-08-16 16:00:00	SPY	ETF	129.75	129.85	129.65	129.72	1591500.0
2006-08-16 17:00:00	SPY	ETF	129.74	129.8	129.71	129.79	9300.0
2006-08-16 18:00:00	SPY	ETF	129.74	129.74	129.65	129.65	22200.0
2006-08-16 19:00:00	SPY	ETF	129.71	129.71	129.71	129.71	200.0
2006-08-16 09:00:00	QQQ	ETF	37.99	38.02	37.85	37.89	21286400.0
2006-08-16 10:00:00	QQQ	ETF	37.89	38.09	37.84	38.04	18642700.0
2006-08-16 11:00:00	QQQ	ETF	38.04	38.13	37.97	38.09	10663100.0
2006-08-16 12:00:00	QQQ	ETF	38.09	38.29	38.06	38.17	15042000.0
2006-08-16 13:00:00	QQQ	ETF	38.17	38.25	36.16	38.22	11287600.0
2006-08-16 14:00:00	QQQ	ETF	38.23	38.43	38.15	38.4	15913600.0
2006-08-16 15:00:00	QQQ	ETF	38.4	38.58	38.39	38.58	26345000.0
2006-08-16 08:00:00	IWM	ETF	69.42	70.09	69.36	70.08	2127500.0
2006-08-16 09:00:00	IWM	ETF	70.08	70.11	69.72	69.77	6822700.0
2006-08-16 10:00:00	IWM	ETF	69.78	70.09	69.49	70.02	9705600.0
2006-08-16 11:00:00	IWM	ETF	70.03	70.04	69.8	69.87	3915700.0
2006-08-16 12:00:00	IWM	ETF	69.88	70.21	69.83	70.04	5404800.0
2006-08-16 13:00:00	IWM	ETF	70.05	70.13	69.84	70.02	2887700.0
2006-08-16 14:00:00	IWM	ETF	70.02	70.24	69.91	70.22	2708100.0
2006-08-16 15:00:00	IWM	ETF	70.22	70.52	70.19	70.4	10271000.0
2006-08-16 16:00:00	IWM	ETF	70.4	70.49	70.35	70.41	666100.0
2006-08-16 17:00:00	IWM	ETF	70.46	70.47	70.34	70.45	1044500.0
2006-08-16 18:00:00	IWM	ETF	70.44	70.44	70.42	70.42	1002000.0
2006-08-16 08:00:00	DIA	ETF	112.38	112.86	112.28	112.86	188000.0
2006-08-16 09:00:00	DIA	ETF	112.81	112.94	112.68	112.78	711400.0
2006-08-16 10:00:00	DIA	ETF	112.75	113.05	112.68	112.99	844000.0
2006-08-16 11:00:00	DIA	ETF	112.99	113.01	112.77	112.93	743500.0
2006-08-16 12:00:00	DIA	ETF	112.93	113.13	112.9	113.02	1141600.0
2006-08-16 13:00:00	DIA	ETF	113.01	113.14	112.95	113.1	626900.0
2006-08-16 14:00:00	DIA	ETF	113.11	113.42	113.05	113.41	1174500.0
2006-08-16 15:00:00	DIA	ETF	113.4	113.55	113.34	113.4	1145800.0
2006-08-16 16:00:00	DIA	ETF	113.401	113.46	113.36	113.46	56700.0
2006-08-16 17:00:00	DIA	ETF	113.45	113.48	113.45	113.48	600.0
2006-08-16 18:00:00	DIA	ETF	113.4	113.48	113.4	113.48	700.0
2006-08-16 08:00:00	GLD	ETF	62.21	62.55	62.21	62.49	100000.0
2006-08-16 09:00:00	GLD	ETF	62.49	62.8	62.41	62.63	477300.0
2006-08-16 10:00:00	GLD	ETF	62.6301	62.8	62.46	62.58	564100.0
2006-08-16 11:00:00	GLD	ETF	62.58	62.89	62.42	62.88	446000.0
2006-08-16 12:00:00	GLD	ETF	62.88	62.88	62.29	62.36	424100.0
2006-08-16 13:00:00	GLD	ETF	62.39	62.49	62.24	62.36	370600.0
2006-08-16 14:00:00	GLD	ETF	62.37	62.41	62.3	62.32	243400.0
2006-08-16 15:00:00	GLD	ETF	62.33	62.54	62.31	62.52	689500.0

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

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