PREVIEW / etf_30min / 2015-04-09

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-04-09.parquet
  size:    376 KB
  rows:    12,566

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-09 04:00:00	SPY	ETF	207.84	207.84	207.33	207.33	2961.0
2015-04-09 04:30:00	SPY	ETF	207.28	207.56	207.28	207.45	21607.0
2015-04-09 05:00:00	SPY	ETF	207.45	207.57	207.45	207.57	12967.0
2015-04-09 05:30:00	SPY	ETF	207.64	207.7	207.5	207.56	36550.0
2015-04-09 06:00:00	SPY	ETF	207.56	207.64	207.5	207.59	13301.0
2015-04-09 06:30:00	SPY	ETF	207.64	207.81	207.64	207.7	12227.0
2015-04-09 07:00:00	SPY	ETF	207.75	207.97	207.71	207.88	49829.0
2015-04-09 07:30:00	SPY	ETF	207.9	208.26	207.9	208.2	77894.0
2015-04-09 08:00:00	SPY	ETF	208.19	208.24	207.79	207.94	279380.0
2015-04-09 08:30:00	SPY	ETF	207.92	208.11	207.75	207.81	494967.0
2015-04-09 09:00:00	SPY	ETF	207.78	207.92	207.68	207.78	356568.0
2015-04-09 09:30:00	SPY	ETF	207.78	208.65	207.75	208.01	9178292.0
2015-04-09 10:00:00	SPY	ETF	208.0	208.34	207.67	208.08	7930578.0
2015-04-09 10:30:00	SPY	ETF	208.08	208.11	207.4	207.78	9677053.0
2015-04-09 11:00:00	SPY	ETF	207.78	207.78	207.19	207.64	5936759.0
2015-04-09 11:30:00	SPY	ETF	207.64	208.01	207.56	207.88	5776277.0
2015-04-09 12:00:00	SPY	ETF	207.88	208.32	207.83	208.23	3820633.0
2015-04-09 12:30:00	SPY	ETF	208.24	208.32	208.09	208.29	2566479.0
2015-04-09 13:00:00	SPY	ETF	208.3	208.46	208.13	208.34	3828673.0
2015-04-09 13:30:00	SPY	ETF	208.34	208.35	208.04	208.13	3181113.0
2015-04-09 14:00:00	SPY	ETF	208.14	208.28	208.04	208.16	2364872.0
2015-04-09 14:30:00	SPY	ETF	208.16	208.53	208.1	208.47	4330659.0
2015-04-09 15:00:00	SPY	ETF	208.47	209.15	208.46	209.12	8965439.0
2015-04-09 15:30:00	SPY	ETF	209.12	209.18	208.73	208.93	11024404.0
2015-04-09 16:00:00	SPY	ETF	208.94	209.08	208.86	209.06	3645081.0
2015-04-09 16:30:00	SPY	ETF	209.05	209.15	208.094	209.0	333013.0
2015-04-09 17:00:00	SPY	ETF	208.97	209.12	208.97	209.09	89348.0
2015-04-09 17:30:00	SPY	ETF	209.1	209.12	209.02	209.02	23761.0
2015-04-09 18:00:00	SPY	ETF	209.08	209.12	209.02	209.08	27799.0
2015-04-09 18:30:00	SPY	ETF	209.08	209.09	209.04	209.07	14100.0
2015-04-09 19:00:00	SPY	ETF	209.07	209.08	209.04	209.08	35753.0
2015-04-09 19:30:00	SPY	ETF	209.05	209.08	209.02	209.05	30426.0
2015-04-09 05:30:00	QQQ	ETF	106.46	106.46	106.46	106.46	15000.0
2015-04-09 06:00:00	QQQ	ETF	106.45	106.5	106.42	106.47	33930.0
2015-04-09 06:30:00	QQQ	ETF	106.49	106.63	106.49	106.6	3300.0
2015-04-09 07:00:00	QQQ	ETF	106.56	106.69	106.55	106.69	18105.0
2015-04-09 07:30:00	QQQ	ETF	106.7	106.81	106.69	106.79	45421.0
2015-04-09 08:00:00	QQQ	ETF	106.68	106.81	106.68	106.71	35324.0
2015-04-09 08:30:00	QQQ	ETF	106.71	106.84	106.66	106.7	165660.0
2015-04-09 09:00:00	QQQ	ETF	106.68	106.68	106.54	106.6	151425.0
2015-04-09 09:30:00	QQQ	ETF	106.59	107.13	106.59	106.79	3837779.0
2015-04-09 10:00:00	QQQ	ETF	106.79	106.94	106.52	106.8	2037230.0
2015-04-09 10:30:00	QQQ	ETF	106.82	106.83	106.385	106.5739	1785252.0
2015-04-09 11:00:00	QQQ	ETF	106.57	106.58	106.23	106.49	1581407.0
2015-04-09 11:30:00	QQQ	ETF	106.495	106.665	106.45	106.59	888045.0
2015-04-09 12:00:00	QQQ	ETF	106.6	106.96	106.56	106.9	1071060.0
2015-04-09 12:30:00	QQQ	ETF	106.9	106.91	106.79	106.879	626698.0
2015-04-09 13:00:00	QQQ	ETF	106.88	106.94	106.78	106.86	753245.0
2015-04-09 13:30:00	QQQ	ETF	106.86	106.88	106.72	106.8	566098.0
2015-04-09 14:00:00	QQQ	ETF	106.81	106.85	106.72	106.8065	623545.0

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

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