PREVIEW / etf_30min / 2017-11-08

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-11-08.parquet
  size:    443 KB
  rows:    15,245

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-11-08 04:00:00	SPY	ETF	258.52	258.66	258.52	258.62	10650.0
2017-11-08 04:30:00	SPY	ETF	258.68	258.71	258.63	258.63	5000.0
2017-11-08 05:00:00	SPY	ETF	258.63	258.63	258.52	258.54	3111.0
2017-11-08 05:30:00	SPY	ETF	258.61	258.61	258.57	258.57	8651.0
2017-11-08 06:00:00	SPY	ETF	258.55	258.58	258.5	258.5	8146.0
2017-11-08 06:30:00	SPY	ETF	258.48	258.48	258.32	258.38	10411.0
2017-11-08 07:00:00	SPY	ETF	258.4	258.48	258.37	258.37	34826.0
2017-11-08 07:30:00	SPY	ETF	258.35	258.37	258.25	258.34	60411.0
2017-11-08 08:00:00	SPY	ETF	258.42	258.57	258.29	258.5	122979.0
2017-11-08 08:30:00	SPY	ETF	258.49	258.54	258.37	258.5	110870.0
2017-11-08 09:00:00	SPY	ETF	258.5	258.54	258.42	258.45	179448.0
2017-11-08 09:30:00	SPY	ETF	258.47	258.58	258.15	258.25	4421077.0
2017-11-08 10:00:00	SPY	ETF	258.26	258.54	258.26	258.48	2726769.0
2017-11-08 10:30:00	SPY	ETF	258.47	258.58	258.23	258.53	3092318.0
2017-11-08 11:00:00	SPY	ETF	258.53	258.68	258.52	258.575	1576977.0
2017-11-08 11:30:00	SPY	ETF	258.575	258.59	258.405	258.58	1550796.0
2017-11-08 12:00:00	SPY	ETF	258.58	258.85	258.55	258.83	2599084.0
2017-11-08 12:30:00	SPY	ETF	258.84	258.94	258.74	258.8999	1852594.0
2017-11-08 13:00:00	SPY	ETF	258.9	259.075	258.89	259.03	3025436.0
2017-11-08 13:30:00	SPY	ETF	259.03	259.03	258.94	259.005	3370591.0
2017-11-08 14:00:00	SPY	ETF	259.0025	259.1	258.9	259.0301	1991036.0
2017-11-08 14:30:00	SPY	ETF	259.04	259.14	258.95	259.05	2135952.0
2017-11-08 15:00:00	SPY	ETF	259.05	259.105	258.961	259.07	1792755.0
2017-11-08 15:30:00	SPY	ETF	259.07	259.22	258.88	259.13	9171479.0
2017-11-08 16:00:00	SPY	ETF	259.13	259.13	258.96	259.08	8695058.0
2017-11-08 16:30:00	SPY	ETF	259.09	259.12	259.02	259.03	771871.0
2017-11-08 17:00:00	SPY	ETF	259.06	259.07	259.02	259.05	113874.0
2017-11-08 17:30:00	SPY	ETF	259.03	259.1	259.03	259.09	34895.0
2017-11-08 18:00:00	SPY	ETF	259.04	259.15	259.04	259.11	20423.0
2017-11-08 18:30:00	SPY	ETF	259.12	259.14	259.08	259.08	16766.0
2017-11-08 19:00:00	SPY	ETF	259.08	259.33	259.05	259.31	72298.0
2017-11-08 19:30:00	SPY	ETF	259.3	259.37	259.19	259.26	47405.0
2017-11-08 04:00:00	QQQ	ETF	153.9	153.98	153.9	153.98	11700.0
2017-11-08 04:30:00	QQQ	ETF	153.89	153.89	153.89	153.89	300.0
2017-11-08 05:00:00	QQQ	ETF	153.89	153.89	153.82	153.82	500.0
2017-11-08 05:30:00	QQQ	ETF	153.86	153.9	153.86	153.9	4700.0
2017-11-08 06:00:00	QQQ	ETF	153.88	153.88	153.87	153.88	11500.0
2017-11-08 06:30:00	QQQ	ETF	153.79	153.82	153.76	153.77	35699.0
2017-11-08 07:00:00	QQQ	ETF	153.84	153.85	153.76	153.76	4298.0
2017-11-08 07:30:00	QQQ	ETF	153.76	153.82	153.75	153.76	4500.0
2017-11-08 08:00:00	QQQ	ETF	153.8	153.88	153.79	153.86	37244.0
2017-11-08 08:30:00	QQQ	ETF	153.83	153.88	153.8	153.85	43954.0
2017-11-08 09:00:00	QQQ	ETF	153.85	153.86	153.78	153.82	53907.0
2017-11-08 09:30:00	QQQ	ETF	153.81	153.98	153.62	153.71	2318805.0
2017-11-08 10:00:00	QQQ	ETF	153.72	153.965	153.72	153.9	1593273.0
2017-11-08 10:30:00	QQQ	ETF	153.9	154.06	153.81	154.02	1595546.0
2017-11-08 11:00:00	QQQ	ETF	154.02	154.2	154.0151	154.09	1155412.0
2017-11-08 11:30:00	QQQ	ETF	154.08	154.15	153.99	154.0551	619664.0
2017-11-08 12:00:00	QQQ	ETF	154.05	154.17	154.03	154.17	620088.0
2017-11-08 12:30:00	QQQ	ETF	154.16	154.24	154.09	154.22	674708.0

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

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