PREVIEW / etf_1hour / 2008-05-30

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-05-30.parquet
  size:    103 KB
  rows:    3,372

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
2008-05-30 04:00:00	SPY	ETF	139.96	140.12	139.96	140.12	3500.0
2008-05-30 05:00:00	SPY	ETF	140.15	140.29	140.15	140.22	27000.0
2008-05-30 06:00:00	SPY	ETF	140.3	140.37	140.21	140.37	37900.0
2008-05-30 07:00:00	SPY	ETF	140.3	140.35	140.2	140.27	254767.0
2008-05-30 08:00:00	SPY	ETF	140.26	140.64	140.22	140.45	3838507.0
2008-05-30 09:00:00	SPY	ETF	140.45	140.58	140.125	140.22	14986122.0
2008-05-30 10:00:00	SPY	ETF	140.22	140.7	140.12	140.32	19721603.0
2008-05-30 11:00:00	SPY	ETF	140.32	140.51	140.05	140.47	15352078.0
2008-05-30 12:00:00	SPY	ETF	140.48	140.57	140.33	140.47	9153764.0
2008-05-30 13:00:00	SPY	ETF	140.47	140.7	140.31	140.57	8324672.0
2008-05-30 14:00:00	SPY	ETF	140.57	140.64	140.36	140.58	10004030.0
2008-05-30 15:00:00	SPY	ETF	140.58	140.74	140.08	140.11	24523934.0
2008-05-30 16:00:00	SPY	ETF	140.21	140.48	140.07	140.47	5908128.0
2008-05-30 17:00:00	SPY	ETF	140.47	140.56	140.3	140.34	168318.0
2008-05-30 18:00:00	SPY	ETF	140.38	140.44	140.38	140.44	12700.0
2008-05-30 19:00:00	SPY	ETF	140.4	140.42	140.4	140.4	6093.0
2008-05-30 20:00:00	SPY	ETF	140.4	140.4	140.4	140.4	500.0
2008-05-30 06:00:00	QQQ	ETF	49.91	49.95	49.91	49.93	5100.0
2008-05-30 07:00:00	QQQ	ETF	49.93	49.96	49.9	49.9	149105.0
2008-05-30 08:00:00	QQQ	ETF	49.91	50.04	49.89	49.98	2352502.0
2008-05-30 09:00:00	QQQ	ETF	49.98	49.98	49.75	49.92	12683613.0
2008-05-30 10:00:00	QQQ	ETF	49.92	50.11	49.88	50.0	15558526.0
2008-05-30 11:00:00	QQQ	ETF	50.01	50.1	49.92	50.07	11958347.0
2008-05-30 12:00:00	QQQ	ETF	50.08	50.12	50.0	50.1	8079023.0
2008-05-30 13:00:00	QQQ	ETF	50.11	50.21	50.03	50.13	8815330.0
2008-05-30 14:00:00	QQQ	ETF	50.14	50.21	50.045	50.1901	7449496.0
2008-05-30 15:00:00	QQQ	ETF	50.191	50.24	49.96	49.98	19029269.0
2008-05-30 16:00:00	QQQ	ETF	49.98	50.1357	49.6914	50.07	6187993.0
2008-05-30 17:00:00	QQQ	ETF	50.07	50.09	50.04	50.06	27680.0
2008-05-30 18:00:00	QQQ	ETF	50.07	50.07	50.06	50.06	3900.0
2008-05-30 19:00:00	QQQ	ETF	50.08	50.13	50.07	50.07	130779.0
2008-05-30 07:00:00	IWM	ETF	74.46	74.56	74.45	74.54	32300.0
2008-05-30 08:00:00	IWM	ETF	74.54	74.68	74.54	74.58	231487.0
2008-05-30 09:00:00	IWM	ETF	74.6	74.61	74.15	74.25	4962956.0
2008-05-30 10:00:00	IWM	ETF	74.26	74.61	74.15	74.44	6983282.0
2008-05-30 11:00:00	IWM	ETF	74.44	74.51	74.23	74.47	5163923.0
2008-05-30 12:00:00	IWM	ETF	74.47	74.56	74.41	74.49	1481610.0
2008-05-30 13:00:00	IWM	ETF	74.49	74.64	74.38	74.59	1972775.0
2008-05-30 14:00:00	IWM	ETF	74.59	74.77	74.49	74.74	3858142.0
2008-05-30 15:00:00	IWM	ETF	74.72	74.81	74.49	74.5	7784213.0
2008-05-30 16:00:00	IWM	ETF	74.49	74.9	74.46	74.8	7824901.0
2008-05-30 17:00:00	IWM	ETF	74.8	74.8	74.8	74.8	2000.0
2008-05-30 19:00:00	IWM	ETF	74.8	74.8	74.8	74.8	150.0
2008-05-30 06:00:00	DIA	ETF	126.42	126.54	126.42	126.54	200.0
2008-05-30 07:00:00	DIA	ETF	126.57	126.6	126.55	126.55	1200.0
2008-05-30 08:00:00	DIA	ETF	126.56	126.78	126.5	126.72	136050.0
2008-05-30 09:00:00	DIA	ETF	126.74	126.74	126.32	126.42	917716.0
2008-05-30 10:00:00	DIA	ETF	126.41	126.85	126.25	126.53	1190658.0
2008-05-30 11:00:00	DIA	ETF	126.53	126.59	126.27	126.55	1734484.0
2008-05-30 12:00:00	DIA	ETF	126.55	126.67	126.38	126.54	479941.0

> showing 50 of 3,372 rows — these rows as CSV

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