PREVIEW / etf_30min / 2023-09-29

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-09-29.parquet
  size:    706 KB
  rows:    28,228

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-09-29 04:00:00	SPY	ETF	429.71	430.57	429.71	430.49	22798.0
2023-09-29 04:30:00	SPY	ETF	430.56	430.63	430.06	430.08	19820.0
2023-09-29 05:00:00	SPY	ETF	430.18	430.56	430.05	430.54	11524.0
2023-09-29 05:30:00	SPY	ETF	430.32	430.55	430.25	430.54	6219.0
2023-09-29 06:00:00	SPY	ETF	430.46	430.84	430.3	430.62	20722.0
2023-09-29 06:30:00	SPY	ETF	430.75	430.75	430.44	430.48	20106.0
2023-09-29 07:00:00	SPY	ETF	430.53	430.77	430.26	430.29	208658.0
2023-09-29 07:30:00	SPY	ETF	430.3	430.32	429.87	429.93	95046.0
2023-09-29 08:00:00	SPY	ETF	430.57	430.9	428.32	430.6	425598.0
2023-09-29 08:30:00	SPY	ETF	430.91	432.0	430.83	431.52	1545295.0
2023-09-29 09:00:00	SPY	ETF	431.54	431.76	431.12	431.69	913838.0
2023-09-29 09:30:00	SPY	ETF	431.69	431.85	430.57	431.39	8124979.0
2023-09-29 10:00:00	SPY	ETF	431.41	431.76	430.04	430.34	6461116.0
2023-09-29 10:30:00	SPY	ETF	430.35	431.3	430.29	430.5408	3921552.0
2023-09-29 11:00:00	SPY	ETF	430.56	431.36	429.93	429.99	4635017.0
2023-09-29 11:30:00	SPY	ETF	430.01	430.2095	428.635	429.23	5110258.0
2023-09-29 12:00:00	SPY	ETF	429.23	429.75	428.66	429.41	3523384.0
2023-09-29 12:30:00	SPY	ETF	429.43	429.595	427.89	428.2201	4150441.0
2023-09-29 13:00:00	SPY	ETF	428.23	428.24	426.5	427.5	5707370.0
2023-09-29 13:30:00	SPY	ETF	427.495	427.68	426.17	426.17	4652281.0
2023-09-29 14:00:00	SPY	ETF	426.17	427.12	426.01	426.26	5935207.0
2023-09-29 14:30:00	SPY	ETF	426.27	428.23	425.91	428.21	6045745.0
2023-09-29 15:00:00	SPY	ETF	428.21	428.47	427.08	427.58	7788083.0
2023-09-29 15:30:00	SPY	ETF	427.59	428.875	426.74	427.39	17439908.0
2023-09-29 16:00:00	SPY	ETF	427.39	430.5158	426.94	427.91	5072884.0
2023-09-29 16:30:00	SPY	ETF	427.91	428.0	427.48	427.73	135304.0
2023-09-29 17:00:00	SPY	ETF	427.67	428.02	427.54	427.99	35356.0
2023-09-29 17:30:00	SPY	ETF	427.96	427.96	427.67	427.7494	21624.0
2023-09-29 18:00:00	SPY	ETF	427.48	427.74	427.48	427.7	104415.0
2023-09-29 18:30:00	SPY	ETF	427.71	427.76	427.6	427.6	6441.0
2023-09-29 19:00:00	SPY	ETF	427.6	427.61	427.52	427.52	5522.0
2023-09-29 19:30:00	SPY	ETF	427.6199	427.7	427.43	427.43	12173.0
2023-09-29 04:00:00	QQQ	ETF	360.24	360.6	360.15	360.6	47489.0
2023-09-29 04:30:00	QQQ	ETF	360.64	360.68	360.01	360.05	26457.0
2023-09-29 05:00:00	QQQ	ETF	360.02	360.6	360.01	360.59	15785.0
2023-09-29 05:30:00	QQQ	ETF	360.46	360.7	360.2	360.62	14222.0
2023-09-29 06:00:00	QQQ	ETF	360.57	360.88	360.25	360.67	25383.0
2023-09-29 06:30:00	QQQ	ETF	360.73	360.73	360.31	360.36	17101.0
2023-09-29 07:00:00	QQQ	ETF	360.35	360.56	360.12	360.18	75164.0
2023-09-29 07:30:00	QQQ	ETF	360.17	360.17	359.65	359.87	99239.0
2023-09-29 08:00:00	QQQ	ETF	360.21	360.86	358.278	360.58	180755.0
2023-09-29 08:30:00	QQQ	ETF	360.55	361.73	360.37	361.56	623642.0
2023-09-29 09:00:00	QQQ	ETF	361.57	361.65	361.2	361.56	382929.0
2023-09-29 09:30:00	QQQ	ETF	361.54	362.55	360.87	362.28	6290526.0
2023-09-29 10:00:00	QQQ	ETF	362.29	362.95	360.79	361.04	4265220.0
2023-09-29 10:30:00	QQQ	ETF	361.05	362.13	361.0	361.3001	3304701.0
2023-09-29 11:00:00	QQQ	ETF	361.33	361.78	360.36	360.405	2857108.0
2023-09-29 11:30:00	QQQ	ETF	360.395	360.6	359.3	360.095	3157817.0
2023-09-29 12:00:00	QQQ	ETF	360.1	360.67	359.45	360.25	1975041.0
2023-09-29 12:30:00	QQQ	ETF	360.28	360.51	358.8	359.03	2312199.0

> showing 50 of 28,228 rows — these rows as CSV

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