PREVIEW / etf_30min / 2017-07-14

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-07-14.parquet
  size:    428 KB
  rows:    14,912

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-07-14 04:00:00	SPY	ETF	244.31	244.31	244.2	244.2	256.0
2017-07-14 04:30:00	SPY	ETF	244.17	244.2	244.17	244.2	4500.0
2017-07-14 05:00:00	SPY	ETF	244.16	244.19	244.16	244.19	1200.0
2017-07-14 05:30:00	SPY	ETF	244.14	244.14	244.13	244.13	305.0
2017-07-14 06:00:00	SPY	ETF	244.21	244.21	244.2	244.2	640.0
2017-07-14 06:30:00	SPY	ETF	244.22	244.35	244.22	244.33	14131.0
2017-07-14 07:00:00	SPY	ETF	244.35	244.35	244.3	244.3	33735.0
2017-07-14 07:30:00	SPY	ETF	244.3	244.37	244.3	244.37	17190.0
2017-07-14 08:00:00	SPY	ETF	244.35	244.39	244.26	244.39	139434.0
2017-07-14 08:30:00	SPY	ETF	244.39	244.76	244.39	244.76	540842.0
2017-07-14 09:00:00	SPY	ETF	244.72	244.76	244.42	244.43	957752.0
2017-07-14 09:30:00	SPY	ETF	244.43	244.87	244.31	244.72	4595237.0
2017-07-14 10:00:00	SPY	ETF	244.725	244.8	244.58	244.735	2238257.0
2017-07-14 10:30:00	SPY	ETF	244.74	244.89	244.7	244.84	1624207.0
2017-07-14 11:00:00	SPY	ETF	244.84	244.9	244.665	244.79	2519731.0
2017-07-14 11:30:00	SPY	ETF	244.78	244.9	244.78	244.875	1526537.0
2017-07-14 12:00:00	SPY	ETF	244.875	244.98	244.8	244.96	1637090.0
2017-07-14 12:30:00	SPY	ETF	244.96	245.29	244.96	245.195	2703119.0
2017-07-14 13:00:00	SPY	ETF	245.19	245.43	245.16	245.4	2381816.0
2017-07-14 13:30:00	SPY	ETF	245.4	245.52	245.315	245.495	2896920.0
2017-07-14 14:00:00	SPY	ETF	245.5	245.655	245.475	245.61	2604103.0
2017-07-14 14:30:00	SPY	ETF	245.6	245.61	245.51	245.515	1669449.0
2017-07-14 15:00:00	SPY	ETF	245.52	245.85	245.51	245.82	4821753.0
2017-07-14 15:30:00	SPY	ETF	245.82	245.97	245.4	245.54	14522467.0
2017-07-14 16:00:00	SPY	ETF	245.53	245.56	245.4	245.51	9956254.0
2017-07-14 16:30:00	SPY	ETF	245.51	245.63	245.49	245.61	1324892.0
2017-07-14 17:00:00	SPY	ETF	245.57	245.64	245.56	245.6	28777.0
2017-07-14 17:30:00	SPY	ETF	245.57	245.57	245.52	245.57	16962.0
2017-07-14 18:00:00	SPY	ETF	245.55	245.55	245.52	245.55	11037.0
2017-07-14 18:30:00	SPY	ETF	245.52	245.59	245.51	245.59	5860.0
2017-07-14 19:00:00	SPY	ETF	245.55	245.61	245.55	245.61	12730.0
2017-07-14 19:30:00	SPY	ETF	245.6	245.64	245.5284	245.6	1085578.0
2017-07-14 04:00:00	QQQ	ETF	141.02	141.02	140.96	140.98	13598.0
2017-07-14 04:30:00	QQQ	ETF	141.02	141.02	141.02	141.02	240.0
2017-07-14 05:00:00	QQQ	ETF	140.96	141.0	140.95	141.0	2300.0
2017-07-14 05:30:00	QQQ	ETF	141.01	141.01	140.93	140.93	600.0
2017-07-14 06:30:00	QQQ	ETF	141.06	141.08	141.06	141.08	5968.0
2017-07-14 07:00:00	QQQ	ETF	141.08	141.08	141.04	141.05	5498.0
2017-07-14 07:30:00	QQQ	ETF	141.1	141.17	141.1	141.16	14938.0
2017-07-14 08:00:00	QQQ	ETF	141.16	141.22	141.07	141.22	32827.0
2017-07-14 08:30:00	QQQ	ETF	141.25	141.76	141.25	141.76	674142.0
2017-07-14 09:00:00	QQQ	ETF	141.77	141.88	141.58	141.58	1407494.0
2017-07-14 09:30:00	QQQ	ETF	141.58	141.7	141.38	141.4	3808992.0
2017-07-14 10:00:00	QQQ	ETF	141.395	141.5159	141.19	141.37	2268160.0
2017-07-14 10:30:00	QQQ	ETF	141.3799	141.52	141.26	141.48	1631079.0
2017-07-14 11:00:00	QQQ	ETF	141.48	141.61	141.375	141.59	1842922.0
2017-07-14 11:30:00	QQQ	ETF	141.59	141.59	141.5	141.58	402628.0
2017-07-14 12:00:00	QQQ	ETF	141.58	141.71	141.535	141.7	644635.0
2017-07-14 12:30:00	QQQ	ETF	141.7	141.8674	141.66	141.8	1489972.0
2017-07-14 13:00:00	QQQ	ETF	141.8	141.88	141.76	141.88	1211341.0

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

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