PREVIEW / etf_1hour / 2013-07-11

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-07-11.parquet
  size:    213 KB
  rows:    6,721

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-11 04:00:00	SPY	ETF	166.75	167.07	166.75	167.05	74417.0
2013-07-11 05:00:00	SPY	ETF	167.1	167.1	166.81	166.91	23959.0
2013-07-11 06:00:00	SPY	ETF	166.91	167.01	166.75	166.87	214766.0
2013-07-11 07:00:00	SPY	ETF	166.87	167.2	166.83	167.0	535099.0
2013-07-11 08:00:00	SPY	ETF	166.9	167.17	166.79	166.86	1927127.0
2013-07-11 09:00:00	SPY	ETF	166.87	167.15	166.68	166.795	20932972.0
2013-07-11 10:00:00	SPY	ETF	166.8	166.92	166.53	166.855	20941004.0
2013-07-11 11:00:00	SPY	ETF	166.85	167.04	166.81	166.97	12307295.0
2013-07-11 12:00:00	SPY	ETF	166.965	166.97	166.74	166.865	7477181.0
2013-07-11 13:00:00	SPY	ETF	166.86	166.94	166.76	166.909	8630361.0
2013-07-11 14:00:00	SPY	ETF	166.91	167.45	166.88	167.27	18481682.0
2013-07-11 15:00:00	SPY	ETF	167.27	167.61	167.2	167.43	24256219.0
2013-07-11 16:00:00	SPY	ETF	167.43	167.53	165.1774	167.44	9603953.0
2013-07-11 17:00:00	SPY	ETF	167.41	167.42	167.36	167.38	69266.0
2013-07-11 18:00:00	SPY	ETF	167.38	167.49	167.36	167.37	39759.0
2013-07-11 19:00:00	SPY	ETF	167.35	167.35	167.22	167.22	87672.0
2013-07-11 04:00:00	QQQ	ETF	74.2	74.33	74.2	74.27	16700.0
2013-07-11 05:00:00	QQQ	ETF	74.25	74.25	74.18	74.18	1870.0
2013-07-11 06:00:00	QQQ	ETF	74.17	74.21	74.15	74.18	2707.0
2013-07-11 07:00:00	QQQ	ETF	74.15	74.29	74.14	74.24	49673.0
2013-07-11 08:00:00	QQQ	ETF	74.22	74.28	74.14	74.17	100675.0
2013-07-11 09:00:00	QQQ	ETF	74.18	74.43	74.17	74.37	4211265.0
2013-07-11 10:00:00	QQQ	ETF	74.37	74.54	74.27	74.518	5821396.0
2013-07-11 11:00:00	QQQ	ETF	74.52	74.66	74.49	74.65	5457395.0
2013-07-11 12:00:00	QQQ	ETF	74.65	74.73	74.59	74.73	5873957.0
2013-07-11 13:00:00	QQQ	ETF	74.725	74.76	74.6401	74.74	5309348.0
2013-07-11 14:00:00	QQQ	ETF	74.7399	74.96	74.7	74.8699	4968294.0
2013-07-11 15:00:00	QQQ	ETF	74.87	74.99	74.84	74.99	9405649.0
2013-07-11 16:00:00	QQQ	ETF	74.985	75.04	73.512	74.98	5459241.0
2013-07-11 17:00:00	QQQ	ETF	74.96	74.97	74.92	74.92	6280.0
2013-07-11 18:00:00	QQQ	ETF	74.93	75.01	74.93	74.99	35634.0
2013-07-11 19:00:00	QQQ	ETF	74.98	74.98	74.9	74.9	6744.0
2013-07-11 05:00:00	IWM	ETF	102.25	102.25	102.23	102.23	1760.0
2013-07-11 06:00:00	IWM	ETF	102.14	102.23	102.14	102.19	15903.0
2013-07-11 07:00:00	IWM	ETF	102.17	102.51	102.16	102.37	122977.0
2013-07-11 08:00:00	IWM	ETF	102.37	102.43	102.22	102.27	98521.0
2013-07-11 09:00:00	IWM	ETF	102.29	102.59	102.08	102.33	5174563.0
2013-07-11 10:00:00	IWM	ETF	102.33	102.47	102.06	102.29	5322711.0
2013-07-11 11:00:00	IWM	ETF	102.28	102.37	102.13	102.22	2897336.0
2013-07-11 12:00:00	IWM	ETF	102.22	102.23	101.94	102.095	1898094.0
2013-07-11 13:00:00	IWM	ETF	102.1	102.28	102.02	102.21	2666136.0
2013-07-11 14:00:00	IWM	ETF	102.21	102.52	102.16	102.39	3441714.0
2013-07-11 15:00:00	IWM	ETF	102.38	102.57	102.32	102.47	5614681.0
2013-07-11 16:00:00	IWM	ETF	102.49	102.59	101.248	101.248	3543819.0
2013-07-11 17:00:00	IWM	ETF	102.4	102.4	102.36	102.36	653.0
2013-07-11 18:00:00	IWM	ETF	102.38	102.38	102.3	102.36	2805.0
2013-07-11 19:00:00	IWM	ETF	102.36	102.37	102.36	102.36	3000.0
2013-07-11 04:00:00	DIA	ETF	153.9	154.31	153.9	154.31	3298.0
2013-07-11 06:00:00	DIA	ETF	154.15	154.2	154.11	154.11	4500.0
2013-07-11 07:00:00	DIA	ETF	154.1	154.37	154.1	154.37	21800.0

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

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