PREVIEW / etf_30min / 2017-12-22

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-12-22.parquet
  size:    435 KB
  rows:    15,128

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-12-22 04:00:00	SPY	ETF	267.8	267.87	267.8	267.87	3483.0
2017-12-22 04:30:00	SPY	ETF	267.9	267.91	267.8	267.8	850.0
2017-12-22 05:00:00	SPY	ETF	267.84	267.84	267.84	267.84	800.0
2017-12-22 05:30:00	SPY	ETF	267.84	267.84	267.74	267.74	800.0
2017-12-22 06:00:00	SPY	ETF	267.74	267.74	267.74	267.74	4700.0
2017-12-22 06:30:00	SPY	ETF	267.78	267.85	267.77	267.77	14300.0
2017-12-22 07:00:00	SPY	ETF	267.82	267.85	267.65	267.65	20257.0
2017-12-22 07:30:00	SPY	ETF	267.7	267.77	267.64	267.64	7660.0
2017-12-22 08:00:00	SPY	ETF	267.84	267.84	267.55	267.58	24666.0
2017-12-22 08:30:00	SPY	ETF	267.58	267.74	267.56	267.56	25921.0
2017-12-22 09:00:00	SPY	ETF	267.56	267.68	267.54	267.59	171092.0
2017-12-22 09:30:00	SPY	ETF	267.6	267.635	267.22	267.6	4925619.0
2017-12-22 10:00:00	SPY	ETF	267.61	267.615	267.23	267.37	3059458.0
2017-12-22 10:30:00	SPY	ETF	267.37	267.46	267.255	267.286	3349317.0
2017-12-22 11:00:00	SPY	ETF	267.28	267.3	267.0	267.15	2083602.0
2017-12-22 11:30:00	SPY	ETF	267.16	267.22	266.9	267.0845	5522585.0
2017-12-22 12:00:00	SPY	ETF	267.08	267.24	267.05	267.22	1510767.0
2017-12-22 12:30:00	SPY	ETF	267.215	267.23	267.08	267.13	951188.0
2017-12-22 13:00:00	SPY	ETF	267.135	267.5492	267.11	267.18	2148334.0
2017-12-22 13:30:00	SPY	ETF	267.185	267.39	267.165	267.355	3634937.0
2017-12-22 14:00:00	SPY	ETF	267.36	267.46	267.23	267.4	2595138.0
2017-12-22 14:30:00	SPY	ETF	267.3992	267.49	267.3	267.44	3620000.0
2017-12-22 15:00:00	SPY	ETF	267.435	267.47	267.31	267.385	1870588.0
2017-12-22 15:30:00	SPY	ETF	267.39	267.56	267.31	267.48	11531531.0
2017-12-22 16:00:00	SPY	ETF	267.48	267.52	267.1	267.2	23865219.0
2017-12-22 16:30:00	SPY	ETF	267.2	267.25	267.14	267.23	2297429.0
2017-12-22 17:00:00	SPY	ETF	267.23	267.23	267.2	267.2	5086.0
2017-12-22 17:30:00	SPY	ETF	267.18	267.45	267.18	267.36	220051.0
2017-12-22 18:00:00	SPY	ETF	267.37	267.37	267.31	267.31	1278.0
2017-12-22 18:30:00	SPY	ETF	267.36	267.38	267.36	267.38	3380.0
2017-12-22 19:00:00	SPY	ETF	267.33	267.33	267.32	267.32	2007.0
2017-12-22 19:30:00	SPY	ETF	267.32	267.35	267.27	267.35	4540.0
2017-12-22 04:00:00	QQQ	ETF	157.71	157.71	157.69	157.69	10500.0
2017-12-22 05:30:00	QQQ	ETF	157.69	157.69	157.64	157.64	4200.0
2017-12-22 06:00:00	QQQ	ETF	157.61	157.63	157.59	157.63	1600.0
2017-12-22 07:00:00	QQQ	ETF	157.67	157.67	157.57	157.57	31700.0
2017-12-22 07:30:00	QQQ	ETF	157.55	157.6	157.52	157.52	13300.0
2017-12-22 08:00:00	QQQ	ETF	157.55	157.59	157.51	157.55	14968.0
2017-12-22 08:30:00	QQQ	ETF	157.56	157.6	157.51	157.53	150276.0
2017-12-22 09:00:00	QQQ	ETF	157.51	157.56	157.26	157.31	214020.0
2017-12-22 09:30:00	QQQ	ETF	157.31	157.432	156.95	157.39	2231437.0
2017-12-22 10:00:00	QQQ	ETF	157.39	157.39	157.1	157.3	965472.0
2017-12-22 10:30:00	QQQ	ETF	157.3	157.42	157.21	157.32	817462.0
2017-12-22 11:00:00	QQQ	ETF	157.32	157.35	157.1	157.2486	1024159.0
2017-12-22 11:30:00	QQQ	ETF	157.25	157.34	157.11	157.18	974735.0
2017-12-22 12:00:00	QQQ	ETF	157.17	157.19	157.1	157.14	559941.0
2017-12-22 12:30:00	QQQ	ETF	157.15	157.16	157.06	157.13	632502.0
2017-12-22 13:00:00	QQQ	ETF	157.13	157.21	157.12	157.14	533311.0
2017-12-22 13:30:00	QQQ	ETF	157.149	157.33	157.14	157.29	1146151.0
2017-12-22 14:00:00	QQQ	ETF	157.3	157.38	157.21	157.32	749688.0

> showing 50 of 15,128 rows — these rows as CSV

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