PREVIEW / etf_30min / 2017-01-31

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-01-31.parquet
  size:    445 KB
  rows:    15,107

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-31 04:00:00	SPY	ETF	227.4	227.47	227.33	227.46	1603.0
2017-01-31 04:30:00	SPY	ETF	227.5	227.55	227.5	227.5	1029.0
2017-01-31 05:00:00	SPY	ETF	227.47	227.47	227.25	227.25	1207.0
2017-01-31 05:30:00	SPY	ETF	227.23	227.3	227.13	227.3	13170.0
2017-01-31 06:00:00	SPY	ETF	227.34	227.46	227.34	227.45	6804.0
2017-01-31 06:30:00	SPY	ETF	227.45	227.45	227.29	227.34	23895.0
2017-01-31 07:00:00	SPY	ETF	227.37	227.42	227.33	227.4	7316.0
2017-01-31 07:30:00	SPY	ETF	227.37	227.37	227.0	227.06	155362.0
2017-01-31 08:00:00	SPY	ETF	227.04	227.41	227.02	227.22	172664.0
2017-01-31 08:30:00	SPY	ETF	227.22	227.38	227.05	227.14	375913.0
2017-01-31 09:00:00	SPY	ETF	227.2	227.23	226.95	226.97	766953.0
2017-01-31 09:30:00	SPY	ETF	226.98	227.31	226.77	226.89	7616409.0
2017-01-31 10:00:00	SPY	ETF	226.89	227.02	226.51	226.755	7356349.0
2017-01-31 10:30:00	SPY	ETF	226.75	227.05	226.515	226.615	4222104.0
2017-01-31 11:00:00	SPY	ETF	226.62	226.88	226.555	226.56	3461016.0
2017-01-31 11:30:00	SPY	ETF	226.56	226.65	226.32	226.48	4665983.0
2017-01-31 12:00:00	SPY	ETF	226.49	226.88	226.47	226.825	3014690.0
2017-01-31 12:30:00	SPY	ETF	226.82	226.93	226.76	226.8443	2111666.0
2017-01-31 13:00:00	SPY	ETF	226.85	226.86	226.56	226.82	1675062.0
2017-01-31 13:30:00	SPY	ETF	226.82	226.88	226.44	226.5	3070656.0
2017-01-31 14:00:00	SPY	ETF	226.51	226.73	226.4201	226.73	3463502.0
2017-01-31 14:30:00	SPY	ETF	226.72	227.08	226.59	227.03	5812790.0
2017-01-31 15:00:00	SPY	ETF	227.04	227.3	227.03	227.17	4857128.0
2017-01-31 15:30:00	SPY	ETF	227.17	227.6	227.16	227.56	10758925.0
2017-01-31 16:00:00	SPY	ETF	227.57	227.7134	227.5091	227.6	8673857.0
2017-01-31 16:30:00	SPY	ETF	227.65	227.87	227.53	227.78	1490676.0
2017-01-31 17:00:00	SPY	ETF	227.79	227.85	227.72	227.85	158361.0
2017-01-31 17:30:00	SPY	ETF	227.83	227.84	227.53	227.83	98189.0
2017-01-31 18:00:00	SPY	ETF	227.81	227.88	227.53	227.65	405775.0
2017-01-31 18:30:00	SPY	ETF	227.65	227.68	227.64	227.68	6317.0
2017-01-31 19:00:00	SPY	ETF	227.68	227.69	227.63	227.66	7226.0
2017-01-31 19:30:00	SPY	ETF	227.69	227.81	227.66	227.81	12292.0
2017-01-31 04:00:00	QQQ	ETF	124.65	124.65	124.65	124.65	1000.0
2017-01-31 04:30:00	QQQ	ETF	124.68	124.68	124.68	124.68	893.0
2017-01-31 05:00:00	QQQ	ETF	124.54	124.54	124.54	124.54	2125.0
2017-01-31 05:30:00	QQQ	ETF	124.58	124.6	124.52	124.6	6253.0
2017-01-31 06:00:00	QQQ	ETF	124.6	124.69	124.6	124.68	35303.0
2017-01-31 06:30:00	QQQ	ETF	124.64	124.67	124.64	124.66	801.0
2017-01-31 07:00:00	QQQ	ETF	124.63	124.69	124.63	124.69	1100.0
2017-01-31 07:30:00	QQQ	ETF	124.64	124.64	124.47	124.49	27754.0
2017-01-31 08:00:00	QQQ	ETF	124.68	124.68	124.49	124.58	30183.0
2017-01-31 08:30:00	QQQ	ETF	124.59	124.65	124.47	124.58	119736.0
2017-01-31 09:00:00	QQQ	ETF	124.57	124.58	124.36	124.4	109523.0
2017-01-31 09:30:00	QQQ	ETF	124.4	124.54	124.151	124.29	2852453.0
2017-01-31 10:00:00	QQQ	ETF	124.285	124.48	124.02	124.27	2121567.0
2017-01-31 10:30:00	QQQ	ETF	124.28	124.44	124.05	124.1	1107690.0
2017-01-31 11:00:00	QQQ	ETF	124.11	124.2196	124.01	124.02	687702.0
2017-01-31 11:30:00	QQQ	ETF	124.02	124.0569	123.87	123.89	1237595.0
2017-01-31 12:00:00	QQQ	ETF	123.89	124.1	123.85	124.08	791944.0
2017-01-31 12:30:00	QQQ	ETF	124.08	124.1493	124.02	124.07	387844.0

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

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