PREVIEW / etf_30min / 2015-08-13

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-08-13.parquet
  size:    372 KB
  rows:    12,549

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
2015-08-13 04:00:00	SPY	ETF	209.39	209.55	209.1	209.1	32978.0
2015-08-13 04:30:00	SPY	ETF	209.08	209.56	209.01	209.54	31577.0
2015-08-13 05:00:00	SPY	ETF	209.61	209.61	209.28	209.35	11761.0
2015-08-13 05:30:00	SPY	ETF	209.36	209.39	209.31	209.39	13300.0
2015-08-13 06:00:00	SPY	ETF	209.44	209.73	209.44	209.61	22188.0
2015-08-13 06:30:00	SPY	ETF	209.61	209.71	209.58	209.69	28798.0
2015-08-13 07:00:00	SPY	ETF	209.63	209.79	209.61	209.69	76786.0
2015-08-13 07:30:00	SPY	ETF	209.69	209.73	209.43	209.43	152902.0
2015-08-13 08:00:00	SPY	ETF	209.43	209.68	209.31	209.34	180763.0
2015-08-13 08:30:00	SPY	ETF	209.34	209.49	208.85	208.86	482232.0
2015-08-13 09:00:00	SPY	ETF	208.86	208.99	208.71	208.74	767254.0
2015-08-13 09:30:00	SPY	ETF	208.73	209.039	208.0901	208.38	11232605.0
2015-08-13 10:00:00	SPY	ETF	208.38	208.53	208.01	208.4099	5929664.0
2015-08-13 10:30:00	SPY	ETF	208.4	208.93	208.23	208.6	7142498.0
2015-08-13 11:00:00	SPY	ETF	208.57	208.82	208.2601	208.61	4980681.0
2015-08-13 11:30:00	SPY	ETF	208.62	209.04	208.52	208.88	5178168.0
2015-08-13 12:00:00	SPY	ETF	208.89	209.36	208.89	209.33	4589829.0
2015-08-13 12:30:00	SPY	ETF	209.34	209.4	209.1	209.305	4121702.0
2015-08-13 13:00:00	SPY	ETF	209.295	209.55	209.28	209.46	3654063.0
2015-08-13 13:30:00	SPY	ETF	209.46	209.51	209.04	209.185	3740717.0
2015-08-13 14:00:00	SPY	ETF	209.19	209.47	209.1	209.435	4346944.0
2015-08-13 14:30:00	SPY	ETF	209.44	209.5	209.32	209.44	4596554.0
2015-08-13 15:00:00	SPY	ETF	209.445	209.48	208.89	208.89	7290965.0
2015-08-13 15:30:00	SPY	ETF	208.9	208.915	208.4	208.63	16092521.0
2015-08-13 16:00:00	SPY	ETF	208.62	208.79	208.61	208.7	2182747.0
2015-08-13 16:30:00	SPY	ETF	208.69	208.77	208.6	208.74	630192.0
2015-08-13 17:00:00	SPY	ETF	208.74	208.8078	208.6	208.65	157848.0
2015-08-13 17:30:00	SPY	ETF	208.64	208.64	208.6	208.6	13856.0
2015-08-13 18:00:00	SPY	ETF	208.66	208.66	208.56	208.6	34098.0
2015-08-13 18:30:00	SPY	ETF	208.6	208.6	208.53	208.53	126265.0
2015-08-13 19:00:00	SPY	ETF	208.54	208.54	208.48	208.51	18823.0
2015-08-13 19:30:00	SPY	ETF	208.55	208.57	208.51	208.54	20341.0
2015-08-13 04:00:00	QQQ	ETF	111.0	111.0	110.88	110.88	52620.0
2015-08-13 04:30:00	QQQ	ETF	110.85	110.99	110.85	110.99	26250.0
2015-08-13 05:30:00	QQQ	ETF	110.85	110.85	110.85	110.85	5000.0
2015-08-13 06:00:00	QQQ	ETF	111.05	111.05	110.9	110.9	1100.0
2015-08-13 06:30:00	QQQ	ETF	110.98	111.01	110.98	111.01	7250.0
2015-08-13 07:00:00	QQQ	ETF	111.09	111.09	111.05	111.05	29950.0
2015-08-13 07:30:00	QQQ	ETF	111.07	111.11	111.0	111.01	11925.0
2015-08-13 08:00:00	QQQ	ETF	111.01	111.1	110.89	110.89	17212.0
2015-08-13 08:30:00	QQQ	ETF	110.9	111.0	110.69	110.69	73089.0
2015-08-13 09:00:00	QQQ	ETF	110.68	110.75	110.553	110.62	232171.0
2015-08-13 09:30:00	QQQ	ETF	110.62	110.94	110.19	110.34	4825044.0
2015-08-13 10:00:00	QQQ	ETF	110.3	110.51	110.1	110.3668	1567136.0
2015-08-13 10:30:00	QQQ	ETF	110.36	110.814	110.22	110.5	1814952.0
2015-08-13 11:00:00	QQQ	ETF	110.5	110.68	110.31	110.53	971031.0
2015-08-13 11:30:00	QQQ	ETF	110.54	110.87	110.49	110.725	846430.0
2015-08-13 12:00:00	QQQ	ETF	110.73	111.03	110.73	111.02	1098773.0
2015-08-13 12:30:00	QQQ	ETF	111.02	111.08	110.87	110.962	901804.0
2015-08-13 13:00:00	QQQ	ETF	110.965	111.16	110.95	111.08	892879.0

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

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