PREVIEW / etf_30min / 2023-04-17

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-04-17.parquet
  size:    682 KB
  rows:    27,407

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-04-17 04:00:00	SPY	ETF	413.32	413.51	413.14	413.24	22096.0
2023-04-17 04:30:00	SPY	ETF	413.11	413.19	413.0	413.04	25042.0
2023-04-17 05:00:00	SPY	ETF	413.08	413.21	412.89	413.02	12506.0
2023-04-17 05:30:00	SPY	ETF	412.99	413.1	412.63	412.81	20994.0
2023-04-17 06:00:00	SPY	ETF	412.81	412.92	412.73	412.75	3310.0
2023-04-17 06:30:00	SPY	ETF	412.84	413.07	412.8	413.04	6160.0
2023-04-17 07:00:00	SPY	ETF	412.99	413.21	412.92	412.92	74562.0
2023-04-17 07:30:00	SPY	ETF	412.95	413.09	412.71	413.06	43973.0
2023-04-17 08:00:00	SPY	ETF	413.0219	413.74	412.71	412.85	216010.0
2023-04-17 08:30:00	SPY	ETF	412.85	413.0896	412.47	412.6	236457.0
2023-04-17 09:00:00	SPY	ETF	412.61	412.77	412.21	412.38	248377.0
2023-04-17 09:30:00	SPY	ETF	412.37	413.19	412.23	412.6786	4977423.0
2023-04-17 10:00:00	SPY	ETF	412.685	413.175	412.32	412.75	3223748.0
2023-04-17 10:30:00	SPY	ETF	412.75	413.11	411.9301	412.3401	4204711.0
2023-04-17 11:00:00	SPY	ETF	412.35	412.69	412.01	412.15	2573217.0
2023-04-17 11:30:00	SPY	ETF	412.14	412.145	411.21	411.67	3976044.0
2023-04-17 12:00:00	SPY	ETF	411.68	411.895	411.26	411.7133	2429571.0
2023-04-17 12:30:00	SPY	ETF	411.71	412.0	411.5	411.7699	1738260.0
2023-04-17 13:00:00	SPY	ETF	411.76	412.12	411.425	411.986	1808071.0
2023-04-17 13:30:00	SPY	ETF	411.98	412.1	411.23	411.3234	2411810.0
2023-04-17 14:00:00	SPY	ETF	411.3201	411.69	411.085	411.64	2304950.0
2023-04-17 14:30:00	SPY	ETF	411.64	412.81	411.54	412.7	3722843.0
2023-04-17 15:00:00	SPY	ETF	412.7	413.54	412.7	413.486	4335802.0
2023-04-17 15:30:00	SPY	ETF	413.49	413.96	413.05	413.94	9458048.0
2023-04-17 16:00:00	SPY	ETF	413.94	414.25	413.88	414.18	2886861.0
2023-04-17 16:30:00	SPY	ETF	414.2	414.29	413.8993	413.95	222474.0
2023-04-17 17:00:00	SPY	ETF	413.9	414.0	413.83	413.88	56734.0
2023-04-17 17:30:00	SPY	ETF	413.94	413.96	413.86	413.87	11063.0
2023-04-17 18:00:00	SPY	ETF	413.87	413.92	413.77	413.81	26043.0
2023-04-17 18:30:00	SPY	ETF	413.8199	413.8657	413.75	413.8657	15245.0
2023-04-17 19:00:00	SPY	ETF	413.88	413.96	413.8	413.89	25574.0
2023-04-17 19:30:00	SPY	ETF	413.88	413.91	413.8	413.88	32169.0
2023-04-17 04:00:00	QQQ	ETF	319.24	319.36	318.67	319.0	29351.0
2023-04-17 04:30:00	QQQ	ETF	319.0	319.02	318.72	318.8	14939.0
2023-04-17 05:00:00	QQQ	ETF	318.82	318.86	318.34	318.55	6446.0
2023-04-17 05:30:00	QQQ	ETF	318.57	318.65	318.03	318.24	19263.0
2023-04-17 06:00:00	QQQ	ETF	318.17	318.39	318.17	318.2	8727.0
2023-04-17 06:30:00	QQQ	ETF	318.31	318.88	318.22	318.76	20257.0
2023-04-17 07:00:00	QQQ	ETF	318.78	319.09	318.54	318.54	49918.0
2023-04-17 07:30:00	QQQ	ETF	318.53	318.73	318.32	318.57	34766.0
2023-04-17 08:00:00	QQQ	ETF	318.83	319.2404	318.2096	318.8	124115.0
2023-04-17 08:30:00	QQQ	ETF	318.65	318.88	318.1	318.48	202947.0
2023-04-17 09:00:00	QQQ	ETF	318.53	318.73	318.11	318.17	366895.0
2023-04-17 09:30:00	QQQ	ETF	318.15	319.1999	317.66	318.1499	4547429.0
2023-04-17 10:00:00	QQQ	ETF	318.14	318.88	317.57	317.91	2961784.0
2023-04-17 10:30:00	QQQ	ETF	317.92	318.18	316.93	317.58	2653155.0
2023-04-17 11:00:00	QQQ	ETF	317.59	317.915	317.07	317.12	1906278.0
2023-04-17 11:30:00	QQQ	ETF	317.12	317.12	316.35	316.7305	2471046.0
2023-04-17 12:00:00	QQQ	ETF	316.73	316.82	316.04	316.525	2032213.0
2023-04-17 12:30:00	QQQ	ETF	316.525	316.96	316.42	316.91	1484630.0

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

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