PREVIEW / etf_30min / 2017-01-19

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-01-19.parquet
  size:    431 KB
  rows:    14,649

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-01-19 04:00:00	SPY	ETF	226.58	226.58	226.56	226.56	700.0
2017-01-19 04:30:00	SPY	ETF	226.39	226.41	226.39	226.41	801.0
2017-01-19 05:00:00	SPY	ETF	226.33	226.33	226.25	226.27	1567.0
2017-01-19 05:30:00	SPY	ETF	226.32	226.36	226.32	226.36	3750.0
2017-01-19 06:00:00	SPY	ETF	226.35	226.56	226.35	226.56	26295.0
2017-01-19 06:30:00	SPY	ETF	226.56	226.56	226.53	226.53	2963.0
2017-01-19 07:00:00	SPY	ETF	226.58	226.59	226.55	226.56	31564.0
2017-01-19 07:30:00	SPY	ETF	226.52	226.58	226.45	226.52	31236.0
2017-01-19 08:00:00	SPY	ETF	226.51	226.75	226.44	226.5	111065.0
2017-01-19 08:30:00	SPY	ETF	226.51	226.73	226.5	226.65	254699.0
2017-01-19 09:00:00	SPY	ETF	226.65	226.85	226.61	226.83	361179.0
2017-01-19 09:30:00	SPY	ETF	226.84	227.0	226.66	226.79	4966620.0
2017-01-19 10:00:00	SPY	ETF	226.78	226.79	226.3035	226.55	4138555.0
2017-01-19 10:30:00	SPY	ETF	226.55	226.83	226.37	226.43	2582390.0
2017-01-19 11:00:00	SPY	ETF	226.42	226.54	226.06	226.46	4590811.0
2017-01-19 11:30:00	SPY	ETF	226.46	226.57	226.34	226.41	3325315.0
2017-01-19 12:00:00	SPY	ETF	226.42	226.47	226.27	226.37	2249966.0
2017-01-19 12:30:00	SPY	ETF	226.37	226.4	226.21	226.34	1992796.0
2017-01-19 13:00:00	SPY	ETF	226.35	226.43	226.14	226.15	2784021.0
2017-01-19 13:30:00	SPY	ETF	226.15	226.31	226.09	226.1141	4163975.0
2017-01-19 14:00:00	SPY	ETF	226.11	226.18	225.41	225.81	8824809.0
2017-01-19 14:30:00	SPY	ETF	225.81	225.91	225.67	225.7461	3290247.0
2017-01-19 15:00:00	SPY	ETF	225.75	226.07	225.63	225.99	5642795.0
2017-01-19 15:30:00	SPY	ETF	225.99	226.1	225.79	225.95	10064485.0
2017-01-19 16:00:00	SPY	ETF	225.96	226.29	225.91	226.18	5331506.0
2017-01-19 16:30:00	SPY	ETF	226.19	226.2	225.91	226.2	385027.0
2017-01-19 17:00:00	SPY	ETF	226.18	226.19	226.13	226.14	51622.0
2017-01-19 17:30:00	SPY	ETF	226.14	226.15	225.91	226.15	105717.0
2017-01-19 18:00:00	SPY	ETF	226.14	226.29	226.14	226.29	122110.0
2017-01-19 18:30:00	SPY	ETF	226.28	226.34	226.28	226.31	32429.0
2017-01-19 19:00:00	SPY	ETF	226.31	226.54	226.31	226.46	163221.0
2017-01-19 19:30:00	SPY	ETF	226.46	226.49	226.41	226.44	23835.0
2017-01-19 04:30:00	QQQ	ETF	123.08	123.08	123.02	123.02	600.0
2017-01-19 06:00:00	QQQ	ETF	122.94	123.03	122.94	123.03	1099.0
2017-01-19 07:00:00	QQQ	ETF	123.1	123.11	123.09	123.09	2496.0
2017-01-19 07:30:00	QQQ	ETF	123.08	123.11	123.06	123.06	4172.0
2017-01-19 08:00:00	QQQ	ETF	123.11	123.11	123.03	123.07	51109.0
2017-01-19 08:30:00	QQQ	ETF	123.05	123.17	123.05	123.15	38441.0
2017-01-19 09:00:00	QQQ	ETF	123.1	123.24	123.08	123.18	136135.0
2017-01-19 09:30:00	QQQ	ETF	123.19	123.65	123.19	123.62	2214725.0
2017-01-19 10:00:00	QQQ	ETF	123.6153	123.619	123.14	123.22	1201491.0
2017-01-19 10:30:00	QQQ	ETF	123.2127	123.24	123.07	123.14	704718.0
2017-01-19 11:00:00	QQQ	ETF	123.13	123.27	122.96	123.25	844296.0
2017-01-19 11:30:00	QQQ	ETF	123.25	123.3454	123.2	123.25	495191.0
2017-01-19 12:00:00	QQQ	ETF	123.25	123.33	123.21	123.28	379760.0
2017-01-19 12:30:00	QQQ	ETF	123.28	123.29	123.1627	123.2259	497546.0
2017-01-19 13:00:00	QQQ	ETF	123.2105	123.26	123.07	123.07	548544.0
2017-01-19 13:30:00	QQQ	ETF	123.07	123.15	123.07	123.0725	450248.0
2017-01-19 14:00:00	QQQ	ETF	123.072	123.11	122.72	122.95	1287030.0
2017-01-19 14:30:00	QQQ	ETF	122.95	122.98	122.8701	122.8834	424135.0

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

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