PREVIEW / etf_30min / 2023-07-05

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-07-05.parquet
  size:    709 KB
  rows:    28,391

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-07-05 04:00:00	SPY	ETF	442.93	443.31	442.71	442.99	25506.0
2023-07-05 04:30:00	SPY	ETF	442.94	442.94	442.69	442.7	4568.0
2023-07-05 05:00:00	SPY	ETF	442.75	442.75	442.23	442.23	15998.0
2023-07-05 05:30:00	SPY	ETF	442.2	442.2	441.59	441.91	20569.0
2023-07-05 06:00:00	SPY	ETF	441.94	442.14	441.86	442.1	7863.0
2023-07-05 06:30:00	SPY	ETF	442.2	442.31	442.14	442.19	16435.0
2023-07-05 07:00:00	SPY	ETF	442.21	442.22	441.85	441.93	51468.0
2023-07-05 07:30:00	SPY	ETF	441.89	442.06	441.69	441.69	88198.0
2023-07-05 08:00:00	SPY	ETF	442.19	443.79	441.44	441.69	235137.0
2023-07-05 08:30:00	SPY	ETF	441.6916	443.79	441.5	441.63	150784.0
2023-07-05 09:00:00	SPY	ETF	441.62	441.99	441.55	441.9	187745.0
2023-07-05 09:30:00	SPY	ETF	441.91	443.32	441.9	443.22	4771723.0
2023-07-05 10:00:00	SPY	ETF	443.23	443.625	442.93	443.47	3198390.0
2023-07-05 10:30:00	SPY	ETF	443.48	443.83	443.1401	443.79	3012708.0
2023-07-05 11:00:00	SPY	ETF	443.795	443.889	443.37	443.57	2867484.0
2023-07-05 11:30:00	SPY	ETF	443.56	443.81	443.16	443.29	1891693.0
2023-07-05 12:00:00	SPY	ETF	443.295	443.3701	443.02	443.24	1976974.0
2023-07-05 12:30:00	SPY	ETF	443.2514	443.36	442.73	443.17	2571948.0
2023-07-05 13:00:00	SPY	ETF	443.16	443.39	443.01	443.1699	1575787.0
2023-07-05 13:30:00	SPY	ETF	443.17	443.36	442.99	443.2801	1138645.0
2023-07-05 14:00:00	SPY	ETF	443.2999	443.605	442.31	442.72	3269579.0
2023-07-05 14:30:00	SPY	ETF	442.72	443.53	442.715	443.5	2278187.0
2023-07-05 15:00:00	SPY	ETF	443.5	443.76	443.44	443.72	2379934.0
2023-07-05 15:30:00	SPY	ETF	443.71	443.7599	443.09	443.14	6003358.0
2023-07-05 16:00:00	SPY	ETF	443.14	443.22	443.03	443.08	1918249.0
2023-07-05 16:30:00	SPY	ETF	443.1	443.19	443.03	443.03	179109.0
2023-07-05 17:00:00	SPY	ETF	443.01	443.08	442.95	443.01	40603.0
2023-07-05 17:30:00	SPY	ETF	443.05	443.07	443.01	443.02	7324.0
2023-07-05 18:00:00	SPY	ETF	442.91	443.09	442.91	443.04	32019.0
2023-07-05 18:30:00	SPY	ETF	443.03	443.03	442.88	442.88	5847.0
2023-07-05 19:00:00	SPY	ETF	442.9	443.05	442.9	443.05	8221.0
2023-07-05 19:30:00	SPY	ETF	443.02	443.03	442.81	442.83	8711.0
2023-07-05 04:00:00	QQQ	ETF	368.85	370.29	368.75	369.04	43620.0
2023-07-05 04:30:00	QQQ	ETF	369.07	369.12	368.7	368.78	31382.0
2023-07-05 05:00:00	QQQ	ETF	368.77	368.88	368.12	368.12	20353.0
2023-07-05 05:30:00	QQQ	ETF	368.2	368.2	367.81	368.07	22840.0
2023-07-05 06:00:00	QQQ	ETF	368.04	368.31	367.94	368.28	20474.0
2023-07-05 06:30:00	QQQ	ETF	368.45	368.69	368.34	368.61	13586.0
2023-07-05 07:00:00	QQQ	ETF	368.63	368.68	368.271	368.38	57352.0
2023-07-05 07:30:00	QQQ	ETF	368.34	368.48	368.15	368.15	38416.0
2023-07-05 08:00:00	QQQ	ETF	368.6291	369.93	367.95	368.18	83536.0
2023-07-05 08:30:00	QQQ	ETF	368.17	368.47	368.06	368.46	91098.0
2023-07-05 09:00:00	QQQ	ETF	368.48	368.7	368.31	368.69	160561.0
2023-07-05 09:30:00	QQQ	ETF	368.695	371.15	368.66	370.65	4681305.0
2023-07-05 10:00:00	QQQ	ETF	370.62	371.83	370.44	371.49	2681133.0
2023-07-05 10:30:00	QQQ	ETF	371.4936	372.01	370.97	371.595	1881600.0
2023-07-05 11:00:00	QQQ	ETF	371.6	371.61	370.21	370.33	1874600.0
2023-07-05 11:30:00	QQQ	ETF	370.33	370.77	369.97	370.09	1908532.0
2023-07-05 12:00:00	QQQ	ETF	370.09	370.63	369.76	370.54	1380917.0
2023-07-05 12:30:00	QQQ	ETF	370.535	370.67	369.805	370.38	1390593.0

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

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