PREVIEW / etf_30min / 2014-05-29

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-05-29.parquet
  size:    324 KB
  rows:    11,188

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-05-29 04:00:00	SPY	ETF	191.65	191.65	191.56	191.65	5428.0
2014-05-29 04:30:00	SPY	ETF	191.63	191.63	191.63	191.63	229.0
2014-05-29 05:30:00	SPY	ETF	191.5	191.62	191.5	191.62	3645.0
2014-05-29 06:00:00	SPY	ETF	191.63	191.66	191.58	191.58	2386.0
2014-05-29 06:30:00	SPY	ETF	191.55	191.68	191.54	191.68	8478.0
2014-05-29 07:00:00	SPY	ETF	191.69	191.69	191.56	191.61	84470.0
2014-05-29 07:30:00	SPY	ETF	191.61	191.69	191.57	191.57	66401.0
2014-05-29 08:00:00	SPY	ETF	191.59	191.77	191.57	191.65	175772.0
2014-05-29 08:30:00	SPY	ETF	191.64	192.08	191.48	191.78	540094.0
2014-05-29 09:00:00	SPY	ETF	191.78	191.89	191.71	191.83	564666.0
2014-05-29 09:30:00	SPY	ETF	191.82	191.96	191.66	191.81	7397165.0
2014-05-29 10:00:00	SPY	ETF	191.81	191.87	191.33	191.55	7479859.0
2014-05-29 10:30:00	SPY	ETF	191.55	191.79	191.46	191.74	4391378.0
2014-05-29 11:00:00	SPY	ETF	191.75	191.86	191.65	191.8	2491392.0
2014-05-29 11:30:00	SPY	ETF	191.81	191.9	191.7	191.73	2552860.0
2014-05-29 12:00:00	SPY	ETF	191.73	191.89	191.715	191.77	2617207.0
2014-05-29 12:30:00	SPY	ETF	191.77	191.815	191.74	191.805	1066155.0
2014-05-29 13:00:00	SPY	ETF	191.8	191.83	191.76	191.775	1066948.0
2014-05-29 13:30:00	SPY	ETF	191.77	191.89	191.74	191.8277	2051828.0
2014-05-29 14:00:00	SPY	ETF	191.82	191.98	191.79	191.96	3478692.0
2014-05-29 14:30:00	SPY	ETF	191.955	192.2	191.93	192.1575	5029303.0
2014-05-29 15:00:00	SPY	ETF	192.17	192.327	192.1599	192.32	5423719.0
2014-05-29 15:30:00	SPY	ETF	192.32	192.38	192.16	192.38	10975487.0
2014-05-29 16:00:00	SPY	ETF	192.37	192.4	192.0845	192.34	3698925.0
2014-05-29 16:30:00	SPY	ETF	192.34	192.38	192.32	192.35	416982.0
2014-05-29 17:00:00	SPY	ETF	192.35	192.36	192.28	192.34	58717.0
2014-05-29 17:30:00	SPY	ETF	192.32	192.35	192.29	192.3	47397.0
2014-05-29 18:00:00	SPY	ETF	192.3	192.32	192.28	192.29	72401.0
2014-05-29 18:30:00	SPY	ETF	192.31	192.34	192.28	192.3	26826.0
2014-05-29 19:00:00	SPY	ETF	192.29	192.3	192.26	192.3	77545.0
2014-05-29 19:30:00	SPY	ETF	192.29	192.32	192.28	192.3	30292.0
2014-05-29 04:00:00	QQQ	ETF	90.99	90.99	90.99	90.99	349.0
2014-05-29 04:30:00	QQQ	ETF	90.96	90.97	90.93	90.93	14000.0
2014-05-29 05:00:00	QQQ	ETF	90.94	90.94	90.93	90.93	7300.0
2014-05-29 06:00:00	QQQ	ETF	90.91	90.91	90.91	90.91	1500.0
2014-05-29 06:30:00	QQQ	ETF	90.95	90.95	90.95	90.95	800.0
2014-05-29 07:00:00	QQQ	ETF	90.94	90.94	90.94	90.94	10000.0
2014-05-29 07:30:00	QQQ	ETF	90.93	90.96	90.93	90.95	89441.0
2014-05-29 08:00:00	QQQ	ETF	90.87	90.94	90.85	90.93	35467.0
2014-05-29 08:30:00	QQQ	ETF	90.86	90.98	90.83	90.95	151921.0
2014-05-29 09:00:00	QQQ	ETF	90.98	91.13	90.95	91.05	172393.0
2014-05-29 09:30:00	QQQ	ETF	91.05	91.14	90.88	91.09	3689555.0
2014-05-29 10:00:00	QQQ	ETF	91.08	91.12	90.86	90.99	2289706.0
2014-05-29 10:30:00	QQQ	ETF	90.99	91.1	90.945	91.06	1614467.0
2014-05-29 11:00:00	QQQ	ETF	91.07	91.12	90.99	91.12	996647.0
2014-05-29 11:30:00	QQQ	ETF	91.11	91.19	90.98	91.0	1242011.0
2014-05-29 12:00:00	QQQ	ETF	91.0	91.11	90.963	91.01	732692.0
2014-05-29 12:30:00	QQQ	ETF	91.008	91.06	90.97	91.06	536155.0
2014-05-29 13:00:00	QQQ	ETF	91.05	91.08	90.99	91.04	579789.0
2014-05-29 13:30:00	QQQ	ETF	91.04	91.1023	91.0	91.06	544962.0

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

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