PREVIEW / etf_1hour / 2014-09-12

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-09-12.parquet
  size:    222 KB
  rows:    6,996

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-09-12 04:00:00	SPY	ETF	200.24	200.25	200.15	200.15	17088.0
2014-09-12 05:00:00	SPY	ETF	200.15	200.27	200.15	200.26	17835.0
2014-09-12 06:00:00	SPY	ETF	200.27	200.35	200.24	200.27	21867.0
2014-09-12 07:00:00	SPY	ETF	200.27	200.44	200.25	200.33	217528.0
2014-09-12 08:00:00	SPY	ETF	200.25	200.36	200.04	200.18	766859.0
2014-09-12 09:00:00	SPY	ETF	200.18	200.27	199.5	199.54	9787180.0
2014-09-12 10:00:00	SPY	ETF	199.54	199.91	199.22	199.835	14945899.0
2014-09-12 11:00:00	SPY	ETF	199.83	199.86	199.28	199.47	10352989.0
2014-09-12 12:00:00	SPY	ETF	199.47	199.55	199.06	199.18	10844326.0
2014-09-12 13:00:00	SPY	ETF	199.18	199.28	198.71	198.92	13791539.0
2014-09-12 14:00:00	SPY	ETF	198.92	199.18	198.56	198.69	14807883.0
2014-09-12 15:00:00	SPY	ETF	198.686	199.2	198.58	199.1299	19966699.0
2014-09-12 16:00:00	SPY	ETF	199.12	200.3032	199.02	199.03	11730712.0
2014-09-12 17:00:00	SPY	ETF	199.03	199.03	198.98	198.98	81665.0
2014-09-12 18:00:00	SPY	ETF	198.98	198.99	198.88	198.9	34464.0
2014-09-12 19:00:00	SPY	ETF	198.91	198.97	198.88	198.88	33031.0
2014-09-12 04:00:00	QQQ	ETF	99.99	99.99	99.93	99.93	10125.0
2014-09-12 06:00:00	QQQ	ETF	100.0	100.0	100.0	100.0	100.0
2014-09-12 07:00:00	QQQ	ETF	100.0	100.03	99.94	99.99	28215.0
2014-09-12 08:00:00	QQQ	ETF	99.98	99.99	99.87	99.95	144189.0
2014-09-12 09:00:00	QQQ	ETF	99.96	99.96	99.53	99.54	3994021.0
2014-09-12 10:00:00	QQQ	ETF	99.54	99.785	99.4	99.76	4835335.0
2014-09-12 11:00:00	QQQ	ETF	99.76	99.81	99.51	99.65	2583233.0
2014-09-12 12:00:00	QQQ	ETF	99.65	99.7	99.44	99.54	1890015.0
2014-09-12 13:00:00	QQQ	ETF	99.54	99.6	99.27	99.39	2665123.0
2014-09-12 14:00:00	QQQ	ETF	99.39	99.56	99.17	99.235	4582007.0
2014-09-12 15:00:00	QQQ	ETF	99.23	99.49	99.18	99.48	5319523.0
2014-09-12 16:00:00	QQQ	ETF	99.49	100.0312	99.42	99.42	1725601.0
2014-09-12 17:00:00	QQQ	ETF	99.43	99.49	99.39	99.47	15267.0
2014-09-12 18:00:00	QQQ	ETF	99.4	99.4	99.4	99.4	1400.0
2014-09-12 19:00:00	QQQ	ETF	99.4	99.44	99.38	99.38	1006.0
2014-09-12 07:00:00	IWM	ETF	116.82	116.83	116.72	116.73	21800.0
2014-09-12 08:00:00	IWM	ETF	116.77	116.79	116.51	116.61	85853.0
2014-09-12 09:00:00	IWM	ETF	116.62	116.66	115.93	115.95	3163034.0
2014-09-12 10:00:00	IWM	ETF	115.932	116.17	115.74	115.95	4128867.0
2014-09-12 11:00:00	IWM	ETF	115.95	115.98	115.23	115.41	3774785.0
2014-09-12 12:00:00	IWM	ETF	115.4	115.47	115.09	115.3	3269505.0
2014-09-12 13:00:00	IWM	ETF	115.31	115.39	114.97	115.27	3095387.0
2014-09-12 14:00:00	IWM	ETF	115.28	115.43	114.99	115.09	2948479.0
2014-09-12 15:00:00	IWM	ETF	115.09	115.51	115.02	115.39	5519136.0
2014-09-12 16:00:00	IWM	ETF	115.38	115.47	115.275	115.41	1778830.0
2014-09-12 17:00:00	IWM	ETF	115.4	115.42	115.37	115.42	2400.0
2014-09-12 18:00:00	IWM	ETF	115.33	115.33	115.33	115.33	250.0
2014-09-12 19:00:00	IWM	ETF	115.33	115.33	115.27	115.27	300.0
2014-09-12 09:00:00	DIA	ETF	170.4	170.4	169.96	169.98	583757.0
2014-09-12 10:00:00	DIA	ETF	169.98	170.44	169.75	170.39	738397.0
2014-09-12 11:00:00	DIA	ETF	170.38	170.4	169.9	170.04	502202.0
2014-09-12 12:00:00	DIA	ETF	170.03	170.0901	169.76	169.86	641841.0
2014-09-12 13:00:00	DIA	ETF	169.85	169.94	169.49	169.62	972512.0
2014-09-12 14:00:00	DIA	ETF	169.63	169.82	169.4	169.55	490356.0

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

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