PREVIEW / etf_1hour / 2006-05-19

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-05-19.parquet
  size:    44 KB
  rows:    1,353

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-05-19 06:00:00	SPY	ETF	126.75	126.75	126.72	126.73	11100.0
2006-05-19 07:00:00	SPY	ETF	126.72	126.8	126.68	126.7	147600.0
2006-05-19 08:00:00	SPY	ETF	126.69	126.98	126.67	126.91	844800.0
2006-05-19 09:00:00	SPY	ETF	126.89	127.04	126.54	126.82	13746500.0
2006-05-19 10:00:00	SPY	ETF	126.82	126.94	126.29	126.59	16785900.0
2006-05-19 11:00:00	SPY	ETF	126.59	126.78	125.8	126.26	23836500.0
2006-05-19 12:00:00	SPY	ETF	126.25	127.26	126.22	126.93	18328000.0
2006-05-19 13:00:00	SPY	ETF	126.93	127.49	126.81	127.25	13324300.0
2006-05-19 14:00:00	SPY	ETF	127.24	127.3	126.68	126.72	11964400.0
2006-05-19 15:00:00	SPY	ETF	126.74	127.31	126.41	126.96	19238500.0
2006-05-19 16:00:00	SPY	ETF	126.96	127.1	126.89	126.98	1182300.0
2006-05-19 17:00:00	SPY	ETF	126.98	127.01	126.96	127.0	33000.0
2006-05-19 18:00:00	SPY	ETF	126.99	127.01	126.99	127.01	30600.0
2006-05-19 19:00:00	SPY	ETF	127.01	127.08	127.01	127.08	5100.0
2006-05-19 09:00:00	QQQ	ETF	39.19	39.27	39.12	39.19	25734700.0
2006-05-19 10:00:00	QQQ	ETF	39.19	39.22	38.81	39.07	28434900.0
2006-05-19 11:00:00	QQQ	ETF	39.08	39.08	38.75	38.95	33701700.0
2006-05-19 12:00:00	QQQ	ETF	38.95	39.29	38.93	39.18	21176800.0
2006-05-19 13:00:00	QQQ	ETF	39.19	39.47	39.13	39.38	24342100.0
2006-05-19 14:00:00	QQQ	ETF	39.38	39.44	39.13	39.15	19084200.0
2006-05-19 15:00:00	QQQ	ETF	39.14	39.41	39.06	39.34	28355300.0
2006-05-19 07:00:00	IWM	ETF	71.27	71.5	71.25	71.5	12800.0
2006-05-19 08:00:00	IWM	ETF	71.62	71.64	71.4	71.57	461900.0
2006-05-19 09:00:00	IWM	ETF	71.59	71.68	71.18	71.6	9633100.0
2006-05-19 10:00:00	IWM	ETF	71.59	71.62	70.99	71.2	10111000.0
2006-05-19 11:00:00	IWM	ETF	71.2001	71.25	70.58	70.83	8768900.0
2006-05-19 12:00:00	IWM	ETF	70.84	72.04	70.81	71.7	14525000.0
2006-05-19 13:00:00	IWM	ETF	71.69	72.18	71.55	71.95	9449200.0
2006-05-19 14:00:00	IWM	ETF	71.9476	72.01	71.32	71.32	8024700.0
2006-05-19 15:00:00	IWM	ETF	71.33	71.95	71.2	71.87	13660900.0
2006-05-19 16:00:00	IWM	ETF	71.87	71.98	71.87	71.96	596200.0
2006-05-19 17:00:00	IWM	ETF	71.96	71.98	71.86	71.98	7900.0
2006-05-19 19:00:00	IWM	ETF	71.78	71.78	71.78	71.78	100.0
2006-05-19 07:00:00	DIA	ETF	111.57	111.57	111.48	111.48	17100.0
2006-05-19 08:00:00	DIA	ETF	111.48	111.63	111.45	111.55	317600.0
2006-05-19 09:00:00	DIA	ETF	111.55	111.7	111.23	111.37	4475700.0
2006-05-19 10:00:00	DIA	ETF	111.38	111.4	110.92	111.18	5027400.0
2006-05-19 11:00:00	DIA	ETF	111.18	111.28	110.63	110.79	4017000.0
2006-05-19 12:00:00	DIA	ETF	110.79	111.63	110.78	111.29	2772700.0
2006-05-19 13:00:00	DIA	ETF	111.28	111.71	111.18	111.48	2600700.0
2006-05-19 14:00:00	DIA	ETF	111.47	111.56	111.13	111.17	1367700.0
2006-05-19 15:00:00	DIA	ETF	111.17	111.48	110.89	111.33	1408200.0
2006-05-19 16:00:00	DIA	ETF	111.33	111.48	111.3	111.48	115100.0
2006-05-19 07:00:00	GLD	ETF	67.6	67.6	67.36	67.48	34400.0
2006-05-19 08:00:00	GLD	ETF	67.47	67.74	65.66	65.85	599300.0
2006-05-19 09:00:00	GLD	ETF	65.8	67.6	65.29	65.68	4649000.0
2006-05-19 10:00:00	GLD	ETF	65.66	65.76	64.7	64.92	4892200.0
2006-05-19 11:00:00	GLD	ETF	64.92	65.48	64.78	65.36	3055800.0
2006-05-19 12:00:00	GLD	ETF	65.35	65.58	65.12	65.56	2241900.0
2006-05-19 13:00:00	GLD	ETF	65.57	65.66	65.15	65.6	1235600.0

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

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