PREVIEW / etf_30min / 2024-04-23

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-04-23.parquet
  size:    795 KB
  rows:    31,698

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-23 04:00:00	SPY	ETF	499.8	500.73	499.8	500.65	11179.0
2024-04-23 04:30:00	SPY	ETF	500.52	500.56	500.0	500.07	29061.0
2024-04-23 05:00:00	SPY	ETF	500.05	500.5	500.05	500.5	3379.0
2024-04-23 05:30:00	SPY	ETF	500.26	500.26	499.85	499.85	8244.0
2024-04-23 06:00:00	SPY	ETF	500.0	500.8	500.0	500.7	8178.0
2024-04-23 06:30:00	SPY	ETF	500.73	501.24	500.73	501.24	34643.0
2024-04-23 07:00:00	SPY	ETF	501.24	501.43	500.8	500.95	162237.0
2024-04-23 07:30:00	SPY	ETF	500.99	501.0	500.51	500.6	53391.0
2024-04-23 08:00:00	SPY	ETF	501.27	501.45	499.22	500.66	141209.0
2024-04-23 08:30:00	SPY	ETF	500.7	501.55	500.7	501.41	125133.0
2024-04-23 09:00:00	SPY	ETF	501.33	501.92	501.26	501.77	179091.0
2024-04-23 09:30:00	SPY	ETF	501.79	503.69	501.225	503.07	5852664.0
2024-04-23 10:00:00	SPY	ETF	503.08	504.4	502.69	504.33	3854964.0
2024-04-23 10:30:00	SPY	ETF	504.33	505.33	504.26	505.21	4896933.0
2024-04-23 11:00:00	SPY	ETF	505.22	505.34	504.05	504.83	3186217.0
2024-04-23 11:30:00	SPY	ETF	504.83	505.02	504.26	504.33	2838188.0
2024-04-23 12:00:00	SPY	ETF	504.33	505.43	504.23	505.31	2536051.0
2024-04-23 12:30:00	SPY	ETF	505.31	505.6	504.93	505.19	2225487.0
2024-04-23 13:00:00	SPY	ETF	505.19	505.55	504.57	505.365	1912101.0
2024-04-23 13:30:00	SPY	ETF	505.38	506.065	505.14	505.98	2064240.0
2024-04-23 14:00:00	SPY	ETF	505.975	506.09	505.485	505.92	2277133.0
2024-04-23 14:30:00	SPY	ETF	505.93	506.07	505.25	505.73	2065003.0
2024-04-23 15:00:00	SPY	ETF	505.725	505.7889	504.96	505.36	2419442.0
2024-04-23 15:30:00	SPY	ETF	505.36	505.75	504.98	505.64	8297233.0
2024-04-23 16:00:00	SPY	ETF	505.63	506.08	505.19	506.02	2889847.0
2024-04-23 16:30:00	SPY	ETF	506.0	506.16	505.95	506.02	193639.0
2024-04-23 17:00:00	SPY	ETF	506.07	506.2	505.95	506.19	73368.0
2024-04-23 17:30:00	SPY	ETF	506.19	507.0	506.19	506.55	72635.0
2024-04-23 18:00:00	SPY	ETF	506.55	506.55	505.65	506.1	136163.0
2024-04-23 18:30:00	SPY	ETF	506.07	506.23	505.98	506.23	9239.0
2024-04-23 19:00:00	SPY	ETF	506.19	506.39	506.13	506.39	23797.0
2024-04-23 19:30:00	SPY	ETF	506.28	506.72	506.27	506.43	63161.0
2024-04-23 04:00:00	QQQ	ETF	419.26	420.06	418.52	419.9	47292.0
2024-04-23 04:30:00	QQQ	ETF	419.92	419.98	419.36	419.66	36038.0
2024-04-23 05:00:00	QQQ	ETF	419.62	420.18	419.62	420.16	18865.0
2024-04-23 05:30:00	QQQ	ETF	420.0	420.0	419.37	419.51	9128.0
2024-04-23 06:00:00	QQQ	ETF	419.48	420.12	419.41	420.02	27040.0
2024-04-23 06:30:00	QQQ	ETF	420.09	420.49	420.09	420.29	56924.0
2024-04-23 07:00:00	QQQ	ETF	420.39	420.81	420.15	420.16	84080.0
2024-04-23 07:30:00	QQQ	ETF	420.21	420.33	419.77	419.9	97830.0
2024-04-23 08:00:00	QQQ	ETF	419.99	420.78	418.19	419.721	273704.0
2024-04-23 08:30:00	QQQ	ETF	419.76	420.75	419.134	420.6	131206.0
2024-04-23 09:00:00	QQQ	ETF	420.6	420.98	420.4	420.8	178039.0
2024-04-23 09:30:00	QQQ	ETF	420.76	423.165	420.42	422.52	5424046.0
2024-04-23 10:00:00	QQQ	ETF	422.54	424.21	421.92	424.1	3510747.0
2024-04-23 10:30:00	QQQ	ETF	424.1	424.89	423.75	424.7201	2634108.0
2024-04-23 11:00:00	QQQ	ETF	424.73	425.08	423.51	424.6101	1935764.0
2024-04-23 11:30:00	QQQ	ETF	424.615	424.93	423.95	424.025	1356690.0
2024-04-23 12:00:00	QQQ	ETF	424.03	425.28	424.03	425.07	1520053.0
2024-04-23 12:30:00	QQQ	ETF	425.07	425.27	424.41	424.78	1288851.0

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

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