PREVIEW / etf_30min / 2016-07-06

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-07-06.parquet
  size:    410 KB
  rows:    13,870

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-07-06 04:00:00	SPY	ETF	208.17	208.33	208.13	208.27	24945.0
2016-07-06 04:30:00	SPY	ETF	208.25	208.25	207.6	207.76	25519.0
2016-07-06 05:00:00	SPY	ETF	207.78	207.8	207.25	207.63	40672.0
2016-07-06 05:30:00	SPY	ETF	207.58	207.92	207.58	207.91	64645.0
2016-07-06 06:00:00	SPY	ETF	207.86	207.88	207.41	207.44	26557.0
2016-07-06 06:30:00	SPY	ETF	207.44	207.55	207.2	207.33	244843.0
2016-07-06 07:00:00	SPY	ETF	207.35	207.78	207.15	207.4	313939.0
2016-07-06 07:30:00	SPY	ETF	207.4	207.57	207.33	207.45	160421.0
2016-07-06 08:00:00	SPY	ETF	207.47	208.11	207.22	207.49	492757.0
2016-07-06 08:30:00	SPY	ETF	207.49	207.62	207.39	207.58	434361.0
2016-07-06 09:00:00	SPY	ETF	207.61	207.92	207.61	207.81	711292.0
2016-07-06 09:30:00	SPY	ETF	207.83	208.05	207.27	207.68	11542653.0
2016-07-06 10:00:00	SPY	ETF	207.69	208.32	207.19	207.25	10868084.0
2016-07-06 10:30:00	SPY	ETF	207.255	208.13	207.06	208.1201	8048849.0
2016-07-06 11:00:00	SPY	ETF	208.13	208.68	208.13	208.33	9405892.0
2016-07-06 11:30:00	SPY	ETF	208.33	208.78	208.327	208.72	5199359.0
2016-07-06 12:00:00	SPY	ETF	208.73	209.2	208.72	209.11	5233095.0
2016-07-06 12:30:00	SPY	ETF	209.11	209.31	208.92	209.3	3123028.0
2016-07-06 13:00:00	SPY	ETF	209.3	209.45	209.06	209.169	3195567.0
2016-07-06 13:30:00	SPY	ETF	209.17	209.27	208.93	209.07	2957310.0
2016-07-06 14:00:00	SPY	ETF	209.07	209.35	208.73	209.09	6161988.0
2016-07-06 14:30:00	SPY	ETF	209.085	209.62	209.04	209.58	5347676.0
2016-07-06 15:00:00	SPY	ETF	209.5899	209.63	209.15	209.24	4059043.0
2016-07-06 15:30:00	SPY	ETF	209.23	209.8	209.21	209.75	11791588.0
2016-07-06 16:00:00	SPY	ETF	209.74	209.88	209.4886	209.74	4100928.0
2016-07-06 16:30:00	SPY	ETF	209.76	209.84	208.5654	209.72	678109.0
2016-07-06 17:00:00	SPY	ETF	209.73	209.78	209.7	209.73	552602.0
2016-07-06 17:30:00	SPY	ETF	209.74	209.76	209.66	209.72	90176.0
2016-07-06 18:00:00	SPY	ETF	209.72	209.72	209.46	209.48	106952.0
2016-07-06 18:30:00	SPY	ETF	209.5	209.51	209.33	209.45	58734.0
2016-07-06 19:00:00	SPY	ETF	209.49	209.5	209.45	209.47	5676.0
2016-07-06 19:30:00	SPY	ETF	209.45	209.7	209.42	209.67	34377.0
2016-07-06 04:00:00	QQQ	ETF	107.1	107.15	107.1	107.15	342.0
2016-07-06 04:30:00	QQQ	ETF	107.0	107.0	106.86	106.86	300.0
2016-07-06 05:00:00	QQQ	ETF	106.91	106.91	106.91	106.91	100.0
2016-07-06 06:00:00	QQQ	ETF	106.7	106.7	106.68	106.68	1947.0
2016-07-06 06:30:00	QQQ	ETF	106.57	106.57	106.56	106.56	298.0
2016-07-06 07:00:00	QQQ	ETF	106.61	106.8	106.61	106.71	110531.0
2016-07-06 07:30:00	QQQ	ETF	106.7	106.75	106.64	106.69	57324.0
2016-07-06 08:00:00	QQQ	ETF	106.72	106.81	106.56	106.77	133287.0
2016-07-06 08:30:00	QQQ	ETF	106.76	106.79	106.7	106.79	18801.0
2016-07-06 09:00:00	QQQ	ETF	106.82	106.97	106.82	106.91	137570.0
2016-07-06 09:30:00	QQQ	ETF	106.93	107.09	106.57	107.03	2481753.0
2016-07-06 10:00:00	QQQ	ETF	107.03	107.4299	106.96	106.96	2434315.0
2016-07-06 10:30:00	QQQ	ETF	106.96	107.57	106.809	107.57	2031505.0
2016-07-06 11:00:00	QQQ	ETF	107.579	107.98	107.56	107.74	1834927.0
2016-07-06 11:30:00	QQQ	ETF	107.74	107.87	107.68	107.85	1770903.0
2016-07-06 12:00:00	QQQ	ETF	107.85	108.22	107.85	108.14	3311686.0
2016-07-06 12:30:00	QQQ	ETF	108.15	108.2	107.98	108.18	720421.0
2016-07-06 13:00:00	QQQ	ETF	108.185	108.27	108.0101	108.06	681822.0

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

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