PREVIEW / etf_30min / 2015-11-20

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-11-20.parquet
  size:    381 KB
  rows:    12,797

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-11-20 04:00:00	SPY	ETF	208.75	208.75	208.53	208.58	5240.0
2015-11-20 04:30:00	SPY	ETF	208.52	208.9	208.52	208.85	14916.0
2015-11-20 05:00:00	SPY	ETF	208.73	208.78	208.73	208.75	6600.0
2015-11-20 05:30:00	SPY	ETF	208.83	209.02	208.83	209.02	7090.0
2015-11-20 06:00:00	SPY	ETF	209.05	209.08	208.98	209.0	15700.0
2015-11-20 06:30:00	SPY	ETF	209.0	209.05	208.95	209.02	10366.0
2015-11-20 07:00:00	SPY	ETF	209.0	209.17	209.0	209.1	76164.0
2015-11-20 07:30:00	SPY	ETF	209.15	209.25	209.02	209.24	181969.0
2015-11-20 08:00:00	SPY	ETF	209.06	209.39	209.03	209.23	339155.0
2015-11-20 08:30:00	SPY	ETF	209.25	209.35	209.17	209.33	263224.0
2015-11-20 09:00:00	SPY	ETF	209.35	209.56	209.11	209.44	1263752.0
2015-11-20 09:30:00	SPY	ETF	209.45	210.02	209.33	209.93	15866214.0
2015-11-20 10:00:00	SPY	ETF	209.93	210.12	209.69	209.84	9028811.0
2015-11-20 10:30:00	SPY	ETF	209.85	209.91	209.55	209.61	5858835.0
2015-11-20 11:00:00	SPY	ETF	209.61	209.85	209.55	209.76	6475946.0
2015-11-20 11:30:00	SPY	ETF	209.76	209.78	209.44	209.495	4410216.0
2015-11-20 12:00:00	SPY	ETF	209.495	209.54	209.31	209.43	3840661.0
2015-11-20 12:30:00	SPY	ETF	209.44	209.65	209.42	209.505	3228873.0
2015-11-20 13:00:00	SPY	ETF	209.505	209.69	209.44	209.46	3118352.0
2015-11-20 13:30:00	SPY	ETF	209.46	209.48	209.19	209.325	3641364.0
2015-11-20 14:00:00	SPY	ETF	209.33	209.47	209.26	209.2662	3763105.0
2015-11-20 14:30:00	SPY	ETF	209.265	209.43	209.01	209.03	3548391.0
2015-11-20 15:00:00	SPY	ETF	209.03	209.18	208.86	209.143	6957662.0
2015-11-20 15:30:00	SPY	ETF	209.141	209.4	209.1103	209.35	12261921.0
2015-11-20 16:00:00	SPY	ETF	209.34	209.57	209.3004	209.53	6646021.0
2015-11-20 16:30:00	SPY	ETF	209.53	209.58	209.49	209.58	1125463.0
2015-11-20 17:00:00	SPY	ETF	209.57	209.59	209.49	209.49	886232.0
2015-11-20 17:30:00	SPY	ETF	209.48	209.5	209.35	209.35	180775.0
2015-11-20 18:00:00	SPY	ETF	209.35	209.48	209.35	209.48	6067.0
2015-11-20 18:30:00	SPY	ETF	209.48	209.49	209.45	209.48	1340.0
2015-11-20 19:00:00	SPY	ETF	209.48	209.48	209.45	209.46	2336.0
2015-11-20 19:30:00	SPY	ETF	209.46	209.52	209.42	209.5	8406.0
2015-11-20 04:30:00	QQQ	ETF	113.84	113.84	113.84	113.84	200.0
2015-11-20 06:00:00	QQQ	ETF	114.05	114.05	114.02	114.02	650.0
2015-11-20 06:30:00	QQQ	ETF	114.03	114.03	114.03	114.03	1700.0
2015-11-20 07:00:00	QQQ	ETF	114.04	114.07	114.04	114.04	8450.0
2015-11-20 07:30:00	QQQ	ETF	114.09	114.1	114.07	114.1	76308.0
2015-11-20 08:00:00	QQQ	ETF	114.1	114.14	114.04	114.13	93721.0
2015-11-20 08:30:00	QQQ	ETF	114.1	114.15	114.1	114.15	64775.0
2015-11-20 09:00:00	QQQ	ETF	114.15	114.26	114.04	114.23	174101.0
2015-11-20 09:30:00	QQQ	ETF	114.24	114.5977	114.1401	114.4	4093791.0
2015-11-20 10:00:00	QQQ	ETF	114.4	114.57	114.25	114.39	2203946.0
2015-11-20 10:30:00	QQQ	ETF	114.39	114.45	114.26	114.29	1070326.0
2015-11-20 11:00:00	QQQ	ETF	114.28	114.54	114.25	114.48	917870.0
2015-11-20 11:30:00	QQQ	ETF	114.48	114.5	114.25	114.28	1052183.0
2015-11-20 12:00:00	QQQ	ETF	114.28	114.39	114.2	114.36	896023.0
2015-11-20 12:30:00	QQQ	ETF	114.3622	114.46	114.3	114.4	563155.0
2015-11-20 13:00:00	QQQ	ETF	114.4	114.52	114.4	114.426	742484.0
2015-11-20 13:30:00	QQQ	ETF	114.44	114.44	114.27	114.35	560576.0
2015-11-20 14:00:00	QQQ	ETF	114.35	114.44	114.3	114.34	847643.0

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

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