PREVIEW / etf_30min / 2016-06-20

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-06-20.parquet
  size:    392 KB
  rows:    13,453

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
2016-06-20 04:00:00	SPY	ETF	208.4	208.81	208.4	208.8	15367.0
2016-06-20 04:30:00	SPY	ETF	208.8	209.0	208.57	209.0	21239.0
2016-06-20 05:00:00	SPY	ETF	208.96	209.07	208.8	208.9	13443.0
2016-06-20 05:30:00	SPY	ETF	208.87	208.95	208.74	208.91	17776.0
2016-06-20 06:00:00	SPY	ETF	208.89	209.08	208.86	208.96	60656.0
2016-06-20 06:30:00	SPY	ETF	209.0	209.06	208.96	209.02	23742.0
2016-06-20 07:00:00	SPY	ETF	209.02	209.06	208.93	209.02	113507.0
2016-06-20 07:30:00	SPY	ETF	209.04	209.13	208.95	209.03	362443.0
2016-06-20 08:00:00	SPY	ETF	208.86	209.05	208.66	208.87	587986.0
2016-06-20 08:30:00	SPY	ETF	208.83	209.0	208.83	208.87	353705.0
2016-06-20 09:00:00	SPY	ETF	208.87	208.99	208.66	208.81	566032.0
2016-06-20 09:30:00	SPY	ETF	208.82	209.36	208.81	209.12	13287158.0
2016-06-20 10:00:00	SPY	ETF	209.12	209.61	209.1	209.3265	6195265.0
2016-06-20 10:30:00	SPY	ETF	209.32	209.34	209.05	209.18	4069737.0
2016-06-20 11:00:00	SPY	ETF	209.18	209.33	209.1	209.16	5008426.0
2016-06-20 11:30:00	SPY	ETF	209.175	209.2297	208.73	208.95	4786099.0
2016-06-20 12:00:00	SPY	ETF	208.945	208.95	208.75	208.8508	3060170.0
2016-06-20 12:30:00	SPY	ETF	208.85	209.06	208.75	208.9501	2757825.0
2016-06-20 13:00:00	SPY	ETF	208.95	209.02	208.55	208.6399	4363771.0
2016-06-20 13:30:00	SPY	ETF	208.64	208.91	208.6	208.84	3204205.0
2016-06-20 14:00:00	SPY	ETF	208.835	208.86	208.44	208.52	3928845.0
2016-06-20 14:30:00	SPY	ETF	208.52	208.83	208.45	208.795	3557510.0
2016-06-20 15:00:00	SPY	ETF	208.79	208.83	208.19	208.205	4779133.0
2016-06-20 15:30:00	SPY	ETF	208.2	208.41	207.75	207.86	13173975.0
2016-06-20 16:00:00	SPY	ETF	207.86	207.91	207.5	207.79	3708638.0
2016-06-20 16:30:00	SPY	ETF	207.79	208.68	207.78	208.63	644157.0
2016-06-20 17:00:00	SPY	ETF	208.62	208.62	208.06	208.16	564651.0
2016-06-20 17:30:00	SPY	ETF	208.18	208.21	208.11	208.2	88394.0
2016-06-20 18:00:00	SPY	ETF	208.19	208.3	208.07	208.16	1097119.0
2016-06-20 18:30:00	SPY	ETF	208.15	208.28	208.14	208.26	27462.0
2016-06-20 19:00:00	SPY	ETF	208.28	208.3	208.2	208.27	15860.0
2016-06-20 19:30:00	SPY	ETF	208.21	208.21	208.09	208.15	42355.0
2016-06-20 04:00:00	QQQ	ETF	107.42	107.66	107.42	107.66	1182.0
2016-06-20 04:30:00	QQQ	ETF	107.75	107.75	107.75	107.75	400.0
2016-06-20 05:00:00	QQQ	ETF	107.79	107.79	107.79	107.79	385.0
2016-06-20 05:30:00	QQQ	ETF	107.66	107.66	107.65	107.65	674.0
2016-06-20 06:00:00	QQQ	ETF	107.72	107.79	107.72	107.79	2701.0
2016-06-20 06:30:00	QQQ	ETF	107.77	107.77	107.77	107.77	800.0
2016-06-20 07:00:00	QQQ	ETF	107.77	107.79	107.75	107.77	24927.0
2016-06-20 07:30:00	QQQ	ETF	107.79	107.87	107.78	107.81	23477.0
2016-06-20 08:00:00	QQQ	ETF	107.8	107.81	107.74	107.74	80779.0
2016-06-20 08:30:00	QQQ	ETF	107.73	107.8	107.73	107.76	63319.0
2016-06-20 09:00:00	QQQ	ETF	107.76	107.79	107.69	107.75	250907.0
2016-06-20 09:30:00	QQQ	ETF	107.76	107.98	107.72	107.925	4920340.0
2016-06-20 10:00:00	QQQ	ETF	107.93	108.22	107.925	108.09	1956966.0
2016-06-20 10:30:00	QQQ	ETF	108.08	108.21	108.06	108.17	925202.0
2016-06-20 11:00:00	QQQ	ETF	108.17	108.24	108.13	108.19	884317.0
2016-06-20 11:30:00	QQQ	ETF	108.18	108.21	107.86	107.97	961839.0
2016-06-20 12:00:00	QQQ	ETF	107.97	107.98	107.85	107.98	553976.0
2016-06-20 12:30:00	QQQ	ETF	107.97	108.06	107.9	107.9901	460568.0

> showing 50 of 13,453 rows — these rows as CSV

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