PREVIEW / etf_30min / 2021-08-17

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-08-17.parquet
  size:    624 KB
  rows:    23,823

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-08-17 04:00:00	SPY	ETF	445.51	445.51	444.95	445.07	79633.0
2021-08-17 04:30:00	SPY	ETF	444.95	445.12	444.89	445.07	2933.0
2021-08-17 05:00:00	SPY	ETF	445.15	445.5	445.07	445.48	9406.0
2021-08-17 05:30:00	SPY	ETF	445.37	445.37	445.0	445.17	11652.0
2021-08-17 06:00:00	SPY	ETF	444.95	445.18	444.92	445.06	31546.0
2021-08-17 06:30:00	SPY	ETF	445.12	445.13	444.83	444.99	54130.0
2021-08-17 07:00:00	SPY	ETF	445.12	445.13	444.6	444.82	99647.0
2021-08-17 07:30:00	SPY	ETF	444.81	445.15	444.69	445.08	188969.0
2021-08-17 08:00:00	SPY	ETF	445.08	447.305	444.62	444.77	120367.0
2021-08-17 08:30:00	SPY	ETF	444.71	445.25	444.43	445.04	201938.0
2021-08-17 09:00:00	SPY	ETF	445.07	445.07	444.23	444.24	496407.0
2021-08-17 09:30:00	SPY	ETF	444.24	444.81	443.27	443.66	9236661.0
2021-08-17 10:00:00	SPY	ETF	443.67	444.85	443.38	444.675	6485887.0
2021-08-17 10:30:00	SPY	ETF	444.67	444.96	444.1	444.37	4450867.0
2021-08-17 11:00:00	SPY	ETF	444.369	444.52	443.71	443.8375	3921351.0
2021-08-17 11:30:00	SPY	ETF	443.82	444.2999	443.0099	443.0599	3435797.0
2021-08-17 12:00:00	SPY	ETF	443.06	443.28	442.43	443.1686	4521292.0
2021-08-17 12:30:00	SPY	ETF	443.16	443.16	440.89	441.02	6188644.0
2021-08-17 13:00:00	SPY	ETF	440.99	442.19	440.85	442.145	5635591.0
2021-08-17 13:30:00	SPY	ETF	442.16	442.1727	441.04	442.09	3902713.0
2021-08-17 14:00:00	SPY	ETF	442.08	442.91	442.05	442.315	3754804.0
2021-08-17 14:30:00	SPY	ETF	442.32	443.16	441.7614	443.065	3601545.0
2021-08-17 15:00:00	SPY	ETF	443.065	443.5	442.88	443.17	4071639.0
2021-08-17 15:30:00	SPY	ETF	443.17	444.07	442.7401	444.06	10119798.0
2021-08-17 16:00:00	SPY	ETF	444.05	444.14	443.36	443.43	2874041.0
2021-08-17 16:30:00	SPY	ETF	443.38	443.44	442.81	443.38	269273.0
2021-08-17 17:00:00	SPY	ETF	443.38	443.5	443.31	443.39	34323.0
2021-08-17 17:30:00	SPY	ETF	443.37	443.43	443.26	443.34	47999.0
2021-08-17 18:00:00	SPY	ETF	443.33	443.51	443.31	443.36	35495.0
2021-08-17 18:30:00	SPY	ETF	443.36	443.43	443.14	443.33	111763.0
2021-08-17 19:00:00	SPY	ETF	443.34	443.47	443.27	443.44	81690.0
2021-08-17 19:30:00	SPY	ETF	443.25	443.3	443.0	443.0	17904.0
2021-08-17 04:00:00	QQQ	ETF	367.68	368.0	367.48	367.59	16458.0
2021-08-17 04:30:00	QQQ	ETF	367.54	367.68	367.46	367.67	12142.0
2021-08-17 05:00:00	QQQ	ETF	367.69	367.92	367.64	367.79	13149.0
2021-08-17 05:30:00	QQQ	ETF	367.69	367.71	367.35	367.53	8835.0
2021-08-17 06:00:00	QQQ	ETF	367.49	367.78	367.44	367.75	5400.0
2021-08-17 06:30:00	QQQ	ETF	367.77	367.82	367.47	367.78	30630.0
2021-08-17 07:00:00	QQQ	ETF	367.71	367.78	367.37	367.51	83461.0
2021-08-17 07:30:00	QQQ	ETF	367.49	367.71	367.46	367.648	87033.0
2021-08-17 08:00:00	QQQ	ETF	367.61	369.256	366.89	367.11	202275.0
2021-08-17 08:30:00	QQQ	ETF	367.0	367.25	366.501	366.9	156831.0
2021-08-17 09:00:00	QQQ	ETF	366.77	366.8	366.1	366.16	162862.0
2021-08-17 09:30:00	QQQ	ETF	366.15	366.77	364.66	365.18	6226927.0
2021-08-17 10:00:00	QQQ	ETF	365.17	366.26	364.51	366.07	3724710.0
2021-08-17 10:30:00	QQQ	ETF	366.06	367.15	365.66	366.38	2271894.0
2021-08-17 11:00:00	QQQ	ETF	366.4	366.4598	365.19	365.34	2223143.0
2021-08-17 11:30:00	QQQ	ETF	365.34	365.75	364.225	364.29	2160632.0
2021-08-17 12:00:00	QQQ	ETF	364.285	365.13	364.0	365.11	2156241.0
2021-08-17 12:30:00	QQQ	ETF	365.105	365.105	363.26	363.4	2714562.0

> showing 50 of 23,823 rows — these rows as CSV

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