PREVIEW / etf_1hour / 2013-06-07

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-06-07.parquet
  size:    209 KB
  rows:    6,509

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-06-07 04:00:00	SPY	ETF	162.66	162.79	162.54	162.7	16950.0
2013-06-07 05:00:00	SPY	ETF	162.72	162.84	162.6	162.8	7900.0
2013-06-07 06:00:00	SPY	ETF	162.79	162.86	162.48	162.82	81873.0
2013-06-07 07:00:00	SPY	ETF	162.8	162.88	162.64	162.82	417701.0
2013-06-07 08:00:00	SPY	ETF	162.8	163.9	162.45	163.67	9263910.0
2013-06-07 09:00:00	SPY	ETF	163.68	163.92	162.7307	163.808	25853898.0
2013-06-07 10:00:00	SPY	ETF	163.82	164.48	163.81	164.22	32311140.0
2013-06-07 11:00:00	SPY	ETF	164.23	164.75	164.22	164.39	22776438.0
2013-06-07 12:00:00	SPY	ETF	164.39	164.45	164.02	164.295	11716067.0
2013-06-07 13:00:00	SPY	ETF	164.29	164.42	164.12	164.13	9780257.0
2013-06-07 14:00:00	SPY	ETF	164.13	164.42	163.74	164.339	18103522.0
2013-06-07 15:00:00	SPY	ETF	164.34	164.95	164.22	164.81	30850346.0
2013-06-07 16:00:00	SPY	ETF	164.8	164.8107	162.7306	164.53	18459900.0
2013-06-07 17:00:00	SPY	ETF	164.53	164.6	164.49	164.5	1344791.0
2013-06-07 18:00:00	SPY	ETF	164.49	164.65	162.7307	164.53	2561885.0
2013-06-07 19:00:00	SPY	ETF	164.55	164.6	164.5	164.53	14821.0
2013-06-07 04:00:00	QQQ	ETF	72.38	72.46	72.31	72.37	7780.0
2013-06-07 05:00:00	QQQ	ETF	72.4	72.45	72.31	72.45	6700.0
2013-06-07 06:00:00	QQQ	ETF	72.42	72.42	72.25	72.4	5700.0
2013-06-07 07:00:00	QQQ	ETF	72.42	72.42	72.34	72.39	24314.0
2013-06-07 08:00:00	QQQ	ETF	72.35	72.89	72.3	72.74	693353.0
2013-06-07 09:00:00	QQQ	ETF	72.74	72.84	72.52	72.83	5398129.0
2013-06-07 10:00:00	QQQ	ETF	72.83	73.1645	72.78	73.02	7033794.0
2013-06-07 11:00:00	QQQ	ETF	73.01	73.28	73.01	73.17	2959601.0
2013-06-07 12:00:00	QQQ	ETF	73.16	73.26	73.051	73.24	2028357.0
2013-06-07 13:00:00	QQQ	ETF	73.25	73.3	73.145	73.16	2085274.0
2013-06-07 14:00:00	QQQ	ETF	73.16	73.26	73.02	73.23	2819281.0
2013-06-07 15:00:00	QQQ	ETF	73.22	73.47	73.21	73.39	5670122.0
2013-06-07 16:00:00	QQQ	ETF	73.4	73.4162	72.422	73.28	2467813.0
2013-06-07 17:00:00	QQQ	ETF	73.28	73.3	73.28	73.3	3850.0
2013-06-07 18:00:00	QQQ	ETF	73.35	73.35	73.31	73.31	1946.0
2013-06-07 19:00:00	QQQ	ETF	73.27	73.35	73.27	73.35	400.0
2013-06-07 06:00:00	IWM	ETF	97.5	97.6	97.5	97.6	1700.0
2013-06-07 07:00:00	IWM	ETF	97.55	97.6	97.48	97.59	29000.0
2013-06-07 08:00:00	IWM	ETF	97.55	98.35	97.51	98.1	2244380.0
2013-06-07 09:00:00	IWM	ETF	98.08	98.15	97.27	97.79	7935775.0
2013-06-07 10:00:00	IWM	ETF	97.78	98.29	97.64	98.03	11370972.0
2013-06-07 11:00:00	IWM	ETF	98.03	98.41	97.99	98.23	4181839.0
2013-06-07 12:00:00	IWM	ETF	98.23	98.26	97.96	98.11	2379587.0
2013-06-07 13:00:00	IWM	ETF	98.11	98.22	97.97	97.985	1988479.0
2013-06-07 14:00:00	IWM	ETF	97.985	98.1	97.625	98.028	3689383.0
2013-06-07 15:00:00	IWM	ETF	98.03	98.45	97.97	98.18	6337180.0
2013-06-07 16:00:00	IWM	ETF	98.18	98.2	97.72	98.0	1905881.0
2013-06-07 17:00:00	IWM	ETF	97.99	97.99	97.91	97.99	124360.0
2013-06-07 19:00:00	IWM	ETF	98.09	98.09	98.09	98.09	200.0
2013-06-07 05:00:00	DIA	ETF	150.29	150.29	150.29	150.29	1000.0
2013-06-07 07:00:00	DIA	ETF	150.17	150.3	150.17	150.3	1100.0
2013-06-07 08:00:00	DIA	ETF	150.25	151.21	150.24	150.85	33447.0
2013-06-07 09:00:00	DIA	ETF	150.81	151.3	150.67	151.3	1368657.0
2013-06-07 10:00:00	DIA	ETF	151.31	152.18	151.31	151.93	2127843.0

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

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