PREVIEW / etf_30min / 2024-04-18

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-04-18.parquet
  size:    785 KB
  rows:    31,316

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-18 04:00:00	SPY	ETF	502.68	502.7	501.82	502.17	10253.0
2024-04-18 04:30:00	SPY	ETF	502.22	502.29	501.89	501.99	2511.0
2024-04-18 05:00:00	SPY	ETF	502.04	502.19	501.17	501.17	5103.0
2024-04-18 05:30:00	SPY	ETF	501.18	501.81	501.1	501.81	13183.0
2024-04-18 06:00:00	SPY	ETF	501.7	502.01	501.42	501.97	9222.0
2024-04-18 06:30:00	SPY	ETF	502.11	502.33	501.99	502.04	32400.0
2024-04-18 07:00:00	SPY	ETF	501.99	502.38	501.4	502.0	168613.0
2024-04-18 07:30:00	SPY	ETF	502.04	502.52	502.031	502.24	103125.0
2024-04-18 08:00:00	SPY	ETF	502.19	502.86	501.13	501.39	165839.0
2024-04-18 08:30:00	SPY	ETF	501.39	502.0	501.04	501.58	205854.0
2024-04-18 09:00:00	SPY	ETF	501.7	502.32	501.52	501.98	307470.0
2024-04-18 09:30:00	SPY	ETF	501.98	502.08	499.73	501.18	5967531.0
2024-04-18 10:00:00	SPY	ETF	501.17	502.24	500.35	502.04	3781597.0
2024-04-18 10:30:00	SPY	ETF	502.03	503.82	501.99	503.39	3991162.0
2024-04-18 11:00:00	SPY	ETF	503.385	504.13	503.0701	503.21	3134529.0
2024-04-18 11:30:00	SPY	ETF	503.21	503.39	502.63	502.885	2182505.0
2024-04-18 12:00:00	SPY	ETF	502.88	503.34	502.22	502.6324	2116320.0
2024-04-18 12:30:00	SPY	ETF	502.62	502.65	500.62	500.79	2955150.0
2024-04-18 13:00:00	SPY	ETF	500.78	501.14	498.8701	500.2691	4306710.0
2024-04-18 13:30:00	SPY	ETF	500.27	500.32	498.94	499.62	3454101.0
2024-04-18 14:00:00	SPY	ETF	499.61	500.44	498.61	499.53	4003025.0
2024-04-18 14:30:00	SPY	ETF	499.55	499.68	498.56	498.96	3110923.0
2024-04-18 15:00:00	SPY	ETF	498.96	500.32	498.96	499.79	3675593.0
2024-04-18 15:30:00	SPY	ETF	499.8	500.83	499.21	499.48	7916671.0
2024-04-18 16:00:00	SPY	ETF	499.48	500.15	499.01	499.5595	2545464.0
2024-04-18 16:30:00	SPY	ETF	499.54	499.61	499.12	499.45	324535.0
2024-04-18 17:00:00	SPY	ETF	499.45	499.46	499.26	499.26	42928.0
2024-04-18 17:30:00	SPY	ETF	499.25	499.36	499.21	499.36	42461.0
2024-04-18 18:00:00	SPY	ETF	499.38	499.76	499.38	499.64	77039.0
2024-04-18 18:30:00	SPY	ETF	499.62	499.67	499.35	499.37	8095.0
2024-04-18 19:00:00	SPY	ETF	499.38	499.41	499.03	499.13	30463.0
2024-04-18 19:30:00	SPY	ETF	499.15	499.21	498.38	498.68	41064.0
2024-04-18 04:00:00	QQQ	ETF	428.31	428.7	427.5	427.81	43741.0
2024-04-18 04:30:00	QQQ	ETF	427.87	427.92	427.55	427.71	13367.0
2024-04-18 05:00:00	QQQ	ETF	427.66	427.89	426.65	426.82	25434.0
2024-04-18 05:30:00	QQQ	ETF	426.77	427.38	426.66	427.35	22545.0
2024-04-18 06:00:00	QQQ	ETF	427.29	427.45	426.83	427.34	38811.0
2024-04-18 06:30:00	QQQ	ETF	427.5	427.63	427.3	427.44	16972.0
2024-04-18 07:00:00	QQQ	ETF	427.38	427.71	427.07	427.32	79700.0
2024-04-18 07:30:00	QQQ	ETF	427.35	427.73	427.3	427.37	66251.0
2024-04-18 08:00:00	QQQ	ETF	428.23	428.9	426.7102	426.77	303968.0
2024-04-18 08:30:00	QQQ	ETF	426.9	427.26	426.29	426.61	295774.0
2024-04-18 09:00:00	QQQ	ETF	426.75	427.0104	426.4	426.48	159811.0
2024-04-18 09:30:00	QQQ	ETF	426.48	426.61	423.53	424.98	5916945.0
2024-04-18 10:00:00	QQQ	ETF	424.96	426.4	424.3	425.99	2797634.0
2024-04-18 10:30:00	QQQ	ETF	426.01	427.88	425.975	427.41	2385354.0
2024-04-18 11:00:00	QQQ	ETF	427.41	428.24	426.96	427.265	2117301.0
2024-04-18 11:30:00	QQQ	ETF	427.27	427.49	426.74	426.96	1554478.0
2024-04-18 12:00:00	QQQ	ETF	426.96	427.425	426.39	426.7794	1657938.0
2024-04-18 12:30:00	QQQ	ETF	426.78	426.84	424.78	424.965	1757428.0

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

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