PREVIEW / etf_30min / 2014-11-24

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-11-24.parquet
  size:    360 KB
  rows:    12,340

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-11-24 04:00:00	SPY	ETF	206.68	207.2	206.68	207.05	53370.0
2014-11-24 04:30:00	SPY	ETF	207.05	207.05	207.05	207.05	1500.0
2014-11-24 05:00:00	SPY	ETF	207.06	207.09	207.05	207.07	3540.0
2014-11-24 05:30:00	SPY	ETF	207.06	207.18	207.06	207.18	22790.0
2014-11-24 06:00:00	SPY	ETF	207.2	207.23	207.05	207.07	14319.0
2014-11-24 06:30:00	SPY	ETF	207.07	207.11	206.95	207.04	50628.0
2014-11-24 07:00:00	SPY	ETF	207.15	207.21	207.12	207.16	50723.0
2014-11-24 07:30:00	SPY	ETF	207.18	207.26	207.08	207.12	56764.0
2014-11-24 08:00:00	SPY	ETF	207.12	207.26	207.05	207.23	190729.0
2014-11-24 08:30:00	SPY	ETF	207.24	207.33	207.19	207.28	211540.0
2014-11-24 09:00:00	SPY	ETF	207.27	207.29	207.14	207.19	667385.0
2014-11-24 09:30:00	SPY	ETF	207.17	207.39	206.93	207.03	9837041.0
2014-11-24 10:00:00	SPY	ETF	207.01	207.27	206.97	207.2443	6190821.0
2014-11-24 10:30:00	SPY	ETF	207.25	207.34	207.145	207.2	3404870.0
2014-11-24 11:00:00	SPY	ETF	207.205	207.25	206.96	207.01	4324315.0
2014-11-24 11:30:00	SPY	ETF	207.0	207.11	206.97	207.06	2343118.0
2014-11-24 12:00:00	SPY	ETF	207.051	207.2	207.03	207.17	2205162.0
2014-11-24 12:30:00	SPY	ETF	207.16	207.17	206.91	206.99	2856785.0
2014-11-24 13:00:00	SPY	ETF	206.99	207.11	206.96	207.1	1647410.0
2014-11-24 13:30:00	SPY	ETF	207.1	207.11	206.97	207.07	1619569.0
2014-11-24 14:00:00	SPY	ETF	207.07	207.25	207.06	207.24	2185593.0
2014-11-24 14:30:00	SPY	ETF	207.24	207.27	207.04	207.085	4125865.0
2014-11-24 15:00:00	SPY	ETF	207.0855	207.14	206.985	207.125	5943702.0
2014-11-24 15:30:00	SPY	ETF	207.12	207.32	207.12	207.28	8896894.0
2014-11-24 16:00:00	SPY	ETF	207.29	207.31	207.24	207.25	3969732.0
2014-11-24 16:30:00	SPY	ETF	207.26	207.29	206.6801	207.26	1048034.0
2014-11-24 17:00:00	SPY	ETF	207.26	207.27	207.25	207.27	36976.0
2014-11-24 17:30:00	SPY	ETF	207.27	207.28	207.25	207.26	33901.0
2014-11-24 18:00:00	SPY	ETF	207.25	207.26	207.22	207.25	49005.0
2014-11-24 18:30:00	SPY	ETF	207.24	207.38	207.24	207.36	45219.0
2014-11-24 19:00:00	SPY	ETF	207.33	207.33	207.23	207.25	38746.0
2014-11-24 19:30:00	SPY	ETF	207.27	207.27	207.18	207.22	82398.0
2014-11-24 04:00:00	QQQ	ETF	104.53	104.53	104.14	104.14	200.0
2014-11-24 05:30:00	QQQ	ETF	104.07	104.07	104.07	104.07	300.0
2014-11-24 06:00:00	QQQ	ETF	104.1	104.1	104.08	104.08	2700.0
2014-11-24 06:30:00	QQQ	ETF	104.02	104.1	104.02	104.07	19850.0
2014-11-24 07:00:00	QQQ	ETF	104.11	104.11	104.1	104.1	4800.0
2014-11-24 07:30:00	QQQ	ETF	104.15	104.17	104.08	104.09	17679.0
2014-11-24 08:00:00	QQQ	ETF	104.1	104.17	104.07	104.15	59772.0
2014-11-24 08:30:00	QQQ	ETF	104.17	104.24	104.16	104.2	50972.0
2014-11-24 09:00:00	QQQ	ETF	104.2	104.2	103.87	104.16	54294.0
2014-11-24 09:30:00	QQQ	ETF	104.15	104.385	104.06	104.315	2569403.0
2014-11-24 10:00:00	QQQ	ETF	104.31	104.48	104.3	104.46	1225602.0
2014-11-24 10:30:00	QQQ	ETF	104.455	104.52	104.34	104.415	1221219.0
2014-11-24 11:00:00	QQQ	ETF	104.41	104.45	104.36	104.4099	750529.0
2014-11-24 11:30:00	QQQ	ETF	104.41	104.5	104.38	104.49	467477.0
2014-11-24 12:00:00	QQQ	ETF	104.49	104.6	104.49	104.5901	932213.0
2014-11-24 12:30:00	QQQ	ETF	104.59	104.5999	104.41	104.49	888614.0
2014-11-24 13:00:00	QQQ	ETF	104.48	104.59	104.46	104.59	560184.0
2014-11-24 13:30:00	QQQ	ETF	104.59	104.61	104.53	104.6	512724.0

> showing 50 of 12,340 rows — these rows as CSV

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