PREVIEW / etf_30min / 2016-11-14

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-11-14.parquet
  size:    448 KB
  rows:    15,136

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-11-14 04:00:00	SPY	ETF	217.29	217.7	217.24	217.67	17105.0
2016-11-14 04:30:00	SPY	ETF	217.68	217.71	217.46	217.47	5500.0
2016-11-14 05:00:00	SPY	ETF	217.4	217.48	217.36	217.37	7187.0
2016-11-14 05:30:00	SPY	ETF	217.38	217.43	217.2	217.22	4268.0
2016-11-14 06:00:00	SPY	ETF	217.14	217.18	216.4	216.49	89627.0
2016-11-14 06:30:00	SPY	ETF	216.47	216.66	216.34	216.57	30382.0
2016-11-14 07:00:00	SPY	ETF	216.57	216.82	216.54	216.8	63041.0
2016-11-14 07:30:00	SPY	ETF	216.8	216.98	216.65	216.73	87631.0
2016-11-14 08:00:00	SPY	ETF	216.76	217.61	216.54	216.75	281385.0
2016-11-14 08:30:00	SPY	ETF	216.75	217.37	216.72	217.22	598438.0
2016-11-14 09:00:00	SPY	ETF	217.2	217.23	216.96	217.02	657646.0
2016-11-14 09:30:00	SPY	ETF	217.03	217.22	216.49	216.59	10738449.0
2016-11-14 10:00:00	SPY	ETF	216.59	217.27	216.52	216.745	8352544.0
2016-11-14 10:30:00	SPY	ETF	216.75	216.86	216.15	216.185	8346687.0
2016-11-14 11:00:00	SPY	ETF	216.18	216.48	215.9	216.19	7249841.0
2016-11-14 11:30:00	SPY	ETF	216.19	216.58	216.11	216.27	6130155.0
2016-11-14 12:00:00	SPY	ETF	216.29	216.36	215.79	215.92	4763734.0
2016-11-14 12:30:00	SPY	ETF	215.92	216.15	215.72	216.12	5670646.0
2016-11-14 13:00:00	SPY	ETF	216.12	216.46	215.95	216.3755	4601995.0
2016-11-14 13:30:00	SPY	ETF	216.38	216.73	216.22	216.32	4869820.0
2016-11-14 14:00:00	SPY	ETF	216.32	216.55	216.21	216.32	3493261.0
2016-11-14 14:30:00	SPY	ETF	216.3127	216.8	216.12	216.79	4236129.0
2016-11-14 15:00:00	SPY	ETF	216.79	216.88	216.63	216.77	4855795.0
2016-11-14 15:30:00	SPY	ETF	216.76	216.89	216.27	216.55	11653838.0
2016-11-14 16:00:00	SPY	ETF	216.53	216.7129	216.4086	216.62	6246810.0
2016-11-14 16:30:00	SPY	ETF	216.62	216.68	216.58	216.63	412186.0
2016-11-14 17:00:00	SPY	ETF	216.63	216.65	216.54	216.55	113203.0
2016-11-14 17:30:00	SPY	ETF	216.57	216.59	216.54	216.55	19063.0
2016-11-14 18:00:00	SPY	ETF	216.56	216.65	216.45	216.52	66587.0
2016-11-14 18:30:00	SPY	ETF	216.52	216.59	216.38	216.59	48739.0
2016-11-14 19:00:00	SPY	ETF	216.6	216.64	216.45	216.5	26979.0
2016-11-14 19:30:00	SPY	ETF	216.48	216.74	216.47	216.72	39800.0
2016-11-14 04:00:00	QQQ	ETF	116.09	116.39	116.09	116.39	3241.0
2016-11-14 05:30:00	QQQ	ETF	116.22	116.23	116.22	116.23	627.0
2016-11-14 06:00:00	QQQ	ETF	116.09	116.09	115.62	115.62	6820.0
2016-11-14 06:30:00	QQQ	ETF	115.61	115.82	115.61	115.74	11468.0
2016-11-14 07:00:00	QQQ	ETF	115.75	115.83	115.7	115.82	9900.0
2016-11-14 07:30:00	QQQ	ETF	115.79	115.91	115.73	115.75	37351.0
2016-11-14 08:00:00	QQQ	ETF	115.77	115.77	115.57	115.64	39245.0
2016-11-14 08:30:00	QQQ	ETF	115.64	116.01	115.6	115.86	98035.0
2016-11-14 09:00:00	QQQ	ETF	115.89	115.9	115.71	115.84	273146.0
2016-11-14 09:30:00	QQQ	ETF	115.85	115.94	114.88	114.9474	6458281.0
2016-11-14 10:00:00	QQQ	ETF	114.94	115.36	114.7	114.98	4784876.0
2016-11-14 10:30:00	QQQ	ETF	114.98	115.09	114.36	114.39	3954322.0
2016-11-14 11:00:00	QQQ	ETF	114.4	114.799	114.03	114.47	3724097.0
2016-11-14 11:30:00	QQQ	ETF	114.47	114.85	114.37	114.5999	1858714.0
2016-11-14 12:00:00	QQQ	ETF	114.62	114.7	114.2331	114.27	1304594.0
2016-11-14 12:30:00	QQQ	ETF	114.27	114.61	114.13	114.56	1480222.0
2016-11-14 13:00:00	QQQ	ETF	114.58	114.9	114.5	114.88	1307581.0
2016-11-14 13:30:00	QQQ	ETF	114.88	115.14	114.6	114.69	1405546.0

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

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