PREVIEW / etf_30min / 2015-04-21

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-04-21.parquet
  size:    374 KB
  rows:    12,704

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-04-21 04:00:00	SPY	ETF	210.8	211.05	210.8	210.85	32237.0
2015-04-21 04:30:00	SPY	ETF	210.85	210.86	210.62	210.66	89991.0
2015-04-21 05:00:00	SPY	ETF	210.57	210.69	210.26	210.34	22920.0
2015-04-21 05:30:00	SPY	ETF	210.14	210.46	210.03	210.43	18013.0
2015-04-21 06:00:00	SPY	ETF	210.43	210.6	210.41	210.51	23258.0
2015-04-21 06:30:00	SPY	ETF	210.48	210.48	210.26	210.26	21418.0
2015-04-21 07:00:00	SPY	ETF	210.33	210.47	210.26	210.26	58564.0
2015-04-21 07:30:00	SPY	ETF	210.28	210.65	210.28	210.51	149859.0
2015-04-21 08:00:00	SPY	ETF	210.51	210.6	210.02	210.54	225447.0
2015-04-21 08:30:00	SPY	ETF	210.54	210.61	209.85	210.59	184643.0
2015-04-21 09:00:00	SPY	ETF	210.6	210.74	210.06	210.69	474079.0
2015-04-21 09:30:00	SPY	ETF	210.67	210.86	210.0	210.06	10545238.0
2015-04-21 10:00:00	SPY	ETF	210.07	210.26	209.8	210.03	6877416.0
2015-04-21 10:30:00	SPY	ETF	210.04	210.05	209.65	209.88	6306887.0
2015-04-21 11:00:00	SPY	ETF	209.88	210.15	209.825	209.88	3290064.0
2015-04-21 11:30:00	SPY	ETF	209.87	209.98	209.495	209.65	3753606.0
2015-04-21 12:00:00	SPY	ETF	209.66	209.78	209.53	209.74	2857356.0
2015-04-21 12:30:00	SPY	ETF	209.74	209.82	209.62	209.72	2855606.0
2015-04-21 13:00:00	SPY	ETF	209.72	209.96	209.71	209.86	3056286.0
2015-04-21 13:30:00	SPY	ETF	209.86	209.92	209.44	209.441	2956833.0
2015-04-21 14:00:00	SPY	ETF	209.44	209.83	209.24	209.82	5167055.0
2015-04-21 14:30:00	SPY	ETF	209.82	209.8643	209.66	209.775	2682955.0
2015-04-21 15:00:00	SPY	ETF	209.775	209.8	209.52	209.58	3307348.0
2015-04-21 15:30:00	SPY	ETF	209.59	209.74	209.43	209.62	7573903.0
2015-04-21 16:00:00	SPY	ETF	209.61	210.7	209.52	209.64	4918109.0
2015-04-21 16:30:00	SPY	ETF	209.65	209.7	209.6	209.66	1863179.0
2015-04-21 17:00:00	SPY	ETF	209.66	209.68	209.6	209.68	1470955.0
2015-04-21 17:30:00	SPY	ETF	209.68	209.69	209.66	209.69	515386.0
2015-04-21 18:00:00	SPY	ETF	209.69	209.88	209.69	209.77	590473.0
2015-04-21 18:30:00	SPY	ETF	209.77	209.79	209.75	209.79	28675.0
2015-04-21 19:00:00	SPY	ETF	209.8	209.8	209.77	209.79	12075.0
2015-04-21 19:30:00	SPY	ETF	209.75	209.84	209.75	209.81	57815.0
2015-04-21 04:00:00	QQQ	ETF	108.26	108.33	108.24	108.29	28588.0
2015-04-21 04:30:00	QQQ	ETF	108.29	108.34	108.15	108.15	57865.0
2015-04-21 05:00:00	QQQ	ETF	108.08	108.09	108.04	108.04	1700.0
2015-04-21 05:30:00	QQQ	ETF	107.92	107.92	107.89	107.89	6200.0
2015-04-21 06:00:00	QQQ	ETF	108.11	108.11	108.03	108.03	1200.0
2015-04-21 06:30:00	QQQ	ETF	108.0	108.0	107.98	107.98	300.0
2015-04-21 07:00:00	QQQ	ETF	107.91	108.04	107.91	107.97	23140.0
2015-04-21 07:30:00	QQQ	ETF	107.97	108.14	107.97	108.08	35610.0
2015-04-21 08:00:00	QQQ	ETF	108.04	108.13	108.01	108.09	32478.0
2015-04-21 08:30:00	QQQ	ETF	108.1	108.18	108.07	108.18	64104.0
2015-04-21 09:00:00	QQQ	ETF	108.19	108.23	108.18	108.21	142029.0
2015-04-21 09:30:00	QQQ	ETF	108.22	108.41	107.95	108.045	5800247.0
2015-04-21 10:00:00	QQQ	ETF	108.05	108.24	107.93	108.1201	3534016.0
2015-04-21 10:30:00	QQQ	ETF	108.13	108.16	107.94	108.067	2682297.0
2015-04-21 11:00:00	QQQ	ETF	108.06	108.22	108.03	108.11	891628.0
2015-04-21 11:30:00	QQQ	ETF	108.1	108.205	107.99	108.06	938844.0
2015-04-21 12:00:00	QQQ	ETF	108.06	108.16	107.99	108.1236	501554.0
2015-04-21 12:30:00	QQQ	ETF	108.13	108.18	108.07	108.13	302432.0

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

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