PREVIEW / etf_30min / 2023-04-04

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-04-04.parquet
  size:    691 KB
  rows:    27,999

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-04 04:00:00	SPY	ETF	410.7	411.47	410.65	411.2	9629.0
2023-04-04 04:30:00	SPY	ETF	411.27	411.3	410.97	411.1	18072.0
2023-04-04 05:00:00	SPY	ETF	411.24	411.85	411.16	411.85	6477.0
2023-04-04 05:30:00	SPY	ETF	411.78	412.39	411.75	412.24	28260.0
2023-04-04 06:00:00	SPY	ETF	412.13	412.25	412.0	412.2	16381.0
2023-04-04 06:30:00	SPY	ETF	412.2	412.75	412.2	412.42	27856.0
2023-04-04 07:00:00	SPY	ETF	412.4	412.5	412.03	412.19	72424.0
2023-04-04 07:30:00	SPY	ETF	412.14	412.31	412.01	412.14	40768.0
2023-04-04 08:00:00	SPY	ETF	412.37	412.74	410.75	412.16	90426.0
2023-04-04 08:30:00	SPY	ETF	412.12	412.18	411.76	412.03	75551.0
2023-04-04 09:00:00	SPY	ETF	412.01	412.06	409.7339	411.61	207813.0
2023-04-04 09:30:00	SPY	ETF	411.61	411.68	410.45	411.01	5053410.0
2023-04-04 10:00:00	SPY	ETF	411.03	411.92	409.99	410.48	6109953.0
2023-04-04 10:30:00	SPY	ETF	410.49	411.03	409.54	409.72	3740821.0
2023-04-04 11:00:00	SPY	ETF	409.714	409.72	408.21	408.8719	5235542.0
2023-04-04 11:30:00	SPY	ETF	408.875	409.13	408.26	408.3	3388073.0
2023-04-04 12:00:00	SPY	ETF	408.3	408.5	407.24	408.3	4101023.0
2023-04-04 12:30:00	SPY	ETF	408.29	408.54	407.88	408.33	2340137.0
2023-04-04 13:00:00	SPY	ETF	408.35	409.15	408.11	408.98	2253276.0
2023-04-04 13:30:00	SPY	ETF	408.98	409.29	408.505	408.68	2422505.0
2023-04-04 14:00:00	SPY	ETF	408.69	408.975	407.91	407.96	2242723.0
2023-04-04 14:30:00	SPY	ETF	407.955	408.43	407.68	407.85	2768965.0
2023-04-04 15:00:00	SPY	ETF	407.84	408.52	407.67	407.79	2943699.0
2023-04-04 15:30:00	SPY	ETF	407.79	408.71	407.48	408.7	7366453.0
2023-04-04 16:00:00	SPY	ETF	408.71	409.0385	408.63	408.84	2408206.0
2023-04-04 16:30:00	SPY	ETF	408.83	409.01	408.67	408.97	394013.0
2023-04-04 17:00:00	SPY	ETF	408.99	409.01	408.91	408.94	11881.0
2023-04-04 17:30:00	SPY	ETF	408.92	409.05	408.91	409.05	26759.0
2023-04-04 18:00:00	SPY	ETF	409.04	409.06	408.88	408.9099	56453.0
2023-04-04 18:30:00	SPY	ETF	408.96	409.09	408.93	408.95	78211.0
2023-04-04 19:00:00	SPY	ETF	409.04	409.07	408.95	409.07	14822.0
2023-04-04 19:30:00	SPY	ETF	409.05	409.18	408.97	409.09	41823.0
2023-04-04 04:00:00	QQQ	ETF	319.52	320.05	319.52	319.9	18088.0
2023-04-04 04:30:00	QQQ	ETF	319.92	320.22	319.84	320.13	14837.0
2023-04-04 05:00:00	QQQ	ETF	320.22	321.14	320.18	321.06	34146.0
2023-04-04 05:30:00	QQQ	ETF	321.09	322.16	321.06	322.04	48277.0
2023-04-04 06:00:00	QQQ	ETF	322.05	322.05	321.67	321.73	40274.0
2023-04-04 06:30:00	QQQ	ETF	321.89	322.16	321.67	321.7	38708.0
2023-04-04 07:00:00	QQQ	ETF	321.62	321.81	321.29	321.6	90767.0
2023-04-04 07:30:00	QQQ	ETF	321.58	321.75	321.42	321.63	67023.0
2023-04-04 08:00:00	QQQ	ETF	321.6287	322.0496	319.52	321.33	221796.0
2023-04-04 08:30:00	QQQ	ETF	321.3	321.35	320.86	321.04	131396.0
2023-04-04 09:00:00	QQQ	ETF	321.03	321.03	320.47	320.58	164785.0
2023-04-04 09:30:00	QQQ	ETF	320.6	320.87	319.28	320.49	4210654.0
2023-04-04 10:00:00	QQQ	ETF	320.51	321.63	319.67	320.43	4238420.0
2023-04-04 10:30:00	QQQ	ETF	320.42	321.0	319.82	320.13	2777559.0
2023-04-04 11:00:00	QQQ	ETF	320.13	320.15	318.73	319.482	2766767.0
2023-04-04 11:30:00	QQQ	ETF	319.47	319.82	319.17	319.32	1855111.0
2023-04-04 12:00:00	QQQ	ETF	319.33	319.5001	318.22	319.03	2320853.0
2023-04-04 12:30:00	QQQ	ETF	318.994	319.36	318.71	319.075	1351408.0

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

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