PREVIEW / etf_1hour / 2009-09-15

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-09-15.parquet
  size:    142 KB
  rows:    4,381

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
2009-09-15 05:00:00	SPY	ETF	104.87	104.97	104.86	104.97	4000.0
2009-09-15 06:00:00	SPY	ETF	105.03	105.18	105.03	105.18	9200.0
2009-09-15 07:00:00	SPY	ETF	105.17	105.37	105.02	105.35	415438.0
2009-09-15 08:00:00	SPY	ETF	105.35	105.78	105.0	105.51	5563599.0
2009-09-15 09:00:00	SPY	ETF	105.51	105.67	105.12	105.29	28509210.0
2009-09-15 10:00:00	SPY	ETF	105.29	105.62	104.76	105.45	41856646.0
2009-09-15 11:00:00	SPY	ETF	105.44	105.54	105.1	105.42	18618764.0
2009-09-15 12:00:00	SPY	ETF	105.43	105.64	105.35	105.62	10799162.0
2009-09-15 13:00:00	SPY	ETF	105.61	105.91	105.57	105.8778	15755297.0
2009-09-15 14:00:00	SPY	ETF	105.87	105.9	105.5	105.73	15844815.0
2009-09-15 15:00:00	SPY	ETF	105.74	106.11	105.64	105.72	39192462.0
2009-09-15 16:00:00	SPY	ETF	105.72	106.1	105.08	105.42	16587153.0
2009-09-15 17:00:00	SPY	ETF	105.43	105.52	105.4	105.49	81377.0
2009-09-15 18:00:00	SPY	ETF	105.47	105.74	105.45	105.59	94080.0
2009-09-15 19:00:00	SPY	ETF	105.59	105.6	105.49	105.6	60587.0
2009-09-15 05:00:00	QQQ	ETF	41.48	41.49	41.48	41.48	1700.0
2009-09-15 06:00:00	QQQ	ETF	41.56	41.61	41.56	41.61	1100.0
2009-09-15 07:00:00	QQQ	ETF	41.62	41.66	41.52	41.65	71170.0
2009-09-15 08:00:00	QQQ	ETF	41.64	41.79	41.54	41.64	3860779.0
2009-09-15 09:00:00	QQQ	ETF	41.65	41.88	41.57	41.73	16327700.0
2009-09-15 10:00:00	QQQ	ETF	41.74	41.84	41.57	41.8286	19467441.0
2009-09-15 11:00:00	QQQ	ETF	41.8297	41.86	41.68	41.82	5559478.0
2009-09-15 12:00:00	QQQ	ETF	41.82	41.86	41.76	41.84	3830288.0
2009-09-15 13:00:00	QQQ	ETF	41.84	41.91	41.82	41.9	6119501.0
2009-09-15 14:00:00	QQQ	ETF	41.8999	41.9	41.77	41.8201	5669016.0
2009-09-15 15:00:00	QQQ	ETF	41.83	41.95	41.79	41.81	18771709.0
2009-09-15 16:00:00	QQQ	ETF	41.81	41.877	41.73	41.75	2539952.0
2009-09-15 17:00:00	QQQ	ETF	41.75	41.78	41.75	41.75	35543.0
2009-09-15 18:00:00	QQQ	ETF	41.75	41.85	41.75	41.82	105875.0
2009-09-15 19:00:00	QQQ	ETF	41.82	41.83	41.8	41.82	63200.0
2009-09-15 07:00:00	IWM	ETF	59.85	59.96	59.77	59.96	9193.0
2009-09-15 08:00:00	IWM	ETF	59.99	60.26	59.91	60.0	890438.0
2009-09-15 09:00:00	IWM	ETF	60.0	60.32	59.91	60.07	8276433.0
2009-09-15 10:00:00	IWM	ETF	60.07	60.24	59.77	60.22	9778819.0
2009-09-15 11:00:00	IWM	ETF	60.22	60.3	60.02	60.24	2585914.0
2009-09-15 12:00:00	IWM	ETF	60.23	60.4	60.21	60.39	1796746.0
2009-09-15 13:00:00	IWM	ETF	60.398	60.66	60.3601	60.64	3826507.0
2009-09-15 14:00:00	IWM	ETF	60.64	60.69	60.4	60.51	3166343.0
2009-09-15 15:00:00	IWM	ETF	60.51	60.72	60.42	60.56	8012160.0
2009-09-15 16:00:00	IWM	ETF	60.56	60.57	60.1082	60.1082	4098628.0
2009-09-15 17:00:00	IWM	ETF	60.38	60.44	60.37	60.42	4424.0
2009-09-15 18:00:00	IWM	ETF	60.4	60.4	60.4	60.4	300.0
2009-09-15 07:00:00	DIA	ETF	96.22	96.39	96.22	96.39	13100.0
2009-09-15 08:00:00	DIA	ETF	96.28	96.67	96.14	96.52	52703.0
2009-09-15 09:00:00	DIA	ETF	96.53	96.67	96.26	96.431	1823003.0
2009-09-15 10:00:00	DIA	ETF	96.41	96.55	95.96	96.53	3281920.0
2009-09-15 11:00:00	DIA	ETF	96.54	96.65	96.27	96.58	956111.0
2009-09-15 12:00:00	DIA	ETF	96.58	96.8	96.5	96.77	996583.0
2009-09-15 13:00:00	DIA	ETF	96.77	97.1	96.72	97.0894	1260863.0
2009-09-15 14:00:00	DIA	ETF	97.08	97.1	96.83	96.97	1099638.0

> showing 50 of 4,381 rows — these rows as CSV

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