PREVIEW / etf_30min / 2020-06-25

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-06-25.parquet
  size:    544 KB
  rows:    20,369

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
2020-06-25 04:00:00	SPY	ETF	301.53	304.23	301.48	303.69	141145.0
2020-06-25 04:30:00	SPY	ETF	303.74	304.75	303.6	304.4	42428.0
2020-06-25 05:00:00	SPY	ETF	304.39	305.01	304.13	305.01	25084.0
2020-06-25 05:30:00	SPY	ETF	305.19	305.33	303.84	304.08	89630.0
2020-06-25 06:00:00	SPY	ETF	304.2	304.49	303.8	304.17	123290.0
2020-06-25 06:30:00	SPY	ETF	304.14	304.52	303.79	304.51	114518.0
2020-06-25 07:00:00	SPY	ETF	304.47	304.52	303.37	303.49	226992.0
2020-06-25 07:30:00	SPY	ETF	303.45	303.58	302.3	302.44	435366.0
2020-06-25 08:00:00	SPY	ETF	302.47	304.47	300.83	302.68	768867.0
2020-06-25 08:30:00	SPY	ETF	302.75	303.8	302.03	302.91	1032010.0
2020-06-25 09:00:00	SPY	ETF	302.95	304.09	302.78	303.48	602655.0
2020-06-25 09:30:00	SPY	ETF	303.47	303.83	301.28	302.98	9967907.0
2020-06-25 10:00:00	SPY	ETF	302.99	304.98	302.87	304.77	7285820.0
2020-06-25 10:30:00	SPY	ETF	304.78	304.95	303.46	303.96	5668341.0
2020-06-25 11:00:00	SPY	ETF	303.96	304.38	302.64	303.9014	5710765.0
2020-06-25 11:30:00	SPY	ETF	303.89	304.13	302.51	303.84	5318324.0
2020-06-25 12:00:00	SPY	ETF	303.86	305.12	303.85	304.54	3859590.0
2020-06-25 12:30:00	SPY	ETF	304.56	305.27	303.97	304.66	3459711.0
2020-06-25 13:00:00	SPY	ETF	304.66	304.87	304.12	304.5	3505624.0
2020-06-25 13:30:00	SPY	ETF	304.5	305.03	304.06	304.57	3336439.0
2020-06-25 14:00:00	SPY	ETF	304.56	304.8485	303.82	304.17	2806217.0
2020-06-25 14:30:00	SPY	ETF	304.17	304.5	303.5	304.27	3743764.0
2020-06-25 15:00:00	SPY	ETF	304.26	306.98	304.0	306.69	9590935.0
2020-06-25 15:30:00	SPY	ETF	306.68	307.64	306.18	307.31	14576162.0
2020-06-25 16:00:00	SPY	ETF	307.25	308.0	307.01	307.19	4212806.0
2020-06-25 16:30:00	SPY	ETF	307.2	307.49	306.56	307.42	665990.0
2020-06-25 17:00:00	SPY	ETF	307.42	307.45	307.24	307.3	104940.0
2020-06-25 17:30:00	SPY	ETF	307.26	307.3	307.13	307.28	74959.0
2020-06-25 18:00:00	SPY	ETF	307.23	307.47	306.92	307.47	164821.0
2020-06-25 18:30:00	SPY	ETF	307.39	307.42	306.96	307.42	87664.0
2020-06-25 19:00:00	SPY	ETF	307.4	307.9	307.16	307.8	89099.0
2020-06-25 19:30:00	SPY	ETF	307.8	308.0	307.33	307.37	159970.0
2020-06-25 04:00:00	QQQ	ETF	242.38	244.21	242.35	243.88	47446.0
2020-06-25 04:30:00	QQQ	ETF	243.93	244.58	243.75	244.34	41069.0
2020-06-25 05:00:00	QQQ	ETF	244.2	244.88	244.2	244.88	27322.0
2020-06-25 05:30:00	QQQ	ETF	244.97	245.03	243.9	243.95	19532.0
2020-06-25 06:00:00	QQQ	ETF	244.13	244.37	243.8	244.2	113379.0
2020-06-25 06:30:00	QQQ	ETF	244.11	244.48	243.9	244.48	19800.0
2020-06-25 07:00:00	QQQ	ETF	244.51	244.54	243.9	244.12	65852.0
2020-06-25 07:30:00	QQQ	ETF	244.09	244.12	243.25	243.31	97475.0
2020-06-25 08:00:00	QQQ	ETF	243.31	244.54	241.69	243.38	160774.0
2020-06-25 08:30:00	QQQ	ETF	243.26	244.15	243.05	243.89	213216.0
2020-06-25 09:00:00	QQQ	ETF	243.84	244.3	243.71	243.86	105363.0
2020-06-25 09:30:00	QQQ	ETF	243.87	244.38	241.14	242.65	5796181.0
2020-06-25 10:00:00	QQQ	ETF	242.64	244.19	242.19	243.92	4037786.0
2020-06-25 10:30:00	QQQ	ETF	243.93	244.27	243.29	243.77	2461694.0
2020-06-25 11:00:00	QQQ	ETF	243.75	244.035	242.62	243.77	2127183.0
2020-06-25 11:30:00	QQQ	ETF	243.75	243.902	242.79	243.89	1745109.0
2020-06-25 12:00:00	QQQ	ETF	243.91	244.95	243.91	244.49	1622879.0
2020-06-25 12:30:00	QQQ	ETF	244.49	244.79	244.13	244.25	1468548.0

> showing 50 of 20,369 rows — these rows as CSV

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