PREVIEW / etf_30min / 2015-02-10

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-02-10.parquet
  size:    377 KB
  rows:    12,661

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
2015-02-10 04:00:00	SPY	ETF	204.77	204.8	204.59	204.63	1500.0
2015-02-10 04:30:00	SPY	ETF	204.64	204.84	204.64	204.84	2400.0
2015-02-10 05:00:00	SPY	ETF	204.9	205.14	204.84	205.05	9270.0
2015-02-10 05:30:00	SPY	ETF	205.0	205.14	204.87	204.87	12094.0
2015-02-10 06:00:00	SPY	ETF	204.84	205.17	204.84	205.08	35347.0
2015-02-10 06:30:00	SPY	ETF	205.09	205.1	204.98	205.1	117377.0
2015-02-10 07:00:00	SPY	ETF	205.12	206.36	205.12	205.99	596048.0
2015-02-10 07:30:00	SPY	ETF	205.99	206.09	205.55	205.69	442387.0
2015-02-10 08:00:00	SPY	ETF	205.65	206.2	205.11	206.2	544322.0
2015-02-10 08:30:00	SPY	ETF	206.2	206.24	204.63	205.99	296566.0
2015-02-10 09:00:00	SPY	ETF	205.98	206.11	205.85	205.88	1488409.0
2015-02-10 09:30:00	SPY	ETF	205.88	205.94	205.225	205.33	10340793.0
2015-02-10 10:00:00	SPY	ETF	205.31	205.72	205.13	205.28	6474012.0
2015-02-10 10:30:00	SPY	ETF	205.27	205.445	204.82	205.23	6869475.0
2015-02-10 11:00:00	SPY	ETF	205.24	205.65	205.1	205.615	9898634.0
2015-02-10 11:30:00	SPY	ETF	205.63	205.79	205.55	205.76	5566102.0
2015-02-10 12:00:00	SPY	ETF	205.76	206.24	205.54	206.06	4523832.0
2015-02-10 12:30:00	SPY	ETF	206.06	206.12	205.87	206.05	4395157.0
2015-02-10 13:00:00	SPY	ETF	206.05	206.2	205.77	205.89	3360523.0
2015-02-10 13:30:00	SPY	ETF	205.89	206.15	205.84	205.86	6152677.0
2015-02-10 14:00:00	SPY	ETF	205.86	206.34	205.845	206.275	3322483.0
2015-02-10 14:30:00	SPY	ETF	206.275	206.89	206.21	206.885	7408761.0
2015-02-10 15:00:00	SPY	ETF	206.89	206.99	206.68	206.98	5334125.0
2015-02-10 15:30:00	SPY	ETF	206.9899	207.12	206.72	206.81	13323421.0
2015-02-10 16:00:00	SPY	ETF	206.81	206.95	205.6522	206.74	3820071.0
2015-02-10 16:30:00	SPY	ETF	206.75	206.81	206.72	206.78	534052.0
2015-02-10 17:00:00	SPY	ETF	206.77	206.78	206.72	206.76	126246.0
2015-02-10 17:30:00	SPY	ETF	206.75	206.78	206.73	206.73	74211.0
2015-02-10 18:00:00	SPY	ETF	206.76	206.84	206.75	206.77	79051.0
2015-02-10 18:30:00	SPY	ETF	206.76	206.76	206.71	206.76	7103.0
2015-02-10 19:00:00	SPY	ETF	206.75	206.76	206.69	206.73	17677.0
2015-02-10 19:30:00	SPY	ETF	206.78	206.78	206.74	206.75	24724.0
2015-02-10 06:00:00	QQQ	ETF	103.1	103.11	103.05	103.11	3919.0
2015-02-10 06:30:00	QQQ	ETF	103.08	103.08	103.07	103.08	13600.0
2015-02-10 07:00:00	QQQ	ETF	103.19	103.69	103.19	103.54	47900.0
2015-02-10 07:30:00	QQQ	ETF	103.55	103.57	103.33	103.4	42854.0
2015-02-10 08:00:00	QQQ	ETF	103.56	103.57	103.33	103.57	58702.0
2015-02-10 08:30:00	QQQ	ETF	103.57	103.57	102.8	103.43	60858.0
2015-02-10 09:00:00	QQQ	ETF	103.43	103.5	103.38	103.38	164444.0
2015-02-10 09:30:00	QQQ	ETF	103.37	103.63	103.24	103.45	2731479.0
2015-02-10 10:00:00	QQQ	ETF	103.45	103.6	103.285	103.4	1656716.0
2015-02-10 10:30:00	QQQ	ETF	103.38	103.55	103.21	103.47	1343395.0
2015-02-10 11:00:00	QQQ	ETF	103.46	103.72	103.38	103.7	1190044.0
2015-02-10 11:30:00	QQQ	ETF	103.71	103.86	103.666	103.84	1577351.0
2015-02-10 12:00:00	QQQ	ETF	103.84	104.06	103.72	103.99	1747646.0
2015-02-10 12:30:00	QQQ	ETF	103.99	104.03	103.9	104.02	740857.0
2015-02-10 13:00:00	QQQ	ETF	104.02	104.1	103.87	103.97	1520664.0
2015-02-10 13:30:00	QQQ	ETF	103.97	104.1	103.935	103.94	511185.0
2015-02-10 14:00:00	QQQ	ETF	103.95	104.15	103.94	104.12	659588.0
2015-02-10 14:30:00	QQQ	ETF	104.12	104.42	104.08	104.42	1947652.0

> showing 50 of 12,661 rows — these rows as CSV

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