PREVIEW / etf_30min / 2016-10-20

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-10-20.parquet
  size:    386 KB
  rows:    13,129

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-20 04:00:00	SPY	ETF	214.33	214.38	214.33	214.37	2302.0
2016-10-20 04:30:00	SPY	ETF	214.38	214.39	214.29	214.29	7801.0
2016-10-20 05:00:00	SPY	ETF	214.28	214.44	214.28	214.4	2388.0
2016-10-20 05:30:00	SPY	ETF	214.39	214.41	214.35	214.41	2591.0
2016-10-20 06:00:00	SPY	ETF	214.46	214.51	214.46	214.49	1604.0
2016-10-20 06:30:00	SPY	ETF	214.46	214.46	214.43	214.46	24300.0
2016-10-20 07:00:00	SPY	ETF	214.46	214.47	214.41	214.45	22107.0
2016-10-20 07:30:00	SPY	ETF	214.44	214.45	214.28	214.38	273073.0
2016-10-20 08:00:00	SPY	ETF	214.38	214.611	214.03	214.07	207301.0
2016-10-20 08:30:00	SPY	ETF	214.09	214.13	213.62	213.96	976070.0
2016-10-20 09:00:00	SPY	ETF	213.95	214.05	213.82	213.88	340264.0
2016-10-20 09:30:00	SPY	ETF	213.87	214.18	213.52	214.14	10248280.0
2016-10-20 10:00:00	SPY	ETF	214.132	214.53	213.79	213.88	6210653.0
2016-10-20 10:30:00	SPY	ETF	213.88	213.88	213.11	213.3367	10294030.0
2016-10-20 11:00:00	SPY	ETF	213.33	213.73	213.2	213.5353	4524159.0
2016-10-20 11:30:00	SPY	ETF	213.55	213.945	213.43	213.93	4072983.0
2016-10-20 12:00:00	SPY	ETF	213.93	214.19	213.8779	214.09	5223011.0
2016-10-20 12:30:00	SPY	ETF	214.08	214.42	214.02	214.16	3283803.0
2016-10-20 13:00:00	SPY	ETF	214.16	214.3	214.065	214.18	2186294.0
2016-10-20 13:30:00	SPY	ETF	214.18	214.265	213.639	213.8	4464479.0
2016-10-20 14:00:00	SPY	ETF	213.805	214.2003	213.78	213.9801	2415297.0
2016-10-20 14:30:00	SPY	ETF	213.9899	214.239	213.87	214.1	2532558.0
2016-10-20 15:00:00	SPY	ETF	214.0999	214.24	213.89	213.89	3049086.0
2016-10-20 15:30:00	SPY	ETF	213.89	214.16	213.79	213.89	8590642.0
2016-10-20 16:00:00	SPY	ETF	213.9	214.17	213.88	214.1	3302920.0
2016-10-20 16:30:00	SPY	ETF	214.1	214.16	213.88	214.08	523391.0
2016-10-20 17:00:00	SPY	ETF	214.1	214.14	214.05	214.05	59645.0
2016-10-20 17:30:00	SPY	ETF	214.06	214.08	214.04	214.05	8639.0
2016-10-20 18:00:00	SPY	ETF	214.04	214.05	213.9	213.97	52485.0
2016-10-20 18:30:00	SPY	ETF	213.98	214.11	213.98	214.1	13067.0
2016-10-20 19:00:00	SPY	ETF	214.1	214.24	214.1	214.21	50059.0
2016-10-20 19:30:00	SPY	ETF	214.21	214.23	214.06	214.15	26361.0
2016-10-20 06:00:00	QQQ	ETF	117.93	117.93	117.93	117.93	100.0
2016-10-20 07:00:00	QQQ	ETF	117.98	117.98	117.94	117.94	4500.0
2016-10-20 07:30:00	QQQ	ETF	117.95	117.96	117.93	117.93	71028.0
2016-10-20 08:00:00	QQQ	ETF	117.93	117.93	117.78	117.78	37480.0
2016-10-20 08:30:00	QQQ	ETF	117.8	117.81	117.58	117.7	68794.0
2016-10-20 09:00:00	QQQ	ETF	117.7	117.76	117.66	117.66	48501.0
2016-10-20 09:30:00	QQQ	ETF	117.67	117.73	117.24	117.66	2427676.0
2016-10-20 10:00:00	QQQ	ETF	117.66	117.97	117.47	117.51	1350560.0
2016-10-20 10:30:00	QQQ	ETF	117.51	117.51	117.03	117.21	2000823.0
2016-10-20 11:00:00	QQQ	ETF	117.22	117.445	117.12	117.37	884005.0
2016-10-20 11:30:00	QQQ	ETF	117.38	117.54	117.28	117.54	764848.0
2016-10-20 12:00:00	QQQ	ETF	117.54	117.75	117.49	117.69	1324195.0
2016-10-20 12:30:00	QQQ	ETF	117.6998	117.94	117.65	117.8	1307096.0
2016-10-20 13:00:00	QQQ	ETF	117.79	117.83	117.7	117.78	763273.0
2016-10-20 13:30:00	QQQ	ETF	117.7863	117.83	117.37	117.45	837001.0
2016-10-20 14:00:00	QQQ	ETF	117.44	117.63	117.44	117.61	362107.0
2016-10-20 14:30:00	QQQ	ETF	117.62	117.907	117.56	117.8	812899.0
2016-10-20 15:00:00	QQQ	ETF	117.81	117.89	117.69	117.7	763620.0

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

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