PREVIEW / etf_30min / 2017-09-18

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-09-18.parquet
  size:    440 KB
  rows:    15,241

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
2017-09-18 04:00:00	SPY	ETF	249.61	249.78	249.61	249.78	3263.0
2017-09-18 04:30:00	SPY	ETF	249.78	249.86	249.76	249.8	2700.0
2017-09-18 05:00:00	SPY	ETF	249.8	249.86	249.79	249.8	1900.0
2017-09-18 05:30:00	SPY	ETF	249.85	249.88	249.85	249.88	1630.0
2017-09-18 06:00:00	SPY	ETF	249.78	249.82	249.75	249.75	3900.0
2017-09-18 06:30:00	SPY	ETF	249.75	249.82	249.75	249.75	55051.0
2017-09-18 07:00:00	SPY	ETF	249.75	249.75	249.67	249.67	49627.0
2017-09-18 07:30:00	SPY	ETF	249.66	249.75	249.66	249.74	36087.0
2017-09-18 08:00:00	SPY	ETF	249.74	249.75	249.6	249.6	153948.0
2017-09-18 08:30:00	SPY	ETF	249.61	249.65	249.52	249.56	81298.0
2017-09-18 09:00:00	SPY	ETF	249.57	249.71	249.57	249.65	293090.0
2017-09-18 09:30:00	SPY	ETF	249.61	250.12	249.47	249.995	5635703.0
2017-09-18 10:00:00	SPY	ETF	249.99	250.05	249.3	249.93	4425645.0
2017-09-18 10:30:00	SPY	ETF	249.93	250.01	249.875	249.885	1694403.0
2017-09-18 11:00:00	SPY	ETF	249.88	250.07	249.87	250.05	2860081.0
2017-09-18 11:30:00	SPY	ETF	250.06	250.07	249.87	249.9	2017445.0
2017-09-18 12:00:00	SPY	ETF	249.9	249.96	249.86	249.89	1289861.0
2017-09-18 12:30:00	SPY	ETF	249.89	249.89	249.71	249.86	3130618.0
2017-09-18 13:00:00	SPY	ETF	249.86	249.8715	249.75	249.77	1055036.0
2017-09-18 13:30:00	SPY	ETF	249.76	249.95	249.76	249.84	1216995.0
2017-09-18 14:00:00	SPY	ETF	249.84	249.845	249.35	249.51	3003075.0
2017-09-18 14:30:00	SPY	ETF	249.51	249.54	249.28	249.48	2906687.0
2017-09-18 15:00:00	SPY	ETF	249.47	249.68	249.455	249.625	3141260.0
2017-09-18 15:30:00	SPY	ETF	249.62	249.78	249.56	249.69	5522019.0
2017-09-18 16:00:00	SPY	ETF	249.7	249.78	249.63	249.76	6474039.0
2017-09-18 16:30:00	SPY	ETF	249.76	249.77	249.72	249.77	184367.0
2017-09-18 17:00:00	SPY	ETF	249.75	249.76	249.69	249.71	321160.0
2017-09-18 17:30:00	SPY	ETF	249.74	249.74	249.71	249.72	3737.0
2017-09-18 18:00:00	SPY	ETF	249.72	249.78	249.71	249.74	36678.0
2017-09-18 18:30:00	SPY	ETF	249.72	249.78	249.72	249.75	6956.0
2017-09-18 19:00:00	SPY	ETF	249.75	249.76	249.75	249.76	980.0
2017-09-18 19:30:00	SPY	ETF	249.75	249.78	249.72	249.74	20478.0
2017-09-18 04:00:00	QQQ	ETF	146.04	146.3	145.97	146.04	45201.0
2017-09-18 04:30:00	QQQ	ETF	146.05	146.05	145.95	145.95	837.0
2017-09-18 05:30:00	QQQ	ETF	146.07	146.08	146.07	146.08	6700.0
2017-09-18 06:00:00	QQQ	ETF	146.0	146.0	146.0	146.0	100.0
2017-09-18 06:30:00	QQQ	ETF	146.04	146.25	146.04	146.1	58095.0
2017-09-18 07:00:00	QQQ	ETF	146.06	146.06	145.99	146.0	8865.0
2017-09-18 07:30:00	QQQ	ETF	146.05	146.07	146.0	146.05	14437.0
2017-09-18 08:00:00	QQQ	ETF	146.0	146.06	145.9	145.91	39267.0
2017-09-18 08:30:00	QQQ	ETF	145.92	145.96	145.82	145.85	58818.0
2017-09-18 09:00:00	QQQ	ETF	145.87	145.98	145.85	145.86	88127.0
2017-09-18 09:30:00	QQQ	ETF	145.88	146.37	145.75	146.2	2765196.0
2017-09-18 10:00:00	QQQ	ETF	146.2	146.3399	146.005	146.17	1180253.0
2017-09-18 10:30:00	QQQ	ETF	146.1658	146.22	145.98	146.05	1448394.0
2017-09-18 11:00:00	QQQ	ETF	146.05	146.29	146.045	146.27	1448626.0
2017-09-18 11:30:00	QQQ	ETF	146.28	146.28	146.16	146.17	778746.0
2017-09-18 12:00:00	QQQ	ETF	146.18	146.28	146.17	146.23	648450.0
2017-09-18 12:30:00	QQQ	ETF	146.221	146.24	146.06	146.1793	687576.0
2017-09-18 13:00:00	QQQ	ETF	146.17	146.1701	146.02	146.02	371483.0

> showing 50 of 15,241 rows — these rows as CSV

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