PREVIEW / etf_30min / 2023-06-14

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-06-14.parquet
  size:    725 KB
  rows:    28,394

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-06-14 04:00:00	SPY	ETF	437.53	437.6	437.37	437.6	12136.0
2023-06-14 04:30:00	SPY	ETF	437.56	437.87	437.54	437.73	19862.0
2023-06-14 05:00:00	SPY	ETF	437.66	437.79	437.4	437.56	8616.0
2023-06-14 05:30:00	SPY	ETF	437.71	437.71	437.21	437.27	6514.0
2023-06-14 06:00:00	SPY	ETF	437.26	437.4	437.21	437.4	6561.0
2023-06-14 06:30:00	SPY	ETF	437.41	437.68	437.4	437.58	20488.0
2023-06-14 07:00:00	SPY	ETF	437.53	437.77	437.41	437.75	45059.0
2023-06-14 07:30:00	SPY	ETF	437.79	437.79	437.2	437.31	49808.0
2023-06-14 08:00:00	SPY	ETF	437.5317	437.7492	436.65	437.52	91842.0
2023-06-14 08:30:00	SPY	ETF	437.37	437.8	436.64	437.15	191932.0
2023-06-14 09:00:00	SPY	ETF	437.15	437.22	436.94	437.01	115750.0
2023-06-14 09:30:00	SPY	ETF	437.01	437.69	436.51	437.5	4519296.0
2023-06-14 10:00:00	SPY	ETF	437.51	438.25	437.35	437.71	4229464.0
2023-06-14 10:30:00	SPY	ETF	437.715	438.35	437.66	437.865	2747764.0
2023-06-14 11:00:00	SPY	ETF	437.865	439.0612	437.74	438.65	3157980.0
2023-06-14 11:30:00	SPY	ETF	438.6499	438.735	438.08	438.25	2170358.0
2023-06-14 12:00:00	SPY	ETF	438.25	438.4	437.57	438.1601	2095479.0
2023-06-14 12:30:00	SPY	ETF	438.16	438.1899	437.82	438.075	1730160.0
2023-06-14 13:00:00	SPY	ETF	438.08	438.09	437.05	437.2805	2341104.0
2023-06-14 13:30:00	SPY	ETF	437.29	437.51	436.94	437.29	2660752.0
2023-06-14 14:00:00	SPY	ETF	437.29	437.32	433.59	434.49	13315837.0
2023-06-14 14:30:00	SPY	ETF	434.495	437.08	433.96	436.352	10301123.0
2023-06-14 15:00:00	SPY	ETF	436.37	438.15	435.7195	436.62	7700922.0
2023-06-14 15:30:00	SPY	ETF	436.66	437.19	435.13	437.18	10816759.0
2023-06-14 16:00:00	SPY	ETF	437.17	437.53	437.01	437.37	3271676.0
2023-06-14 16:30:00	SPY	ETF	437.39	437.88	437.38	437.65	297740.0
2023-06-14 17:00:00	SPY	ETF	437.64	437.72	437.18	437.68	30293.0
2023-06-14 17:30:00	SPY	ETF	437.58	437.7	437.18	437.53	81081.0
2023-06-14 18:00:00	SPY	ETF	437.5	437.76	437.4	437.49	77432.0
2023-06-14 18:30:00	SPY	ETF	437.48	437.65	437.45	437.52	7400.0
2023-06-14 19:00:00	SPY	ETF	437.5	437.52	437.36	437.36	14643.0
2023-06-14 19:30:00	SPY	ETF	437.36	437.44	437.24	437.24	25738.0
2023-06-14 04:00:00	QQQ	ETF	364.42	364.45	363.78	364.42	17221.0
2023-06-14 04:30:00	QQQ	ETF	364.39	364.67	364.27	364.34	22860.0
2023-06-14 05:00:00	QQQ	ETF	364.29	364.35	363.98	364.28	31029.0
2023-06-14 05:30:00	QQQ	ETF	364.28	364.5	364.0	364.0	31336.0
2023-06-14 06:00:00	QQQ	ETF	364.08	364.09	363.82	364.09	9448.0
2023-06-14 06:30:00	QQQ	ETF	364.07	364.3	363.7	363.83	26770.0
2023-06-14 07:00:00	QQQ	ETF	363.83	364.04	363.71	364.04	42099.0
2023-06-14 07:30:00	QQQ	ETF	364.09	364.1	363.75	363.91	48550.0
2023-06-14 08:00:00	QQQ	ETF	363.7809	364.4	362.988	364.01	138062.0
2023-06-14 08:30:00	QQQ	ETF	363.9	364.45	363.22	363.56	341323.0
2023-06-14 09:00:00	QQQ	ETF	363.48	363.5	363.06	363.25	224321.0
2023-06-14 09:30:00	QQQ	ETF	363.27	363.98	362.26	363.87	4167485.0
2023-06-14 10:00:00	QQQ	ETF	363.88	365.12	363.57	364.505	2650075.0
2023-06-14 10:30:00	QQQ	ETF	364.54	365.29	364.48	364.58	2192605.0
2023-06-14 11:00:00	QQQ	ETF	364.58	366.19	364.2017	365.74	2233685.0
2023-06-14 11:30:00	QQQ	ETF	365.75	365.91	364.97	365.19	1661059.0
2023-06-14 12:00:00	QQQ	ETF	365.18	365.56	364.56	365.27	1425661.0
2023-06-14 12:30:00	QQQ	ETF	365.279	365.32	364.9005	365.265	1294181.0

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

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