PREVIEW / etf_30min / 2023-07-14

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-07-14.parquet
  size:    718 KB
  rows:    28,149

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
2023-07-14 04:00:00	SPY	ETF	449.51	449.61	449.4	449.44	12272.0
2023-07-14 04:30:00	SPY	ETF	449.48	449.63	449.36	449.36	9602.0
2023-07-14 05:00:00	SPY	ETF	449.39	449.45	449.31	449.44	3296.0
2023-07-14 05:30:00	SPY	ETF	449.39	449.43	449.16	449.36	6112.0
2023-07-14 06:00:00	SPY	ETF	449.3	449.52	449.3	449.5	6763.0
2023-07-14 06:30:00	SPY	ETF	449.46	450.02	449.45	449.92	56889.0
2023-07-14 07:00:00	SPY	ETF	449.93	450.2	449.92	450.15	65261.0
2023-07-14 07:30:00	SPY	ETF	450.19	450.33	450.05	450.17	67082.0
2023-07-14 08:00:00	SPY	ETF	450.06	450.55	449.31	450.4	110586.0
2023-07-14 08:30:00	SPY	ETF	450.41	450.61	449.27	450.51	238073.0
2023-07-14 09:00:00	SPY	ETF	450.43	450.51	450.19	450.46	185156.0
2023-07-14 09:30:00	SPY	ETF	450.48	451.09	450.35	451.03	5643771.0
2023-07-14 10:00:00	SPY	ETF	451.03	451.36	450.18	450.4325	5105349.0
2023-07-14 10:30:00	SPY	ETF	450.43	450.725	449.52	450.155	4975444.0
2023-07-14 11:00:00	SPY	ETF	450.155	450.53	450.05	450.3975	2646640.0
2023-07-14 11:30:00	SPY	ETF	450.4	450.815	450.0783	450.49	2901936.0
2023-07-14 12:00:00	SPY	ETF	450.5	450.54	449.715	449.755	2532433.0
2023-07-14 12:30:00	SPY	ETF	449.76	450.1173	449.56	449.8096	2217426.0
2023-07-14 13:00:00	SPY	ETF	449.81	449.855	449.19	449.75	2380642.0
2023-07-14 13:30:00	SPY	ETF	449.75	450.14	449.67	449.8387	1908834.0
2023-07-14 14:00:00	SPY	ETF	449.84	450.26	449.54	449.59	2292785.0
2023-07-14 14:30:00	SPY	ETF	449.61	449.81	449.19	449.2699	2283112.0
2023-07-14 15:00:00	SPY	ETF	449.265	449.55	448.63	449.12	3974131.0
2023-07-14 15:30:00	SPY	ETF	449.13	449.35	448.49	449.28	8061079.0
2023-07-14 16:00:00	SPY	ETF	449.27	449.28	448.8	448.92	2532989.0
2023-07-14 16:30:00	SPY	ETF	448.92	448.96	448.82	448.82	74720.0
2023-07-14 17:00:00	SPY	ETF	448.85	449.03	448.82	449.01	102068.0
2023-07-14 17:30:00	SPY	ETF	449.0	449.0	448.84	448.9	49796.0
2023-07-14 18:00:00	SPY	ETF	448.84	449.0	448.84	448.98	5240.0
2023-07-14 18:30:00	SPY	ETF	448.98	449.39	448.94	449.3	32256.0
2023-07-14 19:00:00	SPY	ETF	449.27	449.27	449.16	449.16	2049.0
2023-07-14 19:30:00	SPY	ETF	449.18	449.3	449.15	449.19	6583.0
2023-07-14 04:00:00	QQQ	ETF	379.5	379.97	379.39	379.4	37859.0
2023-07-14 04:30:00	QQQ	ETF	379.4	379.69	379.3	379.3	23592.0
2023-07-14 05:00:00	QQQ	ETF	379.29	379.36	379.26	379.33	9450.0
2023-07-14 05:30:00	QQQ	ETF	379.3	379.33	378.76	378.81	21978.0
2023-07-14 06:00:00	QQQ	ETF	378.85	379.09	378.85	379.05	15900.0
2023-07-14 06:30:00	QQQ	ETF	379.06	379.1	378.73	378.84	65709.0
2023-07-14 07:00:00	QQQ	ETF	378.86	379.3	378.83	379.28	141215.0
2023-07-14 07:30:00	QQQ	ETF	379.23	379.49	379.07	379.35	119618.0
2023-07-14 08:00:00	QQQ	ETF	379.01	379.9504	378.89	379.54	149488.0
2023-07-14 08:30:00	QQQ	ETF	379.57	379.64	379.24	379.33	184948.0
2023-07-14 09:00:00	QQQ	ETF	379.32	379.56	379.15	379.56	247872.0
2023-07-14 09:30:00	QQQ	ETF	379.59	381.768	379.58	381.67	5657669.0
2023-07-14 10:00:00	QQQ	ETF	381.63	382.86	380.77	381.9	5086178.0
2023-07-14 10:30:00	QQQ	ETF	381.93	382.43	380.34	381.16	4593891.0
2023-07-14 11:00:00	QQQ	ETF	381.1882	382.035	381.04	381.665	2633437.0
2023-07-14 11:30:00	QQQ	ETF	381.67	382.2499	381.565	381.86	1738769.0
2023-07-14 12:00:00	QQQ	ETF	381.865	381.9	380.6	380.84	1952590.0
2023-07-14 12:30:00	QQQ	ETF	380.85	381.285	380.385	380.62	1952082.0

> showing 50 of 28,149 rows — these rows as CSV

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