PREVIEW / etf_30min / 2016-08-29

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-08-29.parquet
  size:    385 KB
  rows:    13,057

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-08-29 04:30:00	SPY	ETF	217.16	217.2	217.16	217.19	3446.0
2016-08-29 05:00:00	SPY	ETF	217.13	217.16	217.11	217.11	606.0
2016-08-29 05:30:00	SPY	ETF	217.08	217.23	217.0	217.21	4739.0
2016-08-29 06:00:00	SPY	ETF	217.21	217.26	217.21	217.23	2110.0
2016-08-29 06:30:00	SPY	ETF	217.24	217.32	217.24	217.32	904.0
2016-08-29 07:00:00	SPY	ETF	217.34	217.38	217.31	217.35	9683.0
2016-08-29 07:30:00	SPY	ETF	217.3	217.37	217.3	217.34	19951.0
2016-08-29 08:00:00	SPY	ETF	217.34	217.47	217.227	217.47	105968.0
2016-08-29 08:30:00	SPY	ETF	217.48	217.63	217.41	217.54	331107.0
2016-08-29 09:00:00	SPY	ETF	217.54	217.56	217.42	217.44	177544.0
2016-08-29 09:30:00	SPY	ETF	217.44	218.18	217.4	218.05	8392687.0
2016-08-29 10:00:00	SPY	ETF	218.05	218.24	218.02	218.11	6498366.0
2016-08-29 10:30:00	SPY	ETF	218.115	218.29	217.987	218.16	5491364.0
2016-08-29 11:00:00	SPY	ETF	218.1599	218.3	218.12	218.27	3837761.0
2016-08-29 11:30:00	SPY	ETF	218.27	218.57	218.18	218.4899	3895690.0
2016-08-29 12:00:00	SPY	ETF	218.49	218.6	218.3601	218.42	2228453.0
2016-08-29 12:30:00	SPY	ETF	218.42	218.58	218.38	218.5536	1961720.0
2016-08-29 13:00:00	SPY	ETF	218.555	218.59	218.49	218.56	1918343.0
2016-08-29 13:30:00	SPY	ETF	218.57	218.665	218.53	218.61	2213617.0
2016-08-29 14:00:00	SPY	ETF	218.61	218.65	218.38	218.42	2947028.0
2016-08-29 14:30:00	SPY	ETF	218.42	218.47	218.3489	218.45	2490617.0
2016-08-29 15:00:00	SPY	ETF	218.45	218.53	218.28	218.33	6208127.0
2016-08-29 15:30:00	SPY	ETF	218.33	218.42	218.265	218.36	11810086.0
2016-08-29 16:00:00	SPY	ETF	218.37	218.43	218.26	218.39	7994144.0
2016-08-29 16:30:00	SPY	ETF	218.4	218.46	218.34	218.45	76530.0
2016-08-29 17:00:00	SPY	ETF	218.44	218.44	218.39	218.39	13403.0
2016-08-29 17:30:00	SPY	ETF	218.42	218.42	218.4	218.42	22640.0
2016-08-29 18:00:00	SPY	ETF	218.41	218.46	218.39	218.46	19027.0
2016-08-29 18:30:00	SPY	ETF	218.46	218.47	218.45	218.47	6039.0
2016-08-29 19:00:00	SPY	ETF	218.47	218.53	218.47	218.47	8697.0
2016-08-29 19:30:00	SPY	ETF	218.49	218.49	218.46	218.48	17615.0
2016-08-29 04:00:00	QQQ	ETF	116.53	116.53	116.53	116.53	300.0
2016-08-29 06:00:00	QQQ	ETF	116.73	116.73	116.73	116.73	394.0
2016-08-29 06:30:00	QQQ	ETF	116.73	116.74	116.73	116.74	200.0
2016-08-29 07:00:00	QQQ	ETF	116.76	116.79	116.75	116.78	7600.0
2016-08-29 07:30:00	QQQ	ETF	116.77	116.77	116.74	116.74	5097.0
2016-08-29 08:00:00	QQQ	ETF	116.77	116.81	116.75	116.81	9051.0
2016-08-29 08:30:00	QQQ	ETF	116.84	116.89	116.8	116.89	7227.0
2016-08-29 09:00:00	QQQ	ETF	116.88	116.88	116.83	116.84	12806.0
2016-08-29 09:30:00	QQQ	ETF	116.81	117.1	116.79	117.01	2016795.0
2016-08-29 10:00:00	QQQ	ETF	117.01	117.07	116.89	116.93	865891.0
2016-08-29 10:30:00	QQQ	ETF	116.93	117.02	116.83	116.9	542005.0
2016-08-29 11:00:00	QQQ	ETF	116.9	116.97	116.86	116.95	364055.0
2016-08-29 11:30:00	QQQ	ETF	116.96	117.19	116.89	117.15	682478.0
2016-08-29 12:00:00	QQQ	ETF	117.1411	117.21	117.1001	117.11	349438.0
2016-08-29 12:30:00	QQQ	ETF	117.12	117.24	117.0961	117.24	266468.0
2016-08-29 13:00:00	QQQ	ETF	117.24	117.251	117.16	117.18	394651.0
2016-08-29 13:30:00	QQQ	ETF	117.18	117.235	117.16	117.2	617184.0
2016-08-29 14:00:00	QQQ	ETF	117.195	117.23	117.0804	117.09	326828.0
2016-08-29 14:30:00	QQQ	ETF	117.09	117.12	117.03	117.1	566059.0

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

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