PREVIEW / etf_30min / 2015-11-25

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-11-25.parquet
  size:    358 KB
  rows:    12,293

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-11-25 04:00:00	SPY	ETF	209.5	209.79	209.48	209.79	9513.0
2015-11-25 04:30:00	SPY	ETF	209.79	209.96	209.78	209.78	18235.0
2015-11-25 05:00:00	SPY	ETF	209.73	209.73	209.64	209.65	3805.0
2015-11-25 05:30:00	SPY	ETF	209.74	209.84	209.72	209.81	9006.0
2015-11-25 06:00:00	SPY	ETF	209.77	209.82	209.65	209.65	2730.0
2015-11-25 06:30:00	SPY	ETF	209.63	209.67	209.5	209.67	20492.0
2015-11-25 07:00:00	SPY	ETF	209.65	209.69	209.45	209.57	35070.0
2015-11-25 07:30:00	SPY	ETF	209.55	209.7	209.55	209.57	110822.0
2015-11-25 08:00:00	SPY	ETF	209.57	209.94	208.96	209.77	231415.0
2015-11-25 08:30:00	SPY	ETF	209.76	209.88	209.51	209.56	321198.0
2015-11-25 09:00:00	SPY	ETF	209.56	209.66	209.42	209.5	343406.0
2015-11-25 09:30:00	SPY	ETF	209.5	209.59	209.01	209.55	7812523.0
2015-11-25 10:00:00	SPY	ETF	209.55	209.58	209.3	209.3733	5448503.0
2015-11-25 10:30:00	SPY	ETF	209.37	209.73	209.34	209.5	4623746.0
2015-11-25 11:00:00	SPY	ETF	209.5	209.55	209.31	209.39	3343533.0
2015-11-25 11:30:00	SPY	ETF	209.39	209.56	209.32	209.51	4218207.0
2015-11-25 12:00:00	SPY	ETF	209.515	209.73	209.51	209.6777	3432692.0
2015-11-25 12:30:00	SPY	ETF	209.67	209.74	209.6	209.62	2055810.0
2015-11-25 13:00:00	SPY	ETF	209.63	209.66	209.47	209.51	1973126.0
2015-11-25 13:30:00	SPY	ETF	209.5	209.59	209.38	209.5625	2073831.0
2015-11-25 14:00:00	SPY	ETF	209.56	209.65	209.49	209.575	1868367.0
2015-11-25 14:30:00	SPY	ETF	209.575	209.615	209.44	209.57	2281446.0
2015-11-25 15:00:00	SPY	ETF	209.58	209.66	209.53	209.64	2201397.0
2015-11-25 15:30:00	SPY	ETF	209.64	209.65	209.27	209.32	6693953.0
2015-11-25 16:00:00	SPY	ETF	209.33	209.63	209.29	209.5	1832200.0
2015-11-25 16:30:00	SPY	ETF	209.51	209.59	209.5	209.55	275452.0
2015-11-25 17:00:00	SPY	ETF	209.55	209.56	209.47	209.5	64379.0
2015-11-25 17:30:00	SPY	ETF	209.5	209.61	209.48	209.6	57421.0
2015-11-25 18:00:00	SPY	ETF	209.6	209.64	209.57	209.61	67973.0
2015-11-25 18:30:00	SPY	ETF	209.61	209.62	209.59	209.6	14197.0
2015-11-25 19:00:00	SPY	ETF	209.58	209.63	209.57	209.58	2458.0
2015-11-25 19:30:00	SPY	ETF	209.58	209.69	209.58	209.68	19113.0
2015-11-25 04:00:00	QQQ	ETF	114.3	114.3	114.3	114.3	200.0
2015-11-25 04:30:00	QQQ	ETF	114.32	114.33	114.32	114.33	1300.0
2015-11-25 05:00:00	QQQ	ETF	114.25	114.25	114.21	114.22	1400.0
2015-11-25 05:30:00	QQQ	ETF	114.28	114.3	114.28	114.3	900.0
2015-11-25 06:00:00	QQQ	ETF	114.26	114.26	114.19	114.19	900.0
2015-11-25 06:30:00	QQQ	ETF	114.19	114.19	114.19	114.19	150.0
2015-11-25 07:00:00	QQQ	ETF	114.24	114.24	114.14	114.19	12900.0
2015-11-25 08:00:00	QQQ	ETF	114.21	114.32	114.2	114.28	14919.0
2015-11-25 08:30:00	QQQ	ETF	114.26	114.3	114.2	114.2	37636.0
2015-11-25 09:00:00	QQQ	ETF	114.18	114.2	114.14	114.19	62281.0
2015-11-25 09:30:00	QQQ	ETF	114.19	114.29	113.91	114.27	2875588.0
2015-11-25 10:00:00	QQQ	ETF	114.26	114.33	114.07	114.15	1328674.0
2015-11-25 10:30:00	QQQ	ETF	114.14	114.36	114.14	114.16	952945.0
2015-11-25 11:00:00	QQQ	ETF	114.159	114.19	114.0	114.02	759476.0
2015-11-25 11:30:00	QQQ	ETF	114.02	114.31	114.01	114.29	1025661.0
2015-11-25 12:00:00	QQQ	ETF	114.29	114.33	114.24	114.295	964768.0
2015-11-25 12:30:00	QQQ	ETF	114.3	114.36	114.2601	114.29	717022.0
2015-11-25 13:00:00	QQQ	ETF	114.3	114.32	114.16	114.19	359588.0

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

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