PREVIEW / etf_30min / 2023-12-14

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-12-14.parquet
  size:    833 KB
  rows:    33,206

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-14 04:00:00	SPY	ETF	472.05	472.06	471.3	471.4	100388.0
2023-12-14 04:30:00	SPY	ETF	471.48	471.6	471.32	471.52	16238.0
2023-12-14 05:00:00	SPY	ETF	471.59	471.98	471.41	471.86	12535.0
2023-12-14 05:30:00	SPY	ETF	472.03	472.25	471.88	471.9	30840.0
2023-12-14 06:00:00	SPY	ETF	472.03	472.24	471.8	471.95	11438.0
2023-12-14 06:30:00	SPY	ETF	471.92	471.95	471.63	471.92	37108.0
2023-12-14 07:00:00	SPY	ETF	471.8	472.36	471.8	472.19	67460.0
2023-12-14 07:30:00	SPY	ETF	472.2	472.4	472.1	472.17	68879.0
2023-12-14 08:00:00	SPY	ETF	471.7995	472.69	471.3796	472.09	190560.0
2023-12-14 08:30:00	SPY	ETF	472.02	473.31	471.68	473.31	459243.0
2023-12-14 09:00:00	SPY	ETF	473.33	473.55	472.39	472.51	629544.0
2023-12-14 09:30:00	SPY	ETF	472.51	473.73	472.255	473.14	8743311.0
2023-12-14 10:00:00	SPY	ETF	473.14	473.18	471.78	472.28	7036225.0
2023-12-14 10:30:00	SPY	ETF	472.29	472.81	471.67	472.5899	4270896.0
2023-12-14 11:00:00	SPY	ETF	472.585	472.68	471.46	471.93	3944128.0
2023-12-14 11:30:00	SPY	ETF	471.95	472.67	471.54	472.54	3264937.0
2023-12-14 12:00:00	SPY	ETF	472.54	473.28	472.475	473.26	3474942.0
2023-12-14 12:30:00	SPY	ETF	473.26	473.365	471.9513	471.9901	3796861.0
2023-12-14 13:00:00	SPY	ETF	472.0	472.01	470.82	470.845	5833024.0
2023-12-14 13:30:00	SPY	ETF	470.845	471.06	469.25	470.18	5423691.0
2023-12-14 14:00:00	SPY	ETF	470.18	471.255	470.15	471.1901	3789927.0
2023-12-14 14:30:00	SPY	ETF	471.1913	471.57	470.935	471.52	3326415.0
2023-12-14 15:00:00	SPY	ETF	471.52	471.73	471.31	471.47	4878789.0
2023-12-14 15:30:00	SPY	ETF	471.47	472.06	471.09	472.0	11345475.0
2023-12-14 16:00:00	SPY	ETF	472.01	472.11	470.28	471.28	8266948.0
2023-12-14 16:30:00	SPY	ETF	471.3	471.5003	471.21	471.37	305226.0
2023-12-14 17:00:00	SPY	ETF	471.4	471.49	471.3	471.31	93570.0
2023-12-14 17:30:00	SPY	ETF	471.31	472.01	471.24	471.3	988351.0
2023-12-14 18:00:00	SPY	ETF	471.25	472.01	471.04	471.59	475743.0
2023-12-14 18:30:00	SPY	ETF	471.6	471.69	471.5	471.68	571684.0
2023-12-14 19:00:00	SPY	ETF	471.69	471.93	471.69	471.71	76822.0
2023-12-14 19:30:00	SPY	ETF	471.72	471.86	471.64	471.67	53278.0
2023-12-14 04:00:00	QQQ	ETF	405.65	406.12	405.0	405.12	58138.0
2023-12-14 04:30:00	QQQ	ETF	405.1	405.25	405.0	405.06	25863.0
2023-12-14 05:00:00	QQQ	ETF	405.2	405.6	405.05	405.6	32056.0
2023-12-14 05:30:00	QQQ	ETF	405.6	405.79	405.5	405.62	12680.0
2023-12-14 06:00:00	QQQ	ETF	405.57	405.73	405.21	405.21	14927.0
2023-12-14 06:30:00	QQQ	ETF	405.28	405.41	405.17	405.28	26245.0
2023-12-14 07:00:00	QQQ	ETF	405.26	405.8	405.26	405.64	57048.0
2023-12-14 07:30:00	QQQ	ETF	405.64	405.78	405.4	405.47	52594.0
2023-12-14 08:00:00	QQQ	ETF	405.65	406.42	404.042	405.32	187070.0
2023-12-14 08:30:00	QQQ	ETF	405.13	405.79	404.69	405.75	221624.0
2023-12-14 09:00:00	QQQ	ETF	405.75	405.95	404.89	404.95	388448.0
2023-12-14 09:30:00	QQQ	ETF	404.98	406.3	404.76	405.6399	5115099.0
2023-12-14 10:00:00	QQQ	ETF	405.63	405.66	404.11	404.31	4604622.0
2023-12-14 10:30:00	QQQ	ETF	404.31	404.94	403.65	404.76	3154956.0
2023-12-14 11:00:00	QQQ	ETF	404.77	404.8651	403.17	403.67	3190755.0
2023-12-14 11:30:00	QQQ	ETF	403.69	404.27	403.12	404.01	2031486.0
2023-12-14 12:00:00	QQQ	ETF	404.01	404.7511	403.93	404.74	1546416.0
2023-12-14 12:30:00	QQQ	ETF	404.72	404.9479	402.93	402.95	2301495.0

> showing 50 of 33,206 rows — these rows as CSV

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