PREVIEW / etf_30min / 2017-02-23

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-02-23.parquet
  size:    432 KB
  rows:    14,887

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
2017-02-23 04:00:00	SPY	ETF	236.27	236.46	236.27	236.46	488.0
2017-02-23 04:30:00	SPY	ETF	236.5	236.58	236.5	236.58	3325.0
2017-02-23 05:00:00	SPY	ETF	236.49	236.49	236.44	236.47	1700.0
2017-02-23 05:30:00	SPY	ETF	236.52	236.52	236.47	236.47	700.0
2017-02-23 06:00:00	SPY	ETF	236.38	236.42	236.38	236.39	2600.0
2017-02-23 06:30:00	SPY	ETF	236.37	236.45	236.37	236.45	25600.0
2017-02-23 07:00:00	SPY	ETF	236.46	236.58	236.36	236.48	51750.0
2017-02-23 07:30:00	SPY	ETF	236.46	236.7	236.45	236.64	59960.0
2017-02-23 08:00:00	SPY	ETF	236.44	236.68	236.42	236.63	175948.0
2017-02-23 08:30:00	SPY	ETF	236.63	236.75	236.59	236.72	161034.0
2017-02-23 09:00:00	SPY	ETF	236.73	236.99	236.7	236.87	355558.0
2017-02-23 09:30:00	SPY	ETF	236.88	236.9	236.52	236.68	7508570.0
2017-02-23 10:00:00	SPY	ETF	236.69	236.71	236.08	236.15	7544486.0
2017-02-23 10:30:00	SPY	ETF	236.15	236.31	235.76	235.91	6273846.0
2017-02-23 11:00:00	SPY	ETF	235.92	236.06	235.56	235.8	6849783.0
2017-02-23 11:30:00	SPY	ETF	235.79	236.22	235.79	236.04	4528892.0
2017-02-23 12:00:00	SPY	ETF	236.04	236.49	235.995	236.38	4274691.0
2017-02-23 12:30:00	SPY	ETF	236.385	236.6	236.36	236.375	3377033.0
2017-02-23 13:00:00	SPY	ETF	236.37	236.435	236.22	236.235	2905687.0
2017-02-23 13:30:00	SPY	ETF	236.24	236.46	236.2	236.45	2715789.0
2017-02-23 14:00:00	SPY	ETF	236.4401	236.52	236.37	236.485	2635998.0
2017-02-23 14:30:00	SPY	ETF	236.48	236.68	236.43	236.62	3171106.0
2017-02-23 15:00:00	SPY	ETF	236.62	236.71	236.44	236.45	3998216.0
2017-02-23 15:30:00	SPY	ETF	236.4419	236.49	236.25	236.45	10349328.0
2017-02-23 16:00:00	SPY	ETF	236.45	236.63	236.35	236.54	4707159.0
2017-02-23 16:30:00	SPY	ETF	236.56	236.56	236.37	236.48	273027.0
2017-02-23 17:00:00	SPY	ETF	236.46	236.5	236.44	236.46	106598.0
2017-02-23 17:30:00	SPY	ETF	236.46	236.5	236.41	236.41	84830.0
2017-02-23 18:00:00	SPY	ETF	236.41	236.41	236.27	236.29	1687560.0
2017-02-23 18:30:00	SPY	ETF	236.27	236.28	236.26	236.26	12627.0
2017-02-23 19:00:00	SPY	ETF	236.25	236.34	236.23	236.32	16625.0
2017-02-23 19:30:00	SPY	ETF	236.32	236.39	236.32	236.37	20016.0
2017-02-23 04:30:00	QQQ	ETF	130.57	130.57	130.57	130.57	1000.0
2017-02-23 05:00:00	QQQ	ETF	130.48	130.48	130.48	130.48	1000.0
2017-02-23 07:00:00	QQQ	ETF	130.56	130.56	130.52	130.54	5278.0
2017-02-23 07:30:00	QQQ	ETF	130.59	130.59	130.54	130.56	7450.0
2017-02-23 08:00:00	QQQ	ETF	130.59	130.6	130.54	130.6	45335.0
2017-02-23 08:30:00	QQQ	ETF	130.61	130.61	130.58	130.59	18679.0
2017-02-23 09:00:00	QQQ	ETF	130.6	130.73	130.6	130.67	137417.0
2017-02-23 09:30:00	QQQ	ETF	130.7	130.7	130.2	130.36	1821006.0
2017-02-23 10:00:00	QQQ	ETF	130.37	130.38	129.93	130.0121	1792190.0
2017-02-23 10:30:00	QQQ	ETF	130.0173	130.1	129.71	129.78	1666724.0
2017-02-23 11:00:00	QQQ	ETF	129.7847	129.81	129.49	129.65	1883908.0
2017-02-23 11:30:00	QQQ	ETF	129.645	129.9	129.64	129.8	1216919.0
2017-02-23 12:00:00	QQQ	ETF	129.81	129.97	129.76	129.925	1006174.0
2017-02-23 12:30:00	QQQ	ETF	129.9273	130.03	129.9036	129.93	577242.0
2017-02-23 13:00:00	QQQ	ETF	129.93	130.01	129.8485	129.85	508817.0
2017-02-23 13:30:00	QQQ	ETF	129.85	129.98	129.8456	129.96	582018.0
2017-02-23 14:00:00	QQQ	ETF	129.96	130.06	129.91	129.99	444816.0
2017-02-23 14:30:00	QQQ	ETF	129.98	130.11	129.95	130.07	401869.0

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

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