PREVIEW / etf_1hour / 2012-09-21

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-09-21.parquet
  size:    187 KB
  rows:    5,863

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-21 04:00:00	SPY	ETF	146.74	146.74	146.27	146.5	9008.0
2012-09-21 05:00:00	SPY	ETF	146.5	146.5	146.36	146.36	750.0
2012-09-21 06:00:00	SPY	ETF	146.33	146.33	146.1	146.12	9050.0
2012-09-21 07:00:00	SPY	ETF	146.12	146.52	146.11	146.29	194889.0
2012-09-21 08:00:00	SPY	ETF	146.31	146.5	146.29	146.49	861825.0
2012-09-21 09:00:00	SPY	ETF	146.49	146.76	146.35	146.5099	16185336.0
2012-09-21 10:00:00	SPY	ETF	146.51	146.57	146.25	146.2728	14941381.0
2012-09-21 11:00:00	SPY	ETF	146.2701	146.43	146.2	146.36	13196455.0
2012-09-21 12:00:00	SPY	ETF	146.355	146.42	146.17	146.2799	7495060.0
2012-09-21 13:00:00	SPY	ETF	146.2799	146.37	146.23	146.3	9347731.0
2012-09-21 14:00:00	SPY	ETF	146.3	146.31	146.03	146.1	10390375.0
2012-09-21 15:00:00	SPY	ETF	146.1	146.2	145.81	145.88	22071204.0
2012-09-21 16:00:00	SPY	ETF	145.89	146.6161	145.2206	145.86	11494740.0
2012-09-21 17:00:00	SPY	ETF	145.86	146.01	145.81	145.84	275361.0
2012-09-21 18:00:00	SPY	ETF	145.83	145.99	145.83	145.97	96967.0
2012-09-21 19:00:00	SPY	ETF	145.95	146.0	145.95	145.99	54956.0
2012-09-21 05:00:00	QQQ	ETF	70.33	70.33	70.33	70.33	300.0
2012-09-21 06:00:00	QQQ	ETF	70.37	70.37	70.37	70.37	300.0
2012-09-21 07:00:00	QQQ	ETF	70.39	70.39	70.23	70.29	75265.0
2012-09-21 08:00:00	QQQ	ETF	70.29	70.55	70.27	70.41	327113.0
2012-09-21 09:00:00	QQQ	ETF	70.42	70.54	70.41	70.49	4023686.0
2012-09-21 10:00:00	QQQ	ETF	70.48	70.5	70.37	70.38	4835405.0
2012-09-21 11:00:00	QQQ	ETF	70.39	70.42	70.33	70.4	2002856.0
2012-09-21 12:00:00	QQQ	ETF	70.4	70.44	70.32	70.42	1259365.0
2012-09-21 13:00:00	QQQ	ETF	70.42	70.44	70.32	70.345	1202699.0
2012-09-21 14:00:00	QQQ	ETF	70.3401	70.35	70.1499	70.21	2630398.0
2012-09-21 15:00:00	QQQ	ETF	70.21	70.29	70.08	70.16	5349039.0
2012-09-21 16:00:00	QQQ	ETF	70.17	70.21	70.06	70.12	1327327.0
2012-09-21 17:00:00	QQQ	ETF	70.14	70.19	70.09	70.1	163826.0
2012-09-21 18:00:00	QQQ	ETF	70.16	70.19	70.16	70.19	13751.0
2012-09-21 19:00:00	QQQ	ETF	70.18	70.19	70.18	70.19	543.0
2012-09-21 04:00:00	IWM	ETF	85.5	85.5	85.5	85.5	447.0
2012-09-21 07:00:00	IWM	ETF	85.65	85.7	85.65	85.69	2495.0
2012-09-21 08:00:00	IWM	ETF	85.7	85.9	85.7	85.9	501870.0
2012-09-21 09:00:00	IWM	ETF	85.9	86.08	85.77	85.98	6907461.0
2012-09-21 10:00:00	IWM	ETF	85.98	86.08	85.8	85.83	5085827.0
2012-09-21 11:00:00	IWM	ETF	85.84	85.95	85.72	85.89	3714621.0
2012-09-21 12:00:00	IWM	ETF	85.89	85.95	85.74	85.79	1869631.0
2012-09-21 13:00:00	IWM	ETF	85.78	85.93	85.74	85.9	2372855.0
2012-09-21 14:00:00	IWM	ETF	85.91	85.91	85.62	85.62	2893036.0
2012-09-21 15:00:00	IWM	ETF	85.62	85.7	85.47	85.57	7000182.0
2012-09-21 16:00:00	IWM	ETF	85.56	85.8475	81.5178	85.58	2924396.0
2012-09-21 17:00:00	IWM	ETF	85.58	85.58	85.5	85.5	11850.0
2012-09-21 18:00:00	IWM	ETF	85.56	85.61	85.56	85.61	600.0
2012-09-21 19:00:00	IWM	ETF	85.57	85.58	85.54	85.54	3494.0
2012-09-21 07:00:00	DIA	ETF	135.69	136.0	135.69	136.0	2043.0
2012-09-21 08:00:00	DIA	ETF	136.0	136.15	136.0	136.14	9744.0
2012-09-21 09:00:00	DIA	ETF	136.16	136.28	135.85	136.049	481093.0
2012-09-21 10:00:00	DIA	ETF	136.04	136.15	135.86	135.9	431496.0
2012-09-21 11:00:00	DIA	ETF	135.881	136.08	135.81	136.05	1114442.0

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

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