PREVIEW / etf_30min / 2024-04-05

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-04-05.parquet
  size:    806 KB
  rows:    31,811

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
2024-04-05 04:00:00	SPY	ETF	514.42	514.62	514.1	514.5	15133.0
2024-04-05 04:30:00	SPY	ETF	514.6	514.74	514.28	514.28	2905.0
2024-04-05 05:00:00	SPY	ETF	514.57	514.61	514.31	514.41	1712.0
2024-04-05 05:30:00	SPY	ETF	514.43	514.75	514.43	514.5	10915.0
2024-04-05 06:00:00	SPY	ETF	514.63	514.63	514.37	514.38	6436.0
2024-04-05 06:30:00	SPY	ETF	514.3	514.67	514.24	514.57	10081.0
2024-04-05 07:00:00	SPY	ETF	514.6	514.74	514.46	514.6	125677.0
2024-04-05 07:30:00	SPY	ETF	514.61	515.24	514.57	514.73	87949.0
2024-04-05 08:00:00	SPY	ETF	514.66	515.21	513.65	515.21	260717.0
2024-04-05 08:30:00	SPY	ETF	514.5	515.749	512.51	514.49	1939413.0
2024-04-05 09:00:00	SPY	ETF	514.51	514.93	513.87	514.41	365066.0
2024-04-05 09:30:00	SPY	ETF	514.43	516.4	514.01	515.92	6226811.0
2024-04-05 10:00:00	SPY	ETF	515.92	516.43	514.89	515.44	4805826.0
2024-04-05 10:30:00	SPY	ETF	515.46	518.0913	515.19	518.06	4113687.0
2024-04-05 11:00:00	SPY	ETF	518.05	518.08	516.43	517.85	4150016.0
2024-04-05 11:30:00	SPY	ETF	517.84	519.72	517.57	519.43	3896953.0
2024-04-05 12:00:00	SPY	ETF	519.43	520.01	519.195	519.615	3619681.0
2024-04-05 12:30:00	SPY	ETF	519.61	520.44	519.08	520.3398	3391976.0
2024-04-05 13:00:00	SPY	ETF	520.33	520.43	518.71	519.26	3121785.0
2024-04-05 13:30:00	SPY	ETF	519.26	519.595	517.43	517.8099	3072118.0
2024-04-05 14:00:00	SPY	ETF	517.8	519.28	516.97	517.79	4172130.0
2024-04-05 14:30:00	SPY	ETF	517.8	518.71	517.24	517.865	3061862.0
2024-04-05 15:00:00	SPY	ETF	517.88	518.39	517.68	518.15	3078577.0
2024-04-05 15:30:00	SPY	ETF	518.15	519.295	518.0199	518.4	7737133.0
2024-04-05 16:00:00	SPY	ETF	518.39	518.69	518.17	518.6	2333410.0
2024-04-05 16:30:00	SPY	ETF	518.63	518.79	518.47	518.79	189659.0
2024-04-05 17:00:00	SPY	ETF	518.73	518.85	518.3	518.45	66982.0
2024-04-05 17:30:00	SPY	ETF	518.45	518.5	518.36	518.38	19448.0
2024-04-05 18:00:00	SPY	ETF	518.38	518.46	518.35	518.46	1395.0
2024-04-05 18:30:00	SPY	ETF	518.42	518.48	518.39	518.39	11892.0
2024-04-05 19:00:00	SPY	ETF	518.38	518.46	518.25	518.46	32869.0
2024-04-05 19:30:00	SPY	ETF	518.46	518.7	518.35	518.51	9844.0
2024-04-05 04:00:00	QQQ	ETF	436.76	437.08	436.51	436.8	25747.0
2024-04-05 04:30:00	QQQ	ETF	436.89	437.0	436.45	436.7	11585.0
2024-04-05 05:00:00	QQQ	ETF	436.8	436.88	436.6	436.74	14153.0
2024-04-05 05:30:00	QQQ	ETF	436.82	437.04	436.6	436.83	35589.0
2024-04-05 06:00:00	QQQ	ETF	436.75	436.78	436.6	436.64	5596.0
2024-04-05 06:30:00	QQQ	ETF	436.55	436.92	436.42	436.86	59178.0
2024-04-05 07:00:00	QQQ	ETF	436.84	436.97	436.7	436.86	46554.0
2024-04-05 07:30:00	QQQ	ETF	436.85	437.46	436.8	437.04	125454.0
2024-04-05 08:00:00	QQQ	ETF	436.88	437.48	435.014	437.2	207917.0
2024-04-05 08:30:00	QQQ	ETF	437.07	438.02	434.48	436.93	1330144.0
2024-04-05 09:00:00	QQQ	ETF	436.95	437.54	436.39	436.79	321722.0
2024-04-05 09:30:00	QQQ	ETF	436.78	439.0	435.96	438.47	4938395.0
2024-04-05 10:00:00	QQQ	ETF	438.47	439.55	437.71	438.36	3277246.0
2024-04-05 10:30:00	QQQ	ETF	438.38	440.9499	438.12	440.9101	2725938.0
2024-04-05 11:00:00	QQQ	ETF	440.92	441.21	439.06	440.2393	3481436.0
2024-04-05 11:30:00	QQQ	ETF	440.24	442.21	440.0	441.96	2584709.0
2024-04-05 12:00:00	QQQ	ETF	441.97	442.43	441.83	441.94	2479314.0
2024-04-05 12:30:00	QQQ	ETF	441.95	443.14	441.44	443.0101	2383284.0

> showing 50 of 31,811 rows — these rows as CSV

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