PREVIEW / etf_30min / 2017-09-20

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-09-20.parquet
  size:    436 KB
  rows:    15,018

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-20 04:00:00	SPY	ETF	249.97	250.01	249.85	249.97	10441.0
2017-09-20 04:30:00	SPY	ETF	249.97	250.05	249.97	250.05	1900.0
2017-09-20 05:00:00	SPY	ETF	250.0	250.0	250.0	250.0	1700.0
2017-09-20 05:30:00	SPY	ETF	250.0	250.02	250.0	250.02	5400.0
2017-09-20 06:00:00	SPY	ETF	250.0	250.03	250.0	250.03	2700.0
2017-09-20 06:30:00	SPY	ETF	249.97	250.01	249.97	250.01	18000.0
2017-09-20 07:00:00	SPY	ETF	250.02	250.07	250.0	250.05	56125.0
2017-09-20 07:30:00	SPY	ETF	250.05	250.08	249.97	249.97	24102.0
2017-09-20 08:00:00	SPY	ETF	249.96	250.03	249.95	250.02	40942.0
2017-09-20 08:30:00	SPY	ETF	250.02	250.05	250.0	250.04	29580.0
2017-09-20 09:00:00	SPY	ETF	250.03	250.07	250.01	250.06	74495.0
2017-09-20 09:30:00	SPY	ETF	250.07	250.19	249.93	250.02	3578445.0
2017-09-20 10:00:00	SPY	ETF	250.02	250.03	249.85	249.955	2334096.0
2017-09-20 10:30:00	SPY	ETF	249.95	250.03	249.75	249.79	2594009.0
2017-09-20 11:00:00	SPY	ETF	249.79	249.945	249.72	249.93	3521122.0
2017-09-20 11:30:00	SPY	ETF	249.94	250.06	249.935	250.025	1378192.0
2017-09-20 12:00:00	SPY	ETF	250.03	250.12	249.98	250.06	1731993.0
2017-09-20 12:30:00	SPY	ETF	250.065	250.16	250.05	250.075	1711864.0
2017-09-20 13:00:00	SPY	ETF	250.08	250.09	249.775	249.85	2073381.0
2017-09-20 13:30:00	SPY	ETF	249.84	249.93	249.8	249.89	1250553.0
2017-09-20 14:00:00	SPY	ETF	249.89	249.89	248.92	249.21	9166486.0
2017-09-20 14:30:00	SPY	ETF	249.21	249.77	249.0	249.62	6928065.0
2017-09-20 15:00:00	SPY	ETF	249.62	249.73	249.43	249.69	2673641.0
2017-09-20 15:30:00	SPY	ETF	249.7	250.15	249.69	250.09	11090813.0
2017-09-20 16:00:00	SPY	ETF	250.09	250.1	250.0	250.01	7255809.0
2017-09-20 16:30:00	SPY	ETF	250.01	250.07	249.97	249.98	746908.0
2017-09-20 17:00:00	SPY	ETF	250.0	250.06	249.97	250.0	456696.0
2017-09-20 17:30:00	SPY	ETF	249.99	250.01	249.94	250.0	48752.0
2017-09-20 18:00:00	SPY	ETF	249.98	249.98	249.93	249.97	38512.0
2017-09-20 18:30:00	SPY	ETF	249.96	250.01	249.95	250.01	44707.0
2017-09-20 19:00:00	SPY	ETF	249.97	250.04	249.97	250.03	7738.0
2017-09-20 19:30:00	SPY	ETF	250.03	250.08	250.03	250.06	21143.0
2017-09-20 06:00:00	QQQ	ETF	145.83	145.84	145.81	145.81	30000.0
2017-09-20 07:00:00	QQQ	ETF	145.85	145.88	145.85	145.86	11500.0
2017-09-20 07:30:00	QQQ	ETF	145.88	145.88	145.78	145.78	1800.0
2017-09-20 08:00:00	QQQ	ETF	145.85	145.85	145.8	145.82	25499.0
2017-09-20 08:30:00	QQQ	ETF	145.82	145.82	145.76	145.76	11870.0
2017-09-20 09:00:00	QQQ	ETF	145.8	145.8	145.75	145.75	19130.0
2017-09-20 09:30:00	QQQ	ETF	145.75	145.91	145.55	145.64	2273007.0
2017-09-20 10:00:00	QQQ	ETF	145.65	145.73	145.49	145.5625	1582402.0
2017-09-20 10:30:00	QQQ	ETF	145.56	145.68	144.93	144.93	1734114.0
2017-09-20 11:00:00	QQQ	ETF	144.935	145.13	144.79	145.07	2905811.0
2017-09-20 11:30:00	QQQ	ETF	145.07	145.205	145.06	145.18	1001149.0
2017-09-20 12:00:00	QQQ	ETF	145.185	145.44	145.16	145.43	1076666.0
2017-09-20 12:30:00	QQQ	ETF	145.43	145.52	145.38	145.42	988998.0
2017-09-20 13:00:00	QQQ	ETF	145.41	145.44	145.17	145.21	736619.0
2017-09-20 13:30:00	QQQ	ETF	145.21	145.32	145.15	145.27	730713.0
2017-09-20 14:00:00	QQQ	ETF	145.26	145.27	144.2656	144.435	4969136.0
2017-09-20 14:30:00	QQQ	ETF	144.44	144.97	144.23	144.86	3465160.0
2017-09-20 15:00:00	QQQ	ETF	144.85	145.056	144.725	145.03	2353647.0

> showing 50 of 15,018 rows — these rows as CSV

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