PREVIEW / etf_1hour / 2009-12-11

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-12-11.parquet
  size:    146 KB
  rows:    4,517

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-12-11 04:00:00	SPY	ETF	111.12	111.45	111.12	111.42	1600.0
2009-12-11 05:00:00	SPY	ETF	111.36	111.4	111.32	111.32	5500.0
2009-12-11 06:00:00	SPY	ETF	111.34	111.34	111.22	111.22	2850.0
2009-12-11 07:00:00	SPY	ETF	111.17	111.35	111.14	111.33	195063.0
2009-12-11 08:00:00	SPY	ETF	111.3	111.79	110.64	111.22	2876702.0
2009-12-11 09:00:00	SPY	ETF	111.21	111.36	110.83	111.25	21502331.0
2009-12-11 10:00:00	SPY	ETF	111.25	111.35	110.95	111.25	19550268.0
2009-12-11 11:00:00	SPY	ETF	111.2501	111.26	110.61	110.771	20284847.0
2009-12-11 12:00:00	SPY	ETF	110.78	111.1	110.77	111.09	10446816.0
2009-12-11 13:00:00	SPY	ETF	111.09	111.12	110.92	111.04	8212376.0
2009-12-11 14:00:00	SPY	ETF	111.04	111.24	110.98	111.03	10017956.0
2009-12-11 15:00:00	SPY	ETF	111.035	111.3	110.94	111.2	19273829.0
2009-12-11 16:00:00	SPY	ETF	111.2	111.36	110.7217	111.35	12214339.0
2009-12-11 17:00:00	SPY	ETF	111.35	111.4	111.32	111.33	96108.0
2009-12-11 18:00:00	SPY	ETF	111.32	111.33	111.26	111.3	34506.0
2009-12-11 19:00:00	SPY	ETF	111.3	111.38	111.3	111.38	21360.0
2009-12-11 04:00:00	QQQ	ETF	44.59	44.59	44.59	44.59	200.0
2009-12-11 06:00:00	QQQ	ETF	44.57	44.58	44.5	44.5	566.0
2009-12-11 07:00:00	QQQ	ETF	44.53	44.57	44.49	44.55	111160.0
2009-12-11 08:00:00	QQQ	ETF	44.55	44.63	44.51	44.52	2078691.0
2009-12-11 09:00:00	QQQ	ETF	44.51	44.59	44.32	44.49	10912288.0
2009-12-11 10:00:00	QQQ	ETF	44.5	44.52	44.29	44.38	8858016.0
2009-12-11 11:00:00	QQQ	ETF	44.37	44.375	43.95	44.0224	14816431.0
2009-12-11 12:00:00	QQQ	ETF	44.0201	44.2016	44.02	44.18	7813774.0
2009-12-11 13:00:00	QQQ	ETF	44.18	44.195	44.11	44.13	2120068.0
2009-12-11 14:00:00	QQQ	ETF	44.14	44.2	44.08	44.12	5259900.0
2009-12-11 15:00:00	QQQ	ETF	44.12	44.24	44.05	44.14	12094884.0
2009-12-11 16:00:00	QQQ	ETF	44.15	44.23	44.11	44.18	2385706.0
2009-12-11 17:00:00	QQQ	ETF	44.19	44.31	44.17	44.25	96918.0
2009-12-11 18:00:00	QQQ	ETF	44.24	44.26	44.24	44.24	5938.0
2009-12-11 19:00:00	QQQ	ETF	44.24	44.27	44.23	44.26	9882.0
2009-12-11 06:00:00	IWM	ETF	60.16	60.18	60.16	60.18	300.0
2009-12-11 07:00:00	IWM	ETF	60.14	60.17	60.14	60.17	8700.0
2009-12-11 08:00:00	IWM	ETF	60.15	60.4	59.97	60.11	808148.0
2009-12-11 09:00:00	IWM	ETF	60.1	60.27	59.87	60.17	9760289.0
2009-12-11 10:00:00	IWM	ETF	60.18	60.2	59.9	60.0985	8607220.0
2009-12-11 11:00:00	IWM	ETF	60.0901	60.1	59.48	59.59	8641363.0
2009-12-11 12:00:00	IWM	ETF	59.5895	60.11	59.58	60.1025	5165071.0
2009-12-11 13:00:00	IWM	ETF	60.11	60.13	60.01	60.1	3715562.0
2009-12-11 14:00:00	IWM	ETF	60.1092	60.21	59.96	60.06	3879731.0
2009-12-11 15:00:00	IWM	ETF	60.0588	60.26	60.01	60.19	5998823.0
2009-12-11 16:00:00	IWM	ETF	60.18	60.23	60.0338	60.17	1233235.0
2009-12-11 17:00:00	IWM	ETF	60.2	60.23	60.18	60.18	2036.0
2009-12-11 18:00:00	IWM	ETF	60.18	60.2	60.17	60.17	1277.0
2009-12-11 19:00:00	IWM	ETF	60.2	60.2	60.2	60.2	800.0
2009-12-11 07:00:00	DIA	ETF	104.96	104.96	104.96	104.96	400.0
2009-12-11 08:00:00	DIA	ETF	104.69	104.78	104.55	104.61	13591.0
2009-12-11 09:00:00	DIA	ETF	104.58	104.84	104.39	104.77	1534753.0
2009-12-11 10:00:00	DIA	ETF	104.77	104.91	104.5306	104.8206	1153693.0
2009-12-11 11:00:00	DIA	ETF	104.81	104.82	104.35	104.5	1169282.0

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

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