PREVIEW / etf_30min / 2017-02-21

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-02-21.parquet
  size:    443 KB
  rows:    15,325

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-02-21 04:00:00	SPY	ETF	235.2	235.48	235.2	235.48	6360.0
2017-02-21 04:30:00	SPY	ETF	235.49	235.49	235.45	235.45	2435.0
2017-02-21 05:00:00	SPY	ETF	235.45	235.5	235.45	235.5	4300.0
2017-02-21 05:30:00	SPY	ETF	235.55	235.55	235.49	235.55	10044.0
2017-02-21 06:00:00	SPY	ETF	235.54	235.58	235.49	235.52	36826.0
2017-02-21 06:30:00	SPY	ETF	235.52	235.61	235.5	235.5	44310.0
2017-02-21 07:00:00	SPY	ETF	235.52	235.64	235.52	235.54	84050.0
2017-02-21 07:30:00	SPY	ETF	235.56	235.6	235.51	235.52	35988.0
2017-02-21 08:00:00	SPY	ETF	235.62	235.62	235.39	235.48	190418.0
2017-02-21 08:30:00	SPY	ETF	235.47	235.53	235.47	235.49	77787.0
2017-02-21 09:00:00	SPY	ETF	235.5	235.71	235.09	235.53	299057.0
2017-02-21 09:30:00	SPY	ETF	235.52	236.17	235.51	236.1	7603520.0
2017-02-21 10:00:00	SPY	ETF	236.1	236.54	236.07	236.44	7658764.0
2017-02-21 10:30:00	SPY	ETF	236.44	236.65	236.31	236.4	4448197.0
2017-02-21 11:00:00	SPY	ETF	236.41	236.44	235.96	235.99	5853337.0
2017-02-21 11:30:00	SPY	ETF	235.99	236.14	235.81	236.1	3798898.0
2017-02-21 12:00:00	SPY	ETF	236.095	236.28	236.06	236.22	3382258.0
2017-02-21 12:30:00	SPY	ETF	236.22	236.27	236.07	236.11	1936578.0
2017-02-21 13:00:00	SPY	ETF	236.11	236.23	236.0	236.19	2920334.0
2017-02-21 13:30:00	SPY	ETF	236.2	236.2	235.95	236.075	2567589.0
2017-02-21 14:00:00	SPY	ETF	236.08	236.33	236.015	236.3163	3400094.0
2017-02-21 14:30:00	SPY	ETF	236.32	236.46	236.24	236.365	3915480.0
2017-02-21 15:00:00	SPY	ETF	236.37	236.58	236.32	236.575	6552914.0
2017-02-21 15:30:00	SPY	ETF	236.58	236.69	236.42	236.45	11090201.0
2017-02-21 16:00:00	SPY	ETF	236.45	236.5886	236.07	236.2	17652861.0
2017-02-21 16:30:00	SPY	ETF	236.19	236.5411	236.13	236.25	465861.0
2017-02-21 17:00:00	SPY	ETF	236.24	236.28	236.24	236.25	28971.0
2017-02-21 17:30:00	SPY	ETF	236.25	236.26	236.19	236.2	2040111.0
2017-02-21 18:00:00	SPY	ETF	236.21	236.25	236.16	236.17	38163.0
2017-02-21 18:30:00	SPY	ETF	236.2	236.25	236.17	236.25	26927.0
2017-02-21 19:00:00	SPY	ETF	236.21	236.22	236.15	236.15	24651.0
2017-02-21 19:30:00	SPY	ETF	236.17	236.27	236.17	236.27	23823.0
2017-02-21 04:00:00	QQQ	ETF	130.05	130.14	130.05	130.13	1600.0
2017-02-21 04:30:00	QQQ	ETF	130.15	130.15	130.14	130.14	600.0
2017-02-21 05:30:00	QQQ	ETF	130.17	130.25	130.17	130.25	15200.0
2017-02-21 06:00:00	QQQ	ETF	130.19	130.19	130.16	130.18	400.0
2017-02-21 06:30:00	QQQ	ETF	130.19	130.2	130.19	130.2	5400.0
2017-02-21 07:00:00	QQQ	ETF	130.21	130.21	130.17	130.17	59350.0
2017-02-21 07:30:00	QQQ	ETF	130.17	130.19	130.11	130.13	19727.0
2017-02-21 08:00:00	QQQ	ETF	130.12	130.2	130.06	130.06	43029.0
2017-02-21 08:30:00	QQQ	ETF	130.07	130.11	130.06	130.08	23889.0
2017-02-21 09:00:00	QQQ	ETF	130.08	130.18	129.81	130.04	139903.0
2017-02-21 09:30:00	QQQ	ETF	130.03	130.37	129.99	130.29	1925238.0
2017-02-21 10:00:00	QQQ	ETF	130.29	130.43	130.23	130.359	1547328.0
2017-02-21 10:30:00	QQQ	ETF	130.3584	130.52	130.31	130.38	991456.0
2017-02-21 11:00:00	QQQ	ETF	130.37	130.395	130.16	130.1811	774144.0
2017-02-21 11:30:00	QQQ	ETF	130.18	130.2355	130.06	130.18	646416.0
2017-02-21 12:00:00	QQQ	ETF	130.19	130.23	130.08	130.19	969413.0
2017-02-21 12:30:00	QQQ	ETF	130.19	130.23	130.11	130.16	490325.0
2017-02-21 13:00:00	QQQ	ETF	130.16	130.255	130.13	130.24	335787.0

> showing 50 of 15,325 rows — these rows as CSV

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