PREVIEW / etf_1hour / 2008-05-08

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-05-08.parquet
  size:    104 KB
  rows:    3,317

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-08 04:00:00	SPY	ETF	139.87	139.87	139.87	139.87	100.0
2008-05-08 05:00:00	SPY	ETF	139.97	139.98	139.91	139.91	7100.0
2008-05-08 06:00:00	SPY	ETF	139.9	140.09	139.9	140.06	93800.0
2008-05-08 07:00:00	SPY	ETF	140.05	140.18	139.92	140.02	597498.0
2008-05-08 08:00:00	SPY	ETF	140.12	140.22	139.69	139.76	3459215.0
2008-05-08 09:00:00	SPY	ETF	139.77	140.02	139.45	139.73	17031175.0
2008-05-08 10:00:00	SPY	ETF	139.73	139.73	138.98	139.36	32505573.0
2008-05-08 11:00:00	SPY	ETF	139.36	139.95	139.26	139.7	28782243.0
2008-05-08 12:00:00	SPY	ETF	139.7	139.8	139.31	139.6	14806055.0
2008-05-08 13:00:00	SPY	ETF	139.6	140.32	139.31	140.29	24695943.0
2008-05-08 14:00:00	SPY	ETF	140.29	140.3	139.45	139.54	19902821.0
2008-05-08 15:00:00	SPY	ETF	139.53	140.0	139.24	139.84	25417562.0
2008-05-08 16:00:00	SPY	ETF	139.869	140.35	138.98	138.99	7170199.0
2008-05-08 17:00:00	SPY	ETF	138.98	139.16	138.98	139.1	1848729.0
2008-05-08 18:00:00	SPY	ETF	139.07	139.13	138.97	139.13	39971.0
2008-05-08 19:00:00	SPY	ETF	139.1	139.22	139.1	139.22	19647.0
2008-05-08 06:00:00	QQQ	ETF	48.25	48.3	48.25	48.3	1100.0
2008-05-08 07:00:00	QQQ	ETF	48.23	48.28	48.22	48.26	253257.0
2008-05-08 08:00:00	QQQ	ETF	48.25	48.29	48.2	48.22	835824.0
2008-05-08 09:00:00	QQQ	ETF	48.22	48.37	48.13	48.249	15491833.0
2008-05-08 10:00:00	QQQ	ETF	48.25	48.33	48.06	48.29	24079900.0
2008-05-08 11:00:00	QQQ	ETF	48.29	48.58	48.27	48.44	19564236.0
2008-05-08 12:00:00	QQQ	ETF	48.44	48.5	48.22	48.35	9127910.0
2008-05-08 13:00:00	QQQ	ETF	48.35	48.7	48.15	48.69	11767378.0
2008-05-08 14:00:00	QQQ	ETF	48.68	48.69	48.22	48.31	15072428.0
2008-05-08 15:00:00	QQQ	ETF	48.31	48.42	48.17	48.41	18866997.0
2008-05-08 16:00:00	QQQ	ETF	48.41	48.43	48.0041	48.16	9060727.0
2008-05-08 17:00:00	QQQ	ETF	48.15	48.23	48.15	48.22	190799.0
2008-05-08 18:00:00	QQQ	ETF	48.22	48.22	48.12	48.18	25546.0
2008-05-08 19:00:00	QQQ	ETF	48.18	48.25	48.18	48.23	21278.0
2008-05-08 05:00:00	IWM	ETF	71.83	71.83	71.83	71.83	3000.0
2008-05-08 06:00:00	IWM	ETF	71.86	71.91	71.86	71.91	13000.0
2008-05-08 07:00:00	IWM	ETF	71.89	71.92	71.78	71.78	126344.0
2008-05-08 08:00:00	IWM	ETF	71.78	71.91	71.65	71.7	345274.0
2008-05-08 09:00:00	IWM	ETF	71.71	71.82	71.46	71.51	4613118.0
2008-05-08 10:00:00	IWM	ETF	71.5	71.51	71.19	71.35	11183618.0
2008-05-08 11:00:00	IWM	ETF	71.35	71.7	71.23	71.45	8837523.0
2008-05-08 12:00:00	IWM	ETF	71.46	71.59	71.35	71.45	5091596.0
2008-05-08 13:00:00	IWM	ETF	71.45	71.97	71.42	71.93	7140129.0
2008-05-08 14:00:00	IWM	ETF	71.93	71.94	71.41	71.45	5626534.0
2008-05-08 15:00:00	IWM	ETF	71.45	71.8	71.31	71.79	8969763.0
2008-05-08 16:00:00	IWM	ETF	71.79	71.81	71.38	71.41	6353911.0
2008-05-08 17:00:00	IWM	ETF	71.41	71.41	71.38	71.41	2127.0
2008-05-08 18:00:00	IWM	ETF	71.39	71.39	71.39	71.39	1460.0
2008-05-08 19:00:00	IWM	ETF	71.36	71.49	71.34	71.49	450.0
2008-05-08 04:00:00	DIA	ETF	128.61	128.61	128.61	128.61	100.0
2008-05-08 06:00:00	DIA	ETF	128.72	128.73	128.7	128.7	400.0
2008-05-08 07:00:00	DIA	ETF	128.75	128.86	128.75	128.81	3300.0
2008-05-08 08:00:00	DIA	ETF	128.81	128.89	128.57	128.61	22966.0
2008-05-08 09:00:00	DIA	ETF	128.66	128.87	128.31	128.66	1087245.0

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

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