PREVIEW / etf_30min / 2023-07-31

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-07-31.parquet
  size:    712 KB
  rows:    28,495

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-31 04:00:00	SPY	ETF	456.63	457.05	456.63	456.84	18610.0
2023-07-31 04:30:00	SPY	ETF	457.07	457.29	457.03	457.29	6584.0
2023-07-31 05:00:00	SPY	ETF	457.32	457.43	457.23	457.32	5467.0
2023-07-31 05:30:00	SPY	ETF	457.27	457.27	456.94	457.04	5026.0
2023-07-31 06:00:00	SPY	ETF	457.07	457.23	456.95	457.23	4773.0
2023-07-31 06:30:00	SPY	ETF	457.12	457.32	457.12	457.29	3050.0
2023-07-31 07:00:00	SPY	ETF	457.32	457.57	457.32	457.51	81978.0
2023-07-31 07:30:00	SPY	ETF	457.5	457.63	457.35	457.63	44609.0
2023-07-31 08:00:00	SPY	ETF	457.3399	457.73	456.1	457.62	75696.0
2023-07-31 08:30:00	SPY	ETF	457.66	458.1	457.59	457.97	213243.0
2023-07-31 09:00:00	SPY	ETF	457.96	457.96	457.37	457.41	184017.0
2023-07-31 09:30:00	SPY	ETF	457.41	458.16	456.5	457.0	6027497.0
2023-07-31 10:00:00	SPY	ETF	457.0	457.71	456.66	457.7	2879192.0
2023-07-31 10:30:00	SPY	ETF	457.7	457.82	457.155	457.513	2623023.0
2023-07-31 11:00:00	SPY	ETF	457.53	457.83	457.12	457.28	1757283.0
2023-07-31 11:30:00	SPY	ETF	457.3	457.36	456.684	456.945	2692342.0
2023-07-31 12:00:00	SPY	ETF	456.95	457.24	456.82	457.21	1921982.0
2023-07-31 12:30:00	SPY	ETF	457.2	457.24	456.5	456.63	1373573.0
2023-07-31 13:00:00	SPY	ETF	456.63	457.02	456.24	456.6187	2063560.0
2023-07-31 13:30:00	SPY	ETF	456.6189	457.17	456.595	456.88	1505841.0
2023-07-31 14:00:00	SPY	ETF	456.89	457.04	456.48	456.68	1815604.0
2023-07-31 14:30:00	SPY	ETF	456.68	457.18	456.585	457.05	1486917.0
2023-07-31 15:00:00	SPY	ETF	457.059	457.1001	456.46	456.685	3208308.0
2023-07-31 15:30:00	SPY	ETF	456.68	457.84	456.045	457.79	11195457.0
2023-07-31 16:00:00	SPY	ETF	457.79	458.09	457.6342	457.79	4946167.0
2023-07-31 16:30:00	SPY	ETF	457.93	458.01	457.79	457.92	250888.0
2023-07-31 17:00:00	SPY	ETF	457.95	457.95	457.85	457.91	17523.0
2023-07-31 17:30:00	SPY	ETF	457.9	457.98	457.79	457.98	471705.0
2023-07-31 18:00:00	SPY	ETF	457.95	458.08	457.9	457.95	53878.0
2023-07-31 18:30:00	SPY	ETF	457.88	457.88	457.74	457.8	22066.0
2023-07-31 19:00:00	SPY	ETF	457.81	457.81	457.72	457.72	4638.0
2023-07-31 19:30:00	SPY	ETF	457.75	457.87	457.75	457.83	24499.0
2023-07-31 04:00:00	QQQ	ETF	382.86	383.32	382.86	383.22	21507.0
2023-07-31 04:30:00	QQQ	ETF	383.32	383.75	383.28	383.7	31952.0
2023-07-31 05:00:00	QQQ	ETF	383.7	383.83	383.5	383.6	7378.0
2023-07-31 05:30:00	QQQ	ETF	383.54	383.54	383.12	383.22	5554.0
2023-07-31 06:00:00	QQQ	ETF	383.24	383.48	383.17	383.48	10011.0
2023-07-31 06:30:00	QQQ	ETF	383.41	383.52	383.28	383.51	10960.0
2023-07-31 07:00:00	QQQ	ETF	383.57	383.87	383.53	383.78	58421.0
2023-07-31 07:30:00	QQQ	ETF	383.78	384.1	383.6	384.09	50068.0
2023-07-31 08:00:00	QQQ	ETF	382.68	384.21	382.42	384.14	207559.0
2023-07-31 08:30:00	QQQ	ETF	384.16	384.629	384.0	384.4	242578.0
2023-07-31 09:00:00	QQQ	ETF	384.42	384.43	383.68	383.79	171865.0
2023-07-31 09:30:00	QQQ	ETF	383.8	384.88	382.49	383.03	5364412.0
2023-07-31 10:00:00	QQQ	ETF	383.0299	383.9	382.52	383.805	2876642.0
2023-07-31 10:30:00	QQQ	ETF	383.8	384.12	383.02	383.8001	2342904.0
2023-07-31 11:00:00	QQQ	ETF	383.8023	384.26	383.35	383.595	1434529.0
2023-07-31 11:30:00	QQQ	ETF	383.61	383.8304	382.855	383.42	2136330.0
2023-07-31 12:00:00	QQQ	ETF	383.435	383.81	383.125	383.76	1529379.0
2023-07-31 12:30:00	QQQ	ETF	383.74	383.84	382.9105	382.985	1258158.0

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

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