PREVIEW / etf_30min / 2021-09-15

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-09-15.parquet
  size:    616 KB
  rows:    22,941

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
2021-09-15 04:00:00	SPY	ETF	444.61	445.17	444.61	445.16	26344.0
2021-09-15 04:30:00	SPY	ETF	445.23	445.32	445.11	445.15	9001.0
2021-09-15 05:00:00	SPY	ETF	445.14	445.31	445.09	445.13	3056.0
2021-09-15 05:30:00	SPY	ETF	445.08	445.41	445.03	445.3	5849.0
2021-09-15 06:00:00	SPY	ETF	445.33	445.4	445.07	445.22	14764.0
2021-09-15 06:30:00	SPY	ETF	445.2	445.2	444.58	444.58	9374.0
2021-09-15 07:00:00	SPY	ETF	444.73	444.76	444.38	444.38	33337.0
2021-09-15 07:30:00	SPY	ETF	444.39	444.64	444.12	444.47	116377.0
2021-09-15 08:00:00	SPY	ETF	444.7	445.07	443.74	443.95	129802.0
2021-09-15 08:30:00	SPY	ETF	443.93	444.78	443.93	444.74	228218.0
2021-09-15 09:00:00	SPY	ETF	444.73	444.95	444.42	444.63	272000.0
2021-09-15 09:30:00	SPY	ETF	444.62	445.39	443.44	445.05	7739196.0
2021-09-15 10:00:00	SPY	ETF	445.06	445.53	443.91	444.41	5063926.0
2021-09-15 10:30:00	SPY	ETF	444.41	445.22	444.22	445.03	3503462.0
2021-09-15 11:00:00	SPY	ETF	445.02	445.57	444.745	445.29	2899828.0
2021-09-15 11:30:00	SPY	ETF	445.29	445.4	444.81	445.379	2536243.0
2021-09-15 12:00:00	SPY	ETF	445.37	446.16	445.03	445.94	2510352.0
2021-09-15 12:30:00	SPY	ETF	445.95	447.1	445.95	446.93	3973243.0
2021-09-15 13:00:00	SPY	ETF	446.94	447.52	446.92	447.4	2681737.0
2021-09-15 13:30:00	SPY	ETF	447.41	447.93	447.39	447.3961	2707088.0
2021-09-15 14:00:00	SPY	ETF	447.39	447.65	447.155	447.33	2736441.0
2021-09-15 14:30:00	SPY	ETF	447.33	447.69	447.23	447.27	2971012.0
2021-09-15 15:00:00	SPY	ETF	447.28	448.17	447.18	447.9292	3851877.0
2021-09-15 15:30:00	SPY	ETF	447.92	448.41	447.63	447.86	11546308.0
2021-09-15 16:00:00	SPY	ETF	447.86	448.03	447.68	448.03	2321703.0
2021-09-15 16:30:00	SPY	ETF	448.04	448.32	447.88	448.22	253373.0
2021-09-15 17:00:00	SPY	ETF	448.17	448.25	448.02	448.02	180881.0
2021-09-15 17:30:00	SPY	ETF	448.08	448.17	448.07	448.16	16184.0
2021-09-15 18:00:00	SPY	ETF	448.16	448.33	448.1	448.27	129907.0
2021-09-15 18:30:00	SPY	ETF	448.31	448.32	448.2	448.26	9882.0
2021-09-15 19:00:00	SPY	ETF	448.3	448.3	448.04	448.09	23747.0
2021-09-15 19:30:00	SPY	ETF	448.08	448.22	448.04	448.18	24124.0
2021-09-15 04:00:00	QQQ	ETF	375.85	376.15	375.85	376.1	8186.0
2021-09-15 04:30:00	QQQ	ETF	376.25	376.31	376.19	376.24	4625.0
2021-09-15 05:00:00	QQQ	ETF	376.25	376.34	376.1	376.1	11524.0
2021-09-15 05:30:00	QQQ	ETF	376.21	376.37	376.21	376.26	3497.0
2021-09-15 06:00:00	QQQ	ETF	376.26	376.32	376.09	376.15	5020.0
2021-09-15 06:30:00	QQQ	ETF	376.22	376.22	375.85	375.96	5914.0
2021-09-15 07:00:00	QQQ	ETF	375.99	376.02	375.64	375.72	50734.0
2021-09-15 07:30:00	QQQ	ETF	375.69	375.78	375.45	375.72	33798.0
2021-09-15 08:00:00	QQQ	ETF	375.7399	376.0	375.39	375.49	91786.0
2021-09-15 08:30:00	QQQ	ETF	375.46	375.97	375.42	375.86	78923.0
2021-09-15 09:00:00	QQQ	ETF	375.89	376.01	375.55	375.7104	112289.0
2021-09-15 09:30:00	QQQ	ETF	375.73	376.4	373.93	374.54	5209615.0
2021-09-15 10:00:00	QQQ	ETF	374.5528	375.05	373.37	373.85	3255388.0
2021-09-15 10:30:00	QQQ	ETF	373.86	374.89	373.635	374.76	2528237.0
2021-09-15 11:00:00	QQQ	ETF	374.75	375.01	374.31	374.4399	1448564.0
2021-09-15 11:30:00	QQQ	ETF	374.45	374.66	374.01	374.635	1239241.0
2021-09-15 12:00:00	QQQ	ETF	374.63	375.46	374.461	375.31	1391118.0
2021-09-15 12:30:00	QQQ	ETF	375.34	376.6745	375.33	376.55	2056258.0

> showing 50 of 22,941 rows — these rows as CSV

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