PREVIEW / etf_1hour / 2006-06-30

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-06-30.parquet
  size:    48 KB
  rows:    1,539

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-06-30 05:00:00	SPY	ETF	127.14	127.14	127.14	127.14	100.0
2006-06-30 07:00:00	SPY	ETF	127.2	127.28	127.17	127.28	10900.0
2006-06-30 08:00:00	SPY	ETF	127.26	127.57	127.19	127.49	1797900.0
2006-06-30 09:00:00	SPY	ETF	127.49	127.73	127.23	127.26	8603100.0
2006-06-30 10:00:00	SPY	ETF	127.26	127.4	126.96	127.34	12197400.0
2006-06-30 11:00:00	SPY	ETF	127.35	127.39	127.15	127.31	3584500.0
2006-06-30 12:00:00	SPY	ETF	127.31	127.36	127.16	127.18	2113900.0
2006-06-30 13:00:00	SPY	ETF	127.19	127.33	127.13	127.28	4019300.0
2006-06-30 14:00:00	SPY	ETF	127.27	127.57	127.2	127.54	6863300.0
2006-06-30 15:00:00	SPY	ETF	127.53	127.54	126.99	126.99	10297200.0
2006-06-30 16:00:00	SPY	ETF	126.99	127.3	126.96	127.15	1970700.0
2006-06-30 17:00:00	SPY	ETF	127.2	127.27	127.16	127.17	35100.0
2006-06-30 18:00:00	SPY	ETF	127.22	127.22	127.22	127.22	2100.0
2006-06-30 19:00:00	SPY	ETF	127.2	127.2	127.2	127.2	300.0
2006-06-30 09:00:00	QQQ	ETF	39.12	39.14	38.82	38.82	16354300.0
2006-06-30 10:00:00	QQQ	ETF	38.83	38.86	38.69	38.82	22378800.0
2006-06-30 11:00:00	QQQ	ETF	38.83	38.87	38.74	38.8	7033000.0
2006-06-30 12:00:00	QQQ	ETF	38.8	38.83	38.73	38.77	4812700.0
2006-06-30 13:00:00	QQQ	ETF	38.77	38.84	38.75	38.83	3911500.0
2006-06-30 14:00:00	QQQ	ETF	38.83	38.92	38.78	38.9	7238100.0
2006-06-30 15:00:00	QQQ	ETF	38.9	38.91	38.68	38.77	12357300.0
2006-06-30 08:00:00	IWM	ETF	71.2	71.67	71.2	71.56	296800.0
2006-06-30 09:00:00	IWM	ETF	71.58	71.66	70.97	70.9906	12202400.0
2006-06-30 10:00:00	IWM	ETF	71.0	71.13	70.55	71.11	10076900.0
2006-06-30 11:00:00	IWM	ETF	71.12	71.27	70.99	71.21	5432200.0
2006-06-30 12:00:00	IWM	ETF	71.22	71.35	71.11	71.26	3329000.0
2006-06-30 13:00:00	IWM	ETF	71.26	71.47	71.23	71.46	3135200.0
2006-06-30 14:00:00	IWM	ETF	71.46	71.66	71.38	71.63	4560900.0
2006-06-30 15:00:00	IWM	ETF	71.61	71.66	71.04	71.46	15240000.0
2006-06-30 16:00:00	IWM	ETF	71.48	72.03	71.42	71.63	2774500.0
2006-06-30 17:00:00	IWM	ETF	71.74	71.74	71.53	71.68	47900.0
2006-06-30 19:00:00	IWM	ETF	71.65	71.65	71.65	71.65	300.0
2006-06-30 08:00:00	DIA	ETF	111.77	112.04	111.75	112.04	28700.0
2006-06-30 09:00:00	DIA	ETF	112.1	112.33	111.91	111.93	870200.0
2006-06-30 10:00:00	DIA	ETF	111.92	111.9395	111.59	111.83	863700.0
2006-06-30 11:00:00	DIA	ETF	111.84	111.92	111.7	111.81	280100.0
2006-06-30 12:00:00	DIA	ETF	111.82	111.85	111.69	111.76	260500.0
2006-06-30 13:00:00	DIA	ETF	111.76	111.91	111.74	111.9	192400.0
2006-06-30 14:00:00	DIA	ETF	111.85	112.05	111.85	112.03	434300.0
2006-06-30 15:00:00	DIA	ETF	112.01	112.0599	111.6	111.6	800700.0
2006-06-30 16:00:00	DIA	ETF	111.6076	111.85	111.42	111.85	154000.0
2006-06-30 18:00:00	DIA	ETF	111.79	111.79	111.79	111.79	100.0
2006-06-30 07:00:00	GLD	ETF	59.57	59.57	59.57	59.57	1000.0
2006-06-30 08:00:00	GLD	ETF	59.68	60.4	59.61	60.12	266300.0
2006-06-30 09:00:00	GLD	ETF	60.14	60.95	60.12	60.85	2025600.0
2006-06-30 10:00:00	GLD	ETF	60.83	61.3	60.71	61.19	2286800.0
2006-06-30 11:00:00	GLD	ETF	61.19	61.28	60.82	60.84	1108100.0
2006-06-30 12:00:00	GLD	ETF	60.84	61.14	60.75	61.0826	620200.0
2006-06-30 13:00:00	GLD	ETF	61.08	61.2	60.97	61.18	370600.0
2006-06-30 14:00:00	GLD	ETF	61.18	61.22	61.08	61.22	374400.0

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

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