PREVIEW / etf_30min / 2017-09-01

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-09-01.parquet
  size:    429 KB
  rows:    14,865

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-01 04:00:00	SPY	ETF	247.65	247.74	247.53	247.53	1006.0
2017-09-01 04:30:00	SPY	ETF	247.57	247.59	247.51	247.58	2000.0
2017-09-01 05:00:00	SPY	ETF	247.54	247.6	247.54	247.6	800.0
2017-09-01 05:30:00	SPY	ETF	247.59	247.59	247.59	247.59	100.0
2017-09-01 06:00:00	SPY	ETF	247.6	247.77	247.6	247.74	4569.0
2017-09-01 06:30:00	SPY	ETF	247.74	247.85	247.74	247.84	17409.0
2017-09-01 07:00:00	SPY	ETF	247.82	247.9	247.81	247.89	51638.0
2017-09-01 07:30:00	SPY	ETF	247.9	248.05	247.86	247.98	58632.0
2017-09-01 08:00:00	SPY	ETF	247.85	248.03	247.45	247.93	484193.0
2017-09-01 08:30:00	SPY	ETF	247.95	248.18	247.49	247.92	455385.0
2017-09-01 09:00:00	SPY	ETF	247.96	248.1	247.88	247.93	374379.0
2017-09-01 09:30:00	SPY	ETF	247.92	248.12	247.69	247.85	6253910.0
2017-09-01 10:00:00	SPY	ETF	247.87	247.94	247.67	247.94	4661065.0
2017-09-01 10:30:00	SPY	ETF	247.93	248.17	247.85	248.13	3734019.0
2017-09-01 11:00:00	SPY	ETF	248.12	248.2	247.905	247.92	5269456.0
2017-09-01 11:30:00	SPY	ETF	247.92	248.115	247.85	248.09	2247027.0
2017-09-01 12:00:00	SPY	ETF	248.1	248.22	248.05	248.17	1933304.0
2017-09-01 12:30:00	SPY	ETF	248.16	248.32	248.13	248.275	2261507.0
2017-09-01 13:00:00	SPY	ETF	248.28	248.33	248.16	248.22	1271981.0
2017-09-01 13:30:00	SPY	ETF	248.23	248.28	248.13	248.17	1420720.0
2017-09-01 14:00:00	SPY	ETF	248.165	248.25	248.1	248.125	2422745.0
2017-09-01 14:30:00	SPY	ETF	248.12	248.2	248.09	248.16	2117199.0
2017-09-01 15:00:00	SPY	ETF	248.155	248.23	248.11	248.2	2580689.0
2017-09-01 15:30:00	SPY	ETF	248.195	248.2	247.87	247.88	8984713.0
2017-09-01 16:00:00	SPY	ETF	247.88	247.9516	247.77	247.78	9780755.0
2017-09-01 16:30:00	SPY	ETF	247.78	247.84	247.74	247.77	2570624.0
2017-09-01 17:00:00	SPY	ETF	247.78	247.8	247.69	247.79	25257.0
2017-09-01 17:30:00	SPY	ETF	247.78	247.8	247.75	247.75	11927.0
2017-09-01 18:00:00	SPY	ETF	247.75	247.79	247.75	247.78	10958.0
2017-09-01 18:30:00	SPY	ETF	247.76	248.25	247.71	247.71	16443.0
2017-09-01 19:00:00	SPY	ETF	247.72	247.76	247.72	247.74	7050.0
2017-09-01 19:30:00	SPY	ETF	247.71	247.72	247.65	247.71	32348.0
2017-09-01 04:00:00	QQQ	ETF	146.15	146.15	146.15	146.15	1000.0
2017-09-01 04:30:00	QQQ	ETF	146.16	146.18	146.16	146.17	3800.0
2017-09-01 05:00:00	QQQ	ETF	146.18	146.18	146.17	146.17	1700.0
2017-09-01 05:30:00	QQQ	ETF	146.13	146.13	146.09	146.1	300.0
2017-09-01 06:00:00	QQQ	ETF	146.17	146.25	146.17	146.25	920.0
2017-09-01 06:30:00	QQQ	ETF	146.27	146.33	146.27	146.3	7250.0
2017-09-01 07:00:00	QQQ	ETF	146.32	146.4	146.32	146.37	5000.0
2017-09-01 07:30:00	QQQ	ETF	146.38	146.5	146.38	146.5	15521.0
2017-09-01 08:00:00	QQQ	ETF	146.29	146.49	146.29	146.49	31345.0
2017-09-01 08:30:00	QQQ	ETF	146.46	146.74	146.2	146.44	249666.0
2017-09-01 09:00:00	QQQ	ETF	146.41	146.53	146.36	146.36	62810.0
2017-09-01 09:30:00	QQQ	ETF	146.36	146.585	145.86	145.93	2950680.0
2017-09-01 10:00:00	QQQ	ETF	145.94	146.03	145.61	146.0	2939951.0
2017-09-01 10:30:00	QQQ	ETF	146.01	146.14	145.86	146.09	1277203.0
2017-09-01 11:00:00	QQQ	ETF	146.08	146.18	145.933	145.975	907768.0
2017-09-01 11:30:00	QQQ	ETF	145.98	146.18	145.97	146.16	635958.0
2017-09-01 12:00:00	QQQ	ETF	146.16	146.24	146.095	146.19	358937.0
2017-09-01 12:30:00	QQQ	ETF	146.19	146.24	146.17	146.17	567372.0

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

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