PREVIEW / etf_30min / 2015-04-07

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-04-07.parquet
  size:    377 KB
  rows:    12,604

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-04-07 04:00:00	SPY	ETF	207.91	207.91	207.83	207.83	1300.0
2015-04-07 05:00:00	SPY	ETF	207.75	207.75	207.65	207.65	600.0
2015-04-07 05:30:00	SPY	ETF	207.68	207.73	207.64	207.68	7283.0
2015-04-07 06:00:00	SPY	ETF	207.65	207.8	207.65	207.75	13120.0
2015-04-07 06:30:00	SPY	ETF	207.74	207.92	207.74	207.91	23400.0
2015-04-07 07:00:00	SPY	ETF	207.9	208.29	207.89	208.28	137930.0
2015-04-07 07:30:00	SPY	ETF	208.28	208.38	208.12	208.15	216240.0
2015-04-07 08:00:00	SPY	ETF	208.1	208.21	208.01	208.03	214306.0
2015-04-07 08:30:00	SPY	ETF	208.03	208.08	207.87	207.93	248245.0
2015-04-07 09:00:00	SPY	ETF	207.91	208.0	207.77	207.85	605970.0
2015-04-07 09:30:00	SPY	ETF	207.855	208.64	207.76	208.08	10626796.0
2015-04-07 10:00:00	SPY	ETF	208.08	208.51	207.73	208.39	5639455.0
2015-04-07 10:30:00	SPY	ETF	208.39	208.76	208.38	208.48	5576662.0
2015-04-07 11:00:00	SPY	ETF	208.48	208.52	208.2	208.35	6168304.0
2015-04-07 11:30:00	SPY	ETF	208.36	208.54	208.36	208.51	4473315.0
2015-04-07 12:00:00	SPY	ETF	208.51	208.63	208.48	208.604	1971074.0
2015-04-07 12:30:00	SPY	ETF	208.605	208.65	208.31	208.41	3512395.0
2015-04-07 13:00:00	SPY	ETF	208.4133	208.55	208.36	208.5	2481261.0
2015-04-07 13:30:00	SPY	ETF	208.51	208.52	208.14	208.25	2966428.0
2015-04-07 14:00:00	SPY	ETF	208.25	208.45	208.24	208.437	2819483.0
2015-04-07 14:30:00	SPY	ETF	208.435	208.47	208.22	208.235	2496351.0
2015-04-07 15:00:00	SPY	ETF	208.24	208.28	207.82	207.9449	4891837.0
2015-04-07 15:30:00	SPY	ETF	207.94	208.02	207.24	207.26	12137453.0
2015-04-07 16:00:00	SPY	ETF	207.25	207.4682	207.23	207.28	3849297.0
2015-04-07 16:30:00	SPY	ETF	207.28	207.32	207.11	207.3	1535222.0
2015-04-07 17:00:00	SPY	ETF	207.28	207.3705	207.25	207.27	7276042.0
2015-04-07 17:30:00	SPY	ETF	207.271	207.33	207.27	207.31	24076.0
2015-04-07 18:00:00	SPY	ETF	207.31	207.41	207.25	207.25	49503.0
2015-04-07 18:30:00	SPY	ETF	207.26	207.27	207.11	207.18	52440.0
2015-04-07 19:00:00	SPY	ETF	207.18	207.19	207.14	207.14	34835.0
2015-04-07 19:30:00	SPY	ETF	207.21	207.28	207.18	207.28	16874.0
2015-04-07 07:00:00	QQQ	ETF	106.13	106.24	106.13	106.24	66200.0
2015-04-07 07:30:00	QQQ	ETF	106.25	106.33	106.16	106.17	98360.0
2015-04-07 08:00:00	QQQ	ETF	106.16	106.22	106.11	106.11	66692.0
2015-04-07 08:30:00	QQQ	ETF	106.11	106.11	106.03	106.051	32529.0
2015-04-07 09:00:00	QQQ	ETF	106.03	106.03	105.9	105.94	256363.0
2015-04-07 09:30:00	QQQ	ETF	105.92	106.48	105.9	106.196	3038292.0
2015-04-07 10:00:00	QQQ	ETF	106.2	106.55	106.02	106.54	1597073.0
2015-04-07 10:30:00	QQQ	ETF	106.55	106.7	106.51	106.55	1288157.0
2015-04-07 11:00:00	QQQ	ETF	106.55	106.59	106.39	106.435	1200415.0
2015-04-07 11:30:00	QQQ	ETF	106.44	106.56	106.44	106.52	901940.0
2015-04-07 12:00:00	QQQ	ETF	106.5299	106.64	106.515	106.59	809549.0
2015-04-07 12:30:00	QQQ	ETF	106.6	106.63	106.41	106.49	842435.0
2015-04-07 13:00:00	QQQ	ETF	106.4987	106.57	106.46	106.5232	511238.0
2015-04-07 13:30:00	QQQ	ETF	106.51	106.53	106.34	106.4	542814.0
2015-04-07 14:00:00	QQQ	ETF	106.4	106.5	106.39	106.49	481070.0
2015-04-07 14:30:00	QQQ	ETF	106.48	106.5	106.34	106.358	598298.0
2015-04-07 15:00:00	QQQ	ETF	106.36	106.39	106.12	106.195	1355058.0
2015-04-07 15:30:00	QQQ	ETF	106.19	106.26	105.8	105.8	3223483.0
2015-04-07 16:00:00	QQQ	ETF	105.8	105.86	105.56	105.7	473012.0

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

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