PREVIEW / etf_30min / 2023-12-21

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-12-21.parquet
  size:    789 KB
  rows:    31,575

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-21 04:00:00	SPY	ETF	470.7	471.01	469.82	470.94	33756.0
2023-12-21 04:30:00	SPY	ETF	470.95	470.96	470.76	470.76	12521.0
2023-12-21 05:00:00	SPY	ETF	470.69	470.73	470.4	470.42	5867.0
2023-12-21 05:30:00	SPY	ETF	470.38	470.49	470.21	470.21	49429.0
2023-12-21 06:00:00	SPY	ETF	470.3	470.6	470.28	470.44	37649.0
2023-12-21 06:30:00	SPY	ETF	470.49	470.49	470.3	470.42	51362.0
2023-12-21 07:00:00	SPY	ETF	470.34	470.76	469.4	470.76	180138.0
2023-12-21 07:30:00	SPY	ETF	470.76	470.81	470.6	470.67	130803.0
2023-12-21 08:00:00	SPY	ETF	470.67	470.82	469.69	470.5	187428.0
2023-12-21 08:30:00	SPY	ETF	470.48	472.64	468.26	471.8	1124232.0
2023-12-21 09:00:00	SPY	ETF	471.8	471.84	471.25	471.31	494284.0
2023-12-21 09:30:00	SPY	ETF	471.32	472.3	470.98	471.4	7841161.0
2023-12-21 10:00:00	SPY	ETF	471.41	472.44	470.55	471.17	6283658.0
2023-12-21 10:30:00	SPY	ETF	471.18	471.81	470.85	471.17	3543190.0
2023-12-21 11:00:00	SPY	ETF	471.16	471.59	470.66	471.51	3234590.0
2023-12-21 11:30:00	SPY	ETF	471.49	471.69	470.42	470.55	3309507.0
2023-12-21 12:00:00	SPY	ETF	470.55	470.55	469.4	469.5401	4280593.0
2023-12-21 12:30:00	SPY	ETF	469.55	470.19	469.27	469.4799	3090677.0
2023-12-21 13:00:00	SPY	ETF	469.48	470.185	468.84	470.095	3537380.0
2023-12-21 13:30:00	SPY	ETF	470.1	470.59	469.79	470.55	2769433.0
2023-12-21 14:00:00	SPY	ETF	470.56	470.85	470.16	470.6197	2669342.0
2023-12-21 14:30:00	SPY	ETF	470.62	471.06	470.18	470.57	2221524.0
2023-12-21 15:00:00	SPY	ETF	470.57	471.9291	470.25	471.895	3538892.0
2023-12-21 15:30:00	SPY	ETF	471.91	472.975	471.63	472.67	11455609.0
2023-12-21 16:00:00	SPY	ETF	472.67	472.95	470.2085	472.9	7774657.0
2023-12-21 16:30:00	SPY	ETF	472.9	473.04	472.77	472.77	307866.0
2023-12-21 17:00:00	SPY	ETF	472.78	472.99	472.7	472.97	573856.0
2023-12-21 17:30:00	SPY	ETF	472.96	472.99	472.81	472.88	47429.0
2023-12-21 18:00:00	SPY	ETF	472.88	472.88	472.39	472.64	76914.0
2023-12-21 18:30:00	SPY	ETF	472.64	472.87	472.56	472.59	32624.0
2023-12-21 19:00:00	SPY	ETF	472.57	472.6	472.36	472.49	49741.0
2023-12-21 19:30:00	SPY	ETF	472.51	472.51	472.35	472.38	31946.0
2023-12-21 04:00:00	QQQ	ETF	405.01	406.3	405.0	406.21	22284.0
2023-12-21 04:30:00	QQQ	ETF	406.21	406.31	406.03	406.04	25722.0
2023-12-21 05:00:00	QQQ	ETF	406.01	406.02	405.72	405.75	17606.0
2023-12-21 05:30:00	QQQ	ETF	405.76	405.88	405.56	405.7	8401.0
2023-12-21 06:00:00	QQQ	ETF	405.79	406.07	405.71	405.83	25257.0
2023-12-21 06:30:00	QQQ	ETF	405.8	405.88	405.73	405.85	8863.0
2023-12-21 07:00:00	QQQ	ETF	405.86	406.24	405.77	406.21	57980.0
2023-12-21 07:30:00	QQQ	ETF	406.25	406.3	406.11	406.14	83307.0
2023-12-21 08:00:00	QQQ	ETF	405.8	406.3	405.06	405.92	171034.0
2023-12-21 08:30:00	QQQ	ETF	405.81	408.16	405.6	407.5	882967.0
2023-12-21 09:00:00	QQQ	ETF	407.46	407.52	403.08	407.08	416924.0
2023-12-21 09:30:00	QQQ	ETF	407.06	407.92	406.135	406.34	5325010.0
2023-12-21 10:00:00	QQQ	ETF	406.32	407.27	405.14	405.975	3451155.0
2023-12-21 10:30:00	QQQ	ETF	405.99	406.83	405.55	405.865	2236999.0
2023-12-21 11:00:00	QQQ	ETF	405.85	406.478	405.58	406.4495	1568905.0
2023-12-21 11:30:00	QQQ	ETF	406.44	407.005	405.89	406.02	2611336.0
2023-12-21 12:00:00	QQQ	ETF	406.02	406.02	404.83	405.07	2502501.0
2023-12-21 12:30:00	QQQ	ETF	405.1	405.735	404.725	405.0	1490669.0

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

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