PREVIEW / etf_30min / 2023-03-24

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-03-24.parquet
  size:    683 KB
  rows:    27,610

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-03-24 04:00:00	SPY	ETF	394.84	394.84	392.85	393.83	79860.0
2023-03-24 04:30:00	SPY	ETF	393.74	393.81	391.77	392.82	66346.0
2023-03-24 05:00:00	SPY	ETF	392.63	393.3	392.02	392.2	80608.0
2023-03-24 05:30:00	SPY	ETF	392.18	392.22	390.49	390.49	85361.0
2023-03-24 06:00:00	SPY	ETF	390.47	391.09	389.9	390.74	154849.0
2023-03-24 06:30:00	SPY	ETF	390.45	390.96	389.78	390.51	177592.0
2023-03-24 07:00:00	SPY	ETF	390.59	390.6	389.74	390.39	400484.0
2023-03-24 07:30:00	SPY	ETF	390.45	390.97	389.56	389.89	331861.0
2023-03-24 08:00:00	SPY	ETF	390.44	395.3	389.33	390.11	567603.0
2023-03-24 08:30:00	SPY	ETF	390.02	391.48	389.61	391.2	649879.0
2023-03-24 09:00:00	SPY	ETF	391.2	391.99	390.13	391.84	472961.0
2023-03-24 09:30:00	SPY	ETF	391.84	391.98	389.4	391.645	10490447.0
2023-03-24 10:00:00	SPY	ETF	391.66	392.63	390.22	392.42	8820584.0
2023-03-24 10:30:00	SPY	ETF	392.42	392.94	390.805	391.54	4908912.0
2023-03-24 11:00:00	SPY	ETF	391.52	391.96	389.92	390.79	5069422.0
2023-03-24 11:30:00	SPY	ETF	390.79	393.3	390.4	393.13	6736502.0
2023-03-24 12:00:00	SPY	ETF	393.13	394.0	391.7	392.35	4722602.0
2023-03-24 12:30:00	SPY	ETF	392.35	393.82	392.16	393.31	4084799.0
2023-03-24 13:00:00	SPY	ETF	393.31	394.17	392.69	393.635	3545851.0
2023-03-24 13:30:00	SPY	ETF	393.62	394.38	393.04	393.555	3338653.0
2023-03-24 14:00:00	SPY	ETF	393.56	394.6	393.42	394.17	3137206.0
2023-03-24 14:30:00	SPY	ETF	394.19	395.14	394.0818	394.65	4317334.0
2023-03-24 15:00:00	SPY	ETF	394.67	395.73	394.05	395.46	4829017.0
2023-03-24 15:30:00	SPY	ETF	395.45	395.84	394.42	395.72	11319911.0
2023-03-24 16:00:00	SPY	ETF	395.71	396.27	395.5	396.23	4387227.0
2023-03-24 16:30:00	SPY	ETF	396.22	396.55	395.75	396.5	484390.0
2023-03-24 17:00:00	SPY	ETF	396.49	396.53	395.75	396.35	45063.0
2023-03-24 17:30:00	SPY	ETF	396.39	396.44	395.75	396.44	512069.0
2023-03-24 18:00:00	SPY	ETF	396.4	396.46	396.35	396.46	10040.0
2023-03-24 18:30:00	SPY	ETF	396.41	396.41	396.1	396.3499	34115.0
2023-03-24 19:00:00	SPY	ETF	396.35	396.5	396.29	396.49	8772.0
2023-03-24 19:30:00	SPY	ETF	396.45	396.49	396.35	396.46	12771.0
2023-03-24 04:00:00	QQQ	ETF	311.21	311.23	309.73	310.73	44454.0
2023-03-24 04:30:00	QQQ	ETF	310.57	310.74	309.26	310.12	33920.0
2023-03-24 05:00:00	QQQ	ETF	309.92	310.49	309.6	309.72	21499.0
2023-03-24 05:30:00	QQQ	ETF	309.67	309.67	308.43	308.52	39846.0
2023-03-24 06:00:00	QQQ	ETF	308.52	309.04	308.1	308.69	61333.0
2023-03-24 06:30:00	QQQ	ETF	308.56	309.03	308.2	308.82	61281.0
2023-03-24 07:00:00	QQQ	ETF	308.9	308.9	308.14	308.65	137789.0
2023-03-24 07:30:00	QQQ	ETF	308.79	309.029	307.93	308.18	164580.0
2023-03-24 08:00:00	QQQ	ETF	308.8	311.74	307.55	308.27	512670.0
2023-03-24 08:30:00	QQQ	ETF	308.29	309.12	308.03	308.87	585932.0
2023-03-24 09:00:00	QQQ	ETF	308.88	309.37	308.1	309.33	317252.0
2023-03-24 09:30:00	QQQ	ETF	309.32	309.73	307.18	309.21	6655101.0
2023-03-24 10:00:00	QQQ	ETF	309.25	309.705	307.65	309.26	5284054.0
2023-03-24 10:30:00	QQQ	ETF	309.26	309.64	308.02	308.74	3491944.0
2023-03-24 11:00:00	QQQ	ETF	308.75	309.05	306.95	307.49	3862646.0
2023-03-24 11:30:00	QQQ	ETF	307.49	309.53	307.14	309.35	3513385.0
2023-03-24 12:00:00	QQQ	ETF	309.3555	310.0	307.555	308.11	2968349.0
2023-03-24 12:30:00	QQQ	ETF	308.12	309.22	307.98	308.71	2234612.0

> showing 50 of 27,610 rows — these rows as CSV

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