PREVIEW / etf_30min / 2017-03-30

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-03-30.parquet
  size:    420 KB
  rows:    14,388

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
2017-03-30 04:00:00	SPY	ETF	235.67	235.67	235.55	235.58	4788.0
2017-03-30 04:30:00	SPY	ETF	235.59	235.59	235.25	235.27	12640.0
2017-03-30 05:00:00	SPY	ETF	235.27	235.33	235.27	235.31	9752.0
2017-03-30 05:30:00	SPY	ETF	235.34	235.36	235.31	235.34	6054.0
2017-03-30 06:00:00	SPY	ETF	235.29	235.29	235.27	235.27	1431.0
2017-03-30 06:30:00	SPY	ETF	235.23	235.26	235.21	235.26	10300.0
2017-03-30 07:00:00	SPY	ETF	235.24	235.3	235.2	235.27	72563.0
2017-03-30 07:30:00	SPY	ETF	235.26	235.35	235.22	235.31	62028.0
2017-03-30 08:00:00	SPY	ETF	235.31	235.4	235.21	235.4	108269.0
2017-03-30 08:30:00	SPY	ETF	235.43	235.55	235.41	235.42	267197.0
2017-03-30 09:00:00	SPY	ETF	235.42	235.52	235.32	235.49	327411.0
2017-03-30 09:30:00	SPY	ETF	235.47	235.8	235.27	235.73	6392051.0
2017-03-30 10:00:00	SPY	ETF	235.73	236.14	235.71	236.0	4563605.0
2017-03-30 10:30:00	SPY	ETF	236.0	236.49	235.97	236.44	3675015.0
2017-03-30 11:00:00	SPY	ETF	236.4399	236.52	236.31	236.41	2594950.0
2017-03-30 11:30:00	SPY	ETF	236.4	236.52	236.05	236.05	2666642.0
2017-03-30 12:00:00	SPY	ETF	236.06	236.19	236.005	236.16	3268429.0
2017-03-30 12:30:00	SPY	ETF	236.16	236.19	235.76	235.91	2203270.0
2017-03-30 13:00:00	SPY	ETF	235.91	236.26	235.88	236.17	2139323.0
2017-03-30 13:30:00	SPY	ETF	236.18	236.365	236.14	236.22	2093825.0
2017-03-30 14:00:00	SPY	ETF	236.2201	236.43	236.18	236.39	2038039.0
2017-03-30 14:30:00	SPY	ETF	236.4	236.48	236.08	236.2	3669213.0
2017-03-30 15:00:00	SPY	ETF	236.2	236.36	236.2	236.34	3328080.0
2017-03-30 15:30:00	SPY	ETF	236.34	236.42	236.13	236.27	7454527.0
2017-03-30 16:00:00	SPY	ETF	236.26	236.34	236.2	236.3	8205900.0
2017-03-30 16:30:00	SPY	ETF	236.29	236.35	236.24	236.35	264107.0
2017-03-30 17:00:00	SPY	ETF	236.36	236.36	236.25	236.32	280142.0
2017-03-30 17:30:00	SPY	ETF	236.33	236.35	236.29	236.34	49170.0
2017-03-30 18:00:00	SPY	ETF	236.36	236.39	236.34	236.35	20189.0
2017-03-30 18:30:00	SPY	ETF	236.35	236.37	236.24	236.26	18913.0
2017-03-30 19:00:00	SPY	ETF	236.26	236.27	236.22	236.25	14440.0
2017-03-30 19:30:00	SPY	ETF	236.25	236.27	236.18	236.21	19250.0
2017-03-30 04:30:00	QQQ	ETF	132.18	132.18	132.18	132.18	600.0
2017-03-30 05:30:00	QQQ	ETF	132.21	132.24	132.21	132.23	28817.0
2017-03-30 06:00:00	QQQ	ETF	132.2	132.2	132.2	132.2	454.0
2017-03-30 07:00:00	QQQ	ETF	132.15	132.18	132.14	132.18	3270.0
2017-03-30 07:30:00	QQQ	ETF	132.18	132.22	132.17	132.2	14682.0
2017-03-30 08:00:00	QQQ	ETF	132.21	132.22	132.17	132.17	6293.0
2017-03-30 08:30:00	QQQ	ETF	132.23	132.27	132.22	132.22	36159.0
2017-03-30 09:00:00	QQQ	ETF	132.2	132.28	132.2	132.22	60576.0
2017-03-30 09:30:00	QQQ	ETF	132.22	132.47	132.08	132.415	2324814.0
2017-03-30 10:00:00	QQQ	ETF	132.4	132.56	132.36	132.418	1379901.0
2017-03-30 10:30:00	QQQ	ETF	132.4142	132.5973	132.35	132.575	849204.0
2017-03-30 11:00:00	QQQ	ETF	132.58	132.61	132.43	132.48	569245.0
2017-03-30 11:30:00	QQQ	ETF	132.49	132.5566	132.26	132.26	848780.0
2017-03-30 12:00:00	QQQ	ETF	132.261	132.4	132.23	132.38	647827.0
2017-03-30 12:30:00	QQQ	ETF	132.375	132.38	132.12	132.25	1169058.0
2017-03-30 13:00:00	QQQ	ETF	132.248	132.4699	132.21	132.4158	813245.0
2017-03-30 13:30:00	QQQ	ETF	132.42	132.53	132.38	132.415	505932.0
2017-03-30 14:00:00	QQQ	ETF	132.42	132.525	132.36	132.48	471335.0

> showing 50 of 14,388 rows — these rows as CSV

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