PREVIEW / etf_30min / 2016-04-27

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-04-27.parquet
  size:    396 KB
  rows:    13,329

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-04-27 04:00:00	SPY	ETF	208.84	208.91	208.57	208.67	35647.0
2016-04-27 04:30:00	SPY	ETF	208.65	208.94	208.64	208.94	7341.0
2016-04-27 05:00:00	SPY	ETF	208.85	208.85	208.72	208.75	25413.0
2016-04-27 05:30:00	SPY	ETF	208.78	208.78	208.7	208.7	52014.0
2016-04-27 06:00:00	SPY	ETF	208.7	208.78	208.7	208.75	17909.0
2016-04-27 06:30:00	SPY	ETF	208.78	208.78	208.6	208.66	19104.0
2016-04-27 07:00:00	SPY	ETF	208.71	208.77	208.64	208.71	14125.0
2016-04-27 07:30:00	SPY	ETF	208.67	208.84	208.67	208.73	172562.0
2016-04-27 08:00:00	SPY	ETF	208.72	208.86	208.65	208.75	170908.0
2016-04-27 08:30:00	SPY	ETF	208.75	208.8	208.65	208.66	87075.0
2016-04-27 09:00:00	SPY	ETF	208.65	208.67	208.38	208.47	483907.0
2016-04-27 09:30:00	SPY	ETF	208.47	209.08	208.46	208.76	6708967.0
2016-04-27 10:00:00	SPY	ETF	208.76	208.92	208.45	208.46	4948075.0
2016-04-27 10:30:00	SPY	ETF	208.45	208.48	208.05	208.16	5623478.0
2016-04-27 11:00:00	SPY	ETF	208.18	208.57	208.085	208.55	2566253.0
2016-04-27 11:30:00	SPY	ETF	208.55	208.8795	208.54	208.87	2621251.0
2016-04-27 12:00:00	SPY	ETF	208.86	209.0	208.65	208.9408	2511033.0
2016-04-27 12:30:00	SPY	ETF	208.94	208.96	208.75	208.7712	1527997.0
2016-04-27 13:00:00	SPY	ETF	208.78	208.8	208.49	208.515	2617497.0
2016-04-27 13:30:00	SPY	ETF	208.515	208.81	208.5	208.538	2254108.0
2016-04-27 14:00:00	SPY	ETF	208.54	209.42	208.2	209.14	12166940.0
2016-04-27 14:30:00	SPY	ETF	209.131	209.21	208.76	209.09	5097566.0
2016-04-27 15:00:00	SPY	ETF	209.08	209.8	209.05	209.68	7628904.0
2016-04-27 15:30:00	SPY	ETF	209.67	209.81	209.24	209.34	12689261.0
2016-04-27 16:00:00	SPY	ETF	209.36	209.55	208.9809	209.55	3923210.0
2016-04-27 16:30:00	SPY	ETF	209.55	209.69	209.38	209.69	2190184.0
2016-04-27 17:00:00	SPY	ETF	209.69	209.69	209.58	209.58	229401.0
2016-04-27 17:30:00	SPY	ETF	209.59	209.65	209.35	209.61	30727.0
2016-04-27 18:00:00	SPY	ETF	209.64	209.65	209.55	209.65	29525.0
2016-04-27 18:30:00	SPY	ETF	209.62	209.7	209.62	209.67	17929.0
2016-04-27 19:00:00	SPY	ETF	209.7	209.73	209.6	209.6	28833.0
2016-04-27 19:30:00	SPY	ETF	209.66	209.71	209.64	209.67	17385.0
2016-04-27 04:00:00	QQQ	ETF	107.49	107.49	107.49	107.49	100.0
2016-04-27 04:30:00	QQQ	ETF	107.51	107.51	107.5	107.5	1100.0
2016-04-27 05:00:00	QQQ	ETF	107.56	107.56	107.43	107.43	800.0
2016-04-27 05:30:00	QQQ	ETF	107.45	107.45	107.44	107.44	631.0
2016-04-27 06:00:00	QQQ	ETF	107.42	107.43	107.42	107.43	600.0
2016-04-27 06:30:00	QQQ	ETF	107.39	107.39	107.37	107.39	737.0
2016-04-27 07:00:00	QQQ	ETF	107.43	107.48	107.39	107.42	39836.0
2016-04-27 07:30:00	QQQ	ETF	107.41	107.5	107.37	107.37	36714.0
2016-04-27 08:00:00	QQQ	ETF	107.47	107.52	107.4	107.47	33654.0
2016-04-27 08:30:00	QQQ	ETF	107.48	107.5	107.45	107.47	81081.0
2016-04-27 09:00:00	QQQ	ETF	107.47	107.52	107.3	107.33	360976.0
2016-04-27 09:30:00	QQQ	ETF	107.33	107.8	107.15	107.2001	4059879.0
2016-04-27 10:00:00	QQQ	ETF	107.2	107.3	106.82	106.84	2113251.0
2016-04-27 10:30:00	QQQ	ETF	106.84	107.01	106.69	106.92	2684923.0
2016-04-27 11:00:00	QQQ	ETF	106.925	107.2399	106.8701	107.2399	1616274.0
2016-04-27 11:30:00	QQQ	ETF	107.23	107.39	107.19	107.341	1042181.0
2016-04-27 12:00:00	QQQ	ETF	107.35	107.37	107.15	107.34	761761.0
2016-04-27 12:30:00	QQQ	ETF	107.335	107.35	107.2	107.22	593993.0

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

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