PREVIEW / etf_30min / 2022-04-08

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-04-08.parquet
  size:    654 KB
  rows:    25,577

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
2022-04-08 04:00:00	SPY	ETF	450.53	450.9	450.45	450.9	15397.0
2022-04-08 04:30:00	SPY	ETF	450.86	451.0	449.91	449.95	17504.0
2022-04-08 05:00:00	SPY	ETF	449.63	449.73	449.5	449.68	7467.0
2022-04-08 05:30:00	SPY	ETF	449.64	449.77	449.5	449.68	2525.0
2022-04-08 06:00:00	SPY	ETF	449.68	449.83	449.1	449.17	11281.0
2022-04-08 06:30:00	SPY	ETF	449.21	450.1	449.2	450.1	15099.0
2022-04-08 07:00:00	SPY	ETF	450.02	450.26	449.86	450.16	25106.0
2022-04-08 07:30:00	SPY	ETF	450.2	450.46	449.98	450.06	124872.0
2022-04-08 08:00:00	SPY	ETF	449.95	450.8904	448.52	449.79	185549.0
2022-04-08 08:30:00	SPY	ETF	449.86	449.89	448.65	448.8	154060.0
2022-04-08 09:00:00	SPY	ETF	448.77	448.77	447.84	447.96	313053.0
2022-04-08 09:30:00	SPY	ETF	447.97	448.2	445.97	446.1	5576738.0
2022-04-08 10:00:00	SPY	ETF	446.08	447.56	445.94	447.45	4596722.0
2022-04-08 10:30:00	SPY	ETF	447.43	449.85	447.14	449.79	4573586.0
2022-04-08 11:00:00	SPY	ETF	449.8	450.255	448.99	449.34	4298225.0
2022-04-08 11:30:00	SPY	ETF	449.34	449.88	448.84	449.58	2377882.0
2022-04-08 12:00:00	SPY	ETF	449.58	450.63	449.0822	450.41	2543295.0
2022-04-08 12:30:00	SPY	ETF	450.42	450.46	449.47	450.19	2516906.0
2022-04-08 13:00:00	SPY	ETF	450.19	450.2168	449.19	449.26	1955837.0
2022-04-08 13:30:00	SPY	ETF	449.27	449.29	448.6	448.83	2498230.0
2022-04-08 14:00:00	SPY	ETF	448.8301	449.35	447.76	448.03	3022875.0
2022-04-08 14:30:00	SPY	ETF	448.04	449.1299	447.64	448.61	2644390.0
2022-04-08 15:00:00	SPY	ETF	448.62	449.37	448.13	448.8999	2788186.0
2022-04-08 15:30:00	SPY	ETF	448.89	449.14	446.68	447.62	11887306.0
2022-04-08 16:00:00	SPY	ETF	447.61	448.04	447.2	447.57	2847397.0
2022-04-08 16:30:00	SPY	ETF	447.54	447.6	447.24	447.41	154919.0
2022-04-08 17:00:00	SPY	ETF	447.54	447.57	447.21	447.22	65609.0
2022-04-08 17:30:00	SPY	ETF	447.22	447.32	447.08	447.08	9278.0
2022-04-08 18:00:00	SPY	ETF	447.18	447.18	447.1	447.1	2475.0
2022-04-08 18:30:00	SPY	ETF	447.11	447.32	447.11	447.31	15165.0
2022-04-08 19:00:00	SPY	ETF	447.3	447.32	447.24	447.29	7003.0
2022-04-08 19:30:00	SPY	ETF	447.29	447.29	447.16	447.24	5388.0
2022-04-08 04:00:00	QQQ	ETF	356.01	356.53	355.97	356.24	40843.0
2022-04-08 04:30:00	QQQ	ETF	356.26	356.33	355.16	355.21	28437.0
2022-04-08 05:00:00	QQQ	ETF	355.08	355.08	354.64	354.99	22403.0
2022-04-08 05:30:00	QQQ	ETF	355.01	355.01	354.62	354.91	10459.0
2022-04-08 06:00:00	QQQ	ETF	354.9	355.07	354.1	354.31	40661.0
2022-04-08 06:30:00	QQQ	ETF	354.29	355.2	354.14	355.15	28455.0
2022-04-08 07:00:00	QQQ	ETF	355.17	355.38	354.95	355.16	50897.0
2022-04-08 07:30:00	QQQ	ETF	355.1	355.5	354.95	355.11	149396.0
2022-04-08 08:00:00	QQQ	ETF	355.21	356.4896	353.9	354.69	243863.0
2022-04-08 08:30:00	QQQ	ETF	354.73	354.81	353.36	353.53	254623.0
2022-04-08 09:00:00	QQQ	ETF	353.47	353.47	352.2	352.37	603218.0
2022-04-08 09:30:00	QQQ	ETF	352.32	352.54	348.62	348.84	7013737.0
2022-04-08 10:00:00	QQQ	ETF	348.82	351.1	348.71	350.84	4500279.0
2022-04-08 10:30:00	QQQ	ETF	350.88	352.42	349.67	352.39	4093661.0
2022-04-08 11:00:00	QQQ	ETF	352.38	353.04	350.98	351.37	3504702.0
2022-04-08 11:30:00	QQQ	ETF	351.41	352.115	350.49	351.83	2796076.0
2022-04-08 12:00:00	QQQ	ETF	351.81	353.09	351.35	352.89	2435501.0
2022-04-08 12:30:00	QQQ	ETF	352.88	352.93	351.92	352.66	1880506.0

> showing 50 of 25,577 rows — these rows as CSV

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