PREVIEW / etf_30min / 2017-01-10

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-01-10.parquet
  size:    429 KB
  rows:    14,594

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
2017-01-10 04:00:00	SPY	ETF	226.46	226.47	226.4	226.47	601.0
2017-01-10 05:00:00	SPY	ETF	226.53	226.66	226.53	226.66	1407.0
2017-01-10 05:30:00	SPY	ETF	226.69	226.7	226.63	226.66	4159.0
2017-01-10 06:30:00	SPY	ETF	226.63	226.69	226.61	226.61	1302.0
2017-01-10 07:00:00	SPY	ETF	226.55	226.63	226.55	226.61	7751.0
2017-01-10 07:30:00	SPY	ETF	226.59	226.64	226.48	226.48	60888.0
2017-01-10 08:00:00	SPY	ETF	226.6	226.61	226.44	226.45	113641.0
2017-01-10 08:30:00	SPY	ETF	226.46	226.54	226.43	226.49	85562.0
2017-01-10 09:00:00	SPY	ETF	226.54	226.57	226.47	226.48	190512.0
2017-01-10 09:30:00	SPY	ETF	226.48	226.49	226.01	226.27	5896333.0
2017-01-10 10:00:00	SPY	ETF	226.27	226.43	226.25	226.43	5324736.0
2017-01-10 10:30:00	SPY	ETF	226.43	226.79	226.425	226.685	3965807.0
2017-01-10 11:00:00	SPY	ETF	226.689	227.12	226.6709	227.03	4356382.0
2017-01-10 11:30:00	SPY	ETF	227.03	227.29	226.995	227.16	2633904.0
2017-01-10 12:00:00	SPY	ETF	227.16	227.45	227.15	227.37	4816185.0
2017-01-10 12:30:00	SPY	ETF	227.37	227.41	227.15	227.18	3243163.0
2017-01-10 13:00:00	SPY	ETF	227.18	227.25	227.13	227.14	1832390.0
2017-01-10 13:30:00	SPY	ETF	227.14	227.16	226.56	226.62	3311445.0
2017-01-10 14:00:00	SPY	ETF	226.61	226.7	226.38	226.47	4358803.0
2017-01-10 14:30:00	SPY	ETF	226.47	226.72	226.46	226.595	3509894.0
2017-01-10 15:00:00	SPY	ETF	226.6	226.79	226.56	226.705	3076162.0
2017-01-10 15:30:00	SPY	ETF	226.7	226.96	226.37	226.43	8588792.0
2017-01-10 16:00:00	SPY	ETF	226.43	226.57	226.37	226.41	6360294.0
2017-01-10 16:30:00	SPY	ETF	226.41	226.5	226.41	226.44	499163.0
2017-01-10 17:00:00	SPY	ETF	226.44	226.47	226.34	226.35	122592.0
2017-01-10 17:30:00	SPY	ETF	226.38	226.42	226.36	226.4	127441.0
2017-01-10 18:00:00	SPY	ETF	226.4	226.48	226.34	226.4	244517.0
2017-01-10 18:30:00	SPY	ETF	226.4	226.44	226.33	226.39	107542.0
2017-01-10 19:00:00	SPY	ETF	226.4	226.47	226.38	226.38	13800.0
2017-01-10 19:30:00	SPY	ETF	226.44	226.52	226.42	226.46	50408.0
2017-01-10 05:30:00	QQQ	ETF	122.43	122.45	122.43	122.45	298.0
2017-01-10 06:30:00	QQQ	ETF	122.42	122.42	122.42	122.42	878.0
2017-01-10 07:00:00	QQQ	ETF	122.38	122.42	122.38	122.41	1550.0
2017-01-10 07:30:00	QQQ	ETF	122.43	122.43	122.41	122.42	30000.0
2017-01-10 08:00:00	QQQ	ETF	122.42	122.42	122.35	122.35	53945.0
2017-01-10 08:30:00	QQQ	ETF	122.32	122.39	122.32	122.35	9600.0
2017-01-10 09:00:00	QQQ	ETF	122.35	122.42	122.34	122.35	32019.0
2017-01-10 09:30:00	QQQ	ETF	122.37	122.5	122.1	122.29	2732122.0
2017-01-10 10:00:00	QQQ	ETF	122.28	122.41	122.19	122.3	1080433.0
2017-01-10 10:30:00	QQQ	ETF	122.3	122.51	122.29	122.47	931495.0
2017-01-10 11:00:00	QQQ	ETF	122.47	122.82	122.45	122.78	1600071.0
2017-01-10 11:30:00	QQQ	ETF	122.78	122.95	122.74	122.84	883164.0
2017-01-10 12:00:00	QQQ	ETF	122.85	122.97	122.84	122.88	716788.0
2017-01-10 12:30:00	QQQ	ETF	122.88	122.93	122.78	122.7999	461009.0
2017-01-10 13:00:00	QQQ	ETF	122.7939	122.85	122.77	122.78	410170.0
2017-01-10 13:30:00	QQQ	ETF	122.78	122.9	122.56	122.59	775240.0
2017-01-10 14:00:00	QQQ	ETF	122.59	122.7	122.5	122.57	1062113.0
2017-01-10 14:30:00	QQQ	ETF	122.5701	122.72	122.56	122.63	1005862.0
2017-01-10 15:00:00	QQQ	ETF	122.63	122.69	122.59	122.63	887415.0
2017-01-10 15:30:00	QQQ	ETF	122.625	122.81	122.58	122.6	1777820.0

> showing 50 of 14,594 rows — these rows as CSV

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