PREVIEW / etf_30min / 2023-04-26

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-04-26.parquet
  size:    684 KB
  rows:    27,699

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-26 04:00:00	SPY	ETF	407.35	407.79	406.8	407.7	48735.0
2023-04-26 04:30:00	SPY	ETF	407.87	407.96	407.66	407.85	20389.0
2023-04-26 05:00:00	SPY	ETF	407.9	408.02	407.59	407.7	11000.0
2023-04-26 05:30:00	SPY	ETF	407.66	407.97	407.09	407.39	53572.0
2023-04-26 06:00:00	SPY	ETF	407.42	407.7	407.2	407.41	8254.0
2023-04-26 06:30:00	SPY	ETF	407.36	407.36	406.53	406.7	73400.0
2023-04-26 07:00:00	SPY	ETF	406.75	406.93	405.81	406.22	143974.0
2023-04-26 07:30:00	SPY	ETF	406.17	407.3	406.16	406.48	333743.0
2023-04-26 08:00:00	SPY	ETF	406.4294	408.38	405.88	407.09	620587.0
2023-04-26 08:30:00	SPY	ETF	407.03	407.45	406.74	407.36	224307.0
2023-04-26 09:00:00	SPY	ETF	407.35	407.54	406.51	406.74	468417.0
2023-04-26 09:30:00	SPY	ETF	406.72	407.27	406.32	406.8987	5216565.0
2023-04-26 10:00:00	SPY	ETF	406.89	406.97	405.02	405.38	5098421.0
2023-04-26 10:30:00	SPY	ETF	405.38	406.32	405.345	406.24	4695415.0
2023-04-26 11:00:00	SPY	ETF	406.25	407.55	406.2372	407.15	4599562.0
2023-04-26 11:30:00	SPY	ETF	407.145	407.53	406.79	407.335	2742183.0
2023-04-26 12:00:00	SPY	ETF	407.33	407.84	407.06	407.1301	2886640.0
2023-04-26 12:30:00	SPY	ETF	407.13	407.1599	406.49	406.68	2533486.0
2023-04-26 13:00:00	SPY	ETF	406.68	406.98	406.06	406.25	3108759.0
2023-04-26 13:30:00	SPY	ETF	406.25	406.42	404.99	405.28	3693669.0
2023-04-26 14:00:00	SPY	ETF	405.28	405.3485	404.585	405.305	3873847.0
2023-04-26 14:30:00	SPY	ETF	405.3	405.33	404.09	404.36	3765673.0
2023-04-26 15:00:00	SPY	ETF	404.37	404.7325	403.95	404.2901	3997681.0
2023-04-26 15:30:00	SPY	ETF	404.31	404.96	403.78	404.37	10617316.0
2023-04-26 16:00:00	SPY	ETF	404.36	405.7462	404.29	405.44	3459330.0
2023-04-26 16:30:00	SPY	ETF	405.42	405.51	405.3	405.36	338813.0
2023-04-26 17:00:00	SPY	ETF	405.35	405.64	404.36	405.49	115678.0
2023-04-26 17:30:00	SPY	ETF	405.5	405.6	405.45	405.6	43227.0
2023-04-26 18:00:00	SPY	ETF	405.6	405.6	404.36	405.24	550931.0
2023-04-26 18:30:00	SPY	ETF	405.25	405.34	405.21	405.34	14893.0
2023-04-26 19:00:00	SPY	ETF	405.34	405.37	405.23	405.3	6557.0
2023-04-26 19:30:00	SPY	ETF	405.32	405.42	405.19	405.42	15272.0
2023-04-26 04:00:00	QQQ	ETF	313.8	313.94	313.23	313.79	101038.0
2023-04-26 04:30:00	QQQ	ETF	313.87	314.1	313.66	314.0	54445.0
2023-04-26 05:00:00	QQQ	ETF	313.97	314.08	313.73	313.79	63836.0
2023-04-26 05:30:00	QQQ	ETF	313.78	314.06	313.61	313.96	108314.0
2023-04-26 06:00:00	QQQ	ETF	313.95	314.01	313.53	313.73	48211.0
2023-04-26 06:30:00	QQQ	ETF	313.71	313.71	312.79	312.89	125452.0
2023-04-26 07:00:00	QQQ	ETF	312.96	313.11	312.04	312.28	429212.0
2023-04-26 07:30:00	QQQ	ETF	312.24	312.99	311.9	312.06	370024.0
2023-04-26 08:00:00	QQQ	ETF	312.1592	314.38	310.222	313.09	377819.0
2023-04-26 08:30:00	QQQ	ETF	312.77	313.52	312.6	313.4	555914.0
2023-04-26 09:00:00	QQQ	ETF	313.42	313.63	312.84	313.43	680598.0
2023-04-26 09:30:00	QQQ	ETF	313.44	313.78	312.22	313.69	5976315.0
2023-04-26 10:00:00	QQQ	ETF	313.69	313.85	312.14	312.67	4418434.0
2023-04-26 10:30:00	QQQ	ETF	312.66	313.43	312.585	313.25	2668414.0
2023-04-26 11:00:00	QQQ	ETF	313.25	314.55	313.18	314.06	3279996.0
2023-04-26 11:30:00	QQQ	ETF	314.065	314.46	313.89	314.3299	1905526.0
2023-04-26 12:00:00	QQQ	ETF	314.355	314.935	314.225	314.44	1914616.0
2023-04-26 12:30:00	QQQ	ETF	314.45	314.47	313.36	313.555	1540958.0

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

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