PREVIEW / etf_30min / 2023-09-19

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-09-19.parquet
  size:    686 KB
  rows:    27,326

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-19 04:00:00	SPY	ETF	444.06	444.36	444.05	444.15	5279.0
2023-09-19 04:30:00	SPY	ETF	444.18	444.3	444.15	444.3	2733.0
2023-09-19 05:00:00	SPY	ETF	444.21	444.5	444.05	444.5	8377.0
2023-09-19 05:30:00	SPY	ETF	444.49	444.5	444.36	444.39	7487.0
2023-09-19 06:00:00	SPY	ETF	444.33	444.44	444.29	444.3	3632.0
2023-09-19 06:30:00	SPY	ETF	444.36	444.56	444.2	444.25	22299.0
2023-09-19 07:00:00	SPY	ETF	444.24	444.35	444.12	444.35	21789.0
2023-09-19 07:30:00	SPY	ETF	444.36	444.36	443.96	444.13	124037.0
2023-09-19 08:00:00	SPY	ETF	444.21	444.41	443.24	444.02	266184.0
2023-09-19 08:30:00	SPY	ETF	444.04	444.07	443.24	443.27	118361.0
2023-09-19 09:00:00	SPY	ETF	443.23	443.34	442.48	442.67	432763.0
2023-09-19 09:30:00	SPY	ETF	442.68	443.25	442.15	442.19	4463983.0
2023-09-19 10:00:00	SPY	ETF	442.19	442.235	441.09	441.62	4829572.0
2023-09-19 10:30:00	SPY	ETF	441.625	441.625	440.51	440.58	4006869.0
2023-09-19 11:00:00	SPY	ETF	440.58	440.92	440.495	440.89	2962639.0
2023-09-19 11:30:00	SPY	ETF	440.865	441.04	440.44	440.86	2258621.0
2023-09-19 12:00:00	SPY	ETF	440.85	440.86	440.231	440.56	2421582.0
2023-09-19 12:30:00	SPY	ETF	440.56	440.665	439.94	440.61	2314076.0
2023-09-19 13:00:00	SPY	ETF	440.61	441.3	440.5	441.1069	2257897.0
2023-09-19 13:30:00	SPY	ETF	441.105	442.27	441.0991	442.15	3573247.0
2023-09-19 14:00:00	SPY	ETF	442.15	442.45	441.97	442.05	2878390.0
2023-09-19 14:30:00	SPY	ETF	442.04	443.29	442.02	442.1	4253396.0
2023-09-19 15:00:00	SPY	ETF	442.095	442.58	441.88	442.5	2772516.0
2023-09-19 15:30:00	SPY	ETF	442.5	443.18	442.26	442.75	6973570.0
2023-09-19 16:00:00	SPY	ETF	442.74	443.04	441.0099	442.77	2045409.0
2023-09-19 16:30:00	SPY	ETF	442.78	442.82	442.75	442.81	133950.0
2023-09-19 17:00:00	SPY	ETF	442.88	442.88	442.78	442.8	8064.0
2023-09-19 17:30:00	SPY	ETF	442.8	442.87	442.75	442.79	9831.0
2023-09-19 18:00:00	SPY	ETF	442.78	442.91	442.75	442.87	28947.0
2023-09-19 18:30:00	SPY	ETF	442.85	442.85	442.75	442.8	5810.0
2023-09-19 19:00:00	SPY	ETF	442.75	442.83	442.73	442.83	4228.0
2023-09-19 19:30:00	SPY	ETF	442.85	442.9	442.8213	442.89	7573.0
2023-09-19 04:00:00	QQQ	ETF	370.75	371.25	370.75	371.03	12352.0
2023-09-19 04:30:00	QQQ	ETF	371.03	371.2	371.0	371.16	5610.0
2023-09-19 05:00:00	QQQ	ETF	371.12	371.35	370.9	371.35	6861.0
2023-09-19 05:30:00	QQQ	ETF	371.36	371.36	371.23	371.26	4589.0
2023-09-19 06:00:00	QQQ	ETF	371.2	371.31	371.14	371.14	6036.0
2023-09-19 06:30:00	QQQ	ETF	371.17	371.39	371.09	371.09	10950.0
2023-09-19 07:00:00	QQQ	ETF	371.06	371.44	371.03	371.44	19673.0
2023-09-19 07:30:00	QQQ	ETF	371.35	371.36	370.82	371.06	33896.0
2023-09-19 08:00:00	QQQ	ETF	371.06	371.41	369.99	370.74	97540.0
2023-09-19 08:30:00	QQQ	ETF	370.65	370.937	370.0	370.0201	134623.0
2023-09-19 09:00:00	QQQ	ETF	370.02	370.11	369.07	369.3	396338.0
2023-09-19 09:30:00	QQQ	ETF	369.32	369.765	368.09	368.1099	4115247.0
2023-09-19 10:00:00	QQQ	ETF	368.12	368.43	367.38	368.05	3418965.0
2023-09-19 10:30:00	QQQ	ETF	368.04	368.069	366.8	366.93	2586568.0
2023-09-19 11:00:00	QQQ	ETF	366.92	367.64	366.85	367.59	1674185.0
2023-09-19 11:30:00	QQQ	ETF	367.59	367.929	367.27	367.8366	1257972.0
2023-09-19 12:00:00	QQQ	ETF	367.8467	367.85	367.05	367.66	914873.0
2023-09-19 12:30:00	QQQ	ETF	367.6306	368.18	367.15	368.095	1107263.0

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

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