PREVIEW / etf_30min / 2016-06-10

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-06-10.parquet
  size:    399 KB
  rows:    13,488

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-06-10 04:00:00	SPY	ETF	211.13	211.15	210.89	211.05	21206.0
2016-06-10 04:30:00	SPY	ETF	211.05	211.1	210.94	210.94	51716.0
2016-06-10 05:00:00	SPY	ETF	210.95	210.97	210.62	210.82	76340.0
2016-06-10 05:30:00	SPY	ETF	210.86	210.87	210.66	210.67	15066.0
2016-06-10 06:00:00	SPY	ETF	210.67	210.84	210.6	210.84	104717.0
2016-06-10 06:30:00	SPY	ETF	210.81	210.82	210.74	210.8	67314.0
2016-06-10 07:00:00	SPY	ETF	210.8	210.97	210.74	210.84	188225.0
2016-06-10 07:30:00	SPY	ETF	210.82	210.83	210.68	210.73	160213.0
2016-06-10 08:00:00	SPY	ETF	210.73	210.89	210.61	210.69	511580.0
2016-06-10 08:30:00	SPY	ETF	210.7	210.72	210.39	210.47	739267.0
2016-06-10 09:00:00	SPY	ETF	210.47	210.51	210.36	210.45	897313.0
2016-06-10 09:30:00	SPY	ETF	210.46	210.6	210.13	210.33	14476951.0
2016-06-10 10:00:00	SPY	ETF	210.33	210.7	210.1	210.59	8093181.0
2016-06-10 10:30:00	SPY	ETF	210.6	210.86	210.4	210.56	5569441.0
2016-06-10 11:00:00	SPY	ETF	210.55	210.825	210.49	210.61	5659740.0
2016-06-10 11:30:00	SPY	ETF	210.61	210.73	210.36	210.56	3446412.0
2016-06-10 12:00:00	SPY	ETF	210.555	210.61	210.13	210.2	4612823.0
2016-06-10 12:30:00	SPY	ETF	210.2	210.4	210.02	210.345	3741318.0
2016-06-10 13:00:00	SPY	ETF	210.35	210.46	210.2	210.36	3512791.0
2016-06-10 13:30:00	SPY	ETF	210.36	210.37	209.7	209.765	6932586.0
2016-06-10 14:00:00	SPY	ETF	209.76	209.785	209.46	209.62	8440482.0
2016-06-10 14:30:00	SPY	ETF	209.62	209.8	209.52	209.66	5594933.0
2016-06-10 15:00:00	SPY	ETF	209.67	209.78	209.43	209.75	6585941.0
2016-06-10 15:30:00	SPY	ETF	209.75	210.26	209.74	210.06	18313245.0
2016-06-10 16:00:00	SPY	ETF	210.08	210.35	210.03	210.15	7481826.0
2016-06-10 16:30:00	SPY	ETF	210.16	210.2	210.11	210.13	2960823.0
2016-06-10 17:00:00	SPY	ETF	210.1	210.22	210.1	210.15	429898.0
2016-06-10 17:30:00	SPY	ETF	210.15	210.15	210.04	210.1	544990.0
2016-06-10 18:00:00	SPY	ETF	210.13	210.16	210.1	210.14	23570.0
2016-06-10 18:30:00	SPY	ETF	210.16	210.16	210.11	210.11	7308.0
2016-06-10 19:00:00	SPY	ETF	210.11	210.11	210.09	210.09	6118.0
2016-06-10 19:30:00	SPY	ETF	210.09	210.14	210.06	210.14	1757142.0
2016-06-10 04:00:00	QQQ	ETF	109.63	109.63	109.48	109.48	9280.0
2016-06-10 05:00:00	QQQ	ETF	109.5	109.5	109.3	109.38	23499.0
2016-06-10 05:30:00	QQQ	ETF	109.44	109.44	109.36	109.36	699.0
2016-06-10 06:00:00	QQQ	ETF	109.31	109.39	109.31	109.39	1299.0
2016-06-10 06:30:00	QQQ	ETF	109.37	109.42	109.37	109.38	2540.0
2016-06-10 07:00:00	QQQ	ETF	109.4	109.51	109.4	109.44	5499.0
2016-06-10 07:30:00	QQQ	ETF	109.43	109.43	109.36	109.36	11058.0
2016-06-10 08:00:00	QQQ	ETF	109.4	109.44	109.31	109.37	214534.0
2016-06-10 08:30:00	QQQ	ETF	109.37	109.38	109.21	109.24	138398.0
2016-06-10 09:00:00	QQQ	ETF	109.25	109.26	109.18	109.19	178498.0
2016-06-10 09:30:00	QQQ	ETF	109.2	109.31	109.0	109.15	4607767.0
2016-06-10 10:00:00	QQQ	ETF	109.15	109.3	108.97	109.23	2000226.0
2016-06-10 10:30:00	QQQ	ETF	109.23	109.4	109.091	109.13	1622841.0
2016-06-10 11:00:00	QQQ	ETF	109.135	109.33	109.1	109.22	1098653.0
2016-06-10 11:30:00	QQQ	ETF	109.22	109.3	109.13	109.24	1076082.0
2016-06-10 12:00:00	QQQ	ETF	109.25	109.28	109.025	109.0959	841311.0
2016-06-10 12:30:00	QQQ	ETF	109.1	109.24	109.01	109.21	752502.0
2016-06-10 13:00:00	QQQ	ETF	109.215	109.27	109.1	109.2	770661.0

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

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