PREVIEW / etf_30min / 2017-02-08

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-02-08.parquet
  size:    434 KB
  rows:    14,759

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-08 04:00:00	SPY	ETF	228.83	229.04	228.82	229.02	930.0
2017-02-08 04:30:00	SPY	ETF	229.0	229.26	229.0	229.26	5500.0
2017-02-08 05:00:00	SPY	ETF	229.28	229.28	229.2	229.24	9800.0
2017-02-08 05:30:00	SPY	ETF	229.17	229.2	229.06	229.08	3300.0
2017-02-08 06:00:00	SPY	ETF	229.13	229.13	229.13	229.13	1500.0
2017-02-08 06:30:00	SPY	ETF	229.15	229.15	229.02	229.02	5000.0
2017-02-08 07:00:00	SPY	ETF	229.04	229.13	229.01	229.01	61381.0
2017-02-08 07:30:00	SPY	ETF	229.02	229.02	228.72	228.72	183700.0
2017-02-08 08:00:00	SPY	ETF	228.75	229.05	228.68	228.69	141133.0
2017-02-08 08:30:00	SPY	ETF	228.71	228.77	228.58	228.75	140193.0
2017-02-08 09:00:00	SPY	ETF	228.75	228.75	228.51	228.6	489100.0
2017-02-08 09:30:00	SPY	ETF	228.61	228.68	228.31	228.5501	5582141.0
2017-02-08 10:00:00	SPY	ETF	228.55	228.84	228.47	228.69	3719275.0
2017-02-08 10:30:00	SPY	ETF	228.69	229.07	228.53	228.97	5241509.0
2017-02-08 11:00:00	SPY	ETF	228.99	229.24	228.96	229.09	4078227.0
2017-02-08 11:30:00	SPY	ETF	229.09	229.1585	228.83	228.86	2678621.0
2017-02-08 12:00:00	SPY	ETF	228.86	229.1	228.85	228.9701	2445009.0
2017-02-08 12:30:00	SPY	ETF	228.9701	228.99	228.82	228.94	2176773.0
2017-02-08 13:00:00	SPY	ETF	228.94	229.17	228.9301	229.125	1669204.0
2017-02-08 13:30:00	SPY	ETF	229.13	229.28	229.0834	229.21	1349809.0
2017-02-08 14:00:00	SPY	ETF	229.21	229.25	229.1	229.16	1479704.0
2017-02-08 14:30:00	SPY	ETF	229.16	229.29	229.15	229.19	2102836.0
2017-02-08 15:00:00	SPY	ETF	229.19	229.34	229.06	229.32	3223418.0
2017-02-08 15:30:00	SPY	ETF	229.3173	229.39	229.2	229.26	7939225.0
2017-02-08 16:00:00	SPY	ETF	229.27	229.33	229.18	229.19	6000684.0
2017-02-08 16:30:00	SPY	ETF	229.19	229.28	229.19	229.24	154001.0
2017-02-08 17:00:00	SPY	ETF	229.23	229.33	229.2	229.21	94868.0
2017-02-08 17:30:00	SPY	ETF	229.24	229.27	229.22	229.27	5394.0
2017-02-08 18:00:00	SPY	ETF	229.25	229.32	229.24	229.32	12794.0
2017-02-08 18:30:00	SPY	ETF	229.28	229.29	229.24	229.25	7302.0
2017-02-08 19:00:00	SPY	ETF	229.25	229.25	229.13	229.16	150510.0
2017-02-08 19:30:00	SPY	ETF	229.18	229.2	229.16	229.17	8834.0
2017-02-08 04:30:00	QQQ	ETF	126.33	126.43	126.32	126.43	4446.0
2017-02-08 05:00:00	QQQ	ETF	126.41	126.41	126.41	126.41	335.0
2017-02-08 05:30:00	QQQ	ETF	126.35	126.35	126.35	126.35	487.0
2017-02-08 07:00:00	QQQ	ETF	126.29	126.33	126.29	126.31	6500.0
2017-02-08 07:30:00	QQQ	ETF	126.27	126.3	126.25	126.25	58979.0
2017-02-08 08:00:00	QQQ	ETF	126.27	126.27	126.17	126.18	68602.0
2017-02-08 08:30:00	QQQ	ETF	126.17	126.19	126.14	126.19	31095.0
2017-02-08 09:00:00	QQQ	ETF	126.16	126.16	126.08	126.11	55283.0
2017-02-08 09:30:00	QQQ	ETF	126.11	126.155	125.88	126.08	1502704.0
2017-02-08 10:00:00	QQQ	ETF	126.08	126.36	126.05	126.31	791473.0
2017-02-08 10:30:00	QQQ	ETF	126.31	126.54	126.2101	126.48	1433549.0
2017-02-08 11:00:00	QQQ	ETF	126.4861	126.57	126.43	126.45	808250.0
2017-02-08 11:30:00	QQQ	ETF	126.449	126.49	126.374	126.44	542219.0
2017-02-08 12:00:00	QQQ	ETF	126.44	126.55	126.41	126.445	392933.0
2017-02-08 12:30:00	QQQ	ETF	126.44	126.44	126.34	126.43	468968.0
2017-02-08 13:00:00	QQQ	ETF	126.44	126.525	126.43	126.5	315273.0
2017-02-08 13:30:00	QQQ	ETF	126.495	126.58	126.47	126.54	380065.0
2017-02-08 14:00:00	QQQ	ETF	126.54	126.625	126.5	126.5587	426460.0

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

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