PREVIEW / etf_30min / 2023-12-01

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-12-01.parquet
  size:    775 KB
  rows:    30,617

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-12-01 04:00:00	SPY	ETF	456.2	457.22	456.2	457.13	47998.0
2023-12-01 04:30:00	SPY	ETF	457.24	457.28	457.05	457.05	3073.0
2023-12-01 05:00:00	SPY	ETF	457.03	457.03	456.94	456.94	2741.0
2023-12-01 05:30:00	SPY	ETF	456.93	456.93	456.65	456.65	16684.0
2023-12-01 06:00:00	SPY	ETF	456.64	456.78	456.53	456.75	55745.0
2023-12-01 06:30:00	SPY	ETF	456.76	456.76	456.45	456.54	19908.0
2023-12-01 07:00:00	SPY	ETF	456.53	456.54	455.82	456.02	126267.0
2023-12-01 07:30:00	SPY	ETF	455.98	456.09	455.45	455.58	55202.0
2023-12-01 08:00:00	SPY	ETF	455.55	457.3104	455.45	455.8101	80678.0
2023-12-01 08:30:00	SPY	ETF	455.94	455.94	455.47	455.5299	144928.0
2023-12-01 09:00:00	SPY	ETF	455.51	455.77	455.31	455.75	210915.0
2023-12-01 09:30:00	SPY	ETF	455.76	456.22	455.18	456.105	4480522.0
2023-12-01 10:00:00	SPY	ETF	456.11	457.13	455.6	455.69	5591823.0
2023-12-01 10:30:00	SPY	ETF	455.68	456.49	455.33	456.33	3131317.0
2023-12-01 11:00:00	SPY	ETF	456.34	457.55	455.16	457.45	6586360.0
2023-12-01 11:30:00	SPY	ETF	457.46	458.75	456.84	458.33	5738482.0
2023-12-01 12:00:00	SPY	ETF	458.34	458.97	458.15	458.915	3993029.0
2023-12-01 12:30:00	SPY	ETF	458.91	459.65	458.69	459.41	4190874.0
2023-12-01 13:00:00	SPY	ETF	459.415	459.49	458.55	458.55	3403468.0
2023-12-01 13:30:00	SPY	ETF	458.55	458.76	458.19	458.31	3076086.0
2023-12-01 14:00:00	SPY	ETF	458.32	458.85	458.195	458.73	2802860.0
2023-12-01 14:30:00	SPY	ETF	458.73	459.09	458.4933	459.08	2311950.0
2023-12-01 15:00:00	SPY	ETF	459.07	459.14	458.38	459.05	3721243.0
2023-12-01 15:30:00	SPY	ETF	459.05	459.32	458.59	459.035	9530605.0
2023-12-01 16:00:00	SPY	ETF	459.03	459.28	458.7734	459.2103	6458684.0
2023-12-01 16:30:00	SPY	ETF	459.23	459.36	459.19	459.31	279171.0
2023-12-01 17:00:00	SPY	ETF	459.24	459.56	459.24	459.52	604302.0
2023-12-01 17:30:00	SPY	ETF	459.53	459.74	459.5	459.7	160505.0
2023-12-01 18:00:00	SPY	ETF	459.69	459.9	459.66	459.72	100247.0
2023-12-01 18:30:00	SPY	ETF	459.7	459.76	459.62	459.75	42482.0
2023-12-01 19:00:00	SPY	ETF	459.73	459.89	459.73	459.8	8884.0
2023-12-01 19:30:00	SPY	ETF	459.77	459.88	459.7518	459.82	18485.0
2023-12-01 04:00:00	QQQ	ETF	388.89	389.24	388.6	389.18	52324.0
2023-12-01 04:30:00	QQQ	ETF	389.22	389.35	388.98	388.98	17017.0
2023-12-01 05:00:00	QQQ	ETF	388.98	389.04	388.77	388.77	6042.0
2023-12-01 05:30:00	QQQ	ETF	388.86	388.86	388.63	388.63	4450.0
2023-12-01 06:00:00	QQQ	ETF	388.57	388.79	388.52	388.7	13412.0
2023-12-01 06:30:00	QQQ	ETF	388.71	388.71	388.36	388.51	8686.0
2023-12-01 07:00:00	QQQ	ETF	388.46	388.46	387.69	388.0	46121.0
2023-12-01 07:30:00	QQQ	ETF	388.01	388.06	387.4	387.52	69837.0
2023-12-01 08:00:00	QQQ	ETF	388.6604	389.2296	387.4	387.97	77745.0
2023-12-01 08:30:00	QQQ	ETF	387.97	388.07	387.62	387.63	88050.0
2023-12-01 09:00:00	QQQ	ETF	387.64	387.83	387.45	387.71	211631.0
2023-12-01 09:30:00	QQQ	ETF	387.72	387.99	386.33	387.25	3280179.0
2023-12-01 10:00:00	QQQ	ETF	387.27	388.46	386.29	386.46	3406800.0
2023-12-01 10:30:00	QQQ	ETF	386.46	387.35	386.0726	387.3	1917573.0
2023-12-01 11:00:00	QQQ	ETF	387.3077	388.95	386.55	388.41	4481780.0
2023-12-01 11:30:00	QQQ	ETF	388.43	389.78	387.82	389.195	3572754.0
2023-12-01 12:00:00	QQQ	ETF	389.2	389.8999	388.85	389.85	2150201.0
2023-12-01 12:30:00	QQQ	ETF	389.845	390.54	389.49	390.261	1869054.0

> showing 50 of 30,617 rows — these rows as CSV

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