PREVIEW / etf_30min / 2023-02-14

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-02-14.parquet
  size:    694 KB
  rows:    27,856

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-02-14 04:00:00	SPY	ETF	412.66	413.65	412.61	412.83	19750.0
2023-02-14 04:30:00	SPY	ETF	412.95	413.4	412.85	413.3	5864.0
2023-02-14 05:00:00	SPY	ETF	413.25	413.56	413.2	413.56	5941.0
2023-02-14 05:30:00	SPY	ETF	413.5	413.79	413.5	413.59	24072.0
2023-02-14 06:00:00	SPY	ETF	413.63	413.94	413.63	413.83	26077.0
2023-02-14 06:30:00	SPY	ETF	413.75	413.84	413.58	413.6	17050.0
2023-02-14 07:00:00	SPY	ETF	413.6	414.0	413.5	413.85	46959.0
2023-02-14 07:30:00	SPY	ETF	413.88	414.3	413.701	414.12	134199.0
2023-02-14 08:00:00	SPY	ETF	413.6	414.5	412.52	414.23	336665.0
2023-02-14 08:30:00	SPY	ETF	413.7	416.67	411.3	412.6	2967893.0
2023-02-14 09:00:00	SPY	ETF	412.62	413.36	411.11	411.25	825471.0
2023-02-14 09:30:00	SPY	ETF	411.24	413.72	409.49	413.2803	8487287.0
2023-02-14 10:00:00	SPY	ETF	413.29	415.05	413.29	413.38	6226049.0
2023-02-14 10:30:00	SPY	ETF	413.38	413.74	409.33	410.53	7768111.0
2023-02-14 11:00:00	SPY	ETF	410.52	411.92	409.75	409.8884	4525601.0
2023-02-14 11:30:00	SPY	ETF	409.86	409.9084	408.511	409.555	4609891.0
2023-02-14 12:00:00	SPY	ETF	409.56	410.98	409.38	410.4799	3367022.0
2023-02-14 12:30:00	SPY	ETF	410.49	411.25	410.3389	411.03	2915546.0
2023-02-14 13:00:00	SPY	ETF	411.05	413.55	410.95	412.505	4725900.0
2023-02-14 13:30:00	SPY	ETF	412.51	412.95	411.795	412.45	2640206.0
2023-02-14 14:00:00	SPY	ETF	412.45	412.99	411.23	412.53	3079513.0
2023-02-14 14:30:00	SPY	ETF	412.53	413.65	412.485	413.16	2901444.0
2023-02-14 15:00:00	SPY	ETF	413.18	413.47	412.4	413.1	3325627.0
2023-02-14 15:30:00	SPY	ETF	413.1	413.7	412.49	412.67	9539863.0
2023-02-14 16:00:00	SPY	ETF	412.66	412.76	412.0	412.21	2792735.0
2023-02-14 16:30:00	SPY	ETF	412.21	412.683	412.14	412.2	110391.0
2023-02-14 17:00:00	SPY	ETF	412.33	412.33	412.22	412.26	11265.0
2023-02-14 17:30:00	SPY	ETF	412.26	412.64	412.2	412.22	372805.0
2023-02-14 18:00:00	SPY	ETF	412.28	412.29	411.75	412.0	40156.0
2023-02-14 18:30:00	SPY	ETF	412.04	412.22	411.96	411.96	24829.0
2023-02-14 19:00:00	SPY	ETF	411.94	411.97	411.5	411.85	31434.0
2023-02-14 19:30:00	SPY	ETF	411.78	411.78	411.49	411.57	60418.0
2023-02-14 04:00:00	QQQ	ETF	304.89	305.26	304.22	304.64	30475.0
2023-02-14 04:30:00	QQQ	ETF	304.59	305.07	304.5	305.07	11556.0
2023-02-14 05:00:00	QQQ	ETF	305.01	305.4	304.93	305.39	4387.0
2023-02-14 05:30:00	QQQ	ETF	305.41	305.76	305.41	305.51	12197.0
2023-02-14 06:00:00	QQQ	ETF	305.55	305.88	305.55	305.67	35946.0
2023-02-14 06:30:00	QQQ	ETF	305.67	305.78	305.35	305.38	20331.0
2023-02-14 07:00:00	QQQ	ETF	305.38	305.94	305.36	305.84	66023.0
2023-02-14 07:30:00	QQQ	ETF	305.73	305.989	305.44	305.79	56552.0
2023-02-14 08:00:00	QQQ	ETF	305.7	306.44	304.24	305.52	529308.0
2023-02-14 08:30:00	QQQ	ETF	305.38	308.0	302.58	303.95	4249800.0
2023-02-14 09:00:00	QQQ	ETF	303.93	304.73	302.64	302.87	1072524.0
2023-02-14 09:30:00	QQQ	ETF	302.89	305.99	300.91	305.6	8223740.0
2023-02-14 10:00:00	QQQ	ETF	305.63	307.72	305.63	305.76	5051148.0
2023-02-14 10:30:00	QQQ	ETF	305.77	306.15	301.7	303.31	5438714.0
2023-02-14 11:00:00	QQQ	ETF	303.3	304.71	302.6576	302.83	3386595.0
2023-02-14 11:30:00	QQQ	ETF	302.84	302.96	301.57	302.79	3711166.0
2023-02-14 12:00:00	QQQ	ETF	302.77	303.96	302.55	303.51	2127676.0
2023-02-14 12:30:00	QQQ	ETF	303.52	304.33	303.38	304.085	1585384.0

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

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