PREVIEW / etf_30min / 2017-02-10

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-02-10.parquet
  size:    441 KB
  rows:    14,856

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
2017-02-10 04:00:00	SPY	ETF	230.85	230.94	230.83	230.91	16588.0
2017-02-10 04:30:00	SPY	ETF	230.84	230.9	230.84	230.9	503.0
2017-02-10 05:00:00	SPY	ETF	230.94	230.94	230.94	230.94	1700.0
2017-02-10 06:00:00	SPY	ETF	230.76	230.76	230.76	230.76	1100.0
2017-02-10 06:30:00	SPY	ETF	230.79	230.84	230.75	230.76	48610.0
2017-02-10 07:00:00	SPY	ETF	230.7	230.84	230.7	230.82	27707.0
2017-02-10 07:30:00	SPY	ETF	230.83	230.94	230.83	230.9	24707.0
2017-02-10 08:00:00	SPY	ETF	230.92	230.94	230.791	230.84	102776.0
2017-02-10 08:30:00	SPY	ETF	230.86	230.91	230.83	230.87	47661.0
2017-02-10 09:00:00	SPY	ETF	230.88	231.06	230.88	231.01	281020.0
2017-02-10 09:30:00	SPY	ETF	231.0	231.2	230.88	231.09	7235793.0
2017-02-10 10:00:00	SPY	ETF	231.09	231.1463	230.915	231.08	4364640.0
2017-02-10 10:30:00	SPY	ETF	231.1	231.355	231.0601	231.21	3685380.0
2017-02-10 11:00:00	SPY	ETF	231.21	231.25	231.065	231.1201	3441870.0
2017-02-10 11:30:00	SPY	ETF	231.125	231.25	231.07	231.25	2299687.0
2017-02-10 12:00:00	SPY	ETF	231.24	231.4	231.18	231.3735	2695243.0
2017-02-10 12:30:00	SPY	ETF	231.38	231.53	231.36	231.47	2748977.0
2017-02-10 13:00:00	SPY	ETF	231.47	231.658	231.45	231.5399	3358928.0
2017-02-10 13:30:00	SPY	ETF	231.54	231.77	231.51	231.585	2913591.0
2017-02-10 14:00:00	SPY	ETF	231.59	231.7	231.5101	231.59	3288058.0
2017-02-10 14:30:00	SPY	ETF	231.59	231.64	231.38	231.4	3223081.0
2017-02-10 15:00:00	SPY	ETF	231.41	231.56	231.4072	231.49	2508044.0
2017-02-10 15:30:00	SPY	ETF	231.49	231.62	231.42	231.48	10269643.0
2017-02-10 16:00:00	SPY	ETF	231.47	231.6	231.42	231.47	11680216.0
2017-02-10 16:30:00	SPY	ETF	231.48	231.52	231.45	231.49	389929.0
2017-02-10 17:00:00	SPY	ETF	231.49	231.53	231.47	231.5	217212.0
2017-02-10 17:30:00	SPY	ETF	231.48	231.56	231.48	231.55	29597.0
2017-02-10 18:00:00	SPY	ETF	231.53	231.54	231.52	231.54	2633.0
2017-02-10 18:30:00	SPY	ETF	231.54	231.54	231.5	231.52	7985.0
2017-02-10 19:00:00	SPY	ETF	231.51	231.54	231.51	231.51	4050.0
2017-02-10 19:30:00	SPY	ETF	231.51	231.54	231.45	231.47	25692.0
2017-02-10 05:00:00	QQQ	ETF	127.26	127.26	127.26	127.26	100.0
2017-02-10 05:30:00	QQQ	ETF	127.18	127.18	127.18	127.18	400.0
2017-02-10 06:00:00	QQQ	ETF	127.19	127.2	127.15	127.15	15400.0
2017-02-10 06:30:00	QQQ	ETF	127.19	127.19	127.19	127.19	5000.0
2017-02-10 07:00:00	QQQ	ETF	127.18	127.22	127.18	127.19	6600.0
2017-02-10 07:30:00	QQQ	ETF	127.22	127.26	127.22	127.26	7000.0
2017-02-10 08:00:00	QQQ	ETF	127.19	127.25	127.18	127.21	49656.0
2017-02-10 08:30:00	QQQ	ETF	127.21	127.22	127.18	127.21	31450.0
2017-02-10 09:00:00	QQQ	ETF	127.2	127.29	127.18	127.19	54263.0
2017-02-10 09:30:00	QQQ	ETF	127.2	127.3	127.07	127.1	1846069.0
2017-02-10 10:00:00	QQQ	ETF	127.09	127.249	127.02	127.235	1406724.0
2017-02-10 10:30:00	QQQ	ETF	127.23	127.37	127.22	127.3	722354.0
2017-02-10 11:00:00	QQQ	ETF	127.3	127.36	127.22	127.27	505777.0
2017-02-10 11:30:00	QQQ	ETF	127.27	127.35	127.19	127.33	739411.0
2017-02-10 12:00:00	QQQ	ETF	127.33	127.41	127.26	127.39	581124.0
2017-02-10 12:30:00	QQQ	ETF	127.39	127.47	127.36	127.435	520382.0
2017-02-10 13:00:00	QQQ	ETF	127.43	127.56	127.4151	127.465	880876.0
2017-02-10 13:30:00	QQQ	ETF	127.46	127.55	127.43	127.44	594525.0
2017-02-10 14:00:00	QQQ	ETF	127.44	127.49	127.41	127.44	389574.0

> showing 50 of 14,856 rows — these rows as CSV

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