PREVIEW / etf_30min / 2017-09-15

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-09-15.parquet
  size:    423 KB
  rows:    14,666

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-15 04:00:00	SPY	ETF	248.72	248.72	248.56	248.7	9406.0
2017-09-15 04:30:00	SPY	ETF	248.68	248.74	248.65	248.74	15027.0
2017-09-15 05:00:00	SPY	ETF	248.75	248.83	248.71	248.83	600.0
2017-09-15 05:30:00	SPY	ETF	248.6	248.63	248.6	248.63	300.0
2017-09-15 06:00:00	SPY	ETF	248.57	248.59	248.52	248.58	17590.0
2017-09-15 06:30:00	SPY	ETF	248.59	248.65	248.55	248.56	45349.0
2017-09-15 07:00:00	SPY	ETF	248.59	248.63	248.55	248.63	92263.0
2017-09-15 07:30:00	SPY	ETF	248.63	248.81	248.63	248.76	136806.0
2017-09-15 08:00:00	SPY	ETF	248.78	248.82	248.58	248.71	167919.0
2017-09-15 08:30:00	SPY	ETF	248.67	248.73	248.58	248.61	214308.0
2017-09-15 09:00:00	SPY	ETF	248.6	248.74	248.45	248.71	1464855.0
2017-09-15 09:30:00	SPY	ETF	248.69	248.88	248.63	248.65	7899037.0
2017-09-15 10:00:00	SPY	ETF	248.645	248.954	248.57	248.765	6652311.0
2017-09-15 10:30:00	SPY	ETF	248.77	249.18	248.72	249.05	16928372.0
2017-09-15 11:00:00	SPY	ETF	249.05	249.06	248.945	249.04	3922681.0
2017-09-15 11:30:00	SPY	ETF	249.03	249.09	248.94	249.0766	2737291.0
2017-09-15 12:00:00	SPY	ETF	249.0701	249.11	249.03	249.08	1813957.0
2017-09-15 12:30:00	SPY	ETF	249.08	249.1	248.95	248.96	2133930.0
2017-09-15 13:00:00	SPY	ETF	248.96	249.03	248.95	249.0	2011512.0
2017-09-15 13:30:00	SPY	ETF	248.995	249.055	248.88	248.955	2458990.0
2017-09-15 14:00:00	SPY	ETF	248.95	249.0	248.91	248.98	1708139.0
2017-09-15 14:30:00	SPY	ETF	248.99	249.08	248.95	249.05	2954060.0
2017-09-15 15:00:00	SPY	ETF	249.055	249.19	249.02	249.1	3003783.0
2017-09-15 15:30:00	SPY	ETF	249.11	249.29	249.07	249.25	12367762.0
2017-09-15 16:00:00	SPY	ETF	249.25	249.31	249.17	249.3	13131987.0
2017-09-15 16:30:00	SPY	ETF	249.28	249.47	248.78	249.47	10058737.0
2017-09-15 17:00:00	SPY	ETF	249.42	249.43	249.2858	249.31	126870.0
2017-09-15 17:30:00	SPY	ETF	249.35	249.39	249.19	249.2	1065456.0
2017-09-15 18:00:00	SPY	ETF	249.22	249.23	249.15	249.15	103518.0
2017-09-15 18:30:00	SPY	ETF	249.16	249.2	249.1	249.16	11732.0
2017-09-15 19:00:00	SPY	ETF	249.16	249.25	249.15	249.17	2774.0
2017-09-15 19:30:00	SPY	ETF	249.23	249.45	249.21	249.34	55840.0
2017-09-15 04:00:00	QQQ	ETF	145.43	145.45	145.43	145.43	2100.0
2017-09-15 04:30:00	QQQ	ETF	145.55	145.55	145.55	145.55	100.0
2017-09-15 05:30:00	QQQ	ETF	145.38	145.38	145.37	145.37	300.0
2017-09-15 06:00:00	QQQ	ETF	145.34	145.34	145.28	145.28	1600.0
2017-09-15 06:30:00	QQQ	ETF	145.35	145.36	145.33	145.33	2300.0
2017-09-15 07:00:00	QQQ	ETF	145.38	145.38	145.33	145.33	1033.0
2017-09-15 07:30:00	QQQ	ETF	145.35	145.48	145.35	145.44	29100.0
2017-09-15 08:00:00	QQQ	ETF	145.44	145.5	145.37	145.38	33859.0
2017-09-15 08:30:00	QQQ	ETF	145.36	145.42	145.32	145.32	30307.0
2017-09-15 09:00:00	QQQ	ETF	145.34	145.6	145.28	145.58	343064.0
2017-09-15 09:30:00	QQQ	ETF	145.56	145.68	145.29	145.48	3635327.0
2017-09-15 10:00:00	QQQ	ETF	145.48	145.78	145.44	145.7	2249221.0
2017-09-15 10:30:00	QQQ	ETF	145.71	146.59	145.68	146.435	3313973.0
2017-09-15 11:00:00	QQQ	ETF	146.43	146.46	146.24	146.275	1318185.0
2017-09-15 11:30:00	QQQ	ETF	146.27	146.309	146.12	146.245	1191110.0
2017-09-15 12:00:00	QQQ	ETF	146.2485	146.31	146.16	146.23	485357.0
2017-09-15 12:30:00	QQQ	ETF	146.23	146.24	146.005	146.015	630960.0
2017-09-15 13:00:00	QQQ	ETF	146.0172	146.1	146.01	146.05	546995.0

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

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