PREVIEW / etf_30min / 2016-02-09

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-02-09.parquet
  size:    407 KB
  rows:    13,880

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
2016-02-09 04:00:00	SPY	ETF	185.52	186.21	185.35	185.57	69668.0
2016-02-09 04:30:00	SPY	ETF	185.51	185.6	185.3	185.38	17397.0
2016-02-09 05:00:00	SPY	ETF	185.12	185.8	185.1	185.8	20973.0
2016-02-09 05:30:00	SPY	ETF	185.7	185.92	185.52	185.63	26481.0
2016-02-09 06:00:00	SPY	ETF	185.6	185.65	185.07	185.18	48955.0
2016-02-09 06:30:00	SPY	ETF	185.15	185.16	184.73	185.0	109355.0
2016-02-09 07:00:00	SPY	ETF	185.06	185.15	184.28	184.35	321824.0
2016-02-09 07:30:00	SPY	ETF	184.33	184.45	184.0	184.21	510984.0
2016-02-09 08:00:00	SPY	ETF	183.99	186.04	183.99	184.13	1233301.0
2016-02-09 08:30:00	SPY	ETF	184.13	184.14	183.38	183.59	995038.0
2016-02-09 09:00:00	SPY	ETF	183.61	183.85	183.28	183.36	1401537.0
2016-02-09 09:30:00	SPY	ETF	183.36	185.82	183.2	185.24	22974251.0
2016-02-09 10:00:00	SPY	ETF	185.23	186.29	185.12	185.2699	15756636.0
2016-02-09 10:30:00	SPY	ETF	185.27	185.28	183.99	184.115	15397339.0
2016-02-09 11:00:00	SPY	ETF	184.12	185.74	184.04	185.52	12938341.0
2016-02-09 11:30:00	SPY	ETF	185.51	185.69	184.5	184.585	9148161.0
2016-02-09 12:00:00	SPY	ETF	184.58	185.06	184.28	184.55	7656781.0
2016-02-09 12:30:00	SPY	ETF	184.55	184.9	184.21	184.38	7844847.0
2016-02-09 13:00:00	SPY	ETF	184.38	184.52	183.55	183.95	8742370.0
2016-02-09 13:30:00	SPY	ETF	183.95	184.57	183.71	184.38	9159421.0
2016-02-09 14:00:00	SPY	ETF	184.38	185.38	184.3401	184.66	10874772.0
2016-02-09 14:30:00	SPY	ETF	184.66	185.96	184.64	185.72	12126884.0
2016-02-09 15:00:00	SPY	ETF	185.72	186.94	185.35	185.54	20376514.0
2016-02-09 15:30:00	SPY	ETF	185.53	186.16	185.0	185.38	15657150.0
2016-02-09 16:00:00	SPY	ETF	185.37	185.62	185.1165	185.39	4809046.0
2016-02-09 16:30:00	SPY	ETF	185.41	185.43	185.19	185.2	4079568.0
2016-02-09 17:00:00	SPY	ETF	185.19	185.31	185.17	185.3	93017.0
2016-02-09 17:30:00	SPY	ETF	185.3	185.49	185.2	185.49	677535.0
2016-02-09 18:00:00	SPY	ETF	185.49	185.71	185.42	185.58	116741.0
2016-02-09 18:30:00	SPY	ETF	185.5	186.28	185.48	185.9	108133.0
2016-02-09 19:00:00	SPY	ETF	185.87	185.95	185.44	185.61	62164.0
2016-02-09 19:30:00	SPY	ETF	185.62	185.64	185.31	185.36	93880.0
2016-02-09 04:00:00	QQQ	ETF	96.99	97.09	96.93	96.95	400.0
2016-02-09 04:30:00	QQQ	ETF	96.63	96.64	96.63	96.64	200.0
2016-02-09 05:00:00	QQQ	ETF	96.77	96.77	96.62	96.62	3700.0
2016-02-09 05:30:00	QQQ	ETF	96.83	96.83	96.82	96.82	1562.0
2016-02-09 06:00:00	QQQ	ETF	96.72	96.72	96.53	96.6	6300.0
2016-02-09 06:30:00	QQQ	ETF	96.47	96.47	96.23	96.28	5880.0
2016-02-09 07:00:00	QQQ	ETF	96.43	96.43	96.14	96.16	132987.0
2016-02-09 07:30:00	QQQ	ETF	96.2	96.25	95.89	96.04	87712.0
2016-02-09 08:00:00	QQQ	ETF	96.06	96.18	95.75	95.82	175426.0
2016-02-09 08:30:00	QQQ	ETF	95.83	95.84	95.33	95.41	212000.0
2016-02-09 09:00:00	QQQ	ETF	95.41	95.54	95.23	95.36	256351.0
2016-02-09 09:30:00	QQQ	ETF	95.36	97.352	95.18	96.885	11156708.0
2016-02-09 10:00:00	QQQ	ETF	96.88	97.78	96.82	96.9	7487402.0
2016-02-09 10:30:00	QQQ	ETF	96.9	96.915	95.93	95.99	4955960.0
2016-02-09 11:00:00	QQQ	ETF	95.99	97.0	95.94	96.9	4113138.0
2016-02-09 11:30:00	QQQ	ETF	96.9	97.01	96.19	96.24	2755072.0
2016-02-09 12:00:00	QQQ	ETF	96.24	96.57	95.9	96.1	3734691.0
2016-02-09 12:30:00	QQQ	ETF	96.09	96.24	95.77	95.85	2064486.0

> showing 50 of 13,880 rows — these rows as CSV

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