PREVIEW / etf_30min / 2016-09-27

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-09-27.parquet
  size:    397 KB
  rows:    13,587

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-09-27 04:00:00	SPY	ETF	215.02	215.26	215.02	215.2	38692.0
2016-09-27 04:30:00	SPY	ETF	215.19	215.19	214.81	214.81	10207.0
2016-09-27 05:00:00	SPY	ETF	214.8	214.85	214.45	214.58	17898.0
2016-09-27 05:30:00	SPY	ETF	214.51	214.73	214.46	214.69	4144.0
2016-09-27 06:00:00	SPY	ETF	214.62	214.68	214.57	214.66	41580.0
2016-09-27 06:30:00	SPY	ETF	214.68	214.84	214.63	214.84	34030.0
2016-09-27 07:00:00	SPY	ETF	214.84	214.93	214.64	214.7	173160.0
2016-09-27 07:30:00	SPY	ETF	214.71	214.74	214.6	214.69	113456.0
2016-09-27 08:00:00	SPY	ETF	214.61	214.82	214.45	214.48	260809.0
2016-09-27 08:30:00	SPY	ETF	214.44	214.55	214.15	214.3	491795.0
2016-09-27 09:00:00	SPY	ETF	214.3	214.31	213.84	214.05	958879.0
2016-09-27 09:30:00	SPY	ETF	214.05	214.71	213.62	214.69	10299992.0
2016-09-27 10:00:00	SPY	ETF	214.69	215.13	214.68	214.83	6780691.0
2016-09-27 10:30:00	SPY	ETF	214.82	214.85	214.16	214.265	5169684.0
2016-09-27 11:00:00	SPY	ETF	214.26	214.95	214.26	214.89	3600979.0
2016-09-27 11:30:00	SPY	ETF	214.89	215.11	214.85	215.0	4717272.0
2016-09-27 12:00:00	SPY	ETF	214.99	215.5707	214.85	215.43	6151691.0
2016-09-27 12:30:00	SPY	ETF	215.44	215.51	215.28	215.49	3101472.0
2016-09-27 13:00:00	SPY	ETF	215.49	215.6	215.34	215.54	3462444.0
2016-09-27 13:30:00	SPY	ETF	215.55	215.68	215.39	215.47	2948640.0
2016-09-27 14:00:00	SPY	ETF	215.47	215.58	215.35	215.52	4311913.0
2016-09-27 14:30:00	SPY	ETF	215.51	215.575	215.29	215.37	2913728.0
2016-09-27 15:00:00	SPY	ETF	215.38	215.52	215.23	215.34	3551698.0
2016-09-27 15:30:00	SPY	ETF	215.345	215.55	215.17	215.55	9989154.0
2016-09-27 16:00:00	SPY	ETF	215.56	215.67	215.3415	215.51	3771223.0
2016-09-27 16:30:00	SPY	ETF	215.52	215.57	215.47	215.47	3809787.0
2016-09-27 17:00:00	SPY	ETF	215.46	215.47	215.42	215.44	41568.0
2016-09-27 17:30:00	SPY	ETF	215.44	215.49	215.44	215.49	50790.0
2016-09-27 18:00:00	SPY	ETF	215.48	215.48	215.36	215.37	47214.0
2016-09-27 18:30:00	SPY	ETF	215.48	215.57	215.46	215.52	20717.0
2016-09-27 19:00:00	SPY	ETF	215.53	215.57	215.32	215.33	499764.0
2016-09-27 19:30:00	SPY	ETF	215.37	215.6	215.32	215.44	34630.0
2016-09-27 04:00:00	QQQ	ETF	117.69	117.82	117.69	117.82	15800.0
2016-09-27 04:30:00	QQQ	ETF	117.8	117.81	117.67	117.67	10100.0
2016-09-27 05:00:00	QQQ	ETF	117.57	117.57	117.52	117.53	10249.0
2016-09-27 05:30:00	QQQ	ETF	117.59	117.59	117.55	117.55	1200.0
2016-09-27 06:00:00	QQQ	ETF	117.54	117.54	117.54	117.54	250.0
2016-09-27 06:30:00	QQQ	ETF	117.62	117.65	117.62	117.65	17499.0
2016-09-27 07:00:00	QQQ	ETF	117.7	117.7	117.67	117.67	600.0
2016-09-27 07:30:00	QQQ	ETF	117.6	117.6	117.52	117.52	4128.0
2016-09-27 08:00:00	QQQ	ETF	117.58	117.64	117.48	117.49	68132.0
2016-09-27 08:30:00	QQQ	ETF	117.46	117.48	117.34	117.43	126704.0
2016-09-27 09:00:00	QQQ	ETF	117.38	117.38	117.23	117.32	276353.0
2016-09-27 09:30:00	QQQ	ETF	117.31	117.98	117.15	117.955	2597245.0
2016-09-27 10:00:00	QQQ	ETF	117.96	118.205	117.92	118.04	1455629.0
2016-09-27 10:30:00	QQQ	ETF	118.05	118.07	117.73	117.77	1124895.0
2016-09-27 11:00:00	QQQ	ETF	117.78	118.15	117.735	118.11	738144.0
2016-09-27 11:30:00	QQQ	ETF	118.105	118.19	118.06	118.12	664145.0
2016-09-27 12:00:00	QQQ	ETF	118.12	118.44	118.03	118.33	811927.0
2016-09-27 12:30:00	QQQ	ETF	118.3507	118.37	118.26	118.36	763124.0

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

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