PREVIEW / etf_30min / 2015-10-29

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-10-29.parquet
  size:    377 KB
  rows:    12,834

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-10-29 04:00:00	SPY	ETF	208.49	208.5	208.25	208.27	21988.0
2015-10-29 04:30:00	SPY	ETF	208.31	208.39	208.25	208.25	61054.0
2015-10-29 05:00:00	SPY	ETF	208.22	208.24	208.02	208.06	225670.0
2015-10-29 05:30:00	SPY	ETF	207.99	208.23	207.99	208.21	28084.0
2015-10-29 06:00:00	SPY	ETF	208.16	208.24	208.12	208.19	14437.0
2015-10-29 06:30:00	SPY	ETF	208.32	208.42	208.26	208.26	62268.0
2015-10-29 07:00:00	SPY	ETF	208.32	208.35	208.15	208.22	127896.0
2015-10-29 07:30:00	SPY	ETF	208.25	208.25	208.1	208.12	114231.0
2015-10-29 08:00:00	SPY	ETF	208.12	208.77	208.0	208.15	526099.0
2015-10-29 08:30:00	SPY	ETF	208.2	208.95	208.1	208.38	437188.0
2015-10-29 09:00:00	SPY	ETF	208.37	208.5	208.28	208.33	343481.0
2015-10-29 09:30:00	SPY	ETF	208.35	208.92	208.31	208.5889	9818277.0
2015-10-29 10:00:00	SPY	ETF	208.58	209.1	208.39	208.43	9936635.0
2015-10-29 10:30:00	SPY	ETF	208.435	209.0125	208.21	208.3682	8363592.0
2015-10-29 11:00:00	SPY	ETF	208.37	208.63	208.21	208.57	4876879.0
2015-10-29 11:30:00	SPY	ETF	208.57	208.84	208.56	208.78	3447299.0
2015-10-29 12:00:00	SPY	ETF	208.7899	208.94	208.48	208.93	3395266.0
2015-10-29 12:30:00	SPY	ETF	208.93	208.98	208.65	208.75	3032147.0
2015-10-29 13:00:00	SPY	ETF	208.755	208.98	208.72	208.79	3024377.0
2015-10-29 13:30:00	SPY	ETF	208.795	208.875	208.4	208.415	3213999.0
2015-10-29 14:00:00	SPY	ETF	208.4101	208.84	208.38	208.74	4133658.0
2015-10-29 14:30:00	SPY	ETF	208.735	208.79	208.57	208.7	5836498.0
2015-10-29 15:00:00	SPY	ETF	208.7	209.0	208.55	208.9	6142309.0
2015-10-29 15:30:00	SPY	ETF	208.897	209.27	208.78	208.87	13268374.0
2015-10-29 16:00:00	SPY	ETF	208.88	209.04	208.44	209.0	2842268.0
2015-10-29 16:30:00	SPY	ETF	208.97	209.1	208.92	209.08	3181411.0
2015-10-29 17:00:00	SPY	ETF	209.08	209.16	209.05	209.15	140065.0
2015-10-29 17:30:00	SPY	ETF	209.15	209.16	209.04	209.1	1544055.0
2015-10-29 18:00:00	SPY	ETF	209.13	209.2	208.93	208.96	116276.0
2015-10-29 18:30:00	SPY	ETF	208.96	208.96	208.9	208.95	39838.0
2015-10-29 19:00:00	SPY	ETF	208.96	209.11	208.96	209.09	31254.0
2015-10-29 19:30:00	SPY	ETF	209.06	209.12	209.06	209.11	31539.0
2015-10-29 04:00:00	QQQ	ETF	113.55	113.55	113.55	113.55	6250.0
2015-10-29 04:30:00	QQQ	ETF	113.57	113.57	113.52	113.52	300.0
2015-10-29 05:00:00	QQQ	ETF	113.45	113.45	113.45	113.45	6250.0
2015-10-29 05:30:00	QQQ	ETF	113.5	113.54	113.5	113.54	700.0
2015-10-29 06:00:00	QQQ	ETF	113.54	113.54	113.52	113.52	5180.0
2015-10-29 06:30:00	QQQ	ETF	113.54	113.54	113.54	113.54	300.0
2015-10-29 07:00:00	QQQ	ETF	113.56	113.56	113.45	113.47	32217.0
2015-10-29 07:30:00	QQQ	ETF	113.43	113.47	113.36	113.41	71495.0
2015-10-29 08:00:00	QQQ	ETF	113.42	113.45	113.38	113.42	26193.0
2015-10-29 08:30:00	QQQ	ETF	113.47	113.52	113.43	113.5	115715.0
2015-10-29 09:00:00	QQQ	ETF	113.51	113.53	113.38	113.5	144050.0
2015-10-29 09:30:00	QQQ	ETF	113.5	113.77	113.41	113.4402	3571705.0
2015-10-29 10:00:00	QQQ	ETF	113.452	113.75	113.38	113.57	2426504.0
2015-10-29 10:30:00	QQQ	ETF	113.57	113.76	113.5	113.53	2063830.0
2015-10-29 11:00:00	QQQ	ETF	113.54	113.77	113.465	113.6963	2136750.0
2015-10-29 11:30:00	QQQ	ETF	113.686	113.84	113.686	113.7599	867013.0
2015-10-29 12:00:00	QQQ	ETF	113.75	113.84	113.6	113.83	1016871.0
2015-10-29 12:30:00	QQQ	ETF	113.84	113.93	113.76	113.86	915760.0

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

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