PREVIEW / etf_30min / 2018-12-31

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-12-31.parquet
  size:    549 KB
  rows:    19,256

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-12-31 04:00:00	SPY	ETF	249.62	249.77	249.57	249.68	20108.0
2018-12-31 04:30:00	SPY	ETF	249.65	249.9	249.65	249.85	26742.0
2018-12-31 05:00:00	SPY	ETF	249.86	249.95	249.68	249.68	24508.0
2018-12-31 05:30:00	SPY	ETF	249.66	249.82	249.6	249.82	19719.0
2018-12-31 06:00:00	SPY	ETF	249.78	249.87	249.7	249.79	7475.0
2018-12-31 06:30:00	SPY	ETF	249.76	249.95	249.75	249.87	37882.0
2018-12-31 07:00:00	SPY	ETF	249.86	250.4	249.8	250.13	102692.0
2018-12-31 07:30:00	SPY	ETF	250.19	250.33	250.11	250.25	108587.0
2018-12-31 08:00:00	SPY	ETF	247.75	250.35	247.75	249.75	267381.0
2018-12-31 08:30:00	SPY	ETF	249.7	249.75	249.38	249.43	278206.0
2018-12-31 09:00:00	SPY	ETF	249.44	249.69	249.28	249.47	256249.0
2018-12-31 09:30:00	SPY	ETF	249.56	250.16	249.12	249.39	10764073.0
2018-12-31 10:00:00	SPY	ETF	249.4	249.91	248.87	249.1	6359254.0
2018-12-31 10:30:00	SPY	ETF	249.1	249.1998	248.12	248.3999	5852757.0
2018-12-31 11:00:00	SPY	ETF	248.39	248.71	247.74	248.45	5654067.0
2018-12-31 11:30:00	SPY	ETF	248.4538	248.805	247.47	248.72	6381283.0
2018-12-31 12:00:00	SPY	ETF	248.73	249.0	248.26	248.97	4437203.0
2018-12-31 12:30:00	SPY	ETF	248.9775	249.44	248.86	249.36	5553164.0
2018-12-31 13:00:00	SPY	ETF	249.36	250.09	249.24	250.09	5838281.0
2018-12-31 13:30:00	SPY	ETF	250.09	250.12	248.89	248.96	5032068.0
2018-12-31 14:00:00	SPY	ETF	248.9415	249.23	248.08	248.2	8648178.0
2018-12-31 14:30:00	SPY	ETF	248.16	249.38	247.87	248.7	6973469.0
2018-12-31 15:00:00	SPY	ETF	248.7	249.32	248.4	248.83	8281827.0
2018-12-31 15:30:00	SPY	ETF	248.83	250.12	248.06	250.12	26288729.0
2018-12-31 16:00:00	SPY	ETF	250.11	250.48	249.4	250.11	28789985.0
2018-12-31 16:30:00	SPY	ETF	250.11	250.28	249.92	250.1	2720723.0
2018-12-31 17:00:00	SPY	ETF	250.11	250.14	249.8	250.0	337264.0
2018-12-31 17:30:00	SPY	ETF	249.97	250.15	249.79	250.15	902595.0
2018-12-31 18:00:00	SPY	ETF	250.05	250.1	249.98	249.98	26915.0
2018-12-31 18:30:00	SPY	ETF	249.98	250.02	249.95	250.0	7035.0
2018-12-31 19:00:00	SPY	ETF	250.0	250.07	250.0	250.07	7513.0
2018-12-31 19:30:00	SPY	ETF	250.07	250.1	250.03	250.09	5431.0
2018-12-31 04:00:00	QQQ	ETF	154.11	154.19	154.08	154.18	6796.0
2018-12-31 04:30:00	QQQ	ETF	154.21	154.35	154.21	154.35	3940.0
2018-12-31 05:00:00	QQQ	ETF	154.42	154.42	154.22	154.22	10469.0
2018-12-31 05:30:00	QQQ	ETF	154.24	154.32	154.2	154.27	4489.0
2018-12-31 06:00:00	QQQ	ETF	154.31	154.38	154.31	154.38	9900.0
2018-12-31 06:30:00	QQQ	ETF	154.38	154.48	154.36	154.48	5925.0
2018-12-31 07:00:00	QQQ	ETF	154.43	154.85	154.41	154.71	70820.0
2018-12-31 07:30:00	QQQ	ETF	154.71	154.89	154.65	154.83	46594.0
2018-12-31 08:00:00	QQQ	ETF	154.83	154.89	154.1	154.51	192356.0
2018-12-31 08:30:00	QQQ	ETF	154.49	154.5	154.28	154.32	148648.0
2018-12-31 09:00:00	QQQ	ETF	154.33	154.55	154.28	154.49	181473.0
2018-12-31 09:30:00	QQQ	ETF	154.47	154.98	153.84	154.2256	4313663.0
2018-12-31 10:00:00	QQQ	ETF	154.24	154.58	153.57	153.92	2672951.0
2018-12-31 10:30:00	QQQ	ETF	153.93	153.97	153.05	153.26	2839604.0
2018-12-31 11:00:00	QQQ	ETF	153.27	153.56	152.83	153.385	3452901.0
2018-12-31 11:30:00	QQQ	ETF	153.34	153.8	152.71	153.74	3324334.0
2018-12-31 12:00:00	QQQ	ETF	153.75	153.99	153.43	153.87	2757537.0
2018-12-31 12:30:00	QQQ	ETF	153.86	154.31	153.76	154.12	2000165.0

> showing 50 of 19,256 rows — these rows as CSV

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