PREVIEW / etf_30min / 2023-06-16

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-06-16.parquet
  size:    708 KB
  rows:    28,099

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-06-16 04:00:00	SPY	ETF	440.77	441.24	440.56	441.15	56519.0
2023-06-16 04:30:00	SPY	ETF	441.18	441.58	441.16	441.47	32305.0
2023-06-16 05:00:00	SPY	ETF	441.49	441.61	441.3	441.3	22373.0
2023-06-16 05:30:00	SPY	ETF	441.27	441.45	441.21	441.21	12325.0
2023-06-16 06:00:00	SPY	ETF	441.37	441.37	440.8	440.85	30406.0
2023-06-16 06:30:00	SPY	ETF	440.77	440.99	440.72	440.89	13256.0
2023-06-16 07:00:00	SPY	ETF	440.96	441.36	440.93	441.33	91211.0
2023-06-16 07:30:00	SPY	ETF	441.35	441.59	441.19	441.24	291370.0
2023-06-16 08:00:00	SPY	ETF	441.17	441.94	440.01	441.87	285975.0
2023-06-16 08:30:00	SPY	ETF	441.9	442.28	441.9	442.19	157615.0
2023-06-16 09:00:00	SPY	ETF	442.159	443.25	441.48	443.01	718569.0
2023-06-16 09:30:00	SPY	ETF	443.02	443.18	440.77	441.26	8550365.0
2023-06-16 10:00:00	SPY	ETF	441.3	442.43	441.255	442.4	5598607.0
2023-06-16 10:30:00	SPY	ETF	442.4	442.4	440.92	441.53	4717254.0
2023-06-16 11:00:00	SPY	ETF	441.535	442.0	440.335	440.785	4238827.0
2023-06-16 11:30:00	SPY	ETF	440.77	441.26	440.42	441.24	4110560.0
2023-06-16 12:00:00	SPY	ETF	441.25	441.79	440.97	441.75	3067067.0
2023-06-16 12:30:00	SPY	ETF	441.75	442.38	441.65	442.15	3372785.0
2023-06-16 13:00:00	SPY	ETF	442.15	442.24	441.35	441.45	2296865.0
2023-06-16 13:30:00	SPY	ETF	441.45	441.53	440.92	441.32	2920297.0
2023-06-16 14:00:00	SPY	ETF	441.33	441.43	440.78	441.03	2679521.0
2023-06-16 14:30:00	SPY	ETF	441.03	441.04	440.06	440.095	3387411.0
2023-06-16 15:00:00	SPY	ETF	440.1	440.19	439.35	439.57	5516878.0
2023-06-16 15:30:00	SPY	ETF	439.57	440.35	438.97	439.43	11525613.0
2023-06-16 16:00:00	SPY	ETF	439.41	440.1	439.0	440.0	5789057.0
2023-06-16 16:30:00	SPY	ETF	439.97	440.1	439.52	439.7	192672.0
2023-06-16 17:00:00	SPY	ETF	439.7	439.9301	439.7	439.82	32909.0
2023-06-16 17:30:00	SPY	ETF	439.79	439.79	439.45	439.55	42407.0
2023-06-16 18:00:00	SPY	ETF	439.55	439.65	439.55	439.55	4668.0
2023-06-16 18:30:00	SPY	ETF	439.65	439.65	439.55	439.576	4422.0
2023-06-16 19:00:00	SPY	ETF	439.56	439.66	439.55	439.59	3057.0
2023-06-16 19:30:00	SPY	ETF	439.6	439.62	439.55	439.55	9648.0
2023-06-16 04:00:00	QQQ	ETF	369.88	370.66	369.88	370.65	78779.0
2023-06-16 04:30:00	QQQ	ETF	370.71	371.14	370.69	370.86	50146.0
2023-06-16 05:00:00	QQQ	ETF	370.9	371.13	370.63	370.73	20193.0
2023-06-16 05:30:00	QQQ	ETF	370.63	371.02	370.58	370.8	53779.0
2023-06-16 06:00:00	QQQ	ETF	370.84	370.87	370.24	370.36	36445.0
2023-06-16 06:30:00	QQQ	ETF	370.36	370.74	370.33	370.74	47140.0
2023-06-16 07:00:00	QQQ	ETF	370.71	371.36	370.7	371.28	83101.0
2023-06-16 07:30:00	QQQ	ETF	371.319	371.52	371.04	371.07	159539.0
2023-06-16 08:00:00	QQQ	ETF	370.67	371.8	369.34	371.7	330714.0
2023-06-16 08:30:00	QQQ	ETF	371.68	371.99	371.45	371.77	218422.0
2023-06-16 09:00:00	QQQ	ETF	371.79	372.76	371.01	372.7	1124569.0
2023-06-16 09:30:00	QQQ	ETF	372.72	372.85	369.38	370.02	7564590.0
2023-06-16 10:00:00	QQQ	ETF	370.05	371.285	369.64	371.25	3769084.0
2023-06-16 10:30:00	QQQ	ETF	371.235	371.33	369.64	370.34	2718433.0
2023-06-16 11:00:00	QQQ	ETF	370.34	371.35	369.1301	369.58	2922699.0
2023-06-16 11:30:00	QQQ	ETF	369.6	370.34	369.26	370.31	2055689.0
2023-06-16 12:00:00	QQQ	ETF	370.3299	370.725	369.98	370.69	1750563.0
2023-06-16 12:30:00	QQQ	ETF	370.7	371.31	370.48	371.01	1705146.0

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

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