PREVIEW / etf_30min / 2014-02-14

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-02-14.parquet
  size:    333 KB
  rows:    11,282

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-02-14 04:00:00	SPY	ETF	182.6	183.05	182.58	183.05	10219.0
2014-02-14 04:30:00	SPY	ETF	183.04	183.04	182.95	182.95	4791.0
2014-02-14 05:00:00	SPY	ETF	182.95	182.95	182.85	182.86	26832.0
2014-02-14 05:30:00	SPY	ETF	182.91	182.95	182.86	182.92	7055.0
2014-02-14 06:00:00	SPY	ETF	182.87	182.93	182.87	182.91	6968.0
2014-02-14 06:30:00	SPY	ETF	182.9	183.14	182.89	183.14	35724.0
2014-02-14 07:00:00	SPY	ETF	183.12	183.19	183.0	183.05	89639.0
2014-02-14 07:30:00	SPY	ETF	183.06	183.14	183.0	183.08	95178.0
2014-02-14 08:00:00	SPY	ETF	183.07	183.07	182.83	183.06	299407.0
2014-02-14 08:30:00	SPY	ETF	183.05	183.11	182.86	182.95	411126.0
2014-02-14 09:00:00	SPY	ETF	182.96	182.96	182.58	182.84	1361690.0
2014-02-14 09:30:00	SPY	ETF	182.84	183.23	182.67	183.13	9554590.0
2014-02-14 10:00:00	SPY	ETF	183.13	183.6101	182.89	183.554	9698604.0
2014-02-14 10:30:00	SPY	ETF	183.55	183.78	183.44	183.5	5868014.0
2014-02-14 11:00:00	SPY	ETF	183.49	183.57	183.419	183.49	5331240.0
2014-02-14 11:30:00	SPY	ETF	183.5	183.74	183.5	183.61	4360620.0
2014-02-14 12:00:00	SPY	ETF	183.61	183.66	183.53	183.58	3153604.0
2014-02-14 12:30:00	SPY	ETF	183.6	183.73	183.54	183.66	5253627.0
2014-02-14 13:00:00	SPY	ETF	183.66	183.86	183.611	183.85	2664183.0
2014-02-14 13:30:00	SPY	ETF	183.85	184.07	183.81	184.03	4919655.0
2014-02-14 14:00:00	SPY	ETF	184.0201	184.19	184.0	184.145	4448874.0
2014-02-14 14:30:00	SPY	ETF	184.142	184.36	184.11	184.29	4372079.0
2014-02-14 15:00:00	SPY	ETF	184.285	184.31	184.03	184.13	6151605.0
2014-02-14 15:30:00	SPY	ETF	184.14	184.17	183.92	184.01	12133682.0
2014-02-14 16:00:00	SPY	ETF	184.01	184.06	183.1503	184.02	12152280.0
2014-02-14 16:30:00	SPY	ETF	184.0	184.0327	183.98	183.99	1418217.0
2014-02-14 17:00:00	SPY	ETF	183.99	184.0	183.6873	184.0	493485.0
2014-02-14 17:30:00	SPY	ETF	183.98	183.98	183.93	183.97	37360.0
2014-02-14 18:00:00	SPY	ETF	183.97	183.98	183.95	183.98	3080.0
2014-02-14 18:30:00	SPY	ETF	183.99	184.01	183.95	184.01	5743.0
2014-02-14 19:00:00	SPY	ETF	184.0	184.0	183.97	184.0	900.0
2014-02-14 19:30:00	SPY	ETF	184.01	184.01	183.95	184.01	10034.0
2014-02-14 05:30:00	QQQ	ETF	89.65	89.68	89.65	89.68	3300.0
2014-02-14 06:00:00	QQQ	ETF	89.67	89.67	89.65	89.65	2600.0
2014-02-14 06:30:00	QQQ	ETF	89.74	89.78	89.74	89.76	4400.0
2014-02-14 07:00:00	QQQ	ETF	89.76	89.79	89.71	89.74	7700.0
2014-02-14 07:30:00	QQQ	ETF	89.71	89.76	89.71	89.74	9400.0
2014-02-14 08:00:00	QQQ	ETF	89.73	89.74	89.63	89.7	49545.0
2014-02-14 08:30:00	QQQ	ETF	89.69	89.73	89.61	89.65	17232.0
2014-02-14 09:00:00	QQQ	ETF	89.64	89.64	89.48	89.55	505592.0
2014-02-14 09:30:00	QQQ	ETF	89.56	89.63	89.37	89.46	4163729.0
2014-02-14 10:00:00	QQQ	ETF	89.46	89.7	89.33	89.65	3569303.0
2014-02-14 10:30:00	QQQ	ETF	89.65	89.78	89.49	89.5199	2296996.0
2014-02-14 11:00:00	QQQ	ETF	89.52	89.66	89.48	89.63	2408933.0
2014-02-14 11:30:00	QQQ	ETF	89.63	89.75	89.63	89.699	1392103.0
2014-02-14 12:00:00	QQQ	ETF	89.7	89.72	89.57	89.585	1085099.0
2014-02-14 12:30:00	QQQ	ETF	89.58	89.72	89.56	89.67	749029.0
2014-02-14 13:00:00	QQQ	ETF	89.675	89.79	89.65	89.76	654624.0
2014-02-14 13:30:00	QQQ	ETF	89.76	89.9	89.75	89.8699	1205511.0
2014-02-14 14:00:00	QQQ	ETF	89.867	89.92	89.85	89.89	1020375.0

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

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