PREVIEW / etf_30min / 2023-11-27

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-11-27.parquet
  size:    734 KB
  rows:    29,339

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-27 04:00:00	SPY	ETF	454.62	454.71	454.29	454.35	13515.0
2023-11-27 04:30:00	SPY	ETF	454.23	454.23	454.0	454.0	3103.0
2023-11-27 05:00:00	SPY	ETF	454.07	454.7	454.07	454.7	5828.0
2023-11-27 05:30:00	SPY	ETF	454.65	454.96	454.53	454.96	10017.0
2023-11-27 06:00:00	SPY	ETF	454.91	455.0	454.79	454.79	6615.0
2023-11-27 06:30:00	SPY	ETF	454.74	454.79	454.61	454.61	2053.0
2023-11-27 07:00:00	SPY	ETF	454.67	454.93	454.6	454.6	18496.0
2023-11-27 07:30:00	SPY	ETF	454.8	454.8	454.56	454.62	17341.0
2023-11-27 08:00:00	SPY	ETF	454.6817	454.98	453.77	454.95	104017.0
2023-11-27 08:30:00	SPY	ETF	454.95	455.3	454.52	454.6	144363.0
2023-11-27 09:00:00	SPY	ETF	454.71	454.78	454.23	454.62	279036.0
2023-11-27 09:30:00	SPY	ETF	454.65	455.245	454.0799	454.5169	4137964.0
2023-11-27 10:00:00	SPY	ETF	454.52	455.21	454.25	454.61	3269310.0
2023-11-27 10:30:00	SPY	ETF	454.63	455.0704	454.55	454.79	2670442.0
2023-11-27 11:00:00	SPY	ETF	454.8	454.8699	454.2309	454.8699	2376991.0
2023-11-27 11:30:00	SPY	ETF	454.86	455.39	454.571	455.0388	1913297.0
2023-11-27 12:00:00	SPY	ETF	455.04	455.25	454.79	454.95	1734708.0
2023-11-27 12:30:00	SPY	ETF	454.96	455.25	454.895	455.17	1510040.0
2023-11-27 13:00:00	SPY	ETF	455.18	455.4901	454.99	455.24	1801469.0
2023-11-27 13:30:00	SPY	ETF	455.24	455.37	454.955	455.135	1602390.0
2023-11-27 14:00:00	SPY	ETF	455.14	455.29	454.89	454.995	1672856.0
2023-11-27 14:30:00	SPY	ETF	455.0	455.03	454.11	454.655	2503275.0
2023-11-27 15:00:00	SPY	ETF	454.65	454.98	454.47	454.965	1872284.0
2023-11-27 15:30:00	SPY	ETF	454.965	455.31	454.37	454.5	7766631.0
2023-11-27 16:00:00	SPY	ETF	454.49	454.65	454.3	454.62	1682364.0
2023-11-27 16:30:00	SPY	ETF	454.58	454.67	454.57	454.66	77381.0
2023-11-27 17:00:00	SPY	ETF	454.65	454.68	454.63	454.67	19339.0
2023-11-27 17:30:00	SPY	ETF	454.67	454.74	454.67	454.67	13505.0
2023-11-27 18:00:00	SPY	ETF	454.69	454.81	454.67	454.79	27747.0
2023-11-27 18:30:00	SPY	ETF	454.78	454.88	454.76	454.85	11172.0
2023-11-27 19:00:00	SPY	ETF	454.85	454.85	454.5	454.52	23018.0
2023-11-27 19:30:00	SPY	ETF	454.53	454.75	454.53	454.6999	18414.0
2023-11-27 04:00:00	QQQ	ETF	388.02	388.98	388.02	388.79	21924.0
2023-11-27 04:30:00	QQQ	ETF	388.75	388.82	388.37	388.38	8970.0
2023-11-27 05:00:00	QQQ	ETF	388.44	388.98	388.44	388.98	22334.0
2023-11-27 05:30:00	QQQ	ETF	389.0	389.26	388.9	389.23	11954.0
2023-11-27 06:00:00	QQQ	ETF	389.23	389.25	389.05	389.05	4332.0
2023-11-27 06:30:00	QQQ	ETF	389.1	389.19	388.96	389.04	24959.0
2023-11-27 07:00:00	QQQ	ETF	389.04	389.42	389.04	389.13	19615.0
2023-11-27 07:30:00	QQQ	ETF	389.14	389.24	388.989	389.1	16937.0
2023-11-27 08:00:00	QQQ	ETF	387.25	389.802	387.25	389.5	68346.0
2023-11-27 08:30:00	QQQ	ETF	389.51	389.51	388.95	389.0	119466.0
2023-11-27 09:00:00	QQQ	ETF	389.07	389.12	388.45	388.99	150634.0
2023-11-27 09:30:00	QQQ	ETF	389.0	389.912	388.28	389.21	4042283.0
2023-11-27 10:00:00	QQQ	ETF	389.22	390.2	388.98	389.355	2766809.0
2023-11-27 10:30:00	QQQ	ETF	389.37	390.245	389.37	389.995	2129878.0
2023-11-27 11:00:00	QQQ	ETF	390.0	390.0	389.16	389.685	1359851.0
2023-11-27 11:30:00	QQQ	ETF	389.68	390.575	389.51	390.32	1775500.0
2023-11-27 12:00:00	QQQ	ETF	390.34	390.64	390.1603	390.45	1383386.0
2023-11-27 12:30:00	QQQ	ETF	390.455	390.82	390.336	390.745	1174672.0

> showing 50 of 29,339 rows — these rows as CSV

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