PREVIEW / etf_1hour / 2014-09-17

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-09-17.parquet
  size:    219 KB
  rows:    6,911

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-17 04:00:00	SPY	ETF	200.48	200.55	200.45	200.55	1000.0
2014-09-17 05:00:00	SPY	ETF	200.54	200.61	200.53	200.61	4586.0
2014-09-17 06:00:00	SPY	ETF	200.6	200.64	200.53	200.64	47206.0
2014-09-17 07:00:00	SPY	ETF	200.59	200.62	200.45	200.55	252821.0
2014-09-17 08:00:00	SPY	ETF	200.56	200.74	200.33	200.6	1186219.0
2014-09-17 09:00:00	SPY	ETF	200.6	201.0	200.56	200.945	9888183.0
2014-09-17 10:00:00	SPY	ETF	200.95	201.06	200.55	200.65	12066881.0
2014-09-17 11:00:00	SPY	ETF	200.64	200.77	200.46	200.56	7858357.0
2014-09-17 12:00:00	SPY	ETF	200.56	200.66	200.32	200.43	11986411.0
2014-09-17 13:00:00	SPY	ETF	200.42	200.76	200.24	200.7	9666739.0
2014-09-17 14:00:00	SPY	ETF	200.7	201.38	199.75	201.21	47695931.0
2014-09-17 15:00:00	SPY	ETF	201.21	201.68	200.52	200.72	30245161.0
2014-09-17 16:00:00	SPY	ETF	200.72	200.86	200.5099	200.83	17393274.0
2014-09-17 17:00:00	SPY	ETF	200.83	200.94	200.83	200.9	2076374.0
2014-09-17 18:00:00	SPY	ETF	200.9	200.9	200.79	200.79	15333.0
2014-09-17 19:00:00	SPY	ETF	200.81	200.81	200.76	200.76	90788.0
2014-09-17 04:00:00	QQQ	ETF	99.29	99.29	99.29	99.29	2500.0
2014-09-17 05:00:00	QQQ	ETF	99.31	99.31	99.31	99.31	4000.0
2014-09-17 06:00:00	QQQ	ETF	99.32	99.35	99.31	99.35	6277.0
2014-09-17 07:00:00	QQQ	ETF	99.29	99.32	99.23	99.32	49100.0
2014-09-17 08:00:00	QQQ	ETF	99.3	99.43	99.18	99.37	338541.0
2014-09-17 09:00:00	QQQ	ETF	99.36	99.6	99.32	99.465	3973764.0
2014-09-17 10:00:00	QQQ	ETF	99.47	99.54	99.23	99.3172	3221670.0
2014-09-17 11:00:00	QQQ	ETF	99.31	99.425	99.295	99.38	2066094.0
2014-09-17 12:00:00	QQQ	ETF	99.39	99.42	99.21	99.25	1623874.0
2014-09-17 13:00:00	QQQ	ETF	99.25	99.45	99.195	99.42	2716002.0
2014-09-17 14:00:00	QQQ	ETF	99.41	99.8301	98.93	99.8	12189507.0
2014-09-17 15:00:00	QQQ	ETF	99.79	100.0	99.43	99.54	8872840.0
2014-09-17 16:00:00	QQQ	ETF	99.54	99.6	99.4172	99.58	1656168.0
2014-09-17 17:00:00	QQQ	ETF	99.59	99.68	99.58	99.6	16060.0
2014-09-17 18:00:00	QQQ	ETF	99.64	99.64	99.57	99.58	11920.0
2014-09-17 19:00:00	QQQ	ETF	99.57	99.58	99.56	99.58	7980.0
2014-09-17 06:00:00	IWM	ETF	114.41	114.52	114.41	114.52	5500.0
2014-09-17 07:00:00	IWM	ETF	114.36	114.5	114.36	114.38	25000.0
2014-09-17 08:00:00	IWM	ETF	114.3	114.45	114.15	114.31	124325.0
2014-09-17 09:00:00	IWM	ETF	114.3	115.17	114.3	115.135	4190555.0
2014-09-17 10:00:00	IWM	ETF	115.13	115.27	114.89	115.02	3869328.0
2014-09-17 11:00:00	IWM	ETF	115.02	115.15	114.98	115.05	1426004.0
2014-09-17 12:00:00	IWM	ETF	115.06	115.09	114.81	114.92	1413563.0
2014-09-17 13:00:00	IWM	ETF	114.91	114.92	114.49	114.81	2400487.0
2014-09-17 14:00:00	IWM	ETF	114.82	115.47	114.19	115.19	9633516.0
2014-09-17 15:00:00	IWM	ETF	115.185	115.43	114.6	114.74	6866667.0
2014-09-17 16:00:00	IWM	ETF	114.74	114.95	114.4798	114.95	1190900.0
2014-09-17 17:00:00	IWM	ETF	114.98	115.5	114.86	114.89	10750.0
2014-09-17 18:00:00	IWM	ETF	114.85	114.85	114.79	114.79	200.0
2014-09-17 19:00:00	IWM	ETF	114.79	114.79	114.79	114.79	5000.0
2014-09-17 07:00:00	DIA	ETF	171.48	171.5	171.45	171.45	1000.0
2014-09-17 08:00:00	DIA	ETF	171.45	171.5	171.3	171.42	9757.0
2014-09-17 09:00:00	DIA	ETF	171.42	171.75	171.4	171.7	739513.0
2014-09-17 10:00:00	DIA	ETF	171.7	171.8	171.44	171.56	685409.0

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

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