PREVIEW / etf_30min / 2015-11-24

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-11-24.parquet
  size:    383 KB
  rows:    12,858

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-24 04:00:00	SPY	ETF	208.03	208.49	207.31	208.3	27694.0
2015-11-24 04:30:00	SPY	ETF	208.3	208.37	208.12	208.34	22660.0
2015-11-24 05:00:00	SPY	ETF	208.39	208.62	208.36	208.42	21540.0
2015-11-24 05:30:00	SPY	ETF	208.41	208.41	208.05	208.16	13797.0
2015-11-24 06:00:00	SPY	ETF	208.08	208.29	207.95	208.26	35749.0
2015-11-24 06:30:00	SPY	ETF	208.25	208.44	208.11	208.21	77145.0
2015-11-24 07:00:00	SPY	ETF	208.16	208.32	207.97	208.04	121151.0
2015-11-24 07:30:00	SPY	ETF	208.03	208.2	207.55	207.72	967648.0
2015-11-24 08:00:00	SPY	ETF	209.48	209.48	207.42	207.48	1056999.0
2015-11-24 08:30:00	SPY	ETF	207.49	207.88	207.49	207.78	481074.0
2015-11-24 09:00:00	SPY	ETF	207.77	208.04	207.76	207.86	672189.0
2015-11-24 09:30:00	SPY	ETF	207.87	208.55	207.82	208.37	10885869.0
2015-11-24 10:00:00	SPY	ETF	208.3701	208.51	207.92	207.93	6837029.0
2015-11-24 10:30:00	SPY	ETF	207.93	207.93	207.41	207.65	7716080.0
2015-11-24 11:00:00	SPY	ETF	207.65	208.44	207.52	208.41	5812504.0
2015-11-24 11:30:00	SPY	ETF	208.42	208.95	208.42	208.829	7285199.0
2015-11-24 12:00:00	SPY	ETF	208.83	209.13	208.72	208.86	4794091.0
2015-11-24 12:30:00	SPY	ETF	208.86	208.95	208.73	208.89	2657439.0
2015-11-24 13:00:00	SPY	ETF	208.89	209.48	208.89	209.469	7274738.0
2015-11-24 13:30:00	SPY	ETF	209.47	209.59	209.35	209.43	4215167.0
2015-11-24 14:00:00	SPY	ETF	209.42	209.76	209.1	209.22	8384801.0
2015-11-24 14:30:00	SPY	ETF	209.22	209.58	209.085	209.545	5105866.0
2015-11-24 15:00:00	SPY	ETF	209.55	209.83	209.41	209.52	7445668.0
2015-11-24 15:30:00	SPY	ETF	209.515	209.58	209.2	209.38	10117206.0
2015-11-24 16:00:00	SPY	ETF	209.38	209.4881	209.11	209.14	2630446.0
2015-11-24 16:30:00	SPY	ETF	209.14	209.18	209.08	209.08	547555.0
2015-11-24 17:00:00	SPY	ETF	209.11	209.18	209.07	209.12	194370.0
2015-11-24 17:30:00	SPY	ETF	209.11	209.13	209.1	209.11	61237.0
2015-11-24 18:00:00	SPY	ETF	209.1	209.27	209.1	209.23	51117.0
2015-11-24 18:30:00	SPY	ETF	209.18	209.32	209.15	209.31	27461.0
2015-11-24 19:00:00	SPY	ETF	209.3	209.31	209.21	209.21	11981.0
2015-11-24 19:30:00	SPY	ETF	209.22	209.22	209.11	209.11	54028.0
2015-11-24 04:00:00	QQQ	ETF	113.42	113.7	113.22	113.7	4274.0
2015-11-24 04:30:00	QQQ	ETF	113.66	113.66	113.6	113.62	1099.0
2015-11-24 05:00:00	QQQ	ETF	113.8	113.8	113.8	113.8	100.0
2015-11-24 05:30:00	QQQ	ETF	113.69	113.69	113.57	113.57	500.0
2015-11-24 06:00:00	QQQ	ETF	113.54	113.61	113.5	113.61	1600.0
2015-11-24 06:30:00	QQQ	ETF	113.67	113.7	113.58	113.6	3835.0
2015-11-24 07:00:00	QQQ	ETF	113.72	113.74	113.57	113.59	8800.0
2015-11-24 07:30:00	QQQ	ETF	113.59	113.66	113.28	113.36	21540.0
2015-11-24 08:00:00	QQQ	ETF	113.37	113.65	113.24	113.28	52929.0
2015-11-24 08:30:00	QQQ	ETF	113.29	113.42	113.28	113.37	80579.0
2015-11-24 09:00:00	QQQ	ETF	113.39	113.53	113.32	113.42	282837.0
2015-11-24 09:30:00	QQQ	ETF	113.42	113.78	113.38	113.74	3911430.0
2015-11-24 10:00:00	QQQ	ETF	113.74	113.82	113.26	113.27	2617476.0
2015-11-24 10:30:00	QQQ	ETF	113.27	113.27	112.8377	113.0675	2723073.0
2015-11-24 11:00:00	QQQ	ETF	113.07	113.53	112.9	113.5	2001013.0
2015-11-24 11:30:00	QQQ	ETF	113.5	113.87	113.5	113.8	2610068.0
2015-11-24 12:00:00	QQQ	ETF	113.81	114.02	113.58	113.68	1953050.0
2015-11-24 12:30:00	QQQ	ETF	113.69	113.78	113.67	113.73	639840.0

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

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