PREVIEW / etf_30min / 2023-09-08

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-09-08.parquet
  size:    684 KB
  rows:    26,785

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-08 04:00:00	SPY	ETF	445.75	445.86	444.38	444.64	16635.0
2023-09-08 04:30:00	SPY	ETF	444.38	444.66	444.35	444.38	14650.0
2023-09-08 05:00:00	SPY	ETF	444.13	444.14	443.79	443.97	17301.0
2023-09-08 05:30:00	SPY	ETF	443.92	444.27	443.78	443.97	9793.0
2023-09-08 06:00:00	SPY	ETF	443.88	444.45	443.88	444.23	31980.0
2023-09-08 06:30:00	SPY	ETF	444.4	444.61	444.36	444.55	11920.0
2023-09-08 07:00:00	SPY	ETF	444.65	444.66	444.0	444.11	27091.0
2023-09-08 07:30:00	SPY	ETF	444.05	444.35	443.84	444.29	29795.0
2023-09-08 08:00:00	SPY	ETF	444.25	446.0	443.8796	444.74	95801.0
2023-09-08 08:30:00	SPY	ETF	444.82	445.32	444.8	444.84	116580.0
2023-09-08 09:00:00	SPY	ETF	444.78	445.12	444.78	444.88	61776.0
2023-09-08 09:30:00	SPY	ETF	444.9	446.1	444.8	445.8199	4403153.0
2023-09-08 10:00:00	SPY	ETF	445.84	446.91	445.75	446.85	4268996.0
2023-09-08 10:30:00	SPY	ETF	446.86	447.11	445.9	445.905	3705591.0
2023-09-08 11:00:00	SPY	ETF	445.91	446.72	445.77	446.5708	2559056.0
2023-09-08 11:30:00	SPY	ETF	446.58	446.899	446.07	446.1799	2201547.0
2023-09-08 12:00:00	SPY	ETF	446.18	446.78	445.894	446.235	2124171.0
2023-09-08 12:30:00	SPY	ETF	446.23	446.39	445.58	446.101	2317791.0
2023-09-08 13:00:00	SPY	ETF	446.11	446.19	445.52	445.7592	2459795.0
2023-09-08 13:30:00	SPY	ETF	445.76	446.04	445.58	445.881	1608601.0
2023-09-08 14:00:00	SPY	ETF	445.88	446.22	445.07	445.3301	2889964.0
2023-09-08 14:30:00	SPY	ETF	445.34	445.495	444.87	444.92	2520851.0
2023-09-08 15:00:00	SPY	ETF	444.905	445.04	444.53	444.675	3177455.0
2023-09-08 15:30:00	SPY	ETF	444.675	445.61	444.55	445.51	7716899.0
2023-09-08 16:00:00	SPY	ETF	445.51	446.5173	444.0	446.04	2728895.0
2023-09-08 16:30:00	SPY	ETF	446.03	446.06	445.4526	445.68	166876.0
2023-09-08 17:00:00	SPY	ETF	445.68	445.94	445.52	445.9	436560.0
2023-09-08 17:30:00	SPY	ETF	445.89	445.9	445.85	445.89	6098.0
2023-09-08 18:00:00	SPY	ETF	445.87	445.87	445.71	445.75	17995.0
2023-09-08 18:30:00	SPY	ETF	445.75	445.77	445.55	445.56	184213.0
2023-09-08 19:00:00	SPY	ETF	445.5698	445.58	445.37	445.42	97922.0
2023-09-08 19:30:00	SPY	ETF	445.41	445.52	445.1	445.11	93113.0
2023-09-08 04:00:00	QQQ	ETF	373.19	373.35	371.79	371.92	48007.0
2023-09-08 04:30:00	QQQ	ETF	371.98	372.26	371.81	371.81	14921.0
2023-09-08 05:00:00	QQQ	ETF	371.77	371.77	371.0	371.23	16749.0
2023-09-08 05:30:00	QQQ	ETF	371.18	371.39	371.0	371.0	22895.0
2023-09-08 06:00:00	QQQ	ETF	371.03	371.58	371.03	371.55	19191.0
2023-09-08 06:30:00	QQQ	ETF	371.57	371.77	371.5	371.72	17444.0
2023-09-08 07:00:00	QQQ	ETF	371.75	371.86	371.0	371.1	51070.0
2023-09-08 07:30:00	QQQ	ETF	371.05	371.36	370.811	371.34	68588.0
2023-09-08 08:00:00	QQQ	ETF	371.35	373.61	370.92	371.8	163404.0
2023-09-08 08:30:00	QQQ	ETF	371.8	372.41	371.7401	371.97	181956.0
2023-09-08 09:00:00	QQQ	ETF	371.9699	372.298	371.89	371.9104	229229.0
2023-09-08 09:30:00	QQQ	ETF	372.01	374.4	371.92	373.44	3892034.0
2023-09-08 10:00:00	QQQ	ETF	373.46	374.85	373.25	374.4846	2937041.0
2023-09-08 10:30:00	QQQ	ETF	374.51	374.77	372.61	372.61	3158476.0
2023-09-08 11:00:00	QQQ	ETF	372.6	374.14	372.36	373.9908	1957358.0
2023-09-08 11:30:00	QQQ	ETF	374.0	374.35	373.54	373.66	1339736.0
2023-09-08 12:00:00	QQQ	ETF	373.67	374.2	373.28	373.6113	1253976.0
2023-09-08 12:30:00	QQQ	ETF	373.64	373.64	372.72	373.36	1522222.0

> showing 50 of 26,785 rows — these rows as CSV

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