PREVIEW / etf_1hour / 2014-01-14

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-01-14.parquet
  size:    219 KB
  rows:    6,778

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
2014-01-14 04:00:00	SPY	ETF	182.08	182.15	182.0	182.0	43930.0
2014-01-14 05:00:00	SPY	ETF	181.97	182.05	181.97	182.05	30503.0
2014-01-14 06:00:00	SPY	ETF	182.05	182.2	182.04	182.12	99230.0
2014-01-14 07:00:00	SPY	ETF	182.14	182.28	181.99	182.24	304742.0
2014-01-14 08:00:00	SPY	ETF	182.21	182.37	182.04	182.34	1474130.0
2014-01-14 09:00:00	SPY	ETF	182.35	182.56	181.95	182.17	14206649.0
2014-01-14 10:00:00	SPY	ETF	182.165	182.93	182.16	182.87	14484623.0
2014-01-14 11:00:00	SPY	ETF	182.87	183.27	182.8	183.125	11704852.0
2014-01-14 12:00:00	SPY	ETF	183.125	183.57	183.07	183.32	9103496.0
2014-01-14 13:00:00	SPY	ETF	183.32	183.6	183.26	183.37	9034032.0
2014-01-14 14:00:00	SPY	ETF	183.36	183.63	183.21	183.46	12152086.0
2014-01-14 15:00:00	SPY	ETF	183.47	183.77	183.42	183.68	15756662.0
2014-01-14 16:00:00	SPY	ETF	183.68	183.72	181.7411	183.62	5165744.0
2014-01-14 17:00:00	SPY	ETF	183.65	183.71	183.65	183.71	2028138.0
2014-01-14 18:00:00	SPY	ETF	183.68	183.76	183.58	183.7	942589.0
2014-01-14 19:00:00	SPY	ETF	183.68	183.7	183.63	183.66	123530.0
2014-01-14 04:00:00	QQQ	ETF	86.14	86.2	86.14	86.2	2500.0
2014-01-14 05:00:00	QQQ	ETF	86.11	86.11	86.11	86.11	2500.0
2014-01-14 06:00:00	QQQ	ETF	86.18	86.18	86.14	86.17	980.0
2014-01-14 07:00:00	QQQ	ETF	86.15	86.28	86.14	86.28	54025.0
2014-01-14 08:00:00	QQQ	ETF	86.28	86.35	86.19	86.34	78029.0
2014-01-14 09:00:00	QQQ	ETF	86.33	86.51	86.285	86.451	4911079.0
2014-01-14 10:00:00	QQQ	ETF	86.45	87.06	86.45	87.05	7537031.0
2014-01-14 11:00:00	QQQ	ETF	87.05	87.33	87.05	87.29	4875377.0
2014-01-14 12:00:00	QQQ	ETF	87.3	87.62	87.26	87.5	4854453.0
2014-01-14 13:00:00	QQQ	ETF	87.5	87.67	87.47	87.58	3804694.0
2014-01-14 14:00:00	QQQ	ETF	87.57	87.681	87.45	87.6	2960978.0
2014-01-14 15:00:00	QQQ	ETF	87.605	87.72	87.57	87.65	5712359.0
2014-01-14 16:00:00	QQQ	ETF	87.65	87.68	86.394	87.66	1706451.0
2014-01-14 17:00:00	QQQ	ETF	87.66	87.69	87.64	87.64	8040.0
2014-01-14 18:00:00	QQQ	ETF	87.65	87.72	87.64	87.69	9965.0
2014-01-14 19:00:00	QQQ	ETF	87.69	87.7	87.65	87.65	3700.0
2014-01-14 06:00:00	IWM	ETF	114.22	114.22	114.22	114.22	110.0
2014-01-14 07:00:00	IWM	ETF	114.18	114.39	114.16	114.32	61500.0
2014-01-14 08:00:00	IWM	ETF	114.32	114.45	114.23	114.44	179251.0
2014-01-14 09:00:00	IWM	ETF	114.44	114.622	114.18	114.35	5050566.0
2014-01-14 10:00:00	IWM	ETF	114.35	115.05	114.35	114.98	5478764.0
2014-01-14 11:00:00	IWM	ETF	114.98	115.2201	114.87	115.05	4912596.0
2014-01-14 12:00:00	IWM	ETF	115.06	115.31	115.05	115.12	2804595.0
2014-01-14 13:00:00	IWM	ETF	115.13	115.28	115.01	115.12	2872267.0
2014-01-14 14:00:00	IWM	ETF	115.12	115.35	114.91	115.2	3600395.0
2014-01-14 15:00:00	IWM	ETF	115.2	115.51	115.18	115.35	5710652.0
2014-01-14 16:00:00	IWM	ETF	115.35	115.38	113.9168	115.3	2418923.0
2014-01-14 17:00:00	IWM	ETF	115.32	115.33	115.32	115.32	11100.0
2014-01-14 18:00:00	IWM	ETF	115.32	115.32	115.32	115.32	100.0
2014-01-14 19:00:00	IWM	ETF	115.31	115.41	115.31	115.41	400.0
2014-01-14 07:00:00	DIA	ETF	162.8	162.8	162.8	162.8	100.0
2014-01-14 08:00:00	DIA	ETF	162.799	162.82	162.64	162.81	14700.0
2014-01-14 09:00:00	DIA	ETF	162.81	162.93	162.37	162.49	1093152.0
2014-01-14 10:00:00	DIA	ETF	162.5	162.96	162.5	162.9	1080274.0

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

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