PREVIEW / etf_30min / 2016-09-30

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-09-30.parquet
  size:    405 KB
  rows:    13,763

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
2016-09-30 04:00:00	SPY	ETF	214.3	214.7	214.14	214.7	28071.0
2016-09-30 04:30:00	SPY	ETF	214.6	214.8	214.4	214.8	37454.0
2016-09-30 05:00:00	SPY	ETF	214.83	214.85	214.69	214.79	2788.0
2016-09-30 05:30:00	SPY	ETF	214.73	215.07	214.73	215.01	11988.0
2016-09-30 06:00:00	SPY	ETF	214.86	214.92	214.69	214.74	54316.0
2016-09-30 06:30:00	SPY	ETF	214.68	215.25	214.65	215.12	175790.0
2016-09-30 07:00:00	SPY	ETF	215.15	215.21	214.91	214.94	373125.0
2016-09-30 07:30:00	SPY	ETF	214.94	215.14	214.93	215.04	149297.0
2016-09-30 08:00:00	SPY	ETF	214.95	215.31	213.93	215.27	544053.0
2016-09-30 08:30:00	SPY	ETF	215.27	215.54	215.19	215.38	692828.0
2016-09-30 09:00:00	SPY	ETF	215.39	215.7	213.93	215.65	962315.0
2016-09-30 09:30:00	SPY	ETF	215.65	216.13	215.36	215.48	12040221.0
2016-09-30 10:00:00	SPY	ETF	215.49	215.9195	215.41	215.74	7025251.0
2016-09-30 10:30:00	SPY	ETF	215.74	216.02	215.68	216.0	4892044.0
2016-09-30 11:00:00	SPY	ETF	216.0	216.74	215.99	216.575	10892078.0
2016-09-30 11:30:00	SPY	ETF	216.57	216.69	216.3	216.42	3908756.0
2016-09-30 12:00:00	SPY	ETF	216.42	216.66	216.345	216.63	2747326.0
2016-09-30 12:30:00	SPY	ETF	216.62	216.75	216.49	216.5	3865700.0
2016-09-30 13:00:00	SPY	ETF	216.5	216.63	216.35	216.37	1824091.0
2016-09-30 13:30:00	SPY	ETF	216.38	216.7	216.32	216.67	3200451.0
2016-09-30 14:00:00	SPY	ETF	216.68	216.85	216.62	216.8334	4881546.0
2016-09-30 14:30:00	SPY	ETF	216.83	216.94	216.78	216.87	5332902.0
2016-09-30 15:00:00	SPY	ETF	216.87	217.12	216.87	216.95	7917561.0
2016-09-30 15:30:00	SPY	ETF	216.95	217.045	216.29	216.36	23231281.0
2016-09-30 16:00:00	SPY	ETF	216.34	216.59	214.65	216.13	14348639.0
2016-09-30 16:30:00	SPY	ETF	216.16	216.4003	216.04	216.04	1491095.0
2016-09-30 17:00:00	SPY	ETF	216.14	216.3	216.07	216.14	217472.0
2016-09-30 17:30:00	SPY	ETF	216.13	216.3	215.99	216.16	416869.0
2016-09-30 18:00:00	SPY	ETF	216.16	216.92	216.16	216.56	1669191.0
2016-09-30 18:30:00	SPY	ETF	216.58	216.58	216.51	216.51	58660.0
2016-09-30 19:00:00	SPY	ETF	216.3	216.54	216.3	216.52	151955.0
2016-09-30 19:30:00	SPY	ETF	216.53	216.55	216.48	216.5	49062.0
2016-09-30 04:00:00	QQQ	ETF	117.67	117.67	117.64	117.64	1250.0
2016-09-30 04:30:00	QQQ	ETF	117.66	117.79	117.66	117.79	1800.0
2016-09-30 05:00:00	QQQ	ETF	117.78	117.78	117.75	117.75	900.0
2016-09-30 05:30:00	QQQ	ETF	117.75	117.92	117.75	117.92	2699.0
2016-09-30 06:00:00	QQQ	ETF	117.75	117.75	117.75	117.75	798.0
2016-09-30 06:30:00	QQQ	ETF	117.78	118.03	117.78	118.03	3098.0
2016-09-30 07:00:00	QQQ	ETF	118.0	118.03	117.9	117.91	13400.0
2016-09-30 07:30:00	QQQ	ETF	117.94	117.98	117.94	117.96	2600.0
2016-09-30 08:00:00	QQQ	ETF	118.03	118.13	118.03	118.11	13143.0
2016-09-30 08:30:00	QQQ	ETF	118.11	118.19	118.08	118.14	56966.0
2016-09-30 09:00:00	QQQ	ETF	118.12	118.23	118.06	118.16	90449.0
2016-09-30 09:30:00	QQQ	ETF	118.145	118.43	118.14	118.199	1832028.0
2016-09-30 10:00:00	QQQ	ETF	118.2	118.4	118.03	118.18	991865.0
2016-09-30 10:30:00	QQQ	ETF	118.18	118.54	118.18	118.52	822066.0
2016-09-30 11:00:00	QQQ	ETF	118.51	118.82	118.5	118.765	2009840.0
2016-09-30 11:30:00	QQQ	ETF	118.77	118.84	118.675	118.69	1430535.0
2016-09-30 12:00:00	QQQ	ETF	118.69	118.94	118.68	118.92	1339937.0
2016-09-30 12:30:00	QQQ	ETF	118.92	118.93	118.79	118.818	1969278.0

> showing 50 of 13,763 rows — these rows as CSV

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