PREVIEW / etf_30min / 2017-03-28

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-03-28.parquet
  size:    433 KB
  rows:    14,626

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-03-28 04:00:00	SPY	ETF	233.78	233.85	233.78	233.84	3286.0
2017-03-28 04:30:00	SPY	ETF	233.89	233.91	233.89	233.9	1000.0
2017-03-28 05:00:00	SPY	ETF	233.9	233.9	233.87	233.87	200.0
2017-03-28 05:30:00	SPY	ETF	233.92	233.92	233.92	233.92	300.0
2017-03-28 06:00:00	SPY	ETF	233.88	233.88	233.87	233.87	400.0
2017-03-28 06:30:00	SPY	ETF	233.8	233.8	233.78	233.79	1033.0
2017-03-28 07:00:00	SPY	ETF	233.76	233.76	233.54	233.54	25969.0
2017-03-28 07:30:00	SPY	ETF	233.58	233.58	233.3	233.42	133353.0
2017-03-28 08:00:00	SPY	ETF	233.42	233.76	233.26	233.31	228949.0
2017-03-28 08:30:00	SPY	ETF	233.3	233.35	233.24	233.32	152280.0
2017-03-28 09:00:00	SPY	ETF	233.32	233.45	233.25	233.25	212477.0
2017-03-28 09:30:00	SPY	ETF	233.27	233.76	233.14	233.3	7088866.0
2017-03-28 10:00:00	SPY	ETF	233.3	234.03	233.29	233.6	7890795.0
2017-03-28 10:30:00	SPY	ETF	233.6	234.03	233.49	233.985	5049481.0
2017-03-28 11:00:00	SPY	ETF	233.995	234.62	233.97	234.46	7406390.0
2017-03-28 11:30:00	SPY	ETF	234.47	234.91	234.38	234.75	3999101.0
2017-03-28 12:00:00	SPY	ETF	234.75	234.96	234.7	234.73	2940065.0
2017-03-28 12:30:00	SPY	ETF	234.74	234.82	234.62	234.805	2035643.0
2017-03-28 13:00:00	SPY	ETF	234.81	235.08	234.8	235.03	2750703.0
2017-03-28 13:30:00	SPY	ETF	235.03	235.5	234.92	235.4787	4227693.0
2017-03-28 14:00:00	SPY	ETF	235.48	235.75	235.35	235.66	6902785.0
2017-03-28 14:30:00	SPY	ETF	235.66	235.81	235.44	235.46	4996806.0
2017-03-28 15:00:00	SPY	ETF	235.455	235.66	235.33	235.54	4997973.0
2017-03-28 15:30:00	SPY	ETF	235.545	235.65	235.23	235.27	15659116.0
2017-03-28 16:00:00	SPY	ETF	235.27	235.45	234.9	235.0	8272608.0
2017-03-28 16:30:00	SPY	ETF	234.97	235.05	233.5702	235.0	6205897.0
2017-03-28 17:00:00	SPY	ETF	235.0	235.05	234.95	235.02	59746.0
2017-03-28 17:30:00	SPY	ETF	235.04	235.06	235.02	235.05	18958.0
2017-03-28 18:00:00	SPY	ETF	235.06	235.1	234.98	235.1	48055.0
2017-03-28 18:30:00	SPY	ETF	235.07	235.11	235.07	235.09	11522.0
2017-03-28 19:00:00	SPY	ETF	235.09	235.1	235.07	235.09	8895.0
2017-03-28 19:30:00	SPY	ETF	235.09	235.13	235.02	235.12	26425.0
2017-03-28 04:00:00	QQQ	ETF	131.04	131.07	131.04	131.04	410.0
2017-03-28 04:30:00	QQQ	ETF	131.13	131.13	131.11	131.11	1000.0
2017-03-28 05:00:00	QQQ	ETF	131.09	131.1	131.07	131.09	16700.0
2017-03-28 05:30:00	QQQ	ETF	131.1	131.14	131.1	131.14	15600.0
2017-03-28 06:00:00	QQQ	ETF	131.11	131.11	131.06	131.06	2100.0
2017-03-28 06:30:00	QQQ	ETF	131.08	131.09	131.08	131.09	600.0
2017-03-28 07:00:00	QQQ	ETF	131.06	131.06	130.97	130.97	7498.0
2017-03-28 07:30:00	QQQ	ETF	130.97	130.97	130.85	130.87	8349.0
2017-03-28 08:00:00	QQQ	ETF	130.87	130.87	130.76	130.76	9236.0
2017-03-28 08:30:00	QQQ	ETF	130.78	130.79	130.73	130.77	14452.0
2017-03-28 09:00:00	QQQ	ETF	130.78	130.88	130.78	130.84	47050.0
2017-03-28 09:30:00	QQQ	ETF	130.81	131.07	130.55	130.67	1729768.0
2017-03-28 10:00:00	QQQ	ETF	130.6707	131.045	130.59	130.7	1863491.0
2017-03-28 10:30:00	QQQ	ETF	130.7	130.895	130.66	130.86	1050107.0
2017-03-28 11:00:00	QQQ	ETF	130.85	131.23	130.845	131.13	1203642.0
2017-03-28 11:30:00	QQQ	ETF	131.13	131.38	131.09	131.3	1161931.0
2017-03-28 12:00:00	QQQ	ETF	131.29	131.45	131.29	131.3372	751135.0
2017-03-28 12:30:00	QQQ	ETF	131.35	131.42	131.29	131.41	349546.0

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

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