PREVIEW / etf_30min / 2015-03-04

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-03-04.parquet
  size:    367 KB
  rows:    12,498

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-03-04 04:00:00	SPY	ETF	210.25	210.35	210.25	210.35	900.0
2015-03-04 04:30:00	SPY	ETF	210.31	210.4	210.31	210.39	1200.0
2015-03-04 05:00:00	SPY	ETF	210.49	210.49	210.3	210.42	3972.0
2015-03-04 05:30:00	SPY	ETF	210.25	210.36	210.24	210.25	6885.0
2015-03-04 06:00:00	SPY	ETF	210.25	210.29	210.18	210.23	9246.0
2015-03-04 06:30:00	SPY	ETF	210.24	210.39	210.18	210.32	45942.0
2015-03-04 07:00:00	SPY	ETF	210.36	210.36	210.24	210.36	90652.0
2015-03-04 07:30:00	SPY	ETF	210.33	210.44	210.24	210.43	37695.0
2015-03-04 08:00:00	SPY	ETF	210.37	210.54	210.25	210.44	518308.0
2015-03-04 08:30:00	SPY	ETF	210.45	210.47	210.35	210.4	212020.0
2015-03-04 09:00:00	SPY	ETF	210.38	210.43	210.29	210.4	601363.0
2015-03-04 09:30:00	SPY	ETF	210.4	210.45	209.37	209.622	15786921.0
2015-03-04 10:00:00	SPY	ETF	209.63	209.74	209.06	209.37	12429217.0
2015-03-04 10:30:00	SPY	ETF	209.36	209.73	209.26	209.595	6998900.0
2015-03-04 11:00:00	SPY	ETF	209.59	210.09	209.55	209.96	6911952.0
2015-03-04 11:30:00	SPY	ETF	209.96	210.19	209.94	210.01	5648057.0
2015-03-04 12:00:00	SPY	ETF	210.02	210.37	209.94	210.27	4609331.0
2015-03-04 12:30:00	SPY	ETF	210.28	210.49	210.19	210.2	3386591.0
2015-03-04 13:00:00	SPY	ETF	210.21	210.4	210.12	210.29	2330365.0
2015-03-04 13:30:00	SPY	ETF	210.28	210.35	209.86	209.92	4553389.0
2015-03-04 14:00:00	SPY	ETF	209.92	210.1	209.78	209.92	4845857.0
2015-03-04 14:30:00	SPY	ETF	209.93	210.26	209.86	210.23	5692223.0
2015-03-04 15:00:00	SPY	ETF	210.23	210.29	209.98	210.2	7402553.0
2015-03-04 15:30:00	SPY	ETF	210.2	210.35	210.13	210.23	17866954.0
2015-03-04 16:00:00	SPY	ETF	210.22	211.1355	210.13	210.14	4838337.0
2015-03-04 16:30:00	SPY	ETF	210.07	210.175	210.07	210.131	3674106.0
2015-03-04 17:00:00	SPY	ETF	210.2135	210.2135	210.12	210.13	4797277.0
2015-03-04 17:30:00	SPY	ETF	210.13	210.14	210.1	210.14	247171.0
2015-03-04 18:00:00	SPY	ETF	210.15	210.16	210.02	210.06	72994.0
2015-03-04 18:30:00	SPY	ETF	210.08	210.1	210.08	210.09	7773.0
2015-03-04 19:00:00	SPY	ETF	210.07	210.15	210.0	210.11	25337.0
2015-03-04 19:30:00	SPY	ETF	210.12	210.14	210.08	210.14	13572.0
2015-03-04 04:00:00	QQQ	ETF	108.58	108.58	108.45	108.46	1033.0
2015-03-04 05:30:00	QQQ	ETF	108.43	108.43	108.43	108.43	2800.0
2015-03-04 06:00:00	QQQ	ETF	108.43	108.46	108.43	108.46	21100.0
2015-03-04 06:30:00	QQQ	ETF	108.42	108.42	108.42	108.42	5300.0
2015-03-04 07:00:00	QQQ	ETF	108.44	108.51	108.44	108.51	5836.0
2015-03-04 07:30:00	QQQ	ETF	108.5	108.51	108.46	108.51	4500.0
2015-03-04 08:00:00	QQQ	ETF	108.51	108.53	108.47	108.511	22441.0
2015-03-04 08:30:00	QQQ	ETF	108.53	108.53	108.47	108.53	5262.0
2015-03-04 09:00:00	QQQ	ETF	108.5	108.55	108.46	108.52	52323.0
2015-03-04 09:30:00	QQQ	ETF	108.51	108.54	107.92	108.08	4199279.0
2015-03-04 10:00:00	QQQ	ETF	108.09	108.17	107.86	108.01	2464632.0
2015-03-04 10:30:00	QQQ	ETF	108.0	108.27	107.98	108.24	1672694.0
2015-03-04 11:00:00	QQQ	ETF	108.23	108.59	108.22	108.48	1633093.0
2015-03-04 11:30:00	QQQ	ETF	108.48	108.55	108.39	108.46	695561.0
2015-03-04 12:00:00	QQQ	ETF	108.45	108.65	108.41	108.595	856496.0
2015-03-04 12:30:00	QQQ	ETF	108.6	108.67	108.5	108.51	808245.0
2015-03-04 13:00:00	QQQ	ETF	108.515	108.65	108.51	108.61	902620.0
2015-03-04 13:30:00	QQQ	ETF	108.6	108.64	108.36	108.4	911801.0

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

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