PREVIEW / etf_30min / 2020-04-21

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-04-21.parquet
  size:    582 KB
  rows:    21,447

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-04-21 04:00:00	SPY	ETF	279.19	280.3	279.09	279.45	44334.0
2020-04-21 04:30:00	SPY	ETF	279.62	280.05	279.13	279.8	26633.0
2020-04-21 05:00:00	SPY	ETF	280.0	280.18	278.2	278.2	91142.0
2020-04-21 05:30:00	SPY	ETF	278.58	278.7	277.54	278.2	174666.0
2020-04-21 06:00:00	SPY	ETF	278.12	278.72	276.77	277.12	268676.0
2020-04-21 06:30:00	SPY	ETF	276.86	278.17	276.64	277.42	182465.0
2020-04-21 07:00:00	SPY	ETF	277.27	279.44	276.57	276.87	446509.0
2020-04-21 07:30:00	SPY	ETF	276.82	277.1	275.83	276.3	1043354.0
2020-04-21 08:00:00	SPY	ETF	276.3	280.79	275.37	276.5	1396721.0
2020-04-21 08:30:00	SPY	ETF	276.46	276.55	275.22	275.44	664917.0
2020-04-21 09:00:00	SPY	ETF	275.42	276.75	275.1	276.64	1393141.0
2020-04-21 09:30:00	SPY	ETF	276.73	278.04	275.34	277.65	13897282.0
2020-04-21 10:00:00	SPY	ETF	277.655	277.81	276.0	276.882	7644341.0
2020-04-21 10:30:00	SPY	ETF	276.87	277.07	274.11	274.18	8442798.0
2020-04-21 11:00:00	SPY	ETF	274.16	274.37	272.55	272.88	10164764.0
2020-04-21 11:30:00	SPY	ETF	272.88	273.895	272.14	273.61	10182194.0
2020-04-21 12:00:00	SPY	ETF	273.6	273.86	272.8	272.96	7053292.0
2020-04-21 12:30:00	SPY	ETF	272.97	273.495	272.02	273.41	6326865.0
2020-04-21 13:00:00	SPY	ETF	273.41	274.62	273.21	274.47	6359510.0
2020-04-21 13:30:00	SPY	ETF	274.49	275.0	273.72	274.02	7206348.0
2020-04-21 14:00:00	SPY	ETF	274.02	275.69	273.5601	274.93	6148702.0
2020-04-21 14:30:00	SPY	ETF	274.96	275.13	273.24	273.49	5524975.0
2020-04-21 15:00:00	SPY	ETF	273.49	274.81	272.5818	274.29	7014323.0
2020-04-21 15:30:00	SPY	ETF	274.29	275.51	272.5	273.02	18680437.0
2020-04-21 16:00:00	SPY	ETF	273.0101	273.67	273.0101	273.39	3775674.0
2020-04-21 16:30:00	SPY	ETF	273.36	273.77	273.04	273.6	479941.0
2020-04-21 17:00:00	SPY	ETF	273.6	274.41	273.04	274.36	290883.0
2020-04-21 17:30:00	SPY	ETF	274.32	274.4	273.04	274.19	125924.0
2020-04-21 18:00:00	SPY	ETF	274.16	275.0	274.0	274.58	217563.0
2020-04-21 18:30:00	SPY	ETF	274.53	274.75	273.8	274.15	136026.0
2020-04-21 19:00:00	SPY	ETF	274.17	274.28	273.4	273.92	147473.0
2020-04-21 19:30:00	SPY	ETF	273.82	274.5	273.8	274.39	108261.0
2020-04-21 04:00:00	QQQ	ETF	211.48	212.16	211.37	211.72	14187.0
2020-04-21 04:30:00	QQQ	ETF	211.9	212.16	211.5	211.98	23540.0
2020-04-21 05:00:00	QQQ	ETF	212.11	212.31	211.3	211.4	19932.0
2020-04-21 05:30:00	QQQ	ETF	211.55	211.68	211.02	211.1	61303.0
2020-04-21 06:00:00	QQQ	ETF	211.59	211.71	210.18	210.4	42784.0
2020-04-21 06:30:00	QQQ	ETF	210.27	210.92	210.27	210.45	42220.0
2020-04-21 07:00:00	QQQ	ETF	210.44	210.82	210.17	210.35	69919.0
2020-04-21 07:30:00	QQQ	ETF	210.28	210.4	210.0	210.06	150503.0
2020-04-21 08:00:00	QQQ	ETF	210.358	212.3	209.83	210.41	248146.0
2020-04-21 08:30:00	QQQ	ETF	210.4	210.53	209.96	210.12	103238.0
2020-04-21 09:00:00	QQQ	ETF	210.14	210.7	209.92	210.64	339385.0
2020-04-21 09:30:00	QQQ	ETF	210.64	211.16	208.23	209.54	6901603.0
2020-04-21 10:00:00	QQQ	ETF	209.55	209.68	207.87	208.4	4025346.0
2020-04-21 10:30:00	QQQ	ETF	208.39	208.53	204.72	204.91	6845568.0
2020-04-21 11:00:00	QQQ	ETF	204.89	205.36	203.7197	204.27	5619341.0
2020-04-21 11:30:00	QQQ	ETF	204.245	205.22	203.63	205.12	3966790.0
2020-04-21 12:00:00	QQQ	ETF	205.11	205.365	204.41	204.71	2423790.0
2020-04-21 12:30:00	QQQ	ETF	204.7	204.8901	203.91	204.84	3225082.0

> showing 50 of 21,447 rows — these rows as CSV

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