PREVIEW / etf_1hour / 2013-07-29

all etf 1-hour files

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

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-29 04:00:00	SPY	ETF	169.07	169.07	168.54	168.73	24430.0
2013-07-29 05:00:00	SPY	ETF	168.74	168.9	168.6	168.63	51100.0
2013-07-29 06:00:00	SPY	ETF	168.68	168.85	168.56	168.85	112020.0
2013-07-29 07:00:00	SPY	ETF	168.83	168.85	168.65	168.81	173152.0
2013-07-29 08:00:00	SPY	ETF	168.83	168.83	168.67	168.73	350710.0
2013-07-29 09:00:00	SPY	ETF	168.72	169.06	168.62	168.87	10136333.0
2013-07-29 10:00:00	SPY	ETF	168.87	168.92	168.48	168.6987	14372148.0
2013-07-29 11:00:00	SPY	ETF	168.69	168.74	168.11	168.285	13256313.0
2013-07-29 12:00:00	SPY	ETF	168.28	168.53	168.22	168.46	6620833.0
2013-07-29 13:00:00	SPY	ETF	168.45	168.57	168.31	168.45	6470717.0
2013-07-29 14:00:00	SPY	ETF	168.45	168.83	168.44	168.7	7474853.0
2013-07-29 15:00:00	SPY	ETF	168.7	168.74	168.4	168.57	11329290.0
2013-07-29 16:00:00	SPY	ETF	168.57	168.73	168.4931	168.69	5774600.0
2013-07-29 17:00:00	SPY	ETF	168.7	168.75	168.68	168.69	99677.0
2013-07-29 18:00:00	SPY	ETF	168.68	168.71	168.68	168.69	16400.0
2013-07-29 19:00:00	SPY	ETF	168.69	168.75	168.66	168.74	116251.0
2013-07-29 04:00:00	QQQ	ETF	75.26	75.26	75.16	75.22	15400.0
2013-07-29 05:00:00	QQQ	ETF	75.24	75.3	75.2	75.2	10800.0
2013-07-29 06:00:00	QQQ	ETF	75.2	75.26	75.16	75.26	11600.0
2013-07-29 07:00:00	QQQ	ETF	75.26	75.26	75.19	75.24	35900.0
2013-07-29 08:00:00	QQQ	ETF	75.26	75.27	75.22	75.23	57343.0
2013-07-29 09:00:00	QQQ	ETF	75.21	75.54	75.19	75.44	3736092.0
2013-07-29 10:00:00	QQQ	ETF	75.446	75.479	75.25	75.37	2520033.0
2013-07-29 11:00:00	QQQ	ETF	75.37	75.39	75.0299	75.1	2512728.0
2013-07-29 12:00:00	QQQ	ETF	75.1	75.23	75.0565	75.2	1232386.0
2013-07-29 13:00:00	QQQ	ETF	75.2	75.25	75.105	75.2	926954.0
2013-07-29 14:00:00	QQQ	ETF	75.21	75.38	75.21	75.29	1561107.0
2013-07-29 15:00:00	QQQ	ETF	75.29	75.33	75.11	75.21	3435749.0
2013-07-29 16:00:00	QQQ	ETF	75.22	75.4193	75.1862	75.3	1836596.0
2013-07-29 17:00:00	QQQ	ETF	75.31	75.31	75.29	75.29	15000.0
2013-07-29 18:00:00	QQQ	ETF	75.27	75.29	75.26	75.26	8423.0
2013-07-29 19:00:00	QQQ	ETF	75.26	75.27	75.25	75.27	3480.0
2013-07-29 05:00:00	IWM	ETF	103.85	103.85	103.85	103.85	500.0
2013-07-29 06:00:00	IWM	ETF	103.73	103.89	103.73	103.89	2500.0
2013-07-29 07:00:00	IWM	ETF	103.82	103.88	103.81	103.88	7250.0
2013-07-29 08:00:00	IWM	ETF	103.86	103.93	103.83	103.84	58160.0
2013-07-29 09:00:00	IWM	ETF	103.85	104.27	103.81	103.85	2340793.0
2013-07-29 10:00:00	IWM	ETF	103.89	103.925	103.43	103.6203	4206139.0
2013-07-29 11:00:00	IWM	ETF	103.62	103.65	103.0	103.18	4216854.0
2013-07-29 12:00:00	IWM	ETF	103.18	103.51	103.17	103.4435	2236818.0
2013-07-29 13:00:00	IWM	ETF	103.45	103.47	103.28	103.38	1238794.0
2013-07-29 14:00:00	IWM	ETF	103.37	103.63	103.37	103.42	2200001.0
2013-07-29 15:00:00	IWM	ETF	103.42	103.46	103.14	103.36	5978606.0
2013-07-29 16:00:00	IWM	ETF	103.37	104.0562	103.3098	103.35	4012246.0
2013-07-29 17:00:00	IWM	ETF	103.33	103.43	103.32	103.34	10100.0
2013-07-29 18:00:00	IWM	ETF	103.34	103.34	103.24	103.24	8865.0
2013-07-29 06:00:00	DIA	ETF	154.83	154.83	154.83	154.83	500.0
2013-07-29 07:00:00	DIA	ETF	154.93	154.93	154.92	154.92	3000.0
2013-07-29 08:00:00	DIA	ETF	155.03	155.03	154.84	154.86	5500.0
2013-07-29 09:00:00	DIA	ETF	154.87	155.14	154.72	155.02	262861.0

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

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