PREVIEW / etf_30min / 2023-11-13

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-11-13.parquet
  size:    733 KB
  rows:    28,894

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-11-13 04:00:00	SPY	ETF	439.4	439.88	439.4	439.88	13046.0
2023-11-13 04:30:00	SPY	ETF	439.8	439.91	439.67	439.91	2770.0
2023-11-13 05:00:00	SPY	ETF	439.82	439.82	439.54	439.73	7953.0
2023-11-13 05:30:00	SPY	ETF	439.79	440.14	439.77	440.13	17490.0
2023-11-13 06:00:00	SPY	ETF	440.15	440.15	439.76	439.9	5992.0
2023-11-13 06:30:00	SPY	ETF	439.77	440.03	439.69	440.01	16472.0
2023-11-13 07:00:00	SPY	ETF	440.01	440.09	439.63	439.64	43061.0
2023-11-13 07:30:00	SPY	ETF	439.71	439.93	439.65	439.86	40118.0
2023-11-13 08:00:00	SPY	ETF	439.93	440.1	438.6	440.1	98970.0
2023-11-13 08:30:00	SPY	ETF	440.12	440.23	439.13	439.27	244870.0
2023-11-13 09:00:00	SPY	ETF	439.3	439.38	439.08	439.22	122114.0
2023-11-13 09:30:00	SPY	ETF	439.22	439.59	438.42	438.865	5512891.0
2023-11-13 10:00:00	SPY	ETF	438.86	439.24	438.55	439.17	4237265.0
2023-11-13 10:30:00	SPY	ETF	439.17	439.945	439.03	439.72	3070517.0
2023-11-13 11:00:00	SPY	ETF	439.72	440.53	439.54	440.51	2967995.0
2023-11-13 11:30:00	SPY	ETF	440.5	441.33	440.33	440.99	3260341.0
2023-11-13 12:00:00	SPY	ETF	441.01	441.15	440.35	440.73	2106919.0
2023-11-13 12:30:00	SPY	ETF	440.76	440.79	440.19	440.5495	1599504.0
2023-11-13 13:00:00	SPY	ETF	440.54	440.7	440.09	440.14	2034783.0
2023-11-13 13:30:00	SPY	ETF	440.17	441.03	439.9	440.5299	1731349.0
2023-11-13 14:00:00	SPY	ETF	440.5216	440.94	440.3701	440.9299	1669620.0
2023-11-13 14:30:00	SPY	ETF	440.93	441.12	440.46	440.59	1817755.0
2023-11-13 15:00:00	SPY	ETF	440.59	440.94	440.28	440.75	1796243.0
2023-11-13 15:30:00	SPY	ETF	440.75	440.78	440.1	440.2	5001840.0
2023-11-13 16:00:00	SPY	ETF	440.2	440.7898	440.18	440.41	1574075.0
2023-11-13 16:30:00	SPY	ETF	440.41	440.48	440.4	440.47	249530.0
2023-11-13 17:00:00	SPY	ETF	440.4	440.49	440.19	440.39	42464.0
2023-11-13 17:30:00	SPY	ETF	440.37	440.41	440.37	440.4	5495.0
2023-11-13 18:00:00	SPY	ETF	440.39	440.43	440.31	440.33	15397.0
2023-11-13 18:30:00	SPY	ETF	440.38	440.45	440.38	440.38	1695.0
2023-11-13 19:00:00	SPY	ETF	440.38	440.49	440.25	440.3196	11388.0
2023-11-13 19:30:00	SPY	ETF	440.3	440.39	440.28	440.39	41237.0
2023-11-13 04:00:00	QQQ	ETF	377.14	377.34	376.92	377.15	37987.0
2023-11-13 04:30:00	QQQ	ETF	377.16	377.42	377.08	377.31	14330.0
2023-11-13 05:00:00	QQQ	ETF	377.27	377.32	377.08	377.32	7190.0
2023-11-13 05:30:00	QQQ	ETF	377.37	377.7	377.32	377.68	18683.0
2023-11-13 06:00:00	QQQ	ETF	377.67	377.7	377.38	377.56	12954.0
2023-11-13 06:30:00	QQQ	ETF	377.41	377.61	377.27	377.61	12108.0
2023-11-13 07:00:00	QQQ	ETF	377.62	377.69	377.35	377.4	52925.0
2023-11-13 07:30:00	QQQ	ETF	377.41	377.64	377.34	377.6	30893.0
2023-11-13 08:00:00	QQQ	ETF	377.7	378.673	376.43	377.68	85632.0
2023-11-13 08:30:00	QQQ	ETF	377.73	377.83	376.74	376.97	256453.0
2023-11-13 09:00:00	QQQ	ETF	376.98	377.08	376.77	376.8	224482.0
2023-11-13 09:30:00	QQQ	ETF	376.79	377.02	375.24	375.84	5721845.0
2023-11-13 10:00:00	QQQ	ETF	375.85	376.737	375.57	376.62	3870254.0
2023-11-13 10:30:00	QQQ	ETF	376.61	377.26	376.4601	376.95	2368802.0
2023-11-13 11:00:00	QQQ	ETF	376.95	377.765	376.86	377.75	2118969.0
2023-11-13 11:30:00	QQQ	ETF	377.75	378.28	377.49	377.8095	1941973.0
2023-11-13 12:00:00	QQQ	ETF	377.81	377.96	377.06	377.43	2060697.0
2023-11-13 12:30:00	QQQ	ETF	377.44	377.63	377.13	377.51	1235803.0

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

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