PREVIEW / etf_30min / 2023-04-11

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-04-11.parquet
  size:    690 KB
  rows:    27,524

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-11 04:00:00	SPY	ETF	409.9	410.25	409.9	410.1	20451.0
2023-04-11 04:30:00	SPY	ETF	410.11	410.36	409.99	410.34	4489.0
2023-04-11 05:00:00	SPY	ETF	410.36	410.61	410.34	410.54	7551.0
2023-04-11 05:30:00	SPY	ETF	410.56	410.84	410.53	410.8	7517.0
2023-04-11 06:00:00	SPY	ETF	410.85	410.85	410.63	410.63	5741.0
2023-04-11 06:30:00	SPY	ETF	410.64	410.64	410.25	410.43	18906.0
2023-04-11 07:00:00	SPY	ETF	410.4	410.48	409.68	409.68	52009.0
2023-04-11 07:30:00	SPY	ETF	409.74	409.74	409.36	409.54	130262.0
2023-04-11 08:00:00	SPY	ETF	410.45	410.8296	409.36	409.74	221372.0
2023-04-11 08:30:00	SPY	ETF	409.73	410.15	409.68	409.73	117094.0
2023-04-11 09:00:00	SPY	ETF	409.73	410.28	409.63	410.26	142948.0
2023-04-11 09:30:00	SPY	ETF	410.27	410.2809	409.41	409.52	4070461.0
2023-04-11 10:00:00	SPY	ETF	409.54	410.01	409.33	410.005	3552488.0
2023-04-11 10:30:00	SPY	ETF	410.01	410.03	408.92	409.38	2738910.0
2023-04-11 11:00:00	SPY	ETF	409.4	410.1192	409.35	409.83	2335285.0
2023-04-11 11:30:00	SPY	ETF	409.82	410.1075	409.47	410.0291	1763826.0
2023-04-11 12:00:00	SPY	ETF	410.03	410.54	409.98	410.31	1933716.0
2023-04-11 12:30:00	SPY	ETF	410.31	410.49	409.83	410.41	2003871.0
2023-04-11 13:00:00	SPY	ETF	410.42	410.7	410.14	410.49	1833381.0
2023-04-11 13:30:00	SPY	ETF	410.485	410.88	410.33	410.81	1827836.0
2023-04-11 14:00:00	SPY	ETF	410.83	410.95	410.54	410.9399	2030029.0
2023-04-11 14:30:00	SPY	ETF	410.95	411.12	410.81	410.95	2282300.0
2023-04-11 15:00:00	SPY	ETF	410.95	411.18	410.61	410.98	2883167.0
2023-04-11 15:30:00	SPY	ETF	410.98	411.06	409.23	409.71	9670799.0
2023-04-11 16:00:00	SPY	ETF	409.7	410.03	409.6116	409.99	2513134.0
2023-04-11 16:30:00	SPY	ETF	409.97	410.02	409.8	409.8	429000.0
2023-04-11 17:00:00	SPY	ETF	409.86	409.9	409.72	409.79	42171.0
2023-04-11 17:30:00	SPY	ETF	409.805	409.81	409.65	409.75	7161.0
2023-04-11 18:00:00	SPY	ETF	409.74	409.92	409.74	409.83	57199.0
2023-04-11 18:30:00	SPY	ETF	409.87	409.941	409.79	409.85	11085.0
2023-04-11 19:00:00	SPY	ETF	409.85	409.9	409.81	409.83	7563.0
2023-04-11 19:30:00	SPY	ETF	409.85	410.05	409.85	409.94	29172.0
2023-04-11 04:00:00	QQQ	ETF	317.99	318.5	317.99	318.31	32832.0
2023-04-11 04:30:00	QQQ	ETF	318.36	318.6	318.23	318.6	7457.0
2023-04-11 05:00:00	QQQ	ETF	318.58	318.76	318.58	318.74	18433.0
2023-04-11 05:30:00	QQQ	ETF	318.75	319.02	318.66	319.02	18176.0
2023-04-11 06:00:00	QQQ	ETF	319.0	319.02	318.82	318.85	5562.0
2023-04-11 06:30:00	QQQ	ETF	318.85	318.89	318.23	318.33	22935.0
2023-04-11 07:00:00	QQQ	ETF	318.32	318.45	317.27	317.27	133482.0
2023-04-11 07:30:00	QQQ	ETF	317.35	317.5	317.07	317.28	85107.0
2023-04-11 08:00:00	QQQ	ETF	318.36	319.0004	317.1	317.41	159897.0
2023-04-11 08:30:00	QQQ	ETF	317.43	317.8	317.27	317.29	168873.0
2023-04-11 09:00:00	QQQ	ETF	317.28	317.93	317.11	317.84	290649.0
2023-04-11 09:30:00	QQQ	ETF	317.83	317.89	316.26	316.5999	4073879.0
2023-04-11 10:00:00	QQQ	ETF	316.6	316.919	315.68	316.5794	2621097.0
2023-04-11 10:30:00	QQQ	ETF	316.56	316.61	315.42	315.58	2588628.0
2023-04-11 11:00:00	QQQ	ETF	315.575	316.3299	315.37	315.84	2138894.0
2023-04-11 11:30:00	QQQ	ETF	315.82	315.98	315.31	315.86	1615456.0
2023-04-11 12:00:00	QQQ	ETF	315.85	316.55	315.8071	316.12	1479511.0
2023-04-11 12:30:00	QQQ	ETF	316.12	316.45	315.56	316.3613	1556759.0

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

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