PREVIEW / etf_30min / 2023-10-25

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-10-25.parquet
  size:    722 KB
  rows:    29,220

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-10-25 04:00:00	SPY	ETF	422.24	422.29	421.54	422.26	50243.0
2023-10-25 04:30:00	SPY	ETF	422.37	422.43	422.0	422.2	9736.0
2023-10-25 05:00:00	SPY	ETF	422.08	422.2	421.63	422.17	8223.0
2023-10-25 05:30:00	SPY	ETF	422.36	422.36	421.69	421.97	28079.0
2023-10-25 06:00:00	SPY	ETF	421.98	422.03	421.5	422.03	11414.0
2023-10-25 06:30:00	SPY	ETF	422.19	422.34	422.14	422.33	18739.0
2023-10-25 07:00:00	SPY	ETF	422.35	422.7	422.34	422.58	46460.0
2023-10-25 07:30:00	SPY	ETF	422.51	422.7	422.3	422.36	61751.0
2023-10-25 08:00:00	SPY	ETF	422.56	422.95	421.21	422.69	228678.0
2023-10-25 08:30:00	SPY	ETF	422.67	422.83	421.9	421.94	231187.0
2023-10-25 09:00:00	SPY	ETF	421.9	422.25	421.83	421.89	212371.0
2023-10-25 09:30:00	SPY	ETF	421.89	421.92	419.51	420.19	8578193.0
2023-10-25 10:00:00	SPY	ETF	420.18	420.19	419.02	419.3095	5249504.0
2023-10-25 10:30:00	SPY	ETF	419.3	421.12	419.14	420.1488	5951397.0
2023-10-25 11:00:00	SPY	ETF	420.13	421.43	420.055	420.91	5960466.0
2023-10-25 11:30:00	SPY	ETF	420.91	421.08	419.48	419.53	3991479.0
2023-10-25 12:00:00	SPY	ETF	419.531	419.6	418.82	419.21	4138615.0
2023-10-25 12:30:00	SPY	ETF	419.21	419.78	418.34	418.585	3639497.0
2023-10-25 13:00:00	SPY	ETF	418.59	418.86	417.76	417.9371	5064211.0
2023-10-25 13:30:00	SPY	ETF	417.93	417.93	417.015	417.72	4945078.0
2023-10-25 14:00:00	SPY	ETF	417.72	418.32	417.3815	417.735	3864194.0
2023-10-25 14:30:00	SPY	ETF	417.7399	418.06	417.12	417.675	3578344.0
2023-10-25 15:00:00	SPY	ETF	417.695	418.15	417.22	417.9499	4045544.0
2023-10-25 15:30:00	SPY	ETF	417.945	418.455	417.4	417.61	12627231.0
2023-10-25 16:00:00	SPY	ETF	417.61	420.7766	417.53	418.24	4150774.0
2023-10-25 16:30:00	SPY	ETF	418.25	418.25	417.55	417.7	791596.0
2023-10-25 17:00:00	SPY	ETF	417.74	417.78	417.26	417.56	100703.0
2023-10-25 17:30:00	SPY	ETF	417.59	417.75	417.16	417.18	74998.0
2023-10-25 18:00:00	SPY	ETF	417.15	417.15	415.7	416.07	182673.0
2023-10-25 18:30:00	SPY	ETF	416.08	416.29	416.0	416.05	109203.0
2023-10-25 19:00:00	SPY	ETF	416.05	416.14	415.27	415.57	55524.0
2023-10-25 19:30:00	SPY	ETF	415.57	415.81	415.57	415.72	61747.0
2023-10-25 04:00:00	QQQ	ETF	356.8	357.27	356.54	357.2	50711.0
2023-10-25 04:30:00	QQQ	ETF	357.29	357.35	356.9	357.06	27457.0
2023-10-25 05:00:00	QQQ	ETF	357.0	357.09	356.6	357.09	48045.0
2023-10-25 05:30:00	QQQ	ETF	357.12	357.31	356.78	356.94	16448.0
2023-10-25 06:00:00	QQQ	ETF	356.91	357.15	356.5	357.15	15419.0
2023-10-25 06:30:00	QQQ	ETF	357.17	357.39	357.05	357.36	9089.0
2023-10-25 07:00:00	QQQ	ETF	357.39	357.64	357.28	357.56	65635.0
2023-10-25 07:30:00	QQQ	ETF	357.54	357.69	357.19	357.29	111384.0
2023-10-25 08:00:00	QQQ	ETF	357.52	359.399	356.1	357.53	255701.0
2023-10-25 08:30:00	QQQ	ETF	357.53	357.67	356.82	356.85	183391.0
2023-10-25 09:00:00	QQQ	ETF	356.82	357.08	356.5	356.67	223466.0
2023-10-25 09:30:00	QQQ	ETF	356.69	356.88	353.42	354.53	8023406.0
2023-10-25 10:00:00	QQQ	ETF	354.53	354.53	353.23	353.6	4292326.0
2023-10-25 10:30:00	QQQ	ETF	353.58	355.2	353.5	353.85	4550785.0
2023-10-25 11:00:00	QQQ	ETF	353.85	355.36	353.491	354.23	3678774.0
2023-10-25 11:30:00	QQQ	ETF	354.23	354.462	352.72	352.79	2578458.0
2023-10-25 12:00:00	QQQ	ETF	352.79	353.15	352.391	352.81	1685370.0
2023-10-25 12:30:00	QQQ	ETF	352.78	353.175	351.8312	352.16	1922296.0

> showing 50 of 29,220 rows — these rows as CSV

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