PREVIEW / etf_30min / 2014-06-11

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-06-11.parquet
  size:    323 KB
  rows:    11,219

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-06-11 04:00:00	SPY	ETF	195.35	195.36	195.31	195.31	732.0
2014-06-11 04:30:00	SPY	ETF	195.35	195.35	195.32	195.32	404.0
2014-06-11 05:00:00	SPY	ETF	195.24	195.24	195.06	195.07	4896.0
2014-06-11 05:30:00	SPY	ETF	195.27	195.4	194.99	194.99	10164.0
2014-06-11 06:00:00	SPY	ETF	194.97	195.07	194.89	195.03	27370.0
2014-06-11 06:30:00	SPY	ETF	195.03	195.03	194.81	194.81	65753.0
2014-06-11 07:00:00	SPY	ETF	194.88	194.91	194.65	194.68	255390.0
2014-06-11 07:30:00	SPY	ETF	194.68	194.77	194.6	194.75	346955.0
2014-06-11 08:00:00	SPY	ETF	194.65	194.88	194.65	194.82	298720.0
2014-06-11 08:30:00	SPY	ETF	194.82	194.84	194.73	194.79	422180.0
2014-06-11 09:00:00	SPY	ETF	194.79	194.93	194.75	194.9	325232.0
2014-06-11 09:30:00	SPY	ETF	194.9	195.12	194.8	194.96	7526402.0
2014-06-11 10:00:00	SPY	ETF	194.95	195.11	194.8	194.84	3603020.0
2014-06-11 10:30:00	SPY	ETF	194.84	194.945	194.67	194.76	5309144.0
2014-06-11 11:00:00	SPY	ETF	194.765	194.97	194.765	194.8656	3351119.0
2014-06-11 11:30:00	SPY	ETF	194.865	195.055	194.81	195.05	2830338.0
2014-06-11 12:00:00	SPY	ETF	195.045	195.1	194.97	194.981	2312991.0
2014-06-11 12:30:00	SPY	ETF	194.98	195.06	194.96	195.05	1678218.0
2014-06-11 13:00:00	SPY	ETF	195.05	195.055	194.83	194.9986	1812370.0
2014-06-11 13:30:00	SPY	ETF	194.9999	195.02	194.71	194.71	2344785.0
2014-06-11 14:00:00	SPY	ETF	194.71	194.77	194.48	194.655	5481108.0
2014-06-11 14:30:00	SPY	ETF	194.65	194.83	194.62	194.75	2712333.0
2014-06-11 15:00:00	SPY	ETF	194.75	194.931	194.745	194.931	9057361.0
2014-06-11 15:30:00	SPY	ETF	194.94	195.1	194.82	194.94	8194878.0
2014-06-11 16:00:00	SPY	ETF	194.95	195.5803	194.89	194.96	7335777.0
2014-06-11 16:30:00	SPY	ETF	194.97	195.5803	194.95	195.0	1175677.0
2014-06-11 17:00:00	SPY	ETF	195.0	195.05	194.99	195.05	73681.0
2014-06-11 17:30:00	SPY	ETF	195.03	195.04	195.01	195.03	4598.0
2014-06-11 18:00:00	SPY	ETF	195.01	195.01	194.89	194.92	35642.0
2014-06-11 18:30:00	SPY	ETF	194.92	195.0	194.92	195.0	5937.0
2014-06-11 19:00:00	SPY	ETF	195.0	195.06	195.0	195.03	14190.0
2014-06-11 19:30:00	SPY	ETF	195.02	195.06	195.01	195.06	13326.0
2014-06-11 04:30:00	QQQ	ETF	92.81	92.81	92.81	92.81	100.0
2014-06-11 05:00:00	QQQ	ETF	92.76	92.76	92.66	92.66	300.0
2014-06-11 05:30:00	QQQ	ETF	92.65	92.65	92.65	92.65	100.0
2014-06-11 06:00:00	QQQ	ETF	92.63	92.7	92.61	92.7	1200.0
2014-06-11 06:30:00	QQQ	ETF	92.62	92.62	92.56	92.57	22216.0
2014-06-11 07:00:00	QQQ	ETF	92.55	92.55	92.42	92.45	23100.0
2014-06-11 07:30:00	QQQ	ETF	92.47	92.52	92.42	92.49	51400.0
2014-06-11 08:00:00	QQQ	ETF	92.48	92.56	92.47	92.56	24123.0
2014-06-11 08:30:00	QQQ	ETF	92.56	92.56	92.49	92.5	45028.0
2014-06-11 09:00:00	QQQ	ETF	92.5	92.59	92.48	92.59	165119.0
2014-06-11 09:30:00	QQQ	ETF	92.59	92.92	92.53	92.83	3652342.0
2014-06-11 10:00:00	QQQ	ETF	92.83	92.97	92.77	92.84	1870252.0
2014-06-11 10:30:00	QQQ	ETF	92.84	92.86	92.74	92.82	1009844.0
2014-06-11 11:00:00	QQQ	ETF	92.82	92.93	92.79	92.86	1341713.0
2014-06-11 11:30:00	QQQ	ETF	92.87	93.02	92.821	92.975	1130489.0
2014-06-11 12:00:00	QQQ	ETF	92.975	92.98	92.895	92.91	813554.0
2014-06-11 12:30:00	QQQ	ETF	92.91	92.99	92.9	92.99	489754.0
2014-06-11 13:00:00	QQQ	ETF	92.99	92.99	92.85	92.92	889522.0

> showing 50 of 11,219 rows — these rows as CSV

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