PREVIEW / etf_30min / 2016-12-21

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-12-21.parquet
  size:    421 KB
  rows:    14,604

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-12-21 04:00:00	SPY	ETF	226.22	226.32	226.22	226.32	700.0
2016-12-21 05:00:00	SPY	ETF	226.27	226.33	226.27	226.33	3300.0
2016-12-21 05:30:00	SPY	ETF	226.28	226.28	226.25	226.25	2902.0
2016-12-21 06:00:00	SPY	ETF	226.23	226.23	226.16	226.16	1203.0
2016-12-21 06:30:00	SPY	ETF	226.15	226.24	226.1	226.1	1207.0
2016-12-21 07:00:00	SPY	ETF	226.1	226.15	226.02	226.07	47103.0
2016-12-21 07:30:00	SPY	ETF	226.1	226.2	226.04	226.19	94893.0
2016-12-21 08:00:00	SPY	ETF	226.07	226.23	226.05	226.15	85154.0
2016-12-21 08:30:00	SPY	ETF	226.19	226.27	226.14	226.22	63235.0
2016-12-21 09:00:00	SPY	ETF	226.21	226.32	226.21	226.27	132485.0
2016-12-21 09:30:00	SPY	ETF	226.25	226.45	226.07	226.14	4569489.0
2016-12-21 10:00:00	SPY	ETF	226.1467	226.24	226.08	226.1325	5863798.0
2016-12-21 10:30:00	SPY	ETF	226.13	226.24	225.99	225.995	4509577.0
2016-12-21 11:00:00	SPY	ETF	226.0	226.14	225.97	226.1	3476218.0
2016-12-21 11:30:00	SPY	ETF	226.11	226.19	226.06	226.11	3094748.0
2016-12-21 12:00:00	SPY	ETF	226.12	226.22	226.1	226.2005	4558043.0
2016-12-21 12:30:00	SPY	ETF	226.205	226.25	226.16	226.16	3206608.0
2016-12-21 13:00:00	SPY	ETF	226.16	226.23	226.06	226.105	1423928.0
2016-12-21 13:30:00	SPY	ETF	226.105	226.19	226.05	226.0799	1617514.0
2016-12-21 14:00:00	SPY	ETF	226.07	226.22	226.07	226.1558	4066280.0
2016-12-21 14:30:00	SPY	ETF	226.16	226.2	226.1	226.1894	3081617.0
2016-12-21 15:00:00	SPY	ETF	226.18	226.21	225.94	226.0	6607409.0
2016-12-21 15:30:00	SPY	ETF	225.9942	226.01	225.77	225.81	9319699.0
2016-12-21 16:00:00	SPY	ETF	225.82	225.88	225.68	225.69	5673058.0
2016-12-21 16:30:00	SPY	ETF	225.69	225.77	225.55	225.58	5385435.0
2016-12-21 17:00:00	SPY	ETF	225.58	225.62	225.57	225.6	16159.0
2016-12-21 17:30:00	SPY	ETF	225.58	225.77	225.57	225.58	44002.0
2016-12-21 18:00:00	SPY	ETF	225.61	225.68	225.59	225.65	41353.0
2016-12-21 18:30:00	SPY	ETF	225.66	225.67	225.63	225.64	6679.0
2016-12-21 19:00:00	SPY	ETF	225.65	225.65	225.58	225.58	14729.0
2016-12-21 19:30:00	SPY	ETF	225.58	225.63	225.54	225.62	29414.0
2016-12-21 04:30:00	QQQ	ETF	120.65	120.65	120.65	120.65	300.0
2016-12-21 05:30:00	QQQ	ETF	120.61	120.61	120.61	120.61	700.0
2016-12-21 06:00:00	QQQ	ETF	120.52	120.52	120.49	120.49	2099.0
2016-12-21 06:30:00	QQQ	ETF	120.54	120.54	120.54	120.54	1600.0
2016-12-21 07:00:00	QQQ	ETF	120.52	120.52	120.46	120.46	1250.0
2016-12-21 07:30:00	QQQ	ETF	120.46	120.46	120.46	120.46	1000.0
2016-12-21 08:00:00	QQQ	ETF	120.53	120.56	120.53	120.55	8229.0
2016-12-21 08:30:00	QQQ	ETF	120.57	120.6	120.57	120.6	6622.0
2016-12-21 09:00:00	QQQ	ETF	120.64	120.65	120.59	120.59	13330.0
2016-12-21 09:30:00	QQQ	ETF	120.57	120.68	120.39	120.425	812834.0
2016-12-21 10:00:00	QQQ	ETF	120.425	120.53	120.3	120.4219	605916.0
2016-12-21 10:30:00	QQQ	ETF	120.425	120.53	120.19	120.21	576333.0
2016-12-21 11:00:00	QQQ	ETF	120.22	120.3	120.2	120.27	452861.0
2016-12-21 11:30:00	QQQ	ETF	120.27	120.43	120.27	120.4163	379994.0
2016-12-21 12:00:00	QQQ	ETF	120.42	120.49	120.4101	120.49	394859.0
2016-12-21 12:30:00	QQQ	ETF	120.48	120.52	120.45	120.46	263268.0
2016-12-21 13:00:00	QQQ	ETF	120.46	120.53	120.4135	120.48	226897.0
2016-12-21 13:30:00	QQQ	ETF	120.48	120.56	120.45	120.4942	263314.0
2016-12-21 14:00:00	QQQ	ETF	120.4999	120.61	120.49	120.56	175219.0

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

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