PREVIEW / etf_30min / 2018-06-29

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-06-29.parquet
  size:    471 KB
  rows:    16,343

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
2018-06-29 04:00:00	SPY	ETF	272.48	272.7	272.47	272.61	14236.0
2018-06-29 04:30:00	SPY	ETF	272.61	272.8	272.52	272.67	17740.0
2018-06-29 05:00:00	SPY	ETF	272.68	272.69	272.35	272.35	23414.0
2018-06-29 05:30:00	SPY	ETF	272.33	272.35	272.13	272.16	53495.0
2018-06-29 06:00:00	SPY	ETF	272.12	272.33	271.52	271.58	66340.0
2018-06-29 06:30:00	SPY	ETF	271.52	272.21	271.51	271.79	108934.0
2018-06-29 07:00:00	SPY	ETF	271.78	272.13	271.64	272.07	174863.0
2018-06-29 07:30:00	SPY	ETF	272.08	272.32	272.04	272.26	68125.0
2018-06-29 08:00:00	SPY	ETF	271.88	272.52	271.55	272.14	575146.0
2018-06-29 08:30:00	SPY	ETF	272.13	272.2	270.89	271.81	295546.0
2018-06-29 09:00:00	SPY	ETF	271.83	272.1	271.79	272.1	350823.0
2018-06-29 09:30:00	SPY	ETF	272.12	272.98	272.08	272.755	6877013.0
2018-06-29 10:00:00	SPY	ETF	272.755	273.15	272.54	272.77	4900901.0
2018-06-29 10:30:00	SPY	ETF	272.77	273.547	272.67	273.4045	4361478.0
2018-06-29 11:00:00	SPY	ETF	273.4	273.66	273.3	273.41	3885946.0
2018-06-29 11:30:00	SPY	ETF	273.41	273.47	272.79	272.93	3501486.0
2018-06-29 12:00:00	SPY	ETF	272.925	273.41	272.865	273.18	2264818.0
2018-06-29 12:30:00	SPY	ETF	273.17	273.2	272.62	272.84	3686738.0
2018-06-29 13:00:00	SPY	ETF	272.84	273.24	272.835	273.04	2573294.0
2018-06-29 13:30:00	SPY	ETF	273.04	273.24	272.8375	272.96	2133435.0
2018-06-29 14:00:00	SPY	ETF	272.95	273.04	272.71	272.88	2749306.0
2018-06-29 14:30:00	SPY	ETF	272.87	272.9885	272.51	272.98	3438281.0
2018-06-29 15:00:00	SPY	ETF	272.98	273.17	272.33	272.49	6116702.0
2018-06-29 15:30:00	SPY	ETF	272.49	272.56	271.19	271.19	22975270.0
2018-06-29 16:00:00	SPY	ETF	271.23	271.73	270.9481	271.41	17658868.0
2018-06-29 16:30:00	SPY	ETF	271.39	271.48	271.1546	271.23	5453721.0
2018-06-29 17:00:00	SPY	ETF	271.26	271.8	271.08	271.17	118334.0
2018-06-29 17:30:00	SPY	ETF	271.19	271.31	271.1	271.23	69507.0
2018-06-29 18:00:00	SPY	ETF	271.21	271.21	271.11	271.15	23875.0
2018-06-29 18:30:00	SPY	ETF	271.1999	271.1999	271.05	271.15	47719.0
2018-06-29 19:00:00	SPY	ETF	271.18	271.18	271.12	271.15	3976.0
2018-06-29 19:30:00	SPY	ETF	271.17	271.18	271.08	271.16	13199.0
2018-06-29 04:00:00	QQQ	ETF	172.39	172.57	172.39	172.55	22300.0
2018-06-29 04:30:00	QQQ	ETF	172.55	172.63	172.49	172.6	13713.0
2018-06-29 05:00:00	QQQ	ETF	172.6	172.6	172.43	172.43	13240.0
2018-06-29 05:30:00	QQQ	ETF	172.42	172.5	172.3	172.3	13850.0
2018-06-29 06:00:00	QQQ	ETF	172.23	172.5	171.63	171.75	40042.0
2018-06-29 06:30:00	QQQ	ETF	171.72	172.25	171.66	171.97	82141.0
2018-06-29 07:00:00	QQQ	ETF	171.95	172.12	171.83	172.09	86825.0
2018-06-29 07:30:00	QQQ	ETF	172.09	172.28	172.09	172.25	78602.0
2018-06-29 08:00:00	QQQ	ETF	172.25	172.34	171.88	172.0	154982.0
2018-06-29 08:30:00	QQQ	ETF	172.07	172.16	171.95	171.95	89438.0
2018-06-29 09:00:00	QQQ	ETF	171.97	172.11	171.93	172.01	117783.0
2018-06-29 09:30:00	QQQ	ETF	172.01	172.7	171.98	172.52	2801196.0
2018-06-29 10:00:00	QQQ	ETF	172.51	172.78	172.1	172.29	2197125.0
2018-06-29 10:30:00	QQQ	ETF	172.3	172.92	172.185	172.71	2101477.0
2018-06-29 11:00:00	QQQ	ETF	172.7	172.83	172.48	172.48	1111958.0
2018-06-29 11:30:00	QQQ	ETF	172.48	172.54	172.01	172.19	1492472.0
2018-06-29 12:00:00	QQQ	ETF	172.19	172.52	172.14	172.279	1181730.0
2018-06-29 12:30:00	QQQ	ETF	172.28	172.29	171.85	172.04	1265242.0

> showing 50 of 16,343 rows — these rows as CSV

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