PREVIEW / etf_30min / 2015-09-11

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-09-11.parquet
  size:    362 KB
  rows:    12,256

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-09-11 04:00:00	SPY	ETF	195.68	195.68	194.98	195.25	13158.0
2015-09-11 04:30:00	SPY	ETF	194.99	195.18	194.54	194.7	16766.0
2015-09-11 05:00:00	SPY	ETF	194.56	195.02	194.54	195.02	54440.0
2015-09-11 05:30:00	SPY	ETF	195.08	195.36	194.82	195.33	19465.0
2015-09-11 06:00:00	SPY	ETF	195.4	195.47	195.01	195.21	20000.0
2015-09-11 06:30:00	SPY	ETF	195.14	195.27	194.76	194.76	31344.0
2015-09-11 07:00:00	SPY	ETF	194.8	195.2	194.6	195.09	98350.0
2015-09-11 07:30:00	SPY	ETF	195.15	195.3	195.05	195.2	79463.0
2015-09-11 08:00:00	SPY	ETF	195.19	196.45	194.62	195.37	445631.0
2015-09-11 08:30:00	SPY	ETF	195.35	195.38	194.73	194.82	716296.0
2015-09-11 09:00:00	SPY	ETF	194.88	195.37	194.81	195.37	684160.0
2015-09-11 09:30:00	SPY	ETF	195.375	195.52	194.65	194.72	12159804.0
2015-09-11 10:00:00	SPY	ETF	194.7	195.27	194.53	194.97	7562685.0
2015-09-11 10:30:00	SPY	ETF	194.96	195.25	194.68	194.801	5378936.0
2015-09-11 11:00:00	SPY	ETF	194.81	195.25	194.71	195.22	5293862.0
2015-09-11 11:30:00	SPY	ETF	195.22	195.79	194.96	195.66	6937509.0
2015-09-11 12:00:00	SPY	ETF	195.665	196.25	195.62	196.04	6948212.0
2015-09-11 12:30:00	SPY	ETF	196.03	196.33	195.8	196.14	3503232.0
2015-09-11 13:00:00	SPY	ETF	196.15	196.195	195.52	195.54	5758474.0
2015-09-11 13:30:00	SPY	ETF	195.54	195.74	195.3	195.63	6534994.0
2015-09-11 14:00:00	SPY	ETF	195.62	195.94	195.35	195.82	6245186.0
2015-09-11 14:30:00	SPY	ETF	195.83	196.26	195.82	196.04	5954228.0
2015-09-11 15:00:00	SPY	ETF	196.04	196.5	196.03	196.24	9882501.0
2015-09-11 15:30:00	SPY	ETF	196.23	196.77	196.03	196.77	17090603.0
2015-09-11 16:00:00	SPY	ETF	196.76	196.92	196.67	196.83	8293115.0
2015-09-11 16:30:00	SPY	ETF	196.83	197.0	196.74	196.9	8193469.0
2015-09-11 17:00:00	SPY	ETF	196.9	196.99	196.84	196.96	174202.0
2015-09-11 17:30:00	SPY	ETF	196.95	197.09	196.94	197.09	89878.0
2015-09-11 18:00:00	SPY	ETF	197.08	197.18	197.0	197.18	48927.0
2015-09-11 18:30:00	SPY	ETF	197.15	197.19	197.07	197.08	22441.0
2015-09-11 19:00:00	SPY	ETF	197.08	197.09	197.07	197.09	6589.0
2015-09-11 19:30:00	SPY	ETF	197.09	197.25	197.09	197.17	22281.0
2015-09-11 04:00:00	QQQ	ETF	104.51	104.51	104.51	104.51	200.0
2015-09-11 04:30:00	QQQ	ETF	104.34	104.47	104.11	104.12	10450.0
2015-09-11 05:00:00	QQQ	ETF	104.27	104.32	104.27	104.32	1791.0
2015-09-11 05:30:00	QQQ	ETF	104.53	104.53	104.49	104.49	2500.0
2015-09-11 06:00:00	QQQ	ETF	104.45	104.55	104.35	104.45	1530.0
2015-09-11 06:30:00	QQQ	ETF	104.49	104.49	104.26	104.26	1100.0
2015-09-11 07:00:00	QQQ	ETF	104.33	104.53	104.22	104.53	5210.0
2015-09-11 07:30:00	QQQ	ETF	104.48	104.48	104.48	104.48	1500.0
2015-09-11 08:00:00	QQQ	ETF	104.46	104.68	104.43	104.66	57268.0
2015-09-11 08:30:00	QQQ	ETF	104.56	104.56	104.26	104.32	85609.0
2015-09-11 09:00:00	QQQ	ETF	104.29	104.53	104.25	104.53	140955.0
2015-09-11 09:30:00	QQQ	ETF	104.51	104.7699	104.31	104.32	3914296.0
2015-09-11 10:00:00	QQQ	ETF	104.32	104.63	104.21	104.4699	2257363.0
2015-09-11 10:30:00	QQQ	ETF	104.46	104.67	104.31	104.38	1793759.0
2015-09-11 11:00:00	QQQ	ETF	104.38	104.579	104.25	104.55	1905440.0
2015-09-11 11:30:00	QQQ	ETF	104.55	104.88	104.41	104.81	1649476.0
2015-09-11 12:00:00	QQQ	ETF	104.82	105.15	104.79	105.1	1996801.0
2015-09-11 12:30:00	QQQ	ETF	105.1	105.29	105.0	105.19	893284.0

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

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