PREVIEW / etf_1hour / 2012-08-10

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-08-10.parquet
  size:    177 KB
  rows:    5,490

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-08-10 04:00:00	SPY	ETF	140.19	140.33	140.14	140.24	9156.0
2012-08-10 05:00:00	SPY	ETF	140.23	140.31	140.14	140.21	35700.0
2012-08-10 06:00:00	SPY	ETF	140.22	140.25	140.01	140.02	182002.0
2012-08-10 07:00:00	SPY	ETF	140.05	140.1	139.98	140.04	270316.0
2012-08-10 08:00:00	SPY	ETF	140.04	140.21	139.98	140.12	842847.0
2012-08-10 09:00:00	SPY	ETF	140.1	140.22	139.81	140.04	12801838.0
2012-08-10 10:00:00	SPY	ETF	140.04	140.49	139.91	140.4	17934484.0
2012-08-10 11:00:00	SPY	ETF	140.4	140.46	139.97	140.41	16199942.0
2012-08-10 12:00:00	SPY	ETF	140.41	140.574	140.26	140.31	8851714.0
2012-08-10 13:00:00	SPY	ETF	140.32	140.46	140.17	140.4	9239855.0
2012-08-10 14:00:00	SPY	ETF	140.39	140.5	140.31	140.45	7851274.0
2012-08-10 15:00:00	SPY	ETF	140.45	140.89	140.43	140.84	19379557.0
2012-08-10 16:00:00	SPY	ETF	140.85	140.97	140.23	140.71	5664258.0
2012-08-10 17:00:00	SPY	ETF	140.71	140.79	140.71	140.75	50299.0
2012-08-10 18:00:00	SPY	ETF	140.74	140.79	140.74	140.78	22868.0
2012-08-10 19:00:00	SPY	ETF	140.79	140.87	140.77	140.87	32517.0
2012-08-10 04:00:00	QQQ	ETF	66.71	66.71	66.65	66.65	1600.0
2012-08-10 05:00:00	QQQ	ETF	66.63	66.63	66.63	66.63	100.0
2012-08-10 06:00:00	QQQ	ETF	66.62	66.62	66.59	66.59	1700.0
2012-08-10 07:00:00	QQQ	ETF	66.59	66.6	66.52	66.57	80737.0
2012-08-10 08:00:00	QQQ	ETF	66.57	66.64	66.52	66.61	138341.0
2012-08-10 09:00:00	QQQ	ETF	66.62	66.66	66.41	66.5	3046968.0
2012-08-10 10:00:00	QQQ	ETF	66.5	66.71	66.46	66.69	3451737.0
2012-08-10 11:00:00	QQQ	ETF	66.69	66.73	66.51	66.682	2888967.0
2012-08-10 12:00:00	QQQ	ETF	66.6899	66.69	66.6	66.63	1397096.0
2012-08-10 13:00:00	QQQ	ETF	66.6301	66.69	66.58	66.67	1667843.0
2012-08-10 14:00:00	QQQ	ETF	66.67	66.71	66.62	66.67	1003572.0
2012-08-10 15:00:00	QQQ	ETF	66.6701	66.88	66.6526	66.87	3719926.0
2012-08-10 16:00:00	QQQ	ETF	66.85	66.97	66.5454	66.93	1056734.0
2012-08-10 17:00:00	QQQ	ETF	66.9	66.93	66.88	66.9	17200.0
2012-08-10 18:00:00	QQQ	ETF	66.9	66.94	66.9	66.94	9020.0
2012-08-10 19:00:00	QQQ	ETF	66.94	66.95	66.93	66.94	3083.0
2012-08-10 07:00:00	IWM	ETF	79.91	79.91	79.86	79.88	2600.0
2012-08-10 08:00:00	IWM	ETF	79.88	79.95	79.79	79.92	110015.0
2012-08-10 09:00:00	IWM	ETF	79.94	79.98	79.56	79.72	5312948.0
2012-08-10 10:00:00	IWM	ETF	79.71	79.95	79.565	79.84	3588591.0
2012-08-10 11:00:00	IWM	ETF	79.85	79.94	79.5	79.88	2887460.0
2012-08-10 12:00:00	IWM	ETF	79.88	79.91	79.64	79.72	1714993.0
2012-08-10 13:00:00	IWM	ETF	79.7059	79.88	79.63	79.86	2273511.0
2012-08-10 14:00:00	IWM	ETF	79.86	79.88	79.79	79.85	1418591.0
2012-08-10 15:00:00	IWM	ETF	79.85	80.05	79.78	79.94	4767732.0
2012-08-10 16:00:00	IWM	ETF	79.94	80.04	79.86	79.86	2615297.0
2012-08-10 17:00:00	IWM	ETF	79.86	79.87	79.85	79.85	14900.0
2012-08-10 19:00:00	IWM	ETF	79.93	79.99	79.91	79.99	7800.0
2012-08-10 07:00:00	DIA	ETF	131.13	131.13	131.13	131.13	100.0
2012-08-10 08:00:00	DIA	ETF	131.21	131.28	131.11	131.25	10463.0
2012-08-10 09:00:00	DIA	ETF	131.26	131.32	130.79	130.93	525977.0
2012-08-10 10:00:00	DIA	ETF	130.93	131.46	130.88	131.37	841605.0
2012-08-10 11:00:00	DIA	ETF	131.38	131.42	130.97	131.39	589838.0
2012-08-10 12:00:00	DIA	ETF	131.4	131.43	131.26	131.28	204355.0

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

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