PREVIEW / etf_1hour / 2012-09-20

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-09-20.parquet
  size:    188 KB
  rows:    5,875

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
2012-09-20 04:00:00	SPY	ETF	146.19	146.19	146.0	146.14	3616.0
2012-09-20 05:00:00	SPY	ETF	146.15	146.15	145.98	146.15	35520.0
2012-09-20 06:00:00	SPY	ETF	146.15	146.25	146.14	146.19	79839.0
2012-09-20 07:00:00	SPY	ETF	146.17	146.3	146.1	146.18	293066.0
2012-09-20 08:00:00	SPY	ETF	146.18	146.21	145.86	146.01	1197270.0
2012-09-20 09:00:00	SPY	ETF	146.02	146.15	145.63	145.72	24420318.0
2012-09-20 10:00:00	SPY	ETF	145.73	146.41	145.7	146.38	21767097.0
2012-09-20 11:00:00	SPY	ETF	146.37	146.51	146.19	146.44	11763784.0
2012-09-20 12:00:00	SPY	ETF	146.445	146.55	146.15	146.25	11370214.0
2012-09-20 13:00:00	SPY	ETF	146.25	146.54	146.18	146.41	12221828.0
2012-09-20 14:00:00	SPY	ETF	146.41	146.62	146.36	146.54	14936870.0
2012-09-20 15:00:00	SPY	ETF	146.54	146.79	146.45	146.72	22067677.0
2012-09-20 16:00:00	SPY	ETF	146.72	146.85	146.0	146.84	16365568.0
2012-09-20 17:00:00	SPY	ETF	146.83	146.85	146.77	146.84	4754017.0
2012-09-20 18:00:00	SPY	ETF	146.85	146.94	146.84	146.86	77627.0
2012-09-20 19:00:00	SPY	ETF	146.86	146.92	146.85	146.85	39142.0
2012-09-20 04:00:00	QQQ	ETF	70.04	70.04	70.04	70.04	100.0
2012-09-20 05:00:00	QQQ	ETF	70.02	70.06	70.02	70.06	350.0
2012-09-20 07:00:00	QQQ	ETF	70.15	70.15	70.07	70.12	1400.0
2012-09-20 08:00:00	QQQ	ETF	70.1	70.13	69.95	70.06	308547.0
2012-09-20 09:00:00	QQQ	ETF	70.06	70.15	69.87	69.91	4264441.0
2012-09-20 10:00:00	QQQ	ETF	69.91	70.25	69.89	70.23	5191883.0
2012-09-20 11:00:00	QQQ	ETF	70.23	70.28	70.15	70.23	2420486.0
2012-09-20 12:00:00	QQQ	ETF	70.23	70.2617	70.07	70.132	1965182.0
2012-09-20 13:00:00	QQQ	ETF	70.13	70.29	70.11	70.2108	1284012.0
2012-09-20 14:00:00	QQQ	ETF	70.22	70.325	70.182	70.29	1797372.0
2012-09-20 15:00:00	QQQ	ETF	70.29	70.39	70.2	70.34	5601646.0
2012-09-20 16:00:00	QQQ	ETF	70.32	70.4014	70.256	70.35	9552916.0
2012-09-20 17:00:00	QQQ	ETF	70.34	70.4013	70.31	70.34	544259.0
2012-09-20 18:00:00	QQQ	ETF	70.35	70.39	70.34	70.36	3159.0
2012-09-20 19:00:00	QQQ	ETF	70.34	70.38	70.34	70.37	2850.0
2012-09-20 05:00:00	IWM	ETF	85.05	85.05	85.05	85.05	100.0
2012-09-20 06:00:00	IWM	ETF	85.22	85.22	85.22	85.22	100.0
2012-09-20 07:00:00	IWM	ETF	85.32	85.32	85.23	85.28	7980.0
2012-09-20 08:00:00	IWM	ETF	85.27	85.29	85.03	85.13	374756.0
2012-09-20 09:00:00	IWM	ETF	85.12	85.17	84.61	84.72	4953651.0
2012-09-20 10:00:00	IWM	ETF	84.7	85.305	84.64	85.28	5016884.0
2012-09-20 11:00:00	IWM	ETF	85.29	85.4	85.05	85.21	2864727.0
2012-09-20 12:00:00	IWM	ETF	85.22	85.295	84.93	85.0	1839303.0
2012-09-20 13:00:00	IWM	ETF	84.995	85.22	84.95	85.13	1385036.0
2012-09-20 14:00:00	IWM	ETF	85.14	85.25	85.06	85.2	2317271.0
2012-09-20 15:00:00	IWM	ETF	85.21	85.29	85.05	85.19	6010766.0
2012-09-20 16:00:00	IWM	ETF	85.2	85.42	85.1468	85.41	4041688.0
2012-09-20 17:00:00	IWM	ETF	85.41	85.44	85.4	85.44	10600.0
2012-09-20 19:00:00	IWM	ETF	85.4	85.41	85.38	85.38	1700.0
2012-09-20 07:00:00	DIA	ETF	135.3	135.32	135.3	135.32	6000.0
2012-09-20 08:00:00	DIA	ETF	135.38	135.38	135.07	135.17	29300.0
2012-09-20 09:00:00	DIA	ETF	135.15	135.49	135.0	135.1	902982.0
2012-09-20 10:00:00	DIA	ETF	135.12	135.61	135.08	135.555	905839.0
2012-09-20 11:00:00	DIA	ETF	135.56	135.71	135.455	135.64	706208.0

> showing 50 of 5,875 rows — these rows as CSV

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