PREVIEW / etf_30min / 2023-10-23

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-10-23.parquet
  size:    753 KB
  rows:    29,726

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-10-23 04:00:00	SPY	ETF	420.42	421.13	420.15	420.9	43637.0
2023-10-23 04:30:00	SPY	ETF	420.9	421.02	420.5	420.52	17439.0
2023-10-23 05:00:00	SPY	ETF	420.57	420.57	419.26	419.26	43773.0
2023-10-23 05:30:00	SPY	ETF	419.24	419.24	418.1	418.19	73482.0
2023-10-23 06:00:00	SPY	ETF	418.2	418.83	418.16	418.6	38670.0
2023-10-23 06:30:00	SPY	ETF	418.57	419.13	418.57	419.13	20072.0
2023-10-23 07:00:00	SPY	ETF	419.16	419.31	418.9	419.11	58126.0
2023-10-23 07:30:00	SPY	ETF	419.23	419.94	419.0	419.46	115708.0
2023-10-23 08:00:00	SPY	ETF	419.1501	422.38	418.1796	419.83	343414.0
2023-10-23 08:30:00	SPY	ETF	419.77	420.15	419.52	419.52	257604.0
2023-10-23 09:00:00	SPY	ETF	419.61	419.97	419.14	419.6	499226.0
2023-10-23 09:30:00	SPY	ETF	419.61	420.7	417.8	420.6443	9509478.0
2023-10-23 10:00:00	SPY	ETF	420.64	421.64	420.22	420.825	6218896.0
2023-10-23 10:30:00	SPY	ETF	420.81	421.47	420.07	421.405	5167546.0
2023-10-23 11:00:00	SPY	ETF	421.4	422.73	421.2	422.39	5813924.0
2023-10-23 11:30:00	SPY	ETF	422.4	423.02	421.955	422.8267	4143502.0
2023-10-23 12:00:00	SPY	ETF	422.83	422.98	421.89	422.81	3295473.0
2023-10-23 12:30:00	SPY	ETF	422.84	424.41	422.58	424.41	3402386.0
2023-10-23 13:00:00	SPY	ETF	424.42	424.45	422.63	422.88	4347292.0
2023-10-23 13:30:00	SPY	ETF	422.88	423.855	422.66	422.96	3153412.0
2023-10-23 14:00:00	SPY	ETF	422.965	423.305	421.97	422.42	3551711.0
2023-10-23 14:30:00	SPY	ETF	422.42	423.17	422.09	422.75	3134440.0
2023-10-23 15:00:00	SPY	ETF	422.74	423.1	420.94	421.05	5352489.0
2023-10-23 15:30:00	SPY	ETF	421.06	421.35	420.24	420.45	13828389.0
2023-10-23 16:00:00	SPY	ETF	420.45	421.43	420.44	421.33	3397044.0
2023-10-23 16:30:00	SPY	ETF	421.33	423.8003	420.7299	421.41	199027.0
2023-10-23 17:00:00	SPY	ETF	421.45	421.53	421.42	421.46	22550.0
2023-10-23 17:30:00	SPY	ETF	421.44	421.55	421.43	421.51	16199.0
2023-10-23 18:00:00	SPY	ETF	421.51	421.55	421.3	421.55	32531.0
2023-10-23 18:30:00	SPY	ETF	421.56	421.58	421.43	421.58	6878.0
2023-10-23 19:00:00	SPY	ETF	421.6	421.7201	421.56	421.68	16770.0
2023-10-23 19:30:00	SPY	ETF	421.68	421.85	421.58	421.81	62776.0
2023-10-23 04:00:00	QQQ	ETF	354.12	354.82	353.91	354.57	31002.0
2023-10-23 04:30:00	QQQ	ETF	354.39	354.5	353.92	353.95	57061.0
2023-10-23 05:00:00	QQQ	ETF	353.8	353.8	352.92	352.98	42273.0
2023-10-23 05:30:00	QQQ	ETF	352.8	352.8	351.34	351.62	189545.0
2023-10-23 06:00:00	QQQ	ETF	351.7	352.11	351.67	351.97	155709.0
2023-10-23 06:30:00	QQQ	ETF	351.98	352.58	351.98	352.58	196382.0
2023-10-23 07:00:00	QQQ	ETF	352.58	352.8	352.32	352.63	111265.0
2023-10-23 07:30:00	QQQ	ETF	352.74	353.59	352.53	353.02	265320.0
2023-10-23 08:00:00	QQQ	ETF	353.04	355.74	351.48	353.41	262429.0
2023-10-23 08:30:00	QQQ	ETF	353.32	353.78	353.22	353.35	122844.0
2023-10-23 09:00:00	QQQ	ETF	353.37	353.71	352.98	353.16	132282.0
2023-10-23 09:30:00	QQQ	ETF	353.26	354.2	351.1199	354.06	7324437.0
2023-10-23 10:00:00	QQQ	ETF	354.06	355.31	353.41	354.79	4625881.0
2023-10-23 10:30:00	QQQ	ETF	354.78	355.62	354.015	355.61	2867600.0
2023-10-23 11:00:00	QQQ	ETF	355.64	356.77	355.3201	356.57	2917381.0
2023-10-23 11:30:00	QQQ	ETF	356.57	357.2	356.24	356.995	2613949.0
2023-10-23 12:00:00	QQQ	ETF	356.995	357.69	356.69	357.575	2126039.0
2023-10-23 12:30:00	QQQ	ETF	357.6	359.22	357.22	359.21	2291636.0

> showing 50 of 29,726 rows — these rows as CSV

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