PREVIEW / etf_1hour / 2013-07-18

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-07-18.parquet
  size:    204 KB
  rows:    6,367

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-18 04:00:00	SPY	ETF	167.98	168.1	167.98	168.1	1500.0
2013-07-18 05:00:00	SPY	ETF	168.05	168.15	168.05	168.15	1200.0
2013-07-18 06:00:00	SPY	ETF	168.1	168.16	168.09	168.14	21530.0
2013-07-18 07:00:00	SPY	ETF	168.15	168.22	168.09	168.13	108195.0
2013-07-18 08:00:00	SPY	ETF	168.14	170.46	168.08	168.35	565428.0
2013-07-18 09:00:00	SPY	ETF	168.35	168.66	168.2	168.54	10179903.0
2013-07-18 10:00:00	SPY	ETF	168.54	169.27	168.515	169.19	19799163.0
2013-07-18 11:00:00	SPY	ETF	169.19	169.25	168.95	169.01	9674627.0
2013-07-18 12:00:00	SPY	ETF	169.01	169.23	168.76	168.825	11176974.0
2013-07-18 13:00:00	SPY	ETF	168.82	168.92	168.63	168.89	11718780.0
2013-07-18 14:00:00	SPY	ETF	168.89	169.12	168.84	169.01	8006847.0
2013-07-18 15:00:00	SPY	ETF	169.01	169.01	168.69	168.89	14582412.0
2013-07-18 16:00:00	SPY	ETF	168.88	169.15	168.033	168.44	12058801.0
2013-07-18 17:00:00	SPY	ETF	168.45	168.51	168.39	168.41	230162.0
2013-07-18 18:00:00	SPY	ETF	168.4	168.46	168.37	168.38	93813.0
2013-07-18 19:00:00	SPY	ETF	168.37	168.46	168.37	168.43	67312.0
2013-07-18 04:00:00	QQQ	ETF	75.48	75.52	75.47	75.52	3700.0
2013-07-18 05:00:00	QQQ	ETF	75.5	75.56	75.5	75.56	5900.0
2013-07-18 06:00:00	QQQ	ETF	75.54	75.54	75.51	75.52	1900.0
2013-07-18 07:00:00	QQQ	ETF	75.52	75.53	75.48	75.49	20600.0
2013-07-18 08:00:00	QQQ	ETF	75.48	75.61	75.47	75.61	160233.0
2013-07-18 09:00:00	QQQ	ETF	75.63	75.63	75.39	75.45	2774378.0
2013-07-18 10:00:00	QQQ	ETF	75.46	75.74	75.41	75.68	4144205.0
2013-07-18 11:00:00	QQQ	ETF	75.69	75.73	75.5007	75.53	2054195.0
2013-07-18 12:00:00	QQQ	ETF	75.53	75.61	75.301	75.35	2194813.0
2013-07-18 13:00:00	QQQ	ETF	75.3593	75.42	75.25	75.41	2822989.0
2013-07-18 14:00:00	QQQ	ETF	75.41	75.55	75.391	75.48	1455398.0
2013-07-18 15:00:00	QQQ	ETF	75.47	75.47	75.35	75.39	4906282.0
2013-07-18 16:00:00	QQQ	ETF	75.39	75.5815	74.74	74.83	9242858.0
2013-07-18 17:00:00	QQQ	ETF	74.83	74.83	74.75	74.79	90478.0
2013-07-18 18:00:00	QQQ	ETF	74.78	74.8	74.72	74.72	134739.0
2013-07-18 19:00:00	QQQ	ETF	74.73	74.79	74.73	74.77	79235.0
2013-07-18 06:00:00	IWM	ETF	102.67	103.5	102.67	103.5	19800.0
2013-07-18 07:00:00	IWM	ETF	103.54	103.57	103.5	103.53	13300.0
2013-07-18 08:00:00	IWM	ETF	103.54	103.78	103.54	103.78	106137.0
2013-07-18 09:00:00	IWM	ETF	103.79	104.17	103.66	103.93	3335141.0
2013-07-18 10:00:00	IWM	ETF	103.97	104.56	103.94	104.52	6093174.0
2013-07-18 11:00:00	IWM	ETF	104.53	104.59	104.3	104.4	3211347.0
2013-07-18 12:00:00	IWM	ETF	104.4	104.52	104.22	104.29	2391994.0
2013-07-18 13:00:00	IWM	ETF	104.3	104.37	104.2	104.348	2464282.0
2013-07-18 14:00:00	IWM	ETF	104.35	104.42	104.28	104.34	2758445.0
2013-07-18 15:00:00	IWM	ETF	104.34	104.35	104.12	104.17	5286045.0
2013-07-18 16:00:00	IWM	ETF	104.16	104.19	103.84	103.97	1400568.0
2013-07-18 17:00:00	IWM	ETF	103.99	104.02	103.84	103.95	23623.0
2013-07-18 18:00:00	IWM	ETF	103.94	103.97	103.92	103.92	11111.0
2013-07-18 19:00:00	IWM	ETF	103.95	103.95	103.89	103.89	350.0
2013-07-18 04:00:00	DIA	ETF	154.59	154.65	154.59	154.65	200.0
2013-07-18 06:00:00	DIA	ETF	154.7	154.7	154.7	154.7	100.0
2013-07-18 08:00:00	DIA	ETF	154.78	155.01	154.73	155.0	20602.0
2013-07-18 09:00:00	DIA	ETF	154.96	155.37	154.85	155.24	856674.0

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

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