PREVIEW / etf_30min / 2021-04-09

all etf 30-min files

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

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-04-09 04:00:00	SPY	ETF	409.12	409.13	408.56	408.59	14404.0
2021-04-09 04:30:00	SPY	ETF	408.62	409.03	408.62	409.03	3485.0
2021-04-09 05:00:00	SPY	ETF	408.95	408.95	408.71	408.85	3357.0
2021-04-09 05:30:00	SPY	ETF	408.9	408.96	408.7	408.96	6157.0
2021-04-09 06:00:00	SPY	ETF	408.89	409.0	408.59	408.64	8877.0
2021-04-09 06:30:00	SPY	ETF	408.68	408.96	408.64	408.78	9900.0
2021-04-09 07:00:00	SPY	ETF	408.75	409.42	408.75	409.34	104951.0
2021-04-09 07:30:00	SPY	ETF	409.26	409.32	409.03	409.09	28659.0
2021-04-09 08:00:00	SPY	ETF	408.9701	409.4299	408.5	408.77	96732.0
2021-04-09 08:30:00	SPY	ETF	408.75	408.88	407.9	408.04	491879.0
2021-04-09 09:00:00	SPY	ETF	408.02	408.43	407.72	408.4	198746.0
2021-04-09 09:30:00	SPY	ETF	408.39	409.11	408.26	409.06	4460963.0
2021-04-09 10:00:00	SPY	ETF	409.07	409.24	408.615	408.71	4012312.0
2021-04-09 10:30:00	SPY	ETF	408.71	409.04	408.42	408.6343	3674851.0
2021-04-09 11:00:00	SPY	ETF	408.635	409.1	408.565	408.91	2243744.0
2021-04-09 11:30:00	SPY	ETF	408.9	409.47	408.84	409.38	2162801.0
2021-04-09 12:00:00	SPY	ETF	409.375	409.43	409.14	409.25	1731545.0
2021-04-09 12:30:00	SPY	ETF	409.25	409.53	409.245	409.4681	1455081.0
2021-04-09 13:00:00	SPY	ETF	409.465	409.545	409.31	409.45	1353596.0
2021-04-09 13:30:00	SPY	ETF	409.45	409.98	409.44	409.805	2421775.0
2021-04-09 14:00:00	SPY	ETF	409.805	409.95	409.625	409.755	1667147.0
2021-04-09 14:30:00	SPY	ETF	409.75	409.89	409.59	409.71	2142673.0
2021-04-09 15:00:00	SPY	ETF	409.71	410.56	409.5	410.56	3653166.0
2021-04-09 15:30:00	SPY	ETF	410.56	411.67	410.54	411.44	13264668.0
2021-04-09 16:00:00	SPY	ETF	411.44	411.59	410.59	410.83	3253464.0
2021-04-09 16:30:00	SPY	ETF	410.83	411.49	410.75	411.49	197761.0
2021-04-09 17:00:00	SPY	ETF	410.76	411.09	410.76	410.98	75764.0
2021-04-09 17:30:00	SPY	ETF	410.98	411.0	410.81	410.8199	70121.0
2021-04-09 18:00:00	SPY	ETF	410.81	410.9	410.81	410.9	12800.0
2021-04-09 18:30:00	SPY	ETF	410.84	410.9	410.82	410.86	6221.0
2021-04-09 19:00:00	SPY	ETF	410.85	410.9	410.78	410.78	5666.0
2021-04-09 19:30:00	SPY	ETF	410.78	410.78	410.68	410.68	17032.0
2021-04-09 04:00:00	QQQ	ETF	335.2	335.2	334.44	334.75	51614.0
2021-04-09 04:30:00	QQQ	ETF	334.7	334.92	334.65	334.92	5306.0
2021-04-09 05:00:00	QQQ	ETF	334.85	334.89	334.63	334.83	13648.0
2021-04-09 05:30:00	QQQ	ETF	334.83	334.83	334.41	334.69	17704.0
2021-04-09 06:00:00	QQQ	ETF	334.71	334.73	334.15	334.31	22794.0
2021-04-09 06:30:00	QQQ	ETF	334.4	334.86	334.37	334.7	24164.0
2021-04-09 07:00:00	QQQ	ETF	334.67	335.28	334.67	335.16	115023.0
2021-04-09 07:30:00	QQQ	ETF	335.15	335.15	334.52	334.6	91765.0
2021-04-09 08:00:00	QQQ	ETF	335.3	336.37	334.15	334.2499	420363.0
2021-04-09 08:30:00	QQQ	ETF	334.25	334.34	332.69	333.11	651950.0
2021-04-09 09:00:00	QQQ	ETF	333.09	333.68	332.7	333.67	430644.0
2021-04-09 09:30:00	QQQ	ETF	333.68	334.67	332.92	334.44	4398145.0
2021-04-09 10:00:00	QQQ	ETF	334.44	335.08	334.28	334.39	2134861.0
2021-04-09 10:30:00	QQQ	ETF	334.39	334.88	334.01	334.19	1814669.0
2021-04-09 11:00:00	QQQ	ETF	334.19	334.839	333.82	334.515	1662245.0
2021-04-09 11:30:00	QQQ	ETF	334.525	335.65	334.39	335.53	1626419.0
2021-04-09 12:00:00	QQQ	ETF	335.54	335.825	335.19	335.4	1338868.0
2021-04-09 12:30:00	QQQ	ETF	335.3996	335.71	335.26	335.7	880901.0

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

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