PREVIEW / etf_30min / 2021-07-30

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-07-30.parquet
  size:    595 KB
  rows:    22,597

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-07-30 04:00:00	SPY	ETF	437.18	438.08	436.85	437.76	14048.0
2021-07-30 04:30:00	SPY	ETF	437.82	438.28	437.77	437.86	8270.0
2021-07-30 05:00:00	SPY	ETF	437.92	437.95	437.68	437.8	7704.0
2021-07-30 05:30:00	SPY	ETF	437.77	437.77	437.3	437.47	24586.0
2021-07-30 06:00:00	SPY	ETF	437.52	438.02	437.32	437.96	34397.0
2021-07-30 06:30:00	SPY	ETF	437.95	438.39	437.81	438.36	47189.0
2021-07-30 07:00:00	SPY	ETF	438.39	438.39	437.75	437.97	97232.0
2021-07-30 07:30:00	SPY	ETF	437.99	438.01	437.64	437.67	97424.0
2021-07-30 08:00:00	SPY	ETF	437.67	440.98	436.91	437.63	226744.0
2021-07-30 08:30:00	SPY	ETF	437.54	438.24	437.54	438.03	217499.0
2021-07-30 09:00:00	SPY	ETF	438.01	438.15	437.56	437.95	155855.0
2021-07-30 09:30:00	SPY	ETF	437.91	439.7	437.9	439.39	7850042.0
2021-07-30 10:00:00	SPY	ETF	439.39	440.06	438.5963	438.68	3467952.0
2021-07-30 10:30:00	SPY	ETF	438.7	439.23	438.53	438.5942	2802778.0
2021-07-30 11:00:00	SPY	ETF	438.595	439.18	438.145	438.765	2377210.0
2021-07-30 11:30:00	SPY	ETF	438.75	438.93	438.07	438.4	2324156.0
2021-07-30 12:00:00	SPY	ETF	438.4	438.82	438.28	438.59	1262475.0
2021-07-30 12:30:00	SPY	ETF	438.6	439.0699	438.6	438.955	983336.0
2021-07-30 13:00:00	SPY	ETF	438.95	439.0001	438.54	438.72	1316362.0
2021-07-30 13:30:00	SPY	ETF	438.7219	439.165	438.69	438.8702	1657663.0
2021-07-30 14:00:00	SPY	ETF	438.88	438.929	438.14	438.155	2626843.0
2021-07-30 14:30:00	SPY	ETF	438.1581	438.69	437.77	438.53	3973268.0
2021-07-30 15:00:00	SPY	ETF	438.53	438.879	438.09	438.4299	3463032.0
2021-07-30 15:30:00	SPY	ETF	438.43	438.71	437.97	438.47	10970151.0
2021-07-30 16:00:00	SPY	ETF	438.49	439.05	438.3412	439.0	4825827.0
2021-07-30 16:30:00	SPY	ETF	439.01	439.04	438.51	439.0	344991.0
2021-07-30 17:00:00	SPY	ETF	439.01	439.01	438.86	438.86	56116.0
2021-07-30 17:30:00	SPY	ETF	438.97	438.97	438.7999	438.88	26753.0
2021-07-30 18:00:00	SPY	ETF	438.88	438.98	438.8001	438.8001	3083.0
2021-07-30 18:30:00	SPY	ETF	438.85	438.99	438.81	438.99	1888.0
2021-07-30 19:00:00	SPY	ETF	438.99	439.0599	438.8201	439.0599	30000.0
2021-07-30 19:30:00	SPY	ETF	439.03	439.14	439.01	439.04	15114.0
2021-07-30 04:00:00	QQQ	ETF	361.85	362.45	361.66	362.28	57179.0
2021-07-30 04:30:00	QQQ	ETF	362.31	362.79	362.27	362.46	27998.0
2021-07-30 05:00:00	QQQ	ETF	362.43	362.5	362.23	362.46	19350.0
2021-07-30 05:30:00	QQQ	ETF	362.49	362.49	362.15	362.24	47358.0
2021-07-30 06:00:00	QQQ	ETF	362.3	362.74	362.21	362.66	45565.0
2021-07-30 06:30:00	QQQ	ETF	362.67	363.24	362.57	363.23	64550.0
2021-07-30 07:00:00	QQQ	ETF	363.22	363.28	362.71	362.87	158067.0
2021-07-30 07:30:00	QQQ	ETF	362.86	362.89	362.33	362.54	104917.0
2021-07-30 08:00:00	QQQ	ETF	363.17	366.754	361.3	362.37	197838.0
2021-07-30 08:30:00	QQQ	ETF	362.37	362.88	362.16	362.56	150198.0
2021-07-30 09:00:00	QQQ	ETF	362.5	362.58	362.1	362.45	151270.0
2021-07-30 09:30:00	QQQ	ETF	362.45	364.499	362.41	364.37	5547215.0
2021-07-30 10:00:00	QQQ	ETF	364.39	365.17	363.94	364.25	2881433.0
2021-07-30 10:30:00	QQQ	ETF	364.26	364.6	363.69	363.98	1913664.0
2021-07-30 11:00:00	QQQ	ETF	363.96	364.39	363.51	364.12	1541568.0
2021-07-30 11:30:00	QQQ	ETF	364.08	364.25	363.46	364.05	1320397.0
2021-07-30 12:00:00	QQQ	ETF	364.03	364.77	363.98	364.45	1117007.0
2021-07-30 12:30:00	QQQ	ETF	364.46	365.07	364.4401	365.06	765954.0

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

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