PREVIEW / etf_30min / 2023-08-30

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-08-30.parquet
  size:    691 KB
  rows:    27,785

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-08-30 04:00:00	SPY	ETF	449.32	449.33	448.59	448.59	15147.0
2023-08-30 04:30:00	SPY	ETF	448.57	448.76	448.55	448.61	10515.0
2023-08-30 05:00:00	SPY	ETF	448.65	448.65	448.41	448.59	5519.0
2023-08-30 05:30:00	SPY	ETF	448.52	448.65	448.33	448.65	10452.0
2023-08-30 06:00:00	SPY	ETF	448.57	448.9	448.51	448.9	16661.0
2023-08-30 06:30:00	SPY	ETF	448.87	449.1	448.82	449.0	9532.0
2023-08-30 07:00:00	SPY	ETF	449.0	449.05	448.67	449.01	177696.0
2023-08-30 07:30:00	SPY	ETF	448.89	449.0	448.76	448.79	53683.0
2023-08-30 08:00:00	SPY	ETF	448.9188	450.08	448.3104	449.4	377066.0
2023-08-30 08:30:00	SPY	ETF	449.37	450.0	448.92	449.59	257494.0
2023-08-30 09:00:00	SPY	ETF	449.56	449.71	449.26	449.6	185722.0
2023-08-30 09:30:00	SPY	ETF	449.53	451.3383	449.4501	451.23	6093902.0
2023-08-30 10:00:00	SPY	ETF	451.24	451.62	448.78	449.28	6746670.0
2023-08-30 10:30:00	SPY	ETF	449.29	450.6705	449.25	450.59	4525455.0
2023-08-30 11:00:00	SPY	ETF	450.6	450.65	449.74	450.48	2943320.0
2023-08-30 11:30:00	SPY	ETF	450.485	451.17	450.35	451.06	2813490.0
2023-08-30 12:00:00	SPY	ETF	451.06	451.44	450.77	451.34	2404900.0
2023-08-30 12:30:00	SPY	ETF	451.35	451.67	450.95	451.42	2826646.0
2023-08-30 13:00:00	SPY	ETF	451.415	451.46	450.91	450.93	2013370.0
2023-08-30 13:30:00	SPY	ETF	450.93	451.4	450.33	450.735	2685415.0
2023-08-30 14:00:00	SPY	ETF	450.75	450.85	449.98	450.1299	3549878.0
2023-08-30 14:30:00	SPY	ETF	450.12	451.24	450.08	451.1585	2527067.0
2023-08-30 15:00:00	SPY	ETF	451.168	451.4	450.75	450.89	2789649.0
2023-08-30 15:30:00	SPY	ETF	450.89	451.175	450.53	450.99	9240663.0
2023-08-30 16:00:00	SPY	ETF	451.0	451.4054	450.3032	451.25	3958417.0
2023-08-30 16:30:00	SPY	ETF	451.25	451.33	451.01	451.3	1501280.0
2023-08-30 17:00:00	SPY	ETF	451.31	451.35	451.23	451.34	37071.0
2023-08-30 17:30:00	SPY	ETF	451.34	451.34	451.27	451.31	5953.0
2023-08-30 18:00:00	SPY	ETF	451.31	451.31	451.15	451.18	29343.0
2023-08-30 18:30:00	SPY	ETF	451.18	451.21	451.1	451.13	9889.0
2023-08-30 19:00:00	SPY	ETF	451.13	451.15	451.1	451.12	3656.0
2023-08-30 19:30:00	SPY	ETF	451.12	451.12	451.02	451.07	13728.0
2023-08-30 04:00:00	QQQ	ETF	374.9	374.9	373.95	373.95	54558.0
2023-08-30 04:30:00	QQQ	ETF	374.02	374.2	373.93	374.0	16102.0
2023-08-30 05:00:00	QQQ	ETF	373.93	373.99	373.55	373.91	31560.0
2023-08-30 05:30:00	QQQ	ETF	373.83	373.98	373.56	373.8	23572.0
2023-08-30 06:00:00	QQQ	ETF	373.89	374.17	373.84	374.16	13568.0
2023-08-30 06:30:00	QQQ	ETF	374.19	374.4	374.17	374.35	13335.0
2023-08-30 07:00:00	QQQ	ETF	374.33	374.52	374.05	374.47	74267.0
2023-08-30 07:30:00	QQQ	ETF	374.45	374.62	374.18	374.34	42695.0
2023-08-30 08:00:00	QQQ	ETF	374.97	375.71	373.6696	375.0	292181.0
2023-08-30 08:30:00	QQQ	ETF	375.06	375.72	374.8	375.17	302612.0
2023-08-30 09:00:00	QQQ	ETF	375.14	375.15	374.64	374.78	249888.0
2023-08-30 09:30:00	QQQ	ETF	374.89	376.3239	374.13	376.05	4509510.0
2023-08-30 10:00:00	QQQ	ETF	376.07	377.07	373.86	374.62	4459404.0
2023-08-30 10:30:00	QQQ	ETF	374.64	376.38	374.55	376.25	3121498.0
2023-08-30 11:00:00	QQQ	ETF	376.28	376.34	375.28	376.02	1967410.0
2023-08-30 11:30:00	QQQ	ETF	375.99	376.845	375.9	376.79	1945459.0
2023-08-30 12:00:00	QQQ	ETF	376.79	377.32	376.58	377.14	1583201.0
2023-08-30 12:30:00	QQQ	ETF	377.14	377.4467	376.67	377.125	2009715.0

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

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