PREVIEW / etf_30min / 2017-09-22

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-09-22.parquet
  size:    421 KB
  rows:    14,530

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-09-22 04:00:00	SPY	ETF	249.22	249.22	249.08	249.1	5058.0
2017-09-22 04:30:00	SPY	ETF	249.14	249.3	249.14	249.24	3700.0
2017-09-22 05:00:00	SPY	ETF	249.21	249.21	249.21	249.21	200.0
2017-09-22 06:00:00	SPY	ETF	249.32	249.38	249.31	249.36	9100.0
2017-09-22 06:30:00	SPY	ETF	249.37	249.41	249.37	249.38	9100.0
2017-09-22 07:00:00	SPY	ETF	249.41	249.41	249.26	249.28	41672.0
2017-09-22 07:30:00	SPY	ETF	249.3	249.3	249.13	249.13	72627.0
2017-09-22 08:00:00	SPY	ETF	249.12	249.42	249.05	249.11	117596.0
2017-09-22 08:30:00	SPY	ETF	249.11	249.15	249.03	249.03	95901.0
2017-09-22 09:00:00	SPY	ETF	249.03	249.07	248.97	249.03	841810.0
2017-09-22 09:30:00	SPY	ETF	249.05	249.31	249.02	249.14	4142332.0
2017-09-22 10:00:00	SPY	ETF	249.15	249.4	249.15	249.34	2978113.0
2017-09-22 10:30:00	SPY	ETF	249.34	249.42	249.09	249.1189	1714948.0
2017-09-22 11:00:00	SPY	ETF	249.115	249.215	249.05	249.08	1568732.0
2017-09-22 11:30:00	SPY	ETF	249.09	249.3	249.06	249.28	1536261.0
2017-09-22 12:00:00	SPY	ETF	249.29	249.36	249.19	249.21	1098542.0
2017-09-22 12:30:00	SPY	ETF	249.2	249.27	249.14	249.14	2588705.0
2017-09-22 13:00:00	SPY	ETF	249.14	249.21	249.04	249.11	2707022.0
2017-09-22 13:30:00	SPY	ETF	249.11	249.26	249.09	249.23	1152074.0
2017-09-22 14:00:00	SPY	ETF	249.2275	249.25	249.14	249.205	1243961.0
2017-09-22 14:30:00	SPY	ETF	249.21	249.29	249.2	249.26	1616304.0
2017-09-22 15:00:00	SPY	ETF	249.265	249.36	249.26	249.34	2311561.0
2017-09-22 15:30:00	SPY	ETF	249.35	249.63	249.33	249.42	10708294.0
2017-09-22 16:00:00	SPY	ETF	249.43	249.56	249.26	249.49	13368701.0
2017-09-22 16:30:00	SPY	ETF	249.49	249.53	249.2804	249.52	651122.0
2017-09-22 17:00:00	SPY	ETF	249.52	249.53	249.47	249.49	91314.0
2017-09-22 17:30:00	SPY	ETF	249.49	249.52	249.49	249.52	12800.0
2017-09-22 18:00:00	SPY	ETF	249.49	249.52	249.48	249.48	2172.0
2017-09-22 18:30:00	SPY	ETF	249.48	249.49	249.48	249.48	3820.0
2017-09-22 19:00:00	SPY	ETF	249.5	249.53	249.5	249.53	7404.0
2017-09-22 19:30:00	SPY	ETF	249.54	249.54	249.53	249.54	7249.0
2017-09-22 04:00:00	QQQ	ETF	144.32	144.32	144.14	144.14	3700.0
2017-09-22 04:30:00	QQQ	ETF	144.2	144.27	144.2	144.21	3800.0
2017-09-22 05:00:00	QQQ	ETF	144.18	144.19	144.18	144.19	800.0
2017-09-22 06:00:00	QQQ	ETF	144.33	144.34	144.31	144.33	7521.0
2017-09-22 06:30:00	QQQ	ETF	144.35	144.36	144.35	144.35	7100.0
2017-09-22 07:00:00	QQQ	ETF	144.35	144.35	144.22	144.22	8825.0
2017-09-22 07:30:00	QQQ	ETF	144.16	144.19	144.06	144.08	30921.0
2017-09-22 08:00:00	QQQ	ETF	144.35	144.35	144.02	144.1	72642.0
2017-09-22 08:30:00	QQQ	ETF	144.1	144.15	144.04	144.09	103277.0
2017-09-22 09:00:00	QQQ	ETF	144.09	144.12	143.92	143.98	200260.0
2017-09-22 09:30:00	QQQ	ETF	143.99	144.47	143.9108	144.14	2646938.0
2017-09-22 10:00:00	QQQ	ETF	144.15	144.53	144.13	144.37	1473413.0
2017-09-22 10:30:00	QQQ	ETF	144.36	144.44	144.01	144.02	1720006.0
2017-09-22 11:00:00	QQQ	ETF	144.02	144.17	144.01	144.06	1006000.0
2017-09-22 11:30:00	QQQ	ETF	144.07	144.2	144.01	144.18	705352.0
2017-09-22 12:00:00	QQQ	ETF	144.18	144.225	144.05	144.16	700985.0
2017-09-22 12:30:00	QQQ	ETF	144.16	144.2892	144.09	144.09	808733.0
2017-09-22 13:00:00	QQQ	ETF	144.09	144.15	143.855	144.06	802598.0
2017-09-22 13:30:00	QQQ	ETF	144.07	144.21	144.02	144.15	605597.0

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

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