PREVIEW / etf_30min / 2019-05-31

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-05-31.parquet
  size:    508 KB
  rows:    17,823

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-05-31 04:00:00	SPY	ETF	276.51	276.71	276.39	276.46	32255.0
2019-05-31 04:30:00	SPY	ETF	276.53	276.7	276.25	276.25	48843.0
2019-05-31 05:00:00	SPY	ETF	276.3	276.45	275.88	275.99	62251.0
2019-05-31 05:30:00	SPY	ETF	275.87	275.97	275.62	275.73	72031.0
2019-05-31 06:00:00	SPY	ETF	275.8	275.94	275.57	275.82	97701.0
2019-05-31 06:30:00	SPY	ETF	275.86	276.04	275.62	276.04	36827.0
2019-05-31 07:00:00	SPY	ETF	276.09	276.17	275.9	276.17	228293.0
2019-05-31 07:30:00	SPY	ETF	276.18	276.4	276.08	276.1	261986.0
2019-05-31 08:00:00	SPY	ETF	276.06	277.49	275.87	276.01	432268.0
2019-05-31 08:30:00	SPY	ETF	276.0001	276.42	275.94	276.28	314269.0
2019-05-31 09:00:00	SPY	ETF	276.27	279.03	276.09	276.22	459002.0
2019-05-31 09:30:00	SPY	ETF	276.2	276.36	275.29	275.88	10939972.0
2019-05-31 10:00:00	SPY	ETF	275.87	276.11	275.51	275.99	5720522.0
2019-05-31 10:30:00	SPY	ETF	276.0	276.58	275.85	276.335	4797433.0
2019-05-31 11:00:00	SPY	ETF	276.34	277.12	276.19	277.08	3818983.0
2019-05-31 11:30:00	SPY	ETF	277.07	277.11	276.46	276.73	3226945.0
2019-05-31 12:00:00	SPY	ETF	276.7234	276.77	276.134	276.2	2329798.0
2019-05-31 12:30:00	SPY	ETF	276.2	276.3499	275.82	275.98	2667655.0
2019-05-31 13:00:00	SPY	ETF	275.99	276.49	275.88	276.49	2182225.0
2019-05-31 13:30:00	SPY	ETF	276.475	276.66	276.26	276.52	2716313.0
2019-05-31 14:00:00	SPY	ETF	276.51	276.62	275.62	275.69	4538655.0
2019-05-31 14:30:00	SPY	ETF	275.68	276.29	275.36	276.02	6403949.0
2019-05-31 15:00:00	SPY	ETF	276.02	276.07	275.35	275.67	5942614.0
2019-05-31 15:30:00	SPY	ETF	275.65	275.8176	275.24	275.37	14651606.0
2019-05-31 16:00:00	SPY	ETF	275.36	279.0922	275.18	275.36	11110502.0
2019-05-31 16:30:00	SPY	ETF	275.36	275.52	275.21	275.43	700001.0
2019-05-31 17:00:00	SPY	ETF	275.27	275.63	275.27	275.61	495027.0
2019-05-31 17:30:00	SPY	ETF	275.6	275.63	275.27	275.4	220973.0
2019-05-31 18:00:00	SPY	ETF	275.4	275.4	275.28	275.33	28957.0
2019-05-31 18:30:00	SPY	ETF	275.3	275.32	275.27	275.29	63401.0
2019-05-31 19:00:00	SPY	ETF	275.3	275.31	275.26	275.29	12916.0
2019-05-31 19:30:00	SPY	ETF	275.27	275.31	274.95	275.3	35242.0
2019-05-31 04:00:00	QQQ	ETF	174.7	174.8	174.57	174.64	38957.0
2019-05-31 04:30:00	QQQ	ETF	174.6	174.82	174.5	174.57	18267.0
2019-05-31 05:00:00	QQQ	ETF	174.57	174.71	174.33	174.33	21106.0
2019-05-31 05:30:00	QQQ	ETF	174.41	174.41	173.98	174.18	41009.0
2019-05-31 06:00:00	QQQ	ETF	174.11	174.3	174.0	174.26	19965.0
2019-05-31 06:30:00	QQQ	ETF	174.28	174.4	174.05	174.33	50268.0
2019-05-31 07:00:00	QQQ	ETF	174.39	174.58	174.32	174.54	100706.0
2019-05-31 07:30:00	QQQ	ETF	174.54	174.65	174.47	174.49	87101.0
2019-05-31 08:00:00	QQQ	ETF	174.46	175.35	174.27	174.42	296817.0
2019-05-31 08:30:00	QQQ	ETF	174.39	174.78	174.35	174.63	142839.0
2019-05-31 09:00:00	QQQ	ETF	174.65	174.7601	174.5	174.7	287244.0
2019-05-31 09:30:00	QQQ	ETF	174.72	174.84	173.93	174.35	5984209.0
2019-05-31 10:00:00	QQQ	ETF	174.36	174.75	174.2	174.6635	2939056.0
2019-05-31 10:30:00	QQQ	ETF	174.67	175.11	174.41	174.97	2168357.0
2019-05-31 11:00:00	QQQ	ETF	174.9899	175.29	174.83	175.265	1848740.0
2019-05-31 11:30:00	QQQ	ETF	175.27	175.29	174.79	174.97	1702759.0
2019-05-31 12:00:00	QQQ	ETF	174.93	175.01	174.48	174.58	1423913.0
2019-05-31 12:30:00	QQQ	ETF	174.57	174.72	174.335	174.5128	1537599.0

> showing 50 of 17,823 rows — these rows as CSV

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