PREVIEW / etf_30min / 2023-06-28

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-06-28.parquet
  size:    695 KB
  rows:    27,749

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-06-28 04:00:00	SPY	ETF	435.52	435.74	435.37	435.54	14360.0
2023-06-28 04:30:00	SPY	ETF	435.51	435.56	435.09	435.2	10166.0
2023-06-28 05:00:00	SPY	ETF	435.2	435.35	435.13	435.32	8286.0
2023-06-28 05:30:00	SPY	ETF	435.27	435.47	435.23	435.39	6198.0
2023-06-28 06:00:00	SPY	ETF	435.41	435.77	435.38	435.73	8527.0
2023-06-28 06:30:00	SPY	ETF	435.75	435.79	435.48	435.64	5358.0
2023-06-28 07:00:00	SPY	ETF	435.66	436.08	435.66	435.93	42383.0
2023-06-28 07:30:00	SPY	ETF	435.86	435.86	435.43	435.43	40625.0
2023-06-28 08:00:00	SPY	ETF	435.6611	436.0496	435.14	435.53	247161.0
2023-06-28 08:30:00	SPY	ETF	435.62	435.63	435.05	435.24	96086.0
2023-06-28 09:00:00	SPY	ETF	435.24	435.35	434.9	435.02	135937.0
2023-06-28 09:30:00	SPY	ETF	435.05	435.29	434.41	435.2	6548989.0
2023-06-28 10:00:00	SPY	ETF	435.19	435.675	434.44	435.52	4074075.0
2023-06-28 10:30:00	SPY	ETF	435.53	436.47	435.47	435.8788	4924366.0
2023-06-28 11:00:00	SPY	ETF	435.87	436.31	435.39	436.05	3518942.0
2023-06-28 11:30:00	SPY	ETF	436.05	436.73	435.98	436.625	2441088.0
2023-06-28 12:00:00	SPY	ETF	436.62	437.44	436.28	436.53	3441364.0
2023-06-28 12:30:00	SPY	ETF	436.52	436.55	434.56	435.17	5245475.0
2023-06-28 13:00:00	SPY	ETF	435.14	435.79	434.67	435.78	2899186.0
2023-06-28 13:30:00	SPY	ETF	435.78	435.97	435.04	435.38	2435765.0
2023-06-28 14:00:00	SPY	ETF	435.3901	436.04	435.28	435.83	2224897.0
2023-06-28 14:30:00	SPY	ETF	435.84	435.96	435.35	435.525	2129544.0
2023-06-28 15:00:00	SPY	ETF	435.525	435.8	434.59	435.34	4174435.0
2023-06-28 15:30:00	SPY	ETF	435.33	436.43	435.16	436.38	10429900.0
2023-06-28 16:00:00	SPY	ETF	436.38	436.9	436.046	436.65	3885996.0
2023-06-28 16:30:00	SPY	ETF	436.65	436.84	435.4557	436.59	322318.0
2023-06-28 17:00:00	SPY	ETF	436.67	436.75	436.63	436.72	25008.0
2023-06-28 17:30:00	SPY	ETF	436.73	436.79	436.63	436.74	23839.0
2023-06-28 18:00:00	SPY	ETF	436.74	437.29	436.72	437.28	79551.0
2023-06-28 18:30:00	SPY	ETF	437.31	437.31	437.06	437.13	16098.0
2023-06-28 19:00:00	SPY	ETF	437.12	437.17	437.01	437.1	44876.0
2023-06-28 19:30:00	SPY	ETF	437.08	437.08	436.94	436.95	31611.0
2023-06-28 04:00:00	QQQ	ETF	362.8	362.93	362.35	362.43	19408.0
2023-06-28 04:30:00	QQQ	ETF	362.45	362.45	361.9	361.99	16343.0
2023-06-28 05:00:00	QQQ	ETF	362.12	362.14	361.95	362.06	8789.0
2023-06-28 05:30:00	QQQ	ETF	361.84	362.33	361.79	362.33	31646.0
2023-06-28 06:00:00	QQQ	ETF	362.3	362.57	362.3	362.57	32211.0
2023-06-28 06:30:00	QQQ	ETF	362.56	362.82	362.26	362.82	27831.0
2023-06-28 07:00:00	QQQ	ETF	362.82	363.41	362.78	363.14	107547.0
2023-06-28 07:30:00	QQQ	ETF	363.06	363.08	362.41	362.46	122490.0
2023-06-28 08:00:00	QQQ	ETF	362.84	363.35	361.9896	362.72	174147.0
2023-06-28 08:30:00	QQQ	ETF	362.7401	364.102	362.14	362.38	145793.0
2023-06-28 09:00:00	QQQ	ETF	362.38	362.49	361.96	362.05	252964.0
2023-06-28 09:30:00	QQQ	ETF	361.99	363.89	361.9038	363.48	5398569.0
2023-06-28 10:00:00	QQQ	ETF	363.46	364.77	362.31	364.69	2682070.0
2023-06-28 10:30:00	QQQ	ETF	364.7	366.22	364.53	365.53	3384543.0
2023-06-28 11:00:00	QQQ	ETF	365.53	365.94	364.02	364.75	2541437.0
2023-06-28 11:30:00	QQQ	ETF	364.76	365.76	364.66	365.6809	1755793.0
2023-06-28 12:00:00	QQQ	ETF	365.67	366.52	364.47	364.76	2096374.0
2023-06-28 12:30:00	QQQ	ETF	364.76	364.77	362.6901	363.37	3630635.0

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

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