PREVIEW / etf_30min / 2019-01-02

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-01-02.parquet
  size:    516 KB
  rows:    18,469

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
2019-01-02 04:00:00	SPY	ETF	248.0	248.0	244.96	245.99	93536.0
2019-01-02 04:30:00	SPY	ETF	245.91	246.13	245.6	246.13	28158.0
2019-01-02 05:00:00	SPY	ETF	246.06	246.41	245.98	245.98	34603.0
2019-01-02 05:30:00	SPY	ETF	245.9	246.16	245.67	245.87	14136.0
2019-01-02 06:00:00	SPY	ETF	245.71	246.44	245.66	246.26	37788.0
2019-01-02 06:30:00	SPY	ETF	246.21	246.41	245.92	246.2	54150.0
2019-01-02 07:00:00	SPY	ETF	246.23	247.06	246.21	246.99	217291.0
2019-01-02 07:30:00	SPY	ETF	246.94	246.99	246.09	246.09	250678.0
2019-01-02 08:00:00	SPY	ETF	246.05	249.92	244.7	245.57	628027.0
2019-01-02 08:30:00	SPY	ETF	245.58	249.92	245.44	245.73	276114.0
2019-01-02 09:00:00	SPY	ETF	245.73	246.29	245.73	246.04	689406.0
2019-01-02 09:30:00	SPY	ETF	245.98	247.4	245.95	247.18	11252326.0
2019-01-02 10:00:00	SPY	ETF	247.18	248.7	246.615	247.81	8795546.0
2019-01-02 10:30:00	SPY	ETF	247.82	249.17	247.39	248.86	7090540.0
2019-01-02 11:00:00	SPY	ETF	248.87	250.46	248.59	249.52	7846915.0
2019-01-02 11:30:00	SPY	ETF	249.53	250.07	248.85	248.89	8294852.0
2019-01-02 12:00:00	SPY	ETF	248.9	249.34	248.68	249.005	7574516.0
2019-01-02 12:30:00	SPY	ETF	249.0	250.33	248.93	250.16	5330280.0
2019-01-02 13:00:00	SPY	ETF	250.15	251.06	250.15	250.81	5126916.0
2019-01-02 13:30:00	SPY	ETF	250.81	251.21	250.45	251.16	3781350.0
2019-01-02 14:00:00	SPY	ETF	251.16	251.17	249.71	250.23	6263028.0
2019-01-02 14:30:00	SPY	ETF	250.25	250.9	249.83	249.84	4610736.0
2019-01-02 15:00:00	SPY	ETF	249.84	250.21	248.85	249.31	10958179.0
2019-01-02 15:30:00	SPY	ETF	249.31	250.48	248.72	250.26	16157674.0
2019-01-02 16:00:00	SPY	ETF	250.25	250.4	249.55	249.8	13664243.0
2019-01-02 16:30:00	SPY	ETF	249.8	250.2372	248.0	248.1	2742275.0
2019-01-02 17:00:00	SPY	ETF	248.11	250.18	247.96	248.0	290853.0
2019-01-02 17:30:00	SPY	ETF	247.92	248.0	247.35	247.36	334541.0
2019-01-02 18:00:00	SPY	ETF	247.37	250.18	246.5	247.3	458365.0
2019-01-02 18:30:00	SPY	ETF	247.3	247.3	246.3	246.65	90200.0
2019-01-02 19:00:00	SPY	ETF	246.65	247.19	246.65	246.9	56260.0
2019-01-02 19:30:00	SPY	ETF	246.91	247.0	246.65	246.7	49802.0
2019-01-02 04:00:00	QQQ	ETF	150.24	150.62	150.0	150.6	63348.0
2019-01-02 04:30:00	QQQ	ETF	150.58	150.72	150.11	150.57	26302.0
2019-01-02 05:00:00	QQQ	ETF	150.57	151.02	150.57	150.74	27807.0
2019-01-02 05:30:00	QQQ	ETF	150.68	150.71	150.26	150.37	16534.0
2019-01-02 06:00:00	QQQ	ETF	150.35	150.78	150.29	150.63	37842.0
2019-01-02 06:30:00	QQQ	ETF	150.64	150.74	150.39	150.53	34054.0
2019-01-02 07:00:00	QQQ	ETF	150.66	151.35	150.61	151.33	305060.0
2019-01-02 07:30:00	QQQ	ETF	151.32	151.32	150.69	150.69	241794.0
2019-01-02 08:00:00	QQQ	ETF	150.65	154.26	149.95	150.56	220908.0
2019-01-02 08:30:00	QQQ	ETF	150.54	150.67	150.45	150.55	171710.0
2019-01-02 09:00:00	QQQ	ETF	150.56	151.09	150.55	150.99	226844.0
2019-01-02 09:30:00	QQQ	ETF	150.99	152.43	150.88	152.2599	5930595.0
2019-01-02 10:00:00	QQQ	ETF	152.24	153.59	151.76	152.9799	4907515.0
2019-01-02 10:30:00	QQQ	ETF	152.98	154.02	152.64	153.77	3616575.0
2019-01-02 11:00:00	QQQ	ETF	153.77	154.8	153.57	154.24	4403553.0
2019-01-02 11:30:00	QQQ	ETF	154.26	154.5	153.65	153.695	3114480.0
2019-01-02 12:00:00	QQQ	ETF	153.7	154.05	153.57	153.97	2552412.0
2019-01-02 12:30:00	QQQ	ETF	153.97	155.02	153.97	154.89	2790670.0

> showing 50 of 18,469 rows — these rows as CSV

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