PREVIEW / etf_30min / 2016-06-01

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-06-01.parquet
  size:    390 KB
  rows:    13,243

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-01 04:00:00	SPY	ETF	210.09	210.09	209.86	209.86	1002.0
2016-06-01 04:30:00	SPY	ETF	209.81	209.81	209.55	209.55	704.0
2016-06-01 05:00:00	SPY	ETF	209.53	210.37	209.45	209.47	89593.0
2016-06-01 05:30:00	SPY	ETF	209.41	209.59	209.41	209.59	6778.0
2016-06-01 06:00:00	SPY	ETF	209.46	209.47	209.33	209.38	68131.0
2016-06-01 06:30:00	SPY	ETF	209.34	209.45	209.34	209.41	17620.0
2016-06-01 07:00:00	SPY	ETF	209.47	209.47	209.24	209.34	109484.0
2016-06-01 07:30:00	SPY	ETF	209.33	209.47	209.33	209.39	49446.0
2016-06-01 08:00:00	SPY	ETF	209.3	209.84	209.25	209.41	275598.0
2016-06-01 08:30:00	SPY	ETF	209.41	210.08	209.25	209.28	224303.0
2016-06-01 09:00:00	SPY	ETF	209.28	209.29	209.0	209.14	667487.0
2016-06-01 09:30:00	SPY	ETF	209.12	209.24	208.89	209.09	7757806.0
2016-06-01 10:00:00	SPY	ETF	209.1	209.68	208.97	209.36	7523624.0
2016-06-01 10:30:00	SPY	ETF	209.36	209.77	209.3	209.68	5543867.0
2016-06-01 11:00:00	SPY	ETF	209.68	210.05	209.68	209.7999	6243174.0
2016-06-01 11:30:00	SPY	ETF	209.79	209.87	209.61	209.78	3666466.0
2016-06-01 12:00:00	SPY	ETF	209.78	210.09	209.76	209.96	2867144.0
2016-06-01 12:30:00	SPY	ETF	209.96	210.14	209.802	210.13	2626254.0
2016-06-01 13:00:00	SPY	ETF	210.13	210.19	209.94	209.98	2108574.0
2016-06-01 13:30:00	SPY	ETF	209.97	210.03	209.69	209.955	2600102.0
2016-06-01 14:00:00	SPY	ETF	209.955	210.34	209.75	210.227	3878867.0
2016-06-01 14:30:00	SPY	ETF	210.22	210.34	209.98	210.335	4066258.0
2016-06-01 15:00:00	SPY	ETF	210.35	210.48	210.19	210.405	4303584.0
2016-06-01 15:30:00	SPY	ETF	210.4	210.46	210.14	210.27	9343005.0
2016-06-01 16:00:00	SPY	ETF	210.26	210.4	210.1767	210.31	3549004.0
2016-06-01 16:30:00	SPY	ETF	210.34	210.34	210.24	210.28	364587.0
2016-06-01 17:00:00	SPY	ETF	210.27	210.32	210.27	210.28	32040.0
2016-06-01 17:30:00	SPY	ETF	210.3	210.32	210.26	210.26	46449.0
2016-06-01 18:00:00	SPY	ETF	210.25	210.32	210.24	210.3	82829.0
2016-06-01 18:30:00	SPY	ETF	210.32	210.34	210.31	210.33	13428.0
2016-06-01 19:00:00	SPY	ETF	210.33	210.37	210.31	210.35	14649.0
2016-06-01 19:30:00	SPY	ETF	210.35	210.37	210.34	210.35	38786.0
2016-06-01 04:30:00	QQQ	ETF	110.3	110.3	110.3	110.3	400.0
2016-06-01 05:30:00	QQQ	ETF	110.18	110.18	110.18	110.18	498.0
2016-06-01 06:00:00	QQQ	ETF	110.16	110.16	110.15	110.15	2390.0
2016-06-01 06:30:00	QQQ	ETF	110.12	110.2	110.12	110.18	1800.0
2016-06-01 07:00:00	QQQ	ETF	110.19	110.19	110.04	110.07	10871.0
2016-06-01 07:30:00	QQQ	ETF	110.1	110.15	110.1	110.13	9249.0
2016-06-01 08:00:00	QQQ	ETF	110.11	110.18	110.04	110.16	29879.0
2016-06-01 08:30:00	QQQ	ETF	110.17	110.2	110.08	110.08	63786.0
2016-06-01 09:00:00	QQQ	ETF	110.1	110.1	109.98	110.03	94601.0
2016-06-01 09:30:00	QQQ	ETF	110.0	110.11	109.93	109.999	1659462.0
2016-06-01 10:00:00	QQQ	ETF	109.995	110.41	109.91	110.26	2134657.0
2016-06-01 10:30:00	QQQ	ETF	110.2501	110.49	110.2	110.44	1472632.0
2016-06-01 11:00:00	QQQ	ETF	110.44	110.59	110.355	110.36	1285028.0
2016-06-01 11:30:00	QQQ	ETF	110.35	110.42	110.21	110.39	829631.0
2016-06-01 12:00:00	QQQ	ETF	110.4	110.54	110.39	110.43	629962.0
2016-06-01 12:30:00	QQQ	ETF	110.43	110.55	110.33	110.5468	515105.0
2016-06-01 13:00:00	QQQ	ETF	110.55	110.56	110.41	110.44	465823.0
2016-06-01 13:30:00	QQQ	ETF	110.44	110.47	110.23	110.34	466414.0

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

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