PREVIEW / etf_30min / 2023-09-18

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-09-18.parquet
  size:    687 KB
  rows:    27,397

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-18 04:00:00	SPY	ETF	444.0	444.18	443.92	443.92	14177.0
2023-09-18 04:30:00	SPY	ETF	443.87	444.17	443.85	443.85	8020.0
2023-09-18 05:00:00	SPY	ETF	443.85	444.04	443.73	443.75	9770.0
2023-09-18 05:30:00	SPY	ETF	443.74	443.87	443.69	443.81	5997.0
2023-09-18 06:00:00	SPY	ETF	443.78	443.93	443.62	443.89	3603.0
2023-09-18 06:30:00	SPY	ETF	443.89	444.01	443.79	443.85	18809.0
2023-09-18 07:00:00	SPY	ETF	443.85	443.94	443.44	443.45	34896.0
2023-09-18 07:30:00	SPY	ETF	443.4	443.41	442.35	442.63	104770.0
2023-09-18 08:00:00	SPY	ETF	442.61	444.28	442.39	442.96	212124.0
2023-09-18 08:30:00	SPY	ETF	442.95	443.27	442.85	443.08	214354.0
2023-09-18 09:00:00	SPY	ETF	443.12	443.32	442.63	443.05	173568.0
2023-09-18 09:30:00	SPY	ETF	443.05	443.76	442.56	443.04	4517090.0
2023-09-18 10:00:00	SPY	ETF	443.02	443.74	442.7101	443.37	3328183.0
2023-09-18 10:30:00	SPY	ETF	443.37	443.86	443.03	443.67	2984690.0
2023-09-18 11:00:00	SPY	ETF	443.67	444.08	443.27	444.065	2328309.0
2023-09-18 11:30:00	SPY	ETF	444.06	444.79	444.04	444.63	3375801.0
2023-09-18 12:00:00	SPY	ETF	444.64	444.775	444.28	444.65	1985958.0
2023-09-18 12:30:00	SPY	ETF	444.65	444.97	444.44	444.4607	1991658.0
2023-09-18 13:00:00	SPY	ETF	444.47	444.74	444.155	444.4601	1717125.0
2023-09-18 13:30:00	SPY	ETF	444.47	444.79	444.28	444.31	1333406.0
2023-09-18 14:00:00	SPY	ETF	444.31	444.52	444.01	444.0929	1786557.0
2023-09-18 14:30:00	SPY	ETF	444.095	444.34	443.175	443.54	3025853.0
2023-09-18 15:00:00	SPY	ETF	443.53	443.73	443.23	443.54	2907185.0
2023-09-18 15:30:00	SPY	ETF	443.54	443.73	443.175	443.64	7465967.0
2023-09-18 16:00:00	SPY	ETF	443.63	444.0	437.18	443.85	3392796.0
2023-09-18 16:30:00	SPY	ETF	443.87	443.87	443.75	443.76	51142.0
2023-09-18 17:00:00	SPY	ETF	443.73	443.7399	443.63	443.66	32800.0
2023-09-18 17:30:00	SPY	ETF	443.73	443.7899	443.72	443.7899	5784.0
2023-09-18 18:00:00	SPY	ETF	443.78	443.99	443.78	443.98	31131.0
2023-09-18 18:30:00	SPY	ETF	443.98	443.98	443.89	443.95	8377.0
2023-09-18 19:00:00	SPY	ETF	443.95	443.95	443.89	443.93	6033.0
2023-09-18 19:30:00	SPY	ETF	443.89	443.91	443.84	443.9	9272.0
2023-09-18 04:00:00	QQQ	ETF	370.81	370.98	370.65	370.68	28752.0
2023-09-18 04:30:00	QQQ	ETF	370.79	371.03	370.7	370.7	12804.0
2023-09-18 05:00:00	QQQ	ETF	370.76	371.0	370.72	370.74	9776.0
2023-09-18 05:30:00	QQQ	ETF	370.75	370.88	370.72	370.75	9356.0
2023-09-18 06:00:00	QQQ	ETF	370.68	370.81	370.46	370.72	27930.0
2023-09-18 06:30:00	QQQ	ETF	370.75	370.89	370.56	370.7	28818.0
2023-09-18 07:00:00	QQQ	ETF	370.63	370.75	369.95	369.98	69397.0
2023-09-18 07:30:00	QQQ	ETF	369.95	369.97	368.74	368.96	137290.0
2023-09-18 08:00:00	QQQ	ETF	370.72	371.0	368.77	369.33	230293.0
2023-09-18 08:30:00	QQQ	ETF	369.34	369.73	369.28	369.47	122061.0
2023-09-18 09:00:00	QQQ	ETF	369.5	369.5601	369.04	369.31	254951.0
2023-09-18 09:30:00	QQQ	ETF	369.32	371.2	369.03	370.5407	4804684.0
2023-09-18 10:00:00	QQQ	ETF	370.53	371.32	370.02	370.47	2375384.0
2023-09-18 10:30:00	QQQ	ETF	370.49	370.71	369.5	370.34	2603369.0
2023-09-18 11:00:00	QQQ	ETF	370.32	370.93	370.05	370.87	1672023.0
2023-09-18 11:30:00	QQQ	ETF	370.87	371.59	370.81	371.48	1413189.0
2023-09-18 12:00:00	QQQ	ETF	371.48	371.67	370.965	371.52	1297093.0
2023-09-18 12:30:00	QQQ	ETF	371.565	371.79	371.141	371.19	838978.0

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

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