PREVIEW / etf_1hour / 2010-03-17

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-03-17.parquet
  size:    156 KB
  rows:    4,877

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
2010-03-17 04:00:00	SPY	ETF	116.61	116.72	116.61	116.7	2300.0
2010-03-17 05:00:00	SPY	ETF	116.63	116.72	116.63	116.72	7684.0
2010-03-17 06:00:00	SPY	ETF	116.77	116.85	116.75	116.8	45800.0
2010-03-17 07:00:00	SPY	ETF	116.8	116.82	116.65	116.65	339465.0
2010-03-17 08:00:00	SPY	ETF	116.66	116.73	116.54	116.71	1940091.0
2010-03-17 09:00:00	SPY	ETF	116.72	117.06	116.66	117.03	19836224.0
2010-03-17 10:00:00	SPY	ETF	117.03	117.09	116.81	116.9874	29226787.0
2010-03-17 11:00:00	SPY	ETF	116.99	117.22	116.93	117.08	20707149.0
2010-03-17 12:00:00	SPY	ETF	117.08	117.15	116.95	117.12	11045731.0
2010-03-17 13:00:00	SPY	ETF	117.13	117.48	117.11	117.36	21299296.0
2010-03-17 14:00:00	SPY	ETF	117.36	117.45	116.96	116.96	22498476.0
2010-03-17 15:00:00	SPY	ETF	116.97	117.13	116.73	117.1	35427463.0
2010-03-17 16:00:00	SPY	ETF	117.11	117.25	116.4182	117.25	10521063.0
2010-03-17 17:00:00	SPY	ETF	117.17	117.18	116.4197	117.1	2788519.0
2010-03-17 18:00:00	SPY	ETF	117.11	117.17	117.1	117.1	143321.0
2010-03-17 19:00:00	SPY	ETF	117.1	117.32	117.1	117.28	121747.0
2010-03-17 06:00:00	QQQ	ETF	47.63	47.64	47.63	47.64	600.0
2010-03-17 07:00:00	QQQ	ETF	47.65	47.65	47.6	47.6	12880.0
2010-03-17 08:00:00	QQQ	ETF	47.6	47.69	47.55	47.59	1126952.0
2010-03-17 09:00:00	QQQ	ETF	47.59	47.76	47.57	47.72	10773229.0
2010-03-17 10:00:00	QQQ	ETF	47.73	47.75	47.65	47.73	10370289.0
2010-03-17 11:00:00	QQQ	ETF	47.725	47.81	47.7	47.7462	6582343.0
2010-03-17 12:00:00	QQQ	ETF	47.75	47.79	47.73	47.77	3573446.0
2010-03-17 13:00:00	QQQ	ETF	47.7675	47.9	47.5583	47.8299	9176240.0
2010-03-17 14:00:00	QQQ	ETF	47.83	47.845	47.59	47.6	7259845.0
2010-03-17 15:00:00	QQQ	ETF	47.5901	47.69	47.53	47.66	12141018.0
2010-03-17 16:00:00	QQQ	ETF	47.66	47.7518	47.5583	47.66	9671804.0
2010-03-17 17:00:00	QQQ	ETF	47.67	47.68	47.64	47.65	87414.0
2010-03-17 18:00:00	QQQ	ETF	47.66	47.69	47.66	47.68	69640.0
2010-03-17 19:00:00	QQQ	ETF	47.68	47.71	47.66	47.7	8537.0
2010-03-17 04:00:00	IWM	ETF	68.2	68.2	68.2	68.2	100.0
2010-03-17 06:00:00	IWM	ETF	68.29	68.29	68.29	68.29	100.0
2010-03-17 07:00:00	IWM	ETF	68.3	68.42	68.24	68.25	145880.0
2010-03-17 08:00:00	IWM	ETF	68.23	68.31	68.2	68.27	177821.0
2010-03-17 09:00:00	IWM	ETF	68.27	68.59	68.1	68.54	7244160.0
2010-03-17 10:00:00	IWM	ETF	68.53	68.58	68.34	68.51	7549917.0
2010-03-17 11:00:00	IWM	ETF	68.52	68.61	68.45	68.52	3671713.0
2010-03-17 12:00:00	IWM	ETF	68.52	68.59	68.48	68.53	3497367.0
2010-03-17 13:00:00	IWM	ETF	68.539	68.88	68.5	68.8	6195884.0
2010-03-17 14:00:00	IWM	ETF	68.8	68.83	68.55	68.59	6941261.0
2010-03-17 15:00:00	IWM	ETF	68.59	68.67	68.39	68.48	10564149.0
2010-03-17 16:00:00	IWM	ETF	68.47	68.548	68.0658	68.46	4684346.0
2010-03-17 17:00:00	IWM	ETF	68.47	68.5	68.41	68.41	15800.0
2010-03-17 18:00:00	IWM	ETF	68.47	68.47	68.47	68.47	200.0
2010-03-17 19:00:00	IWM	ETF	68.5	68.5	68.5	68.5	2300.0
2010-03-17 06:00:00	DIA	ETF	107.35	107.4	107.35	107.4	200.0
2010-03-17 07:00:00	DIA	ETF	107.37	107.37	107.3	107.3	550.0
2010-03-17 08:00:00	DIA	ETF	107.23	107.25	107.16	107.25	13726.0
2010-03-17 09:00:00	DIA	ETF	107.26	107.47	107.2	107.45	715161.0
2010-03-17 10:00:00	DIA	ETF	107.45	107.5	107.28	107.445	1132221.0

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

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