PREVIEW / etf_30min / 2017-04-13

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-04-13.parquet
  size:    430 KB
  rows:    14,708

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-04-13 04:00:00	SPY	ETF	233.9	233.9	233.54	233.74	8953.0
2017-04-13 04:30:00	SPY	ETF	233.7	233.78	233.68	233.78	8708.0
2017-04-13 05:00:00	SPY	ETF	233.76	233.76	233.57	233.59	3353.0
2017-04-13 05:30:00	SPY	ETF	233.51	233.59	233.49	233.49	9361.0
2017-04-13 06:00:00	SPY	ETF	233.45	233.45	233.32	233.32	59430.0
2017-04-13 06:30:00	SPY	ETF	233.37	233.59	233.28	233.4	49782.0
2017-04-13 07:00:00	SPY	ETF	233.43	233.5	233.34	233.48	62440.0
2017-04-13 07:30:00	SPY	ETF	233.5	233.65	233.48	233.54	319045.0
2017-04-13 08:00:00	SPY	ETF	233.58	233.76	233.35	233.6	191484.0
2017-04-13 08:30:00	SPY	ETF	233.55	233.69	233.49	233.52	308592.0
2017-04-13 09:00:00	SPY	ETF	233.52	233.69	233.52	233.63	354459.0
2017-04-13 09:30:00	SPY	ETF	233.64	234.29	233.42	234.12	8144255.0
2017-04-13 10:00:00	SPY	ETF	234.125	234.465	234.07	234.11	4844212.0
2017-04-13 10:30:00	SPY	ETF	234.1	234.42	234.05	234.29	2681581.0
2017-04-13 11:00:00	SPY	ETF	234.29	234.49	234.15	234.285	2903116.0
2017-04-13 11:30:00	SPY	ETF	234.285	234.39	234.22	234.285	3421471.0
2017-04-13 12:00:00	SPY	ETF	234.28	234.28	233.66	233.81	4248059.0
2017-04-13 12:30:00	SPY	ETF	233.81	233.885	233.45	233.58	4044328.0
2017-04-13 13:00:00	SPY	ETF	233.58	233.6	233.14	233.43	5143888.0
2017-04-13 13:30:00	SPY	ETF	233.44	234.03	233.02	233.11	5894132.0
2017-04-13 14:00:00	SPY	ETF	233.11	233.61	233.06	233.5	4843236.0
2017-04-13 14:30:00	SPY	ETF	233.5	233.63	233.31	233.48	2681863.0
2017-04-13 15:00:00	SPY	ETF	233.48	233.56	232.97	233.08	4385998.0
2017-04-13 15:30:00	SPY	ETF	233.0805	233.18	232.54	232.54	17617613.0
2017-04-13 16:00:00	SPY	ETF	232.54	232.74	232.39	232.67	16308889.0
2017-04-13 16:30:00	SPY	ETF	232.68	232.77	232.51	232.74	1039180.0
2017-04-13 17:00:00	SPY	ETF	232.71	232.73	232.51	232.52	1726184.0
2017-04-13 17:30:00	SPY	ETF	232.51	232.51	232.36	232.42	154729.0
2017-04-13 18:00:00	SPY	ETF	232.43	232.45	232.29	232.4	103301.0
2017-04-13 18:30:00	SPY	ETF	232.39	232.49	232.39	232.43	43319.0
2017-04-13 19:00:00	SPY	ETF	232.44	232.5486	232.4	232.5486	1108995.0
2017-04-13 19:30:00	SPY	ETF	232.41	232.45	232.39	232.42	37467.0
2017-04-13 04:00:00	QQQ	ETF	130.71	130.71	130.71	130.71	400.0
2017-04-13 04:30:00	QQQ	ETF	130.69	130.69	130.69	130.69	100.0
2017-04-13 05:00:00	QQQ	ETF	130.66	130.66	130.63	130.63	212.0
2017-04-13 06:00:00	QQQ	ETF	130.5	130.5	130.49	130.49	450.0
2017-04-13 06:30:00	QQQ	ETF	130.5	130.52	130.5	130.52	1800.0
2017-04-13 07:00:00	QQQ	ETF	130.52	130.55	130.5	130.55	13625.0
2017-04-13 07:30:00	QQQ	ETF	130.58	130.63	130.57	130.6	46202.0
2017-04-13 08:00:00	QQQ	ETF	130.6	130.72	130.59	130.66	19840.0
2017-04-13 08:30:00	QQQ	ETF	130.61	130.71	130.61	130.68	30700.0
2017-04-13 09:00:00	QQQ	ETF	130.67	130.75	130.64	130.75	113295.0
2017-04-13 09:30:00	QQQ	ETF	130.75	131.3	130.68	131.18	2746887.0
2017-04-13 10:00:00	QQQ	ETF	131.19	131.44	131.18	131.28	1430302.0
2017-04-13 10:30:00	QQQ	ETF	131.26	131.48	131.26	131.42	826799.0
2017-04-13 11:00:00	QQQ	ETF	131.43	131.51	131.29	131.37	630361.0
2017-04-13 11:30:00	QQQ	ETF	131.37	131.43	131.31	131.34	440435.0
2017-04-13 12:00:00	QQQ	ETF	131.34	131.34	131.06	131.13	1342910.0
2017-04-13 12:30:00	QQQ	ETF	131.13	131.1678	130.94	130.99	1105271.0
2017-04-13 13:00:00	QQQ	ETF	131.0	131.0	130.69	130.88	1268827.0

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

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