PREVIEW / etf_30min / 2023-04-27

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-04-27.parquet
  size:    687 KB
  rows:    27,123

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-27 04:00:00	SPY	ETF	406.06	406.63	406.06	406.51	9783.0
2023-04-27 04:30:00	SPY	ETF	406.6	406.7	406.5	406.65	12006.0
2023-04-27 05:00:00	SPY	ETF	406.63	406.71	406.45	406.57	3846.0
2023-04-27 05:30:00	SPY	ETF	406.5	406.72	406.45	406.45	16352.0
2023-04-27 06:00:00	SPY	ETF	406.56	406.56	406.35	406.43	12772.0
2023-04-27 06:30:00	SPY	ETF	406.52	406.82	406.5	406.8	27812.0
2023-04-27 07:00:00	SPY	ETF	406.83	407.11	406.4	406.93	156760.0
2023-04-27 07:30:00	SPY	ETF	406.95	407.03	406.65	406.91	98898.0
2023-04-27 08:00:00	SPY	ETF	406.88	407.37	405.73	407.14	192854.0
2023-04-27 08:30:00	SPY	ETF	407.05	407.57	406.01	406.98	598630.0
2023-04-27 09:00:00	SPY	ETF	407.02	407.39	406.78	406.99	427414.0
2023-04-27 09:30:00	SPY	ETF	406.99	407.85	406.74	407.56	7375347.0
2023-04-27 10:00:00	SPY	ETF	407.56	408.51	407.43	408.19	5559912.0
2023-04-27 10:30:00	SPY	ETF	408.195	408.57	407.58	407.699	4162097.0
2023-04-27 11:00:00	SPY	ETF	407.71	408.9555	407.45	408.79	3422956.0
2023-04-27 11:30:00	SPY	ETF	408.79	409.21	408.5	409.17	3461295.0
2023-04-27 12:00:00	SPY	ETF	409.17	409.68	409.16	409.5189	3155007.0
2023-04-27 12:30:00	SPY	ETF	409.515	409.85	409.4	409.755	2611547.0
2023-04-27 13:00:00	SPY	ETF	409.76	410.12	409.57	410.08	2102403.0
2023-04-27 13:30:00	SPY	ETF	410.08	411.149	410.07	410.77	4387132.0
2023-04-27 14:00:00	SPY	ETF	410.78	411.8	410.74	411.69	4182303.0
2023-04-27 14:30:00	SPY	ETF	411.695	412.5	411.55	412.47	5622490.0
2023-04-27 15:00:00	SPY	ETF	412.48	412.69	412.07	412.335	5006599.0
2023-04-27 15:30:00	SPY	ETF	412.33	412.65	412.11	412.4	13177674.0
2023-04-27 16:00:00	SPY	ETF	412.39	413.57	410.4774	412.62	5632664.0
2023-04-27 16:30:00	SPY	ETF	412.6001	412.99	412.41	412.8	274538.0
2023-04-27 17:00:00	SPY	ETF	412.79	412.99	412.41	412.99	39036.0
2023-04-27 17:30:00	SPY	ETF	412.9	412.99	411.8	411.87	635597.0
2023-04-27 18:00:00	SPY	ETF	411.94	412.24	411.72	411.72	153135.0
2023-04-27 18:30:00	SPY	ETF	411.71	411.9199	411.68	411.88	45337.0
2023-04-27 19:00:00	SPY	ETF	411.94	412.21	411.9	411.93	29099.0
2023-04-27 19:30:00	SPY	ETF	411.91	412.0	411.81	411.86	50163.0
2023-04-27 04:00:00	QQQ	ETF	314.86	314.93	313.9	314.59	30595.0
2023-04-27 04:30:00	QQQ	ETF	314.45	314.62	314.31	314.56	17780.0
2023-04-27 05:00:00	QQQ	ETF	314.69	314.8	314.52	314.54	13699.0
2023-04-27 05:30:00	QQQ	ETF	314.57	314.75	314.41	314.41	10866.0
2023-04-27 06:00:00	QQQ	ETF	314.46	314.46	314.11	314.41	28242.0
2023-04-27 06:30:00	QQQ	ETF	314.42	314.72	314.17	314.65	14130.0
2023-04-27 07:00:00	QQQ	ETF	314.64	315.01	314.51	315.0	79079.0
2023-04-27 07:30:00	QQQ	ETF	314.98	315.05	314.69	314.92	108397.0
2023-04-27 08:00:00	QQQ	ETF	314.61	315.64	312.103	315.49	273793.0
2023-04-27 08:30:00	QQQ	ETF	315.31	315.85	314.35	315.28	478340.0
2023-04-27 09:00:00	QQQ	ETF	315.26	315.83	315.15	315.71	397022.0
2023-04-27 09:30:00	QQQ	ETF	315.7	316.24	315.05	315.3	5775604.0
2023-04-27 10:00:00	QQQ	ETF	315.3	316.95	315.11	316.66	4347754.0
2023-04-27 10:30:00	QQQ	ETF	316.66	317.585	316.51	316.84	3471542.0
2023-04-27 11:00:00	QQQ	ETF	316.85	318.275	316.765	318.04	3121920.0
2023-04-27 11:30:00	QQQ	ETF	318.04	318.31	317.79	318.03	2231497.0
2023-04-27 12:00:00	QQQ	ETF	318.05	318.68	318.02	318.49	1665231.0
2023-04-27 12:30:00	QQQ	ETF	318.485	318.97	318.45	318.925	1534292.0

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

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