PREVIEW / etf_1hour / 2010-03-23

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-03-23.parquet
  size:    154 KB
  rows:    4,801

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-23 04:00:00	SPY	ETF	116.87	116.88	116.87	116.88	200.0
2010-03-23 05:00:00	SPY	ETF	116.8	116.9	116.8	116.89	1400.0
2010-03-23 06:00:00	SPY	ETF	116.885	116.885	116.84	116.84	14025.0
2010-03-23 07:00:00	SPY	ETF	116.84	116.84	116.56	116.58	312386.0
2010-03-23 08:00:00	SPY	ETF	116.57	116.74	116.54	116.74	1713261.0
2010-03-23 09:00:00	SPY	ETF	116.74	116.86	116.43	116.631	17412737.0
2010-03-23 10:00:00	SPY	ETF	116.63	116.97	116.51	116.59	32511938.0
2010-03-23 11:00:00	SPY	ETF	116.5825	116.78	116.38	116.74	27087687.0
2010-03-23 12:00:00	SPY	ETF	116.75	116.95	116.705	116.79	15100876.0
2010-03-23 13:00:00	SPY	ETF	116.7801	116.99	116.7	116.7	13277055.0
2010-03-23 14:00:00	SPY	ETF	116.7	117.03	116.5837	116.98	15989551.0
2010-03-23 15:00:00	SPY	ETF	116.97	117.51	116.92	117.42	44881812.0
2010-03-23 16:00:00	SPY	ETF	117.42	117.4619	116.55	117.43	9881424.0
2010-03-23 17:00:00	SPY	ETF	117.42	117.47	117.39	117.4	144050.0
2010-03-23 18:00:00	SPY	ETF	117.35	117.47	117.35	117.42	120587.0
2010-03-23 19:00:00	SPY	ETF	117.44	117.44	117.38	117.4	195713.0
2010-03-23 04:00:00	QQQ	ETF	47.95	47.95	47.95	47.95	1211.0
2010-03-23 06:00:00	QQQ	ETF	48.02	48.03	48.02	48.03	300.0
2010-03-23 07:00:00	QQQ	ETF	48.02	48.02	47.93	47.94	78311.0
2010-03-23 08:00:00	QQQ	ETF	47.92	48.03	47.92	48.02	319444.0
2010-03-23 09:00:00	QQQ	ETF	48.03	48.075	47.87	47.98	6506841.0
2010-03-23 10:00:00	QQQ	ETF	47.9701	48.08	47.84	47.8716	11857991.0
2010-03-23 11:00:00	QQQ	ETF	47.87	47.97	47.77	47.95	7924218.0
2010-03-23 12:00:00	QQQ	ETF	47.95	48.02	47.93	47.98	4729183.0
2010-03-23 13:00:00	QQQ	ETF	47.98	48.07	47.94	47.95	4839862.0
2010-03-23 14:00:00	QQQ	ETF	47.95	48.12	47.94	48.11	6959926.0
2010-03-23 15:00:00	QQQ	ETF	48.1099	48.3	48.08	48.26	13360925.0
2010-03-23 16:00:00	QQQ	ETF	48.26	48.3	48.0029	48.29	2003414.0
2010-03-23 17:00:00	QQQ	ETF	48.3	48.3	48.26	48.28	79199.0
2010-03-23 18:00:00	QQQ	ETF	48.28	48.31	48.28	48.3	29113.0
2010-03-23 19:00:00	QQQ	ETF	48.3	48.3	48.27	48.29	44850.0
2010-03-23 07:00:00	IWM	ETF	68.48	68.48	68.34	68.37	151800.0
2010-03-23 08:00:00	IWM	ETF	68.37	68.47	68.34	68.44	310757.0
2010-03-23 09:00:00	IWM	ETF	68.44	68.55	68.19	68.45	6155207.0
2010-03-23 10:00:00	IWM	ETF	68.46	68.63	68.22	68.28	11758889.0
2010-03-23 11:00:00	IWM	ETF	68.28	68.48	68.11	68.47	6981097.0
2010-03-23 12:00:00	IWM	ETF	68.48	68.64	68.45	68.53	3954826.0
2010-03-23 13:00:00	IWM	ETF	68.53	68.73	68.51	68.55	4026036.0
2010-03-23 14:00:00	IWM	ETF	68.55	68.82	68.55	68.81	5317064.0
2010-03-23 15:00:00	IWM	ETF	68.8	69.25	68.75	69.22	16476676.0
2010-03-23 16:00:00	IWM	ETF	69.22	69.26	68.4035	69.1	3709641.0
2010-03-23 17:00:00	IWM	ETF	69.12	69.17	69.0464	69.1	266044.0
2010-03-23 18:00:00	IWM	ETF	69.17	69.34	69.17	69.28	8050.0
2010-03-23 19:00:00	IWM	ETF	69.22	69.27	69.14	69.15	6597.0
2010-03-23 06:00:00	DIA	ETF	108.03	108.03	108.03	108.03	150.0
2010-03-23 07:00:00	DIA	ETF	107.86	107.86	107.86	107.86	150.0
2010-03-23 08:00:00	DIA	ETF	107.82	107.94	107.82	107.92	29682.0
2010-03-23 09:00:00	DIA	ETF	107.99	108.11	107.84	108.06	581646.0
2010-03-23 10:00:00	DIA	ETF	108.04	108.34	107.99	108.04	1756256.0
2010-03-23 11:00:00	DIA	ETF	108.03	108.24	107.89	108.22	1101644.0

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

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