PREVIEW / etf_30min / 2014-03-27

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-03-27.parquet
  size:    335 KB
  rows:    11,303

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-03-27 04:00:00	SPY	ETF	185.14	185.14	184.94	184.94	11301.0
2014-03-27 04:30:00	SPY	ETF	184.91	185.05	184.91	184.97	2450.0
2014-03-27 05:00:00	SPY	ETF	185.0	185.2	185.0	185.2	9434.0
2014-03-27 05:30:00	SPY	ETF	185.22	185.3	185.14	185.26	63350.0
2014-03-27 06:00:00	SPY	ETF	185.26	185.29	185.04	185.09	92512.0
2014-03-27 06:30:00	SPY	ETF	185.12	185.21	185.08	185.2	10335.0
2014-03-27 07:00:00	SPY	ETF	185.21	185.27	184.96	185.06	140348.0
2014-03-27 07:30:00	SPY	ETF	185.06	185.17	184.94	184.96	125422.0
2014-03-27 08:00:00	SPY	ETF	184.99	185.14	184.89	184.96	236600.0
2014-03-27 08:30:00	SPY	ETF	184.93	185.05	184.43	184.67	1055356.0
2014-03-27 09:00:00	SPY	ETF	184.65	184.85	184.59	184.78	1070508.0
2014-03-27 09:30:00	SPY	ETF	184.77	184.94	183.9	184.48	22239387.0
2014-03-27 10:00:00	SPY	ETF	184.47	185.34	184.32	185.19	16638162.0
2014-03-27 10:30:00	SPY	ETF	185.19	185.31	184.83	185.03	8845868.0
2014-03-27 11:00:00	SPY	ETF	185.07	185.1666	184.64	184.72	10260686.0
2014-03-27 11:30:00	SPY	ETF	184.72	184.725	184.04	184.37	15100158.0
2014-03-27 12:00:00	SPY	ETF	184.37	184.66	184.03	184.65	7786746.0
2014-03-27 12:30:00	SPY	ETF	184.65	184.8799	184.43	184.58	4237567.0
2014-03-27 13:00:00	SPY	ETF	184.58	184.94	184.57	184.82	6033997.0
2014-03-27 13:30:00	SPY	ETF	184.83	184.86	184.36	184.51	5760366.0
2014-03-27 14:00:00	SPY	ETF	184.52	184.73	184.24	184.66	6362317.0
2014-03-27 14:30:00	SPY	ETF	184.6601	184.7	184.32	184.47	4818820.0
2014-03-27 15:00:00	SPY	ETF	184.47	184.71	184.27	184.62	6032549.0
2014-03-27 15:30:00	SPY	ETF	184.63	184.89	184.56	184.62	13507868.0
2014-03-27 16:00:00	SPY	ETF	184.64	185.0035	184.46	184.6	6438355.0
2014-03-27 16:30:00	SPY	ETF	184.61	184.75	184.61	184.74	190829.0
2014-03-27 17:00:00	SPY	ETF	184.75	184.85	184.58	184.85	499476.0
2014-03-27 17:30:00	SPY	ETF	184.83	184.83	184.6523	184.78	243021.0
2014-03-27 18:00:00	SPY	ETF	184.79	184.86	184.79	184.86	86266.0
2014-03-27 18:30:00	SPY	ETF	184.86	184.9	184.83	184.85	32650.0
2014-03-27 19:00:00	SPY	ETF	184.88	184.89	184.83	184.86	42865.0
2014-03-27 19:30:00	SPY	ETF	184.87	184.87	184.76	184.8	49730.0
2014-03-27 04:00:00	QQQ	ETF	87.44	87.44	87.42	87.42	600.0
2014-03-27 04:30:00	QQQ	ETF	87.43	87.48	87.43	87.44	500.0
2014-03-27 05:00:00	QQQ	ETF	87.48	87.5	87.48	87.5	500.0
2014-03-27 05:30:00	QQQ	ETF	87.59	87.6	87.58	87.6	1200.0
2014-03-27 06:00:00	QQQ	ETF	87.6	87.6	87.49	87.5	4100.0
2014-03-27 06:30:00	QQQ	ETF	87.51	87.56	87.48	87.56	21600.0
2014-03-27 07:00:00	QQQ	ETF	87.55	87.57	87.43	87.43	32535.0
2014-03-27 07:30:00	QQQ	ETF	87.48	87.5	87.4	87.4	7800.0
2014-03-27 08:00:00	QQQ	ETF	87.42	87.47	87.35	87.38	33667.0
2014-03-27 08:30:00	QQQ	ETF	87.4	87.42	87.13	87.27	212785.0
2014-03-27 09:00:00	QQQ	ETF	87.25	87.36	87.18	87.27	129072.0
2014-03-27 09:30:00	QQQ	ETF	87.27	87.329	86.4	87.0	12863173.0
2014-03-27 10:00:00	QQQ	ETF	87.01	87.64	86.8701	87.49	10744195.0
2014-03-27 10:30:00	QQQ	ETF	87.5	87.54	87.09	87.319	3869798.0
2014-03-27 11:00:00	QQQ	ETF	87.31	87.36	86.91	86.92	3222403.0
2014-03-27 11:30:00	QQQ	ETF	86.92	86.925	86.56	86.83	3567934.0
2014-03-27 12:00:00	QQQ	ETF	86.83	87.05	86.53	87.031	3910916.0
2014-03-27 12:30:00	QQQ	ETF	87.04	87.089	86.83	86.97	2315901.0

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

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