PREVIEW / etf_30min / 2016-03-23

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-03-23.parquet
  size:    384 KB
  rows:    13,083

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-03-23 04:00:00	SPY	ETF	204.66	204.97	204.63	204.96	31200.0
2016-03-23 04:30:00	SPY	ETF	204.96	204.96	204.72	204.72	3107.0
2016-03-23 05:00:00	SPY	ETF	204.94	204.94	204.67	204.67	1743.0
2016-03-23 05:30:00	SPY	ETF	204.77	204.88	204.77	204.84	4915.0
2016-03-23 06:00:00	SPY	ETF	204.79	204.82	204.69	204.8	5189.0
2016-03-23 06:30:00	SPY	ETF	204.71	204.73	204.65	204.65	25751.0
2016-03-23 07:00:00	SPY	ETF	204.71	204.8	204.7	204.8	25631.0
2016-03-23 07:30:00	SPY	ETF	204.8	204.9	204.8	204.85	255192.0
2016-03-23 08:00:00	SPY	ETF	204.87	204.94	204.455	204.7	192918.0
2016-03-23 08:30:00	SPY	ETF	204.68	204.69	204.51	204.55	303205.0
2016-03-23 09:00:00	SPY	ETF	204.53	204.55	203.99	204.11	704199.0
2016-03-23 09:30:00	SPY	ETF	204.11	204.21	203.73	203.89	8288843.0
2016-03-23 10:00:00	SPY	ETF	203.89	204.11	203.66	204.04	6251588.0
2016-03-23 10:30:00	SPY	ETF	204.03	204.33	203.63	203.87	6925540.0
2016-03-23 11:00:00	SPY	ETF	203.88	204.06	203.56	203.65	5865480.0
2016-03-23 11:30:00	SPY	ETF	203.65	203.72	203.36	203.55	5203341.0
2016-03-23 12:00:00	SPY	ETF	203.55	203.95	203.49	203.95	4200245.0
2016-03-23 12:30:00	SPY	ETF	203.94	204.06	203.78	203.89	3619228.0
2016-03-23 13:00:00	SPY	ETF	203.89	204.0	203.73	203.845	1957535.0
2016-03-23 13:30:00	SPY	ETF	203.85	203.85	203.63	203.819	1753246.0
2016-03-23 14:00:00	SPY	ETF	203.819	204.08	203.67	203.705	3729520.0
2016-03-23 14:30:00	SPY	ETF	203.71	203.88	203.15	203.22	6433909.0
2016-03-23 15:00:00	SPY	ETF	203.21	203.32	203.01	203.2	6038436.0
2016-03-23 15:30:00	SPY	ETF	203.2	203.47	203.14	203.24	11241372.0
2016-03-23 16:00:00	SPY	ETF	203.25	203.48	203.21	203.39	5825784.0
2016-03-23 16:30:00	SPY	ETF	203.38	203.659	203.2092	203.29	483289.0
2016-03-23 17:00:00	SPY	ETF	203.32	203.36	203.2092	203.32	563975.0
2016-03-23 17:30:00	SPY	ETF	203.31	203.34	203.27	203.3	24443.0
2016-03-23 18:00:00	SPY	ETF	203.28	203.28	203.2	203.24	54291.0
2016-03-23 18:30:00	SPY	ETF	203.25	203.28	203.18	203.22	23678.0
2016-03-23 19:00:00	SPY	ETF	203.25	203.32	203.17	203.23	19456.0
2016-03-23 19:30:00	SPY	ETF	203.23	203.28	203.18	203.26	41871.0
2016-03-23 04:00:00	QQQ	ETF	108.22	108.22	108.21	108.21	2100.0
2016-03-23 04:30:00	QQQ	ETF	108.26	108.26	108.26	108.26	200.0
2016-03-23 06:00:00	QQQ	ETF	108.2	108.2	108.2	108.2	600.0
2016-03-23 07:00:00	QQQ	ETF	108.22	108.22	108.21	108.21	2100.0
2016-03-23 07:30:00	QQQ	ETF	108.3	108.32	108.28	108.28	34135.0
2016-03-23 08:00:00	QQQ	ETF	108.28	108.32	108.26	108.26	6827.0
2016-03-23 08:30:00	QQQ	ETF	108.22	108.23	108.15	108.19	6074.0
2016-03-23 09:00:00	QQQ	ETF	108.14	108.14	107.89	107.9	91249.0
2016-03-23 09:30:00	QQQ	ETF	107.91	107.99	107.5399	107.6301	2255971.0
2016-03-23 10:00:00	QQQ	ETF	107.64	107.79	107.51	107.75	1742844.0
2016-03-23 10:30:00	QQQ	ETF	107.73	107.89	107.46	107.52	1742014.0
2016-03-23 11:00:00	QQQ	ETF	107.52	107.62	107.29	107.385	1924131.0
2016-03-23 11:30:00	QQQ	ETF	107.39	107.45	107.21	107.32	1463949.0
2016-03-23 12:00:00	QQQ	ETF	107.32	107.51	107.27	107.51	1084276.0
2016-03-23 12:30:00	QQQ	ETF	107.51	107.575	107.42	107.485	844952.0
2016-03-23 13:00:00	QQQ	ETF	107.485	107.6	107.398	107.54	598201.0
2016-03-23 13:30:00	QQQ	ETF	107.535	107.57	107.42	107.5	508853.0
2016-03-23 14:00:00	QQQ	ETF	107.5	107.68	107.47	107.4801	771429.0

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

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