PREVIEW / etf_1hour / 2013-07-26

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-07-26.parquet
  size:    200 KB
  rows:    6,260

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
2013-07-26 04:00:00	SPY	ETF	168.69	168.84	168.67	168.84	31733.0
2013-07-26 05:00:00	SPY	ETF	168.79	168.84	168.34	168.38	45850.0
2013-07-26 06:00:00	SPY	ETF	168.4	168.42	168.27	168.4	104820.0
2013-07-26 07:00:00	SPY	ETF	168.42	168.46	168.11	168.11	448778.0
2013-07-26 08:00:00	SPY	ETF	168.17	168.36	167.93	167.94	883486.0
2013-07-26 09:00:00	SPY	ETF	167.94	168.44	167.93	168.3999	11724247.0
2013-07-26 10:00:00	SPY	ETF	168.39	168.55	167.52	167.655	18305335.0
2013-07-26 11:00:00	SPY	ETF	167.66	168.11	167.52	168.0699	13266251.0
2013-07-26 12:00:00	SPY	ETF	168.07	168.41	168.07	168.26	8637880.0
2013-07-26 13:00:00	SPY	ETF	168.26	168.68	168.26	168.55	8478964.0
2013-07-26 14:00:00	SPY	ETF	168.549	168.81	168.38	168.71	8597675.0
2013-07-26 15:00:00	SPY	ETF	168.72	169.16	168.62	169.13	19425945.0
2013-07-26 16:00:00	SPY	ETF	169.13	169.22	168.6	169.14	11285521.0
2013-07-26 17:00:00	SPY	ETF	169.14	169.28	169.12	169.27	267166.0
2013-07-26 18:00:00	SPY	ETF	169.25	169.26	169.08	169.17	42486.0
2013-07-26 19:00:00	SPY	ETF	169.17	169.21	169.11	169.12	21612.0
2013-07-26 04:00:00	QQQ	ETF	74.84	74.88	74.81	74.86	16400.0
2013-07-26 05:00:00	QQQ	ETF	74.88	74.88	74.66	74.66	13215.0
2013-07-26 06:00:00	QQQ	ETF	74.67	74.68	74.64	74.68	10700.0
2013-07-26 07:00:00	QQQ	ETF	74.7	74.73	74.67	74.68	82100.0
2013-07-26 08:00:00	QQQ	ETF	74.7	74.75	74.6	74.61	58153.0
2013-07-26 09:00:00	QQQ	ETF	74.6	74.93	74.57	74.9	2525282.0
2013-07-26 10:00:00	QQQ	ETF	74.9	74.94	74.55	74.6799	3936457.0
2013-07-26 11:00:00	QQQ	ETF	74.67	74.96	74.61	74.93	1919084.0
2013-07-26 12:00:00	QQQ	ETF	74.93	75.06	74.92	74.995	1887659.0
2013-07-26 13:00:00	QQQ	ETF	75.0	75.2	74.99	75.11	2349886.0
2013-07-26 14:00:00	QQQ	ETF	75.1001	75.22	75.01	75.17	1793464.0
2013-07-26 15:00:00	QQQ	ETF	75.17	75.38	75.12	75.38	4327024.0
2013-07-26 16:00:00	QQQ	ETF	75.38	75.43	74.901	75.4	1252951.0
2013-07-26 17:00:00	QQQ	ETF	75.4	75.46	75.4	75.44	3105.0
2013-07-26 18:00:00	QQQ	ETF	75.44	75.55	75.44	75.47	21738.0
2013-07-26 19:00:00	QQQ	ETF	75.47	75.5	75.46	75.49	6360.0
2013-07-26 06:00:00	IWM	ETF	104.31	104.31	104.05	104.05	7860.0
2013-07-26 07:00:00	IWM	ETF	104.1	104.15	103.96	103.98	47300.0
2013-07-26 08:00:00	IWM	ETF	103.97	104.03	103.76	103.78	223334.0
2013-07-26 09:00:00	IWM	ETF	103.77	104.12	103.74	104.09	2725899.0
2013-07-26 10:00:00	IWM	ETF	104.09	104.17	103.36	103.46	4785578.0
2013-07-26 11:00:00	IWM	ETF	103.45	103.705	103.36	103.61	3249791.0
2013-07-26 12:00:00	IWM	ETF	103.61	103.98	103.61	103.8701	2247530.0
2013-07-26 13:00:00	IWM	ETF	103.87	104.13	103.87	103.93	2157313.0
2013-07-26 14:00:00	IWM	ETF	103.94	104.08	103.76	103.99	1554663.0
2013-07-26 15:00:00	IWM	ETF	103.99	104.11	103.9	104.1	3948423.0
2013-07-26 16:00:00	IWM	ETF	104.1	104.18	104.0	104.18	1026667.0
2013-07-26 17:00:00	IWM	ETF	104.14	104.19	104.12	104.13	37500.0
2013-07-26 18:00:00	IWM	ETF	104.15	104.17	104.13	104.13	3906.0
2013-07-26 06:00:00	DIA	ETF	154.75	154.75	154.63	154.63	6500.0
2013-07-26 07:00:00	DIA	ETF	154.72	154.72	154.55	154.55	8900.0
2013-07-26 08:00:00	DIA	ETF	154.59	154.59	154.29	154.29	32602.0
2013-07-26 09:00:00	DIA	ETF	154.29	154.5899	154.27	154.54	274074.0
2013-07-26 10:00:00	DIA	ETF	154.53	154.68	153.699	153.8	1018833.0

> showing 50 of 6,260 rows — these rows as CSV

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