PREVIEW / etf_30min / 2016-05-10

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-05-10.parquet
  size:    393 KB
  rows:    13,406

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-05-10 04:00:00	SPY	ETF	206.98	207.17	206.93	207.1	63399.0
2016-05-10 04:30:00	SPY	ETF	207.08	207.42	206.99	207.36	32038.0
2016-05-10 05:00:00	SPY	ETF	207.36	207.38	207.06	207.08	77497.0
2016-05-10 05:30:00	SPY	ETF	207.09	207.17	207.01	207.01	14934.0
2016-05-10 06:00:00	SPY	ETF	207.02	207.15	207.02	207.15	26430.0
2016-05-10 06:30:00	SPY	ETF	207.11	207.12	206.8	206.8	24687.0
2016-05-10 07:00:00	SPY	ETF	206.77	206.77	206.26	206.4	215269.0
2016-05-10 07:30:00	SPY	ETF	206.43	206.65	206.43	206.53	166847.0
2016-05-10 08:00:00	SPY	ETF	206.5	206.73	206.3475	206.66	404775.0
2016-05-10 08:30:00	SPY	ETF	206.67	206.74	206.52	206.65	260900.0
2016-05-10 09:00:00	SPY	ETF	206.65	206.82	205.89	206.69	457387.0
2016-05-10 09:30:00	SPY	ETF	206.72	207.41	206.64	207.3	9214921.0
2016-05-10 10:00:00	SPY	ETF	207.28	207.45	207.06	207.295	6070509.0
2016-05-10 10:30:00	SPY	ETF	207.3	207.75	207.26	207.64	5231308.0
2016-05-10 11:00:00	SPY	ETF	207.64	207.69	207.405	207.5168	4297335.0
2016-05-10 11:30:00	SPY	ETF	207.52	207.77	207.505	207.7499	3030840.0
2016-05-10 12:00:00	SPY	ETF	207.75	207.96	207.75	207.94	2891488.0
2016-05-10 12:30:00	SPY	ETF	207.94	207.975	207.82	207.8789	2288269.0
2016-05-10 13:00:00	SPY	ETF	207.88	207.95	207.71	207.78	4075282.0
2016-05-10 13:30:00	SPY	ETF	207.78	208.05	207.75	208.01	2325152.0
2016-05-10 14:00:00	SPY	ETF	208.01	208.05	207.9	208.03	2422281.0
2016-05-10 14:30:00	SPY	ETF	208.03	208.12	207.97	207.99	3325027.0
2016-05-10 15:00:00	SPY	ETF	207.98	208.31	207.96	208.23	6236543.0
2016-05-10 15:30:00	SPY	ETF	208.23	208.46	208.13	208.43	11059473.0
2016-05-10 16:00:00	SPY	ETF	208.42	208.46	207.8251	208.22	7025760.0
2016-05-10 16:30:00	SPY	ETF	208.21	208.45	208.15	208.21	659606.0
2016-05-10 17:00:00	SPY	ETF	208.2	208.27	208.2	208.27	45323.0
2016-05-10 17:30:00	SPY	ETF	208.27	208.28	208.18	208.22	65908.0
2016-05-10 18:00:00	SPY	ETF	208.21	208.24	208.09	208.1	51361.0
2016-05-10 18:30:00	SPY	ETF	208.1	208.18	208.08	208.18	44471.0
2016-05-10 19:00:00	SPY	ETF	208.15	208.22	208.12	208.22	81379.0
2016-05-10 19:30:00	SPY	ETF	208.21	208.21	208.15	208.17	15346.0
2016-05-10 04:00:00	QQQ	ETF	106.47	106.47	106.47	106.47	2100.0
2016-05-10 04:30:00	QQQ	ETF	106.34	106.57	106.34	106.57	3546.0
2016-05-10 05:30:00	QQQ	ETF	106.39	106.45	106.39	106.45	4200.0
2016-05-10 06:00:00	QQQ	ETF	106.42	106.5	106.41	106.47	3199.0
2016-05-10 06:30:00	QQQ	ETF	106.47	106.47	106.33	106.33	14600.0
2016-05-10 07:00:00	QQQ	ETF	106.15	106.15	105.94	106.0	14300.0
2016-05-10 07:30:00	QQQ	ETF	106.03	106.14	106.03	106.14	52596.0
2016-05-10 08:00:00	QQQ	ETF	106.19	106.19	106.12	106.16	14972.0
2016-05-10 08:30:00	QQQ	ETF	106.16	106.17	106.07	106.12	22198.0
2016-05-10 09:00:00	QQQ	ETF	106.11	106.28	106.09	106.27	79097.0
2016-05-10 09:30:00	QQQ	ETF	106.26	106.52	106.07	106.4001	2754245.0
2016-05-10 10:00:00	QQQ	ETF	106.41	106.53	106.31	106.48	1277364.0
2016-05-10 10:30:00	QQQ	ETF	106.5	106.81	106.45	106.75	1505413.0
2016-05-10 11:00:00	QQQ	ETF	106.75	106.8	106.67	106.73	1163552.0
2016-05-10 11:30:00	QQQ	ETF	106.73	106.91	106.725	106.9	926955.0
2016-05-10 12:00:00	QQQ	ETF	106.91	107.04	106.89	107.01	921288.0
2016-05-10 12:30:00	QQQ	ETF	107.01	107.105	106.957	107.05	1128434.0
2016-05-10 13:00:00	QQQ	ETF	107.04	107.08	106.92	106.9501	950737.0

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

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