PREVIEW / etf_30min / 2016-12-30

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-12-30.parquet
  size:    436 KB
  rows:    14,878

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-12-30 04:00:00	SPY	ETF	224.71	224.9	224.71	224.9	1450.0
2016-12-30 04:30:00	SPY	ETF	224.94	224.94	224.94	224.94	300.0
2016-12-30 05:00:00	SPY	ETF	224.94	224.94	224.84	224.84	10752.0
2016-12-30 05:30:00	SPY	ETF	224.84	224.97	224.84	224.97	35311.0
2016-12-30 06:00:00	SPY	ETF	224.87	224.91	224.76	224.91	37520.0
2016-12-30 06:30:00	SPY	ETF	224.91	224.92	224.81	224.92	13461.0
2016-12-30 07:00:00	SPY	ETF	224.87	224.87	224.71	224.83	40058.0
2016-12-30 07:30:00	SPY	ETF	224.83	225.05	224.83	225.01	158274.0
2016-12-30 08:00:00	SPY	ETF	224.99	225.02	224.71	224.95	128609.0
2016-12-30 08:30:00	SPY	ETF	224.95	225.04	224.87	224.91	105587.0
2016-12-30 09:00:00	SPY	ETF	224.85	224.91	224.7	224.73	320041.0
2016-12-30 09:30:00	SPY	ETF	224.73	224.83	223.735	223.79	7862285.0
2016-12-30 10:00:00	SPY	ETF	223.77	224.0145	223.58	223.62	4203815.0
2016-12-30 10:30:00	SPY	ETF	223.61	223.91	223.6	223.9	3984099.0
2016-12-30 11:00:00	SPY	ETF	223.89	224.06	223.735	223.9527	2864560.0
2016-12-30 11:30:00	SPY	ETF	223.96	224.18	223.92	223.98	2622117.0
2016-12-30 12:00:00	SPY	ETF	223.98	224.0	223.72	223.78	3030306.0
2016-12-30 12:30:00	SPY	ETF	223.785	223.88	223.41	223.54	3624565.0
2016-12-30 13:00:00	SPY	ETF	223.54	223.78	223.48	223.67	2520603.0
2016-12-30 13:30:00	SPY	ETF	223.67	223.75	223.4	223.4375	3339248.0
2016-12-30 14:00:00	SPY	ETF	223.43	223.4707	223.16	223.16	5636956.0
2016-12-30 14:30:00	SPY	ETF	223.17	223.33	222.73	222.9	6758808.0
2016-12-30 15:00:00	SPY	ETF	222.9	223.37	222.81	223.35	8413134.0
2016-12-30 15:30:00	SPY	ETF	223.36	223.56	222.85	223.55	28541988.0
2016-12-30 16:00:00	SPY	ETF	223.56	223.56	223.18	223.28	21318722.0
2016-12-30 16:30:00	SPY	ETF	223.3	223.53	223.22	223.25	425680.0
2016-12-30 17:00:00	SPY	ETF	223.25	223.35	223.24	223.28	52065.0
2016-12-30 17:30:00	SPY	ETF	223.32	223.35	223.27	223.35	21952.0
2016-12-30 18:00:00	SPY	ETF	223.29	223.42	223.26	223.26	40906.0
2016-12-30 18:30:00	SPY	ETF	223.3	223.32	223.28	223.3	1851.0
2016-12-30 19:00:00	SPY	ETF	223.32	223.53	223.32	223.32	233911.0
2016-12-30 19:30:00	SPY	ETF	223.32	223.42	223.3	223.42	8192.0
2016-12-30 04:00:00	QQQ	ETF	119.96	120.03	119.96	120.02	3889.0
2016-12-30 05:00:00	QQQ	ETF	120.02	120.02	120.0	120.0	1000.0
2016-12-30 05:30:00	QQQ	ETF	120.0	120.0	120.0	120.0	400.0
2016-12-30 06:00:00	QQQ	ETF	119.99	119.99	119.96	119.96	15053.0
2016-12-30 07:00:00	QQQ	ETF	120.0	120.0	119.92	119.95	5899.0
2016-12-30 07:30:00	QQQ	ETF	119.96	120.02	119.96	120.02	4100.0
2016-12-30 08:00:00	QQQ	ETF	120.05	120.09	119.98	120.01	100687.0
2016-12-30 08:30:00	QQQ	ETF	120.0	120.05	119.96	119.96	4438.0
2016-12-30 09:00:00	QQQ	ETF	119.96	119.96	119.91	119.92	74623.0
2016-12-30 09:30:00	QQQ	ETF	119.93	119.95	118.86	118.89	3118136.0
2016-12-30 10:00:00	QQQ	ETF	118.85	118.99	118.64	118.71	2724313.0
2016-12-30 10:30:00	QQQ	ETF	118.69	118.9	118.68	118.88	1622848.0
2016-12-30 11:00:00	QQQ	ETF	118.87	118.98	118.71	118.88	1041149.0
2016-12-30 11:30:00	QQQ	ETF	118.867	118.95	118.8147	118.82	887858.0
2016-12-30 12:00:00	QQQ	ETF	118.82	118.83	118.56	118.7	1209019.0
2016-12-30 12:30:00	QQQ	ETF	118.7	118.76	118.35	118.52	2498086.0
2016-12-30 13:00:00	QQQ	ETF	118.519	118.62	118.39	118.555	1128431.0
2016-12-30 13:30:00	QQQ	ETF	118.555	118.5967	118.34	118.37	997246.0

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

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