PREVIEW / etf_30min / 2014-04-11

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-04-11.parquet
  size:    347 KB
  rows:    11,696

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-04-11 04:00:00	SPY	ETF	183.46	183.52	183.28	183.4	11264.0
2014-04-11 04:30:00	SPY	ETF	183.4	183.45	183.25	183.25	7302.0
2014-04-11 05:00:00	SPY	ETF	183.25	183.4	183.2	183.4	17695.0
2014-04-11 05:30:00	SPY	ETF	183.37	183.37	183.16	183.35	21161.0
2014-04-11 06:00:00	SPY	ETF	183.32	183.32	183.15	183.27	43386.0
2014-04-11 06:30:00	SPY	ETF	183.27	183.28	183.03	183.04	50714.0
2014-04-11 07:00:00	SPY	ETF	183.06	183.09	182.27	182.38	520687.0
2014-04-11 07:30:00	SPY	ETF	182.35	182.56	182.01	182.36	816620.0
2014-04-11 08:00:00	SPY	ETF	182.35	182.85	182.05	182.27	1002659.0
2014-04-11 08:30:00	SPY	ETF	182.29	182.78	182.2	182.53	1053733.0
2014-04-11 09:00:00	SPY	ETF	182.5	183.17	182.11	182.17	1178533.0
2014-04-11 09:30:00	SPY	ETF	182.17	182.98	181.86	182.69	24395104.0
2014-04-11 10:00:00	SPY	ETF	182.69	182.7699	181.83	182.35	16703331.0
2014-04-11 10:30:00	SPY	ETF	182.35	183.33	182.25	183.12	14345869.0
2014-04-11 11:00:00	SPY	ETF	183.11	183.42	182.82	183.015	11567486.0
2014-04-11 11:30:00	SPY	ETF	183.0	183.08	182.45	182.64	8750086.0
2014-04-11 12:00:00	SPY	ETF	182.63	182.93	182.37	182.512	5702969.0
2014-04-11 12:30:00	SPY	ETF	182.52	182.76	182.41	182.59	3689482.0
2014-04-11 13:00:00	SPY	ETF	182.6	182.61	182.04	182.0979	6379708.0
2014-04-11 13:30:00	SPY	ETF	182.1	182.5	181.95	182.04	5196975.0
2014-04-11 14:00:00	SPY	ETF	182.05	182.315	181.7	181.79	7882336.0
2014-04-11 14:30:00	SPY	ETF	181.78	181.86	181.31	181.73	9694238.0
2014-04-11 15:00:00	SPY	ETF	181.73	182.21	181.422	181.99	11501204.0
2014-04-11 15:30:00	SPY	ETF	181.99	182.12	181.47	181.48	23215105.0
2014-04-11 16:00:00	SPY	ETF	181.48	183.2155	181.47	181.72	8831860.0
2014-04-11 16:30:00	SPY	ETF	181.73	181.75	181.67	181.72	468765.0
2014-04-11 17:00:00	SPY	ETF	181.67	181.69	181.57	181.59	108800.0
2014-04-11 17:30:00	SPY	ETF	181.58	181.6	181.54	181.57	144744.0
2014-04-11 18:00:00	SPY	ETF	181.56	181.63	181.56	181.6	45957.0
2014-04-11 18:30:00	SPY	ETF	181.59	181.61	181.55	181.55	16862.0
2014-04-11 19:00:00	SPY	ETF	181.55	181.57	181.51	181.53	69277.0
2014-04-11 19:30:00	SPY	ETF	181.56	181.56	181.52	181.54	19136.0
2014-04-11 04:00:00	QQQ	ETF	85.16	85.2	85.07	85.11	9369.0
2014-04-11 04:30:00	QQQ	ETF	85.11	85.11	85.05	85.05	500.0
2014-04-11 05:00:00	QQQ	ETF	85.05	85.05	85.0	85.0	2800.0
2014-04-11 05:30:00	QQQ	ETF	85.07	85.07	85.07	85.07	200.0
2014-04-11 06:00:00	QQQ	ETF	84.99	85.03	84.99	85.03	16000.0
2014-04-11 06:30:00	QQQ	ETF	84.93	84.93	84.9	84.93	1700.0
2014-04-11 07:00:00	QQQ	ETF	84.9	84.91	84.44	84.47	268979.0
2014-04-11 07:30:00	QQQ	ETF	84.45	84.56	84.3	84.5	828134.0
2014-04-11 08:00:00	QQQ	ETF	84.48	84.68	84.37	84.43	1349518.0
2014-04-11 08:30:00	QQQ	ETF	84.44	84.74	84.43	84.62	339184.0
2014-04-11 09:00:00	QQQ	ETF	84.61	85.11	84.31	84.36	619236.0
2014-04-11 09:30:00	QQQ	ETF	84.35	85.21	84.14	84.97	15841032.0
2014-04-11 10:00:00	QQQ	ETF	84.97	85.02	84.25	84.77	7492257.0
2014-04-11 10:30:00	QQQ	ETF	84.764	85.44	84.65	85.25	7759405.0
2014-04-11 11:00:00	QQQ	ETF	85.24	85.44	84.98	85.28	5438564.0
2014-04-11 11:30:00	QQQ	ETF	85.27	85.33	84.82	84.93	4164107.0
2014-04-11 12:00:00	QQQ	ETF	84.92	85.16	84.73	84.86	2480474.0
2014-04-11 12:30:00	QQQ	ETF	84.86	85.05	84.8	84.95	1637654.0

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

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