PREVIEW / etf_30min / 2017-01-30

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-01-30.parquet
  size:    440 KB
  rows:    14,867

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-01-30 04:00:00	SPY	ETF	228.59	228.59	228.29	228.4	13404.0
2017-01-30 04:30:00	SPY	ETF	228.43	228.43	228.31	228.36	3603.0
2017-01-30 05:00:00	SPY	ETF	228.35	228.38	228.31	228.38	5391.0
2017-01-30 05:30:00	SPY	ETF	228.4	228.4	228.31	228.31	3410.0
2017-01-30 06:00:00	SPY	ETF	228.35	228.4	228.31	228.39	8251.0
2017-01-30 06:30:00	SPY	ETF	228.37	228.4	228.31	228.31	9252.0
2017-01-30 07:00:00	SPY	ETF	228.32	228.4	228.31	228.4	14486.0
2017-01-30 07:30:00	SPY	ETF	228.4	228.4	228.21	228.33	61402.0
2017-01-30 08:00:00	SPY	ETF	228.31	228.38	228.05	228.08	233126.0
2017-01-30 08:30:00	SPY	ETF	228.08	228.22	228.01	228.19	142173.0
2017-01-30 09:00:00	SPY	ETF	228.18	228.24	228.12	228.17	361698.0
2017-01-30 09:30:00	SPY	ETF	228.17	228.2	227.02	227.3	12506364.0
2017-01-30 10:00:00	SPY	ETF	227.3	227.38	226.7	226.96	7809813.0
2017-01-30 10:30:00	SPY	ETF	226.97	226.99	226.41	226.591	5135560.0
2017-01-30 11:00:00	SPY	ETF	226.6	227.05	226.53	226.78	5047552.0
2017-01-30 11:30:00	SPY	ETF	226.7799	227.17	226.75	227.115	4372441.0
2017-01-30 12:00:00	SPY	ETF	227.13	227.1739	226.92	227.051	3116363.0
2017-01-30 12:30:00	SPY	ETF	227.05	227.06	226.81	226.935	2291840.0
2017-01-30 13:00:00	SPY	ETF	226.935	227.11	226.84	226.96	2334469.0
2017-01-30 13:30:00	SPY	ETF	226.965	226.965	226.71	226.8501	2527110.0
2017-01-30 14:00:00	SPY	ETF	226.86	227.29	226.86	227.259	3902046.0
2017-01-30 14:30:00	SPY	ETF	227.26	227.38	227.14	227.31	2626179.0
2017-01-30 15:00:00	SPY	ETF	227.3	227.305	226.99	227.12	3347848.0
2017-01-30 15:30:00	SPY	ETF	227.12	227.76	227.1	227.62	11654956.0
2017-01-30 16:00:00	SPY	ETF	227.62	227.7123	227.53	227.69	7635801.0
2017-01-30 16:30:00	SPY	ETF	227.69	227.7	227.65	227.68	973552.0
2017-01-30 17:00:00	SPY	ETF	227.68	227.73	227.55	227.67	824962.0
2017-01-30 17:30:00	SPY	ETF	227.67	227.7	227.66	227.67	49506.0
2017-01-30 18:00:00	SPY	ETF	227.68	227.68	227.56	227.59	81851.0
2017-01-30 18:30:00	SPY	ETF	227.59	227.65	227.59	227.64	11895.0
2017-01-30 19:00:00	SPY	ETF	227.65	227.67	227.58	227.6	28846.0
2017-01-30 19:30:00	SPY	ETF	227.62	227.66	227.59	227.66	21422.0
2017-01-30 04:00:00	QQQ	ETF	125.45	125.45	125.41	125.44	871.0
2017-01-30 04:30:00	QQQ	ETF	125.39	125.39	125.39	125.39	300.0
2017-01-30 05:00:00	QQQ	ETF	125.38	125.38	125.38	125.38	300.0
2017-01-30 05:30:00	QQQ	ETF	125.36	125.37	125.35	125.37	3498.0
2017-01-30 06:00:00	QQQ	ETF	125.37	125.37	125.37	125.37	200.0
2017-01-30 06:30:00	QQQ	ETF	125.42	125.42	125.36	125.36	16596.0
2017-01-30 07:00:00	QQQ	ETF	125.35	125.41	125.35	125.38	16597.0
2017-01-30 07:30:00	QQQ	ETF	125.42	125.43	125.33	125.37	12890.0
2017-01-30 08:00:00	QQQ	ETF	125.37	125.42	125.21	125.28	386266.0
2017-01-30 08:30:00	QQQ	ETF	125.28	125.41	125.28	125.39	49311.0
2017-01-30 09:00:00	QQQ	ETF	125.41	125.41	125.33	125.35	162282.0
2017-01-30 09:30:00	QQQ	ETF	125.37	125.38	124.435	124.56	4680159.0
2017-01-30 10:00:00	QQQ	ETF	124.56	124.6	124.13	124.37	2898567.0
2017-01-30 10:30:00	QQQ	ETF	124.37	124.41	124.16	124.27	1349551.0
2017-01-30 11:00:00	QQQ	ETF	124.27	124.56	124.18	124.44	1356244.0
2017-01-30 11:30:00	QQQ	ETF	124.44	124.66	124.38	124.6458	1102711.0
2017-01-30 12:00:00	QQQ	ETF	124.65	124.69	124.56	124.59	778799.0
2017-01-30 12:30:00	QQQ	ETF	124.5899	124.59	124.425	124.4966	639255.0

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

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