PREVIEW / etf_30min / 2024-02-14

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-02-14.parquet
  size:    803 KB
  rows:    31,872

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
2024-02-14 04:00:00	SPY	ETF	495.0	495.96	495.0	495.93	12871.0
2024-02-14 04:30:00	SPY	ETF	495.93	496.57	495.82	496.51	7444.0
2024-02-14 05:00:00	SPY	ETF	496.5	496.5	496.14	496.15	9791.0
2024-02-14 05:30:00	SPY	ETF	496.09	496.42	496.07	496.37	33340.0
2024-02-14 06:00:00	SPY	ETF	496.18	496.18	495.95	496.03	8842.0
2024-02-14 06:30:00	SPY	ETF	496.01	496.53	495.71	496.52	16825.0
2024-02-14 07:00:00	SPY	ETF	496.49	496.84	496.48	496.551	146528.0
2024-02-14 07:30:00	SPY	ETF	496.53	496.65	496.31	496.44	117632.0
2024-02-14 08:00:00	SPY	ETF	496.55	497.13	494.37	496.36	293255.0
2024-02-14 08:30:00	SPY	ETF	496.37	496.9	496.21	496.4	204866.0
2024-02-14 09:00:00	SPY	ETF	496.42	496.83	496.19	496.79	242786.0
2024-02-14 09:30:00	SPY	ETF	496.79	497.3	495.78	496.88	6388752.0
2024-02-14 10:00:00	SPY	ETF	496.9	497.99	496.57	497.71	4274653.0
2024-02-14 10:30:00	SPY	ETF	497.72	497.91	495.94	495.955	3504008.0
2024-02-14 11:00:00	SPY	ETF	495.95	496.33	495.15	496.23	4231249.0
2024-02-14 11:30:00	SPY	ETF	496.24	496.33	495.32	495.336	2906600.0
2024-02-14 12:00:00	SPY	ETF	495.35	496.04	494.4	496.0	3118828.0
2024-02-14 12:30:00	SPY	ETF	496.03	496.33	495.8399	496.2	1963830.0
2024-02-14 13:00:00	SPY	ETF	496.21	496.57	495.42	495.95	2355884.0
2024-02-14 13:30:00	SPY	ETF	495.95	497.14	495.87	496.5701	2599759.0
2024-02-14 14:00:00	SPY	ETF	496.58	496.7816	495.22	496.69	3312494.0
2024-02-14 14:30:00	SPY	ETF	496.7	497.1047	496.435	496.92	2638550.0
2024-02-14 15:00:00	SPY	ETF	496.92	498.21	496.61	497.9945	4183519.0
2024-02-14 15:30:00	SPY	ETF	497.9906	499.07	497.4701	498.625	9317986.0
2024-02-14 16:00:00	SPY	ETF	498.62	499.23	498.38	499.17	2493997.0
2024-02-14 16:30:00	SPY	ETF	499.17	499.33	498.81	498.84	317465.0
2024-02-14 17:00:00	SPY	ETF	498.84	498.95	498.75	498.93	47948.0
2024-02-14 17:30:00	SPY	ETF	498.92	498.99	498.91	498.93	29178.0
2024-02-14 18:00:00	SPY	ETF	498.91	498.98	498.79	498.94	33664.0
2024-02-14 18:30:00	SPY	ETF	498.945	498.98	498.88	498.94	23762.0
2024-02-14 19:00:00	SPY	ETF	498.9391	498.9391	498.69	498.7	25379.0
2024-02-14 19:30:00	SPY	ETF	498.68	498.79	498.6	498.65	48680.0
2024-02-14 04:00:00	QQQ	ETF	430.05	430.88	429.62	430.78	38613.0
2024-02-14 04:30:00	QQQ	ETF	430.7	431.43	430.66	431.36	32326.0
2024-02-14 05:00:00	QQQ	ETF	431.4	431.4	430.98	431.09	47123.0
2024-02-14 05:30:00	QQQ	ETF	431.06	431.38	430.97	431.3	13438.0
2024-02-14 06:00:00	QQQ	ETF	431.17	431.17	430.75	430.92	18111.0
2024-02-14 06:30:00	QQQ	ETF	430.93	431.31	430.53	431.22	45152.0
2024-02-14 07:00:00	QQQ	ETF	431.26	431.81	431.2	431.32	88793.0
2024-02-14 07:30:00	QQQ	ETF	431.34	431.48	431.15	431.29	55950.0
2024-02-14 08:00:00	QQQ	ETF	429.19	431.78	428.8	430.9711	201850.0
2024-02-14 08:30:00	QQQ	ETF	430.98	431.5	430.74	431.0	451336.0
2024-02-14 09:00:00	QQQ	ETF	431.0	431.31	430.72	431.26	171002.0
2024-02-14 09:30:00	QQQ	ETF	431.26	431.97	430.13	431.28	4113865.0
2024-02-14 10:00:00	QQQ	ETF	431.29	432.65	430.94	432.41	3041846.0
2024-02-14 10:30:00	QQQ	ETF	432.44	432.5401	430.17	430.18	2676937.0
2024-02-14 11:00:00	QQQ	ETF	430.1687	430.57	429.215	430.37	3266992.0
2024-02-14 11:30:00	QQQ	ETF	430.37	430.75	429.665	429.78	1820909.0
2024-02-14 12:00:00	QQQ	ETF	429.79	430.63	428.8799	430.61	2140047.0
2024-02-14 12:30:00	QQQ	ETF	430.62	431.21	430.55	430.96	1460870.0

> showing 50 of 31,872 rows — these rows as CSV

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