PREVIEW / etf_30min / 2015-02-09

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-02-09.parquet
  size:    375 KB
  rows:    12,725

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-09 04:00:00	SPY	ETF	204.85	204.85	204.54	204.54	51571.0
2015-02-09 04:30:00	SPY	ETF	204.63	204.74	204.51	204.59	54322.0
2015-02-09 05:00:00	SPY	ETF	204.5	204.86	204.45	204.8	45989.0
2015-02-09 05:30:00	SPY	ETF	204.81	204.99	204.77	204.81	35616.0
2015-02-09 06:00:00	SPY	ETF	204.86	204.86	204.72	204.81	65764.0
2015-02-09 06:30:00	SPY	ETF	204.78	204.78	204.46	204.49	63350.0
2015-02-09 07:00:00	SPY	ETF	204.45	204.69	204.43	204.62	138575.0
2015-02-09 07:30:00	SPY	ETF	204.63	204.93	204.57	204.86	207046.0
2015-02-09 08:00:00	SPY	ETF	204.87	204.93	204.45	204.75	452541.0
2015-02-09 08:30:00	SPY	ETF	204.75	204.75	204.37	204.69	755921.0
2015-02-09 09:00:00	SPY	ETF	204.72	204.84	204.61	204.75	649115.0
2015-02-09 09:30:00	SPY	ETF	204.77	205.6	204.72	205.34	12507319.0
2015-02-09 10:00:00	SPY	ETF	205.35	205.49	204.93	204.93	7086000.0
2015-02-09 10:30:00	SPY	ETF	204.93	205.3	204.69	204.76	5395152.0
2015-02-09 11:00:00	SPY	ETF	204.755	205.53	204.73	205.44	5319845.0
2015-02-09 11:30:00	SPY	ETF	205.46	205.505	205.22	205.27	2918482.0
2015-02-09 12:00:00	SPY	ETF	205.27	205.45	205.09	205.441	3123416.0
2015-02-09 12:30:00	SPY	ETF	205.45	205.64	205.22	205.285	3573735.0
2015-02-09 13:00:00	SPY	ETF	205.285	205.43	205.06	205.07	2562364.0
2015-02-09 13:30:00	SPY	ETF	205.06	205.09	204.81	205.03	5201021.0
2015-02-09 14:00:00	SPY	ETF	205.04	205.06	204.59	204.88	4422290.0
2015-02-09 14:30:00	SPY	ETF	204.89	205.04	204.53	204.56	3599171.0
2015-02-09 15:00:00	SPY	ETF	204.57	204.66	204.135	204.645	7547310.0
2015-02-09 15:30:00	SPY	ETF	204.65	204.93	204.33	204.59	13318947.0
2015-02-09 16:00:00	SPY	ETF	204.59	205.1161	204.5	204.75	4748471.0
2015-02-09 16:30:00	SPY	ETF	204.76	204.85	204.76	204.78	1836842.0
2015-02-09 17:00:00	SPY	ETF	204.78	204.87	204.76	204.82	573631.0
2015-02-09 17:30:00	SPY	ETF	204.82	204.85	204.63	204.82	13194.0
2015-02-09 18:00:00	SPY	ETF	204.84	204.98	204.84	204.91	53105.0
2015-02-09 18:30:00	SPY	ETF	204.92	205.0	204.92	204.96	24650.0
2015-02-09 19:00:00	SPY	ETF	204.99	205.03	204.97	204.97	10512.0
2015-02-09 19:30:00	SPY	ETF	204.97	204.98	204.86	204.94	43469.0
2015-02-09 04:00:00	QQQ	ETF	102.73	102.73	102.65	102.65	7100.0
2015-02-09 05:00:00	QQQ	ETF	102.64	102.75	102.64	102.75	700.0
2015-02-09 05:30:00	QQQ	ETF	102.79	103.46	102.74	103.46	15600.0
2015-02-09 06:30:00	QQQ	ETF	102.67	102.67	102.6	102.6	7900.0
2015-02-09 07:00:00	QQQ	ETF	102.6	102.69	102.6	102.655	36682.0
2015-02-09 07:30:00	QQQ	ETF	102.66	102.83	102.635	102.81	76178.0
2015-02-09 08:00:00	QQQ	ETF	102.81	102.83	102.67	102.74	55176.0
2015-02-09 08:30:00	QQQ	ETF	102.75	102.75	102.57	102.68	69269.0
2015-02-09 09:00:00	QQQ	ETF	102.69	102.77	102.65	102.72	127430.0
2015-02-09 09:30:00	QQQ	ETF	102.72	103.13	102.67	102.98	3193177.0
2015-02-09 10:00:00	QQQ	ETF	102.97	103.07	102.726	102.76	1302739.0
2015-02-09 10:30:00	QQQ	ETF	102.75	102.92	102.55	102.6	1208987.0
2015-02-09 11:00:00	QQQ	ETF	102.6	103.12	102.6	103.09	1238444.0
2015-02-09 11:30:00	QQQ	ETF	103.081	103.12	102.97	102.98	641528.0
2015-02-09 12:00:00	QQQ	ETF	102.98	103.2	102.92	103.2	1722605.0
2015-02-09 12:30:00	QQQ	ETF	103.2	103.285	103.1201	103.17	2023567.0
2015-02-09 13:00:00	QQQ	ETF	103.165	103.24	103.045	103.045	1542070.0
2015-02-09 13:30:00	QQQ	ETF	103.04	103.07	102.925	103.0	1359608.0

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

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