PREVIEW / etf_30min / 2016-10-14

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-10-14.parquet
  size:    396 KB
  rows:    13,406

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-14 04:00:00	SPY	ETF	213.21	213.25	213.17	213.17	17935.0
2016-10-14 04:30:00	SPY	ETF	213.15	213.44	213.1	213.44	18675.0
2016-10-14 05:00:00	SPY	ETF	213.4	213.68	213.4	213.64	7010.0
2016-10-14 05:30:00	SPY	ETF	213.66	213.83	213.64	213.79	15335.0
2016-10-14 06:00:00	SPY	ETF	213.79	214.05	213.77	214.05	97360.0
2016-10-14 06:30:00	SPY	ETF	214.06	214.25	213.96	214.0	169708.0
2016-10-14 07:00:00	SPY	ETF	214.01	214.06	213.97	213.98	110855.0
2016-10-14 07:30:00	SPY	ETF	213.97	214.0	213.86	213.9	129908.0
2016-10-14 08:00:00	SPY	ETF	213.91	214.05	213.61	213.84	358447.0
2016-10-14 08:30:00	SPY	ETF	213.8	214.1	213.74	213.98	394474.0
2016-10-14 09:00:00	SPY	ETF	214.0	214.19	213.97	214.16	615462.0
2016-10-14 09:30:00	SPY	ETF	214.15	214.55	214.09	214.405	9914860.0
2016-10-14 10:00:00	SPY	ETF	214.4	214.69	214.23	214.38	6369866.0
2016-10-14 10:30:00	SPY	ETF	214.38	214.61	214.17	214.195	4047100.0
2016-10-14 11:00:00	SPY	ETF	214.19	214.2	213.61	213.6199	7327731.0
2016-10-14 11:30:00	SPY	ETF	213.62	213.68	213.29	213.32	6704806.0
2016-10-14 12:00:00	SPY	ETF	213.33	213.44	213.04	213.39	7377566.0
2016-10-14 12:30:00	SPY	ETF	213.38	213.58	213.35	213.45	2482457.0
2016-10-14 13:00:00	SPY	ETF	213.45	213.73	213.26	213.65	3765498.0
2016-10-14 13:30:00	SPY	ETF	213.65	214.0611	213.4	213.51	7012099.0
2016-10-14 14:00:00	SPY	ETF	213.518	213.7	213.22	213.67	4810911.0
2016-10-14 14:30:00	SPY	ETF	213.68	213.72	213.15	213.21	2924168.0
2016-10-14 15:00:00	SPY	ETF	213.21	213.47	213.19	213.35	3206528.0
2016-10-14 15:30:00	SPY	ETF	213.34	213.68	213.03	213.09	12861317.0
2016-10-14 16:00:00	SPY	ETF	213.09	213.24	212.89	213.08	7027001.0
2016-10-14 16:30:00	SPY	ETF	213.06	213.12	213.0	213.02	3865032.0
2016-10-14 17:00:00	SPY	ETF	213.02	214.34	212.96	213.02	233048.0
2016-10-14 17:30:00	SPY	ETF	213.01	213.07	213.0	213.0	28835.0
2016-10-14 18:00:00	SPY	ETF	213.05	213.12	213.05	213.06	25203.0
2016-10-14 18:30:00	SPY	ETF	213.1	213.1	213.02	213.03	8747.0
2016-10-14 19:00:00	SPY	ETF	213.03	213.07	213.02	213.05	3623.0
2016-10-14 19:30:00	SPY	ETF	213.02	213.04	212.97	212.98	12640.0
2016-10-14 04:00:00	QQQ	ETF	117.04	117.04	117.03	117.03	700.0
2016-10-14 05:00:00	QQQ	ETF	117.14	117.2	117.14	117.2	10750.0
2016-10-14 05:30:00	QQQ	ETF	117.34	117.34	117.34	117.34	700.0
2016-10-14 06:00:00	QQQ	ETF	117.35	117.42	117.35	117.42	10200.0
2016-10-14 06:30:00	QQQ	ETF	117.48	117.59	117.47	117.47	18450.0
2016-10-14 07:00:00	QQQ	ETF	117.47	117.49	117.44	117.46	10800.0
2016-10-14 07:30:00	QQQ	ETF	117.45	117.45	117.4	117.41	22051.0
2016-10-14 08:00:00	QQQ	ETF	117.39	117.42	117.32	117.35	50923.0
2016-10-14 08:30:00	QQQ	ETF	117.39	117.5	117.36	117.44	46217.0
2016-10-14 09:00:00	QQQ	ETF	117.47	117.58	117.47	117.54	102259.0
2016-10-14 09:30:00	QQQ	ETF	117.54	118.05	117.54	117.9146	2686656.0
2016-10-14 10:00:00	QQQ	ETF	117.91	118.05	117.77	117.88	1027702.0
2016-10-14 10:30:00	QQQ	ETF	117.88	118.04	117.85	117.87	916537.0
2016-10-14 11:00:00	QQQ	ETF	117.87	117.9	117.5	117.5001	1334489.0
2016-10-14 11:30:00	QQQ	ETF	117.5001	117.5001	117.22	117.23	1622576.0
2016-10-14 12:00:00	QQQ	ETF	117.24	117.32	117.08	117.29	1117099.0
2016-10-14 12:30:00	QQQ	ETF	117.29	117.39	117.27	117.338	598153.0
2016-10-14 13:00:00	QQQ	ETF	117.33	117.419	117.21	117.36	545813.0

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

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