PREVIEW / etf_30min / 2016-10-27

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-10-27.parquet
  size:    403 KB
  rows:    13,653

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-10-27 04:00:00	SPY	ETF	214.19	214.28	214.13	214.15	9470.0
2016-10-27 04:30:00	SPY	ETF	214.17	214.21	213.54	213.54	10143.0
2016-10-27 05:00:00	SPY	ETF	213.59	213.64	213.43	213.62	2206.0
2016-10-27 05:30:00	SPY	ETF	213.62	213.66	213.54	213.66	3501.0
2016-10-27 06:00:00	SPY	ETF	213.69	213.93	213.48	213.93	17648.0
2016-10-27 06:30:00	SPY	ETF	213.95	214.27	213.95	214.13	144441.0
2016-10-27 07:00:00	SPY	ETF	214.16	214.45	214.16	214.29	152900.0
2016-10-27 07:30:00	SPY	ETF	214.3	214.44	214.22	214.43	125616.0
2016-10-27 08:00:00	SPY	ETF	214.39	214.69	213.792	214.61	466080.0
2016-10-27 08:30:00	SPY	ETF	214.61	214.78	214.5	214.73	749111.0
2016-10-27 09:00:00	SPY	ETF	214.72	214.76	214.53	214.59	478498.0
2016-10-27 09:30:00	SPY	ETF	214.58	214.62	213.85	214.08	9441414.0
2016-10-27 10:00:00	SPY	ETF	214.08	214.11	213.1	213.37	7830389.0
2016-10-27 10:30:00	SPY	ETF	213.38	213.54	213.2	213.3079	7114883.0
2016-10-27 11:00:00	SPY	ETF	213.3	213.61	213.22	213.5489	3923752.0
2016-10-27 11:30:00	SPY	ETF	213.55	214.02	213.34	213.96	5189072.0
2016-10-27 12:00:00	SPY	ETF	213.95	214.06	213.8	213.86	5631735.0
2016-10-27 12:30:00	SPY	ETF	213.86	213.9	213.45	213.625	3845250.0
2016-10-27 13:00:00	SPY	ETF	213.63	213.76	213.5	213.68	2133728.0
2016-10-27 13:30:00	SPY	ETF	213.689	213.88	213.6	213.69	3373178.0
2016-10-27 14:00:00	SPY	ETF	213.7	213.9	213.6	213.7673	2783796.0
2016-10-27 14:30:00	SPY	ETF	213.77	213.78	213.394	213.5092	2206993.0
2016-10-27 15:00:00	SPY	ETF	213.51	213.57	213.09	213.31	4805967.0
2016-10-27 15:30:00	SPY	ETF	213.3	213.37	213.08	213.18	9164579.0
2016-10-27 16:00:00	SPY	ETF	213.18	213.7435	212.68	212.97	5458278.0
2016-10-27 16:30:00	SPY	ETF	212.95	213.2	212.86	213.19	843070.0
2016-10-27 17:00:00	SPY	ETF	213.15	213.19	213.06	213.12	117502.0
2016-10-27 17:30:00	SPY	ETF	213.1	213.16	213.1	213.12	24508.0
2016-10-27 18:00:00	SPY	ETF	213.13	213.2	213.11	213.15	90245.0
2016-10-27 18:30:00	SPY	ETF	213.17	213.2	213.16	213.17	20181.0
2016-10-27 19:00:00	SPY	ETF	213.17	213.2	213.17	213.17	16096.0
2016-10-27 19:30:00	SPY	ETF	213.17	213.26	213.16	213.23	33672.0
2016-10-27 04:00:00	QQQ	ETF	118.33	118.59	118.33	118.59	3020.0
2016-10-27 04:30:00	QQQ	ETF	118.42	118.42	118.17	118.17	11097.0
2016-10-27 05:00:00	QQQ	ETF	118.16	118.21	118.16	118.21	750.0
2016-10-27 06:30:00	QQQ	ETF	118.5	118.6	118.5	118.55	23822.0
2016-10-27 07:00:00	QQQ	ETF	118.6	118.7	118.59	118.61	98444.0
2016-10-27 07:30:00	QQQ	ETF	118.7	118.73	118.65	118.73	24931.0
2016-10-27 08:00:00	QQQ	ETF	118.7	118.92	118.69	118.87	211183.0
2016-10-27 08:30:00	QQQ	ETF	118.86	118.99	118.85	118.98	124491.0
2016-10-27 09:00:00	QQQ	ETF	118.99	119.0	118.89	118.89	145931.0
2016-10-27 09:30:00	QQQ	ETF	118.9	118.99	118.6332	118.7889	2109427.0
2016-10-27 10:00:00	QQQ	ETF	118.78	118.78	118.225	118.31	1236400.0
2016-10-27 10:30:00	QQQ	ETF	118.31	118.3625	118.04	118.15	1324122.0
2016-10-27 11:00:00	QQQ	ETF	118.15	118.34	118.09	118.289	1079693.0
2016-10-27 11:30:00	QQQ	ETF	118.29	118.46	118.11	118.41	935067.0
2016-10-27 12:00:00	QQQ	ETF	118.41	118.47	118.29	118.35	566457.0
2016-10-27 12:30:00	QQQ	ETF	118.35	118.36	118.08	118.14	610733.0
2016-10-27 13:00:00	QQQ	ETF	118.14	118.17	117.9805	118.1425	778620.0
2016-10-27 13:30:00	QQQ	ETF	118.145	118.231	118.08	118.1349	854425.0

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

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