PREVIEW / etf_30min / 2022-08-23

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-08-23.parquet
  size:    636 KB
  rows:    25,309

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-08-23 04:00:00	SPY	ETF	414.18	414.88	414.15	414.51	45540.0
2022-08-23 04:30:00	SPY	ETF	414.3	414.66	414.08	414.08	16632.0
2022-08-23 05:00:00	SPY	ETF	414.11	414.35	413.87	413.87	65811.0
2022-08-23 05:30:00	SPY	ETF	413.93	414.49	413.68	414.49	22391.0
2022-08-23 06:00:00	SPY	ETF	414.39	414.39	413.49	413.5	19248.0
2022-08-23 06:30:00	SPY	ETF	413.56	414.29	413.5	413.84	120228.0
2022-08-23 07:00:00	SPY	ETF	413.74	413.92	413.35	413.52	86690.0
2022-08-23 07:30:00	SPY	ETF	413.53	414.2	413.45	414.09	131015.0
2022-08-23 08:00:00	SPY	ETF	413.81	414.72	411.75	413.78	255279.0
2022-08-23 08:30:00	SPY	ETF	413.8	413.87	412.9	413.12	141448.0
2022-08-23 09:00:00	SPY	ETF	413.02	413.2	412.54	412.88	257343.0
2022-08-23 09:30:00	SPY	ETF	412.9	414.51	412.35	413.88	5175802.0
2022-08-23 10:00:00	SPY	ETF	413.88	415.42	413.4071	414.03	3944579.0
2022-08-23 10:30:00	SPY	ETF	414.03	414.94	412.77	412.8999	3194662.0
2022-08-23 11:00:00	SPY	ETF	412.91	413.55	412.03	412.8	2968094.0
2022-08-23 11:30:00	SPY	ETF	412.8092	413.55	412.67	412.95	2047477.0
2022-08-23 12:00:00	SPY	ETF	412.96	413.01	411.77	411.83	2287149.0
2022-08-23 12:30:00	SPY	ETF	411.812	413.21	411.805	413.0909	2047997.0
2022-08-23 13:00:00	SPY	ETF	413.092	413.48	412.42	413.3401	1811619.0
2022-08-23 13:30:00	SPY	ETF	413.35	413.61	412.05	412.46	1736529.0
2022-08-23 14:00:00	SPY	ETF	412.48	413.24	412.18	413.115	1907775.0
2022-08-23 14:30:00	SPY	ETF	413.0999	413.29	412.47	412.82	1600305.0
2022-08-23 15:00:00	SPY	ETF	412.83	413.51	412.79	413.08	2116245.0
2022-08-23 15:30:00	SPY	ETF	413.1	413.21	412.14	412.33	6407345.0
2022-08-23 16:00:00	SPY	ETF	412.32	412.55	411.98	412.2	2263363.0
2022-08-23 16:30:00	SPY	ETF	412.22	412.22	412.0	412.02	88866.0
2022-08-23 17:00:00	SPY	ETF	412.01	412.2	412.0	412.02	10197.0
2022-08-23 17:30:00	SPY	ETF	412.02	412.06	411.99	412.05	23087.0
2022-08-23 18:00:00	SPY	ETF	412.02	412.35	411.99	412.25	65697.0
2022-08-23 18:30:00	SPY	ETF	412.27	412.36	412.19	412.33	8917.0
2022-08-23 19:00:00	SPY	ETF	412.33	412.51	412.33	412.38	23016.0
2022-08-23 19:30:00	SPY	ETF	412.35	412.35	412.0	412.1	42271.0
2022-08-23 04:00:00	QQQ	ETF	314.92	315.71	314.92	315.22	67599.0
2022-08-23 04:30:00	QQQ	ETF	315.15	315.5	315.08	315.13	16921.0
2022-08-23 05:00:00	QQQ	ETF	315.07	315.28	314.74	314.81	15392.0
2022-08-23 05:30:00	QQQ	ETF	314.82	315.43	314.62	315.43	16026.0
2022-08-23 06:00:00	QQQ	ETF	315.31	315.35	314.35	314.35	18999.0
2022-08-23 06:30:00	QQQ	ETF	314.37	315.16	314.37	314.76	13350.0
2022-08-23 07:00:00	QQQ	ETF	314.68	314.84	314.37	314.54	95968.0
2022-08-23 07:30:00	QQQ	ETF	314.78	315.29	314.58	315.11	113227.0
2022-08-23 08:00:00	QQQ	ETF	314.4599	315.53	313.0	314.87	189351.0
2022-08-23 08:30:00	QQQ	ETF	314.88	314.95	314.1	314.19	327428.0
2022-08-23 09:00:00	QQQ	ETF	314.151	314.16	313.63	314.08	421035.0
2022-08-23 09:30:00	QQQ	ETF	314.1	316.17	313.33	315.26	5416725.0
2022-08-23 10:00:00	QQQ	ETF	315.27	317.0	314.71	315.42	3015709.0
2022-08-23 10:30:00	QQQ	ETF	315.43	316.21	314.0028	314.13	2625563.0
2022-08-23 11:00:00	QQQ	ETF	314.1101	315.17	313.5038	314.38	2338550.0
2022-08-23 11:30:00	QQQ	ETF	314.3817	315.2	314.35	314.6	1539032.0
2022-08-23 12:00:00	QQQ	ETF	314.62	314.715	313.69	313.77	1616644.0
2022-08-23 12:30:00	QQQ	ETF	313.74	315.05	313.72	314.94	1226032.0

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

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