PREVIEW / etf_30min / 2017-12-08

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-12-08.parquet
  size:    446 KB
  rows:    15,452

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-12-08 04:00:00	SPY	ETF	264.61	264.66	264.57	264.66	4492.0
2017-12-08 04:30:00	SPY	ETF	264.64	264.8	264.64	264.77	1675.0
2017-12-08 05:00:00	SPY	ETF	264.82	264.96	264.8	264.92	4450.0
2017-12-08 05:30:00	SPY	ETF	264.9	264.95	264.85	264.85	500.0
2017-12-08 06:00:00	SPY	ETF	264.84	264.86	264.8	264.84	7700.0
2017-12-08 06:30:00	SPY	ETF	264.84	264.84	264.71	264.72	8514.0
2017-12-08 07:00:00	SPY	ETF	264.65	264.83	264.64	264.7	84982.0
2017-12-08 07:30:00	SPY	ETF	264.68	264.74	264.63	264.7	48765.0
2017-12-08 08:00:00	SPY	ETF	264.73	264.94	264.66	264.91	85075.0
2017-12-08 08:30:00	SPY	ETF	264.92	265.24	264.88	265.15	911485.0
2017-12-08 09:00:00	SPY	ETF	265.13	265.16	264.25	265.0	425237.0
2017-12-08 09:30:00	SPY	ETF	264.99	265.19	264.82	265.05	7422763.0
2017-12-08 10:00:00	SPY	ETF	265.05	265.09	264.72	264.95	4763338.0
2017-12-08 10:30:00	SPY	ETF	264.96	265.14	264.91	265.14	3572158.0
2017-12-08 11:00:00	SPY	ETF	265.14	265.235	264.89	264.96	2945940.0
2017-12-08 11:30:00	SPY	ETF	264.96	265.22	264.79	265.08	2870446.0
2017-12-08 12:00:00	SPY	ETF	265.085	265.47	265.07	265.4056	4499146.0
2017-12-08 12:30:00	SPY	ETF	265.41	265.5	265.28	265.305	3056434.0
2017-12-08 13:00:00	SPY	ETF	265.3	265.52	265.27	265.42	3598118.0
2017-12-08 13:30:00	SPY	ETF	265.42	265.46	265.25	265.35	2123846.0
2017-12-08 14:00:00	SPY	ETF	265.35	265.36	264.97	265.1235	2407282.0
2017-12-08 14:30:00	SPY	ETF	265.13	265.21	264.95	265.125	3433003.0
2017-12-08 15:00:00	SPY	ETF	265.13	265.28	265.02	265.24	4723165.0
2017-12-08 15:30:00	SPY	ETF	265.24	265.5	265.06	265.49	14139593.0
2017-12-08 16:00:00	SPY	ETF	265.5	265.51	265.3	265.47	11325679.0
2017-12-08 16:30:00	SPY	ETF	265.47	265.53	264.0315	265.5	1091184.0
2017-12-08 17:00:00	SPY	ETF	265.49	265.59	265.49	265.59	1241599.0
2017-12-08 17:30:00	SPY	ETF	265.56	265.61	265.0214	265.57	247746.0
2017-12-08 18:00:00	SPY	ETF	265.57	265.61	265.56	265.59	4730.0
2017-12-08 18:30:00	SPY	ETF	265.59	265.61	265.56	265.56	3902.0
2017-12-08 19:00:00	SPY	ETF	265.56	265.62	265.56	265.61	3763.0
2017-12-08 19:30:00	SPY	ETF	265.6	265.73	265.6	265.73	17986.0
2017-12-08 04:00:00	QQQ	ETF	154.7	154.84	154.7	154.81	19312.0
2017-12-08 04:30:00	QQQ	ETF	154.83	154.91	154.82	154.91	1500.0
2017-12-08 05:00:00	QQQ	ETF	154.95	154.99	154.9	154.9	1700.0
2017-12-08 05:30:00	QQQ	ETF	154.94	154.97	154.94	154.97	4600.0
2017-12-08 06:00:00	QQQ	ETF	154.88	154.97	154.88	154.94	6450.0
2017-12-08 06:30:00	QQQ	ETF	154.91	154.91	154.76	154.78	22362.0
2017-12-08 07:00:00	QQQ	ETF	154.74	154.86	154.74	154.8	58805.0
2017-12-08 07:30:00	QQQ	ETF	154.79	154.97	154.78	154.91	121811.0
2017-12-08 08:00:00	QQQ	ETF	154.88	154.92	154.76	154.85	43961.0
2017-12-08 08:30:00	QQQ	ETF	154.89	155.23	154.87	155.15	476090.0
2017-12-08 09:00:00	QQQ	ETF	155.15	155.2	155.12	155.14	168859.0
2017-12-08 09:30:00	QQQ	ETF	155.1	155.53	155.1	155.28	4643781.0
2017-12-08 10:00:00	QQQ	ETF	155.27	155.4	155.16	155.28	1780155.0
2017-12-08 10:30:00	QQQ	ETF	155.29	155.34	155.14	155.26	1195209.0
2017-12-08 11:00:00	QQQ	ETF	155.27	155.35	154.8215	154.89	1699551.0
2017-12-08 11:30:00	QQQ	ETF	154.89	154.9999	154.65	154.87	1375126.0
2017-12-08 12:00:00	QQQ	ETF	154.87	155.19	154.82	155.18	827033.0
2017-12-08 12:30:00	QQQ	ETF	155.18	155.22	154.96	154.99	742030.0

> showing 50 of 15,452 rows — these rows as CSV

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