PREVIEW / etf_30min / 2016-04-14

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-04-14.parquet
  size:    387 KB
  rows:    13,222

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-04-14 04:00:00	SPY	ETF	207.62	207.67	207.34	207.67	8616.0
2016-04-14 04:30:00	SPY	ETF	207.63	207.63	207.47	207.51	8145.0
2016-04-14 05:00:00	SPY	ETF	207.66	207.69	207.52	207.68	23772.0
2016-04-14 05:30:00	SPY	ETF	207.68	207.94	207.68	207.87	21352.0
2016-04-14 06:00:00	SPY	ETF	207.87	207.98	207.76	207.82	9338.0
2016-04-14 06:30:00	SPY	ETF	207.83	208.03	207.83	207.9	15595.0
2016-04-14 07:00:00	SPY	ETF	207.95	207.96	207.75	207.95	38584.0
2016-04-14 07:30:00	SPY	ETF	207.95	208.04	207.93	207.96	65636.0
2016-04-14 08:00:00	SPY	ETF	207.95	208.09	207.67	207.94	151102.0
2016-04-14 08:30:00	SPY	ETF	207.93	208.35	207.9	208.25	652544.0
2016-04-14 09:00:00	SPY	ETF	208.27	208.27	208.02	208.07	377846.0
2016-04-14 09:30:00	SPY	ETF	208.07	208.15	207.6	207.7192	9411739.0
2016-04-14 10:00:00	SPY	ETF	207.69	208.05	207.62	208.0	5126255.0
2016-04-14 10:30:00	SPY	ETF	208.0	208.18	207.78	208.04	4426547.0
2016-04-14 11:00:00	SPY	ETF	208.03	208.2	207.905	208.065	3890985.0
2016-04-14 11:30:00	SPY	ETF	208.07	208.375	208.06	208.31	4175590.0
2016-04-14 12:00:00	SPY	ETF	208.31	208.41	208.22	208.32	2990463.0
2016-04-14 12:30:00	SPY	ETF	208.32	208.53	208.17	208.45	3041797.0
2016-04-14 13:00:00	SPY	ETF	208.45	208.6	208.21	208.28	3094904.0
2016-04-14 13:30:00	SPY	ETF	208.28	208.33	208.06	208.08	3238089.0
2016-04-14 14:00:00	SPY	ETF	208.08	208.31	207.96	208.165	4445495.0
2016-04-14 14:30:00	SPY	ETF	208.17	208.23	207.9	208.09	3309656.0
2016-04-14 15:00:00	SPY	ETF	208.09	208.25	207.98	208.08	2639707.0
2016-04-14 15:30:00	SPY	ETF	208.08	208.27	207.94	208.01	7228882.0
2016-04-14 16:00:00	SPY	ETF	208.02	208.15	207.97	208.12	5949882.0
2016-04-14 16:30:00	SPY	ETF	208.12	208.22	208.12	208.21	222959.0
2016-04-14 17:00:00	SPY	ETF	208.2	208.24	208.18	208.19	57107.0
2016-04-14 17:30:00	SPY	ETF	208.19	208.21	208.17	208.21	18142.0
2016-04-14 18:00:00	SPY	ETF	208.19	208.2	208.02	208.07	112011.0
2016-04-14 18:30:00	SPY	ETF	208.07	208.1	208.05	208.05	6468.0
2016-04-14 19:00:00	SPY	ETF	208.1	208.13	208.1	208.11	8745.0
2016-04-14 19:30:00	SPY	ETF	208.1	208.1	208.06	208.07	23195.0
2016-04-14 06:30:00	QQQ	ETF	110.85	110.85	110.85	110.85	999.0
2016-04-14 07:00:00	QQQ	ETF	110.87	110.9	110.81	110.9	2912.0
2016-04-14 07:30:00	QQQ	ETF	110.92	110.93	110.88	110.9	5519.0
2016-04-14 08:00:00	QQQ	ETF	110.91	110.92	110.85	110.86	30537.0
2016-04-14 08:30:00	QQQ	ETF	110.89	111.06	110.87	110.98	47459.0
2016-04-14 09:00:00	QQQ	ETF	110.97	110.99	110.9	110.9	100928.0
2016-04-14 09:30:00	QQQ	ETF	110.0	111.0	110.0	110.73	2282149.0
2016-04-14 10:00:00	QQQ	ETF	110.729	111.0	110.66	110.89	1977133.0
2016-04-14 10:30:00	QQQ	ETF	110.9	111.04	110.76	110.96	990877.0
2016-04-14 11:00:00	QQQ	ETF	110.95	110.9903	110.75	110.8599	764798.0
2016-04-14 11:30:00	QQQ	ETF	110.86	111.155	110.855	111.15	935186.0
2016-04-14 12:00:00	QQQ	ETF	111.15	111.16	111.03	111.095	607029.0
2016-04-14 12:30:00	QQQ	ETF	111.09	111.23	110.99	111.22	783114.0
2016-04-14 13:00:00	QQQ	ETF	111.22	111.33	111.06	111.1199	721473.0
2016-04-14 13:30:00	QQQ	ETF	111.11	111.13	110.89	110.89	647695.0
2016-04-14 14:00:00	QQQ	ETF	110.89	111.01	110.82	110.87	1272325.0
2016-04-14 14:30:00	QQQ	ETF	110.88	111.03	110.765	110.93	1501776.0
2016-04-14 15:00:00	QQQ	ETF	110.93	111.05	110.88	110.95	621268.0

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

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