PREVIEW / etf_1hour / 2012-01-06

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-01-06.parquet
  size:    180 KB
  rows:    5,586

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
2012-01-06 04:00:00	SPY	ETF	127.69	127.86	127.69	127.8	1000.0
2012-01-06 05:00:00	SPY	ETF	127.84	127.84	127.76	127.8	6000.0
2012-01-06 06:00:00	SPY	ETF	127.75	127.95	127.61	127.94	17049.0
2012-01-06 07:00:00	SPY	ETF	127.95	128.07	127.88	127.95	172917.0
2012-01-06 08:00:00	SPY	ETF	127.95	128.7	127.4	128.11	8562362.0
2012-01-06 09:00:00	SPY	ETF	128.11	128.27	127.29	127.44	24799995.0
2012-01-06 10:00:00	SPY	ETF	127.44	127.94	127.32	127.7	26052823.0
2012-01-06 11:00:00	SPY	ETF	127.7	128.16	127.6911	128.04	14341581.0
2012-01-06 12:00:00	SPY	ETF	128.03	128.09	127.73	127.82	12363915.0
2012-01-06 13:00:00	SPY	ETF	127.82	128.14	127.64	128.0	12554579.0
2012-01-06 14:00:00	SPY	ETF	128.0	128.08	127.83	127.85	10421714.0
2012-01-06 15:00:00	SPY	ETF	127.85	127.96	127.65	127.79	25297567.0
2012-01-06 16:00:00	SPY	ETF	127.8	128.0756	127.5448	127.97	10899581.0
2012-01-06 17:00:00	SPY	ETF	127.94	127.96	127.82	127.91	193545.0
2012-01-06 18:00:00	SPY	ETF	127.82	127.94	127.82	127.9	1629177.0
2012-01-06 19:00:00	SPY	ETF	127.89	127.92	127.78	127.9	84844.0
2012-01-06 05:00:00	QQQ	ETF	57.57	57.57	57.55	57.55	1100.0
2012-01-06 06:00:00	QQQ	ETF	57.46	57.61	57.46	57.6	5116.0
2012-01-06 07:00:00	QQQ	ETF	57.62	57.62	57.55	57.56	186600.0
2012-01-06 08:00:00	QQQ	ETF	57.55	57.79	57.53	57.56	1016462.0
2012-01-06 09:00:00	QQQ	ETF	57.56	57.69	57.4	57.49	4503970.0
2012-01-06 10:00:00	QQQ	ETF	57.489	57.71	57.42	57.59	6891028.0
2012-01-06 11:00:00	QQQ	ETF	57.6	57.87	57.6	57.8	6672052.0
2012-01-06 12:00:00	QQQ	ETF	57.805	57.84	57.71	57.73	3372738.0
2012-01-06 13:00:00	QQQ	ETF	57.73	57.94	57.68	57.849	5880655.0
2012-01-06 14:00:00	QQQ	ETF	57.845	57.89	57.79	57.81	4578618.0
2012-01-06 15:00:00	QQQ	ETF	57.81	57.87	57.72	57.79	5597821.0
2012-01-06 16:00:00	QQQ	ETF	57.78	57.85	57.77	57.84	780707.0
2012-01-06 17:00:00	QQQ	ETF	57.84	57.84	57.8	57.81	20200.0
2012-01-06 18:00:00	QQQ	ETF	57.84	57.85	57.79	57.79	16617.0
2012-01-06 19:00:00	QQQ	ETF	57.83	57.85	57.83	57.84	7650.0
2012-01-06 06:00:00	IWM	ETF	74.57	74.69	74.55	74.69	1424.0
2012-01-06 07:00:00	IWM	ETF	74.78	74.83	74.78	74.78	3600.0
2012-01-06 08:00:00	IWM	ETF	74.88	75.45	74.82	74.94	1283973.0
2012-01-06 09:00:00	IWM	ETF	74.95	75.06	74.27	74.41	5678556.0
2012-01-06 10:00:00	IWM	ETF	74.4	75.16	74.28	74.97	6463620.0
2012-01-06 11:00:00	IWM	ETF	74.98	75.38	74.98	75.279	4488160.0
2012-01-06 12:00:00	IWM	ETF	75.275	75.31	74.91	74.92	3940208.0
2012-01-06 13:00:00	IWM	ETF	74.92	75.29	74.72	75.1481	4228443.0
2012-01-06 14:00:00	IWM	ETF	75.145	75.29	74.99	75.03	3145067.0
2012-01-06 15:00:00	IWM	ETF	75.02	75.17	74.76	74.79	5679680.0
2012-01-06 16:00:00	IWM	ETF	74.8	75.0481	74.77	74.83	4164252.0
2012-01-06 17:00:00	IWM	ETF	74.84	74.89	74.83	74.85	3670.0
2012-01-06 18:00:00	IWM	ETF	74.82	74.82	74.82	74.82	1561000.0
2012-01-06 19:00:00	IWM	ETF	74.88	74.89	74.83	74.83	896.0
2012-01-06 08:00:00	DIA	ETF	123.98	124.5	123.93	123.98	93128.0
2012-01-06 09:00:00	DIA	ETF	123.99	124.08	123.14	123.29	618803.0
2012-01-06 10:00:00	DIA	ETF	123.2857	123.65	123.19	123.43	640976.0
2012-01-06 11:00:00	DIA	ETF	123.44	123.88	123.44	123.768	607635.0
2012-01-06 12:00:00	DIA	ETF	123.76	123.84	123.5	123.57	323346.0

> showing 50 of 5,586 rows — these rows as CSV

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