PREVIEW / etf_30min / 2016-08-16

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-08-16.parquet
  size:    398 KB
  rows:    13,788

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
2016-08-16 04:00:00	SPY	ETF	218.85	218.85	218.52	218.7	93696.0
2016-08-16 04:30:00	SPY	ETF	218.67	218.67	218.55	218.6	4810.0
2016-08-16 05:00:00	SPY	ETF	218.63	218.97	218.63	218.97	3162.0
2016-08-16 05:30:00	SPY	ETF	218.96	219.0	218.92	218.92	2801.0
2016-08-16 06:00:00	SPY	ETF	218.91	218.91	218.63	218.72	6004.0
2016-08-16 06:30:00	SPY	ETF	218.7	218.82	218.69	218.82	9470.0
2016-08-16 07:00:00	SPY	ETF	218.85	218.85	218.79	218.84	6352.0
2016-08-16 07:30:00	SPY	ETF	218.87	218.87	218.64	218.65	77627.0
2016-08-16 08:00:00	SPY	ETF	218.68	218.82	218.62	218.62	158465.0
2016-08-16 08:30:00	SPY	ETF	218.64	218.72	218.47	218.55	404955.0
2016-08-16 09:00:00	SPY	ETF	218.57	218.61	218.53	218.57	217830.0
2016-08-16 09:30:00	SPY	ETF	218.6	218.65	218.14	218.395	7535208.0
2016-08-16 10:00:00	SPY	ETF	218.39	218.68	218.35	218.415	4913577.0
2016-08-16 10:30:00	SPY	ETF	218.42	218.52	218.21	218.29	3991558.0
2016-08-16 11:00:00	SPY	ETF	218.29	218.62	218.25	218.5299	2524080.0
2016-08-16 11:30:00	SPY	ETF	218.53	218.55	218.31	218.47	2795310.0
2016-08-16 12:00:00	SPY	ETF	218.48	218.48	218.33	218.36	2229697.0
2016-08-16 12:30:00	SPY	ETF	218.3616	218.58	218.32	218.55	1899670.0
2016-08-16 13:00:00	SPY	ETF	218.541	218.58	218.17	218.27	2382844.0
2016-08-16 13:30:00	SPY	ETF	218.26	218.295	218.17	218.26	2312352.0
2016-08-16 14:00:00	SPY	ETF	218.26	218.3599	218.07	218.22	3743879.0
2016-08-16 14:30:00	SPY	ETF	218.225	218.42	218.17	218.39	3357319.0
2016-08-16 15:00:00	SPY	ETF	218.389	218.41	218.26	218.34	2988255.0
2016-08-16 15:30:00	SPY	ETF	218.33	218.38	217.96	217.98	7388319.0
2016-08-16 16:00:00	SPY	ETF	217.98	218.23	217.96	218.16	2758877.0
2016-08-16 16:30:00	SPY	ETF	218.16	218.26	218.1	218.22	365194.0
2016-08-16 17:00:00	SPY	ETF	218.21	218.31	217.96	218.29	150664.0
2016-08-16 17:30:00	SPY	ETF	218.29	218.3	218.21	218.22	53372.0
2016-08-16 18:00:00	SPY	ETF	218.21	218.29	218.18	218.27	65862.0
2016-08-16 18:30:00	SPY	ETF	218.25	218.25	218.19	218.19	8304.0
2016-08-16 19:00:00	SPY	ETF	218.19	218.28	218.19	218.28	13620.0
2016-08-16 19:30:00	SPY	ETF	218.28	218.28	218.23	218.26	16239.0
2016-08-16 04:00:00	QQQ	ETF	117.4	117.55	117.4	117.55	2400.0
2016-08-16 04:30:00	QQQ	ETF	117.49	117.49	117.46	117.46	434.0
2016-08-16 05:00:00	QQQ	ETF	117.5	117.68	117.5	117.65	4400.0
2016-08-16 05:30:00	QQQ	ETF	117.68	117.68	117.67	117.68	1151.0
2016-08-16 06:00:00	QQQ	ETF	117.64	117.64	117.49	117.55	3642.0
2016-08-16 06:30:00	QQQ	ETF	117.57	117.57	117.57	117.57	4102.0
2016-08-16 07:00:00	QQQ	ETF	117.59	117.62	117.56	117.58	9107.0
2016-08-16 07:30:00	QQQ	ETF	117.53	117.53	117.47	117.47	10697.0
2016-08-16 08:00:00	QQQ	ETF	117.54	117.54	117.45	117.5	23177.0
2016-08-16 08:30:00	QQQ	ETF	117.5	117.5	117.4	117.44	21918.0
2016-08-16 09:00:00	QQQ	ETF	117.46	117.51	117.44	117.47	40123.0
2016-08-16 09:30:00	QQQ	ETF	117.47	117.49	117.03	117.26	1856865.0
2016-08-16 10:00:00	QQQ	ETF	117.26	117.44	117.23	117.28	595886.0
2016-08-16 10:30:00	QQQ	ETF	117.2844	117.38	117.14	117.2065	602485.0
2016-08-16 11:00:00	QQQ	ETF	117.2	117.38	117.16	117.31	530487.0
2016-08-16 11:30:00	QQQ	ETF	117.3	117.34	117.21	117.2999	748977.0
2016-08-16 12:00:00	QQQ	ETF	117.3	117.31	117.245	117.25	558051.0
2016-08-16 12:30:00	QQQ	ETF	117.24	117.42	117.23	117.403	438658.0

> showing 50 of 13,788 rows — these rows as CSV

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