PREVIEW / etf_30min / 2023-11-30

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-11-30.parquet
  size:    752 KB
  rows:    30,051

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-30 04:00:00	SPY	ETF	455.09	455.55	455.04	455.54	10203.0
2023-11-30 04:30:00	SPY	ETF	455.57	455.59	455.28	455.44	9391.0
2023-11-30 05:00:00	SPY	ETF	455.5	455.67	455.42	455.67	3675.0
2023-11-30 05:30:00	SPY	ETF	455.61	455.87	455.61	455.8	8115.0
2023-11-30 06:00:00	SPY	ETF	455.75	455.78	455.54	455.65	11495.0
2023-11-30 06:30:00	SPY	ETF	455.72	455.72	455.54	455.56	11477.0
2023-11-30 07:00:00	SPY	ETF	455.51	455.97	455.5	455.96	76934.0
2023-11-30 07:30:00	SPY	ETF	455.92	456.15	455.92	456.11	40800.0
2023-11-30 08:00:00	SPY	ETF	455.98	456.35	454.85	456.3	187040.0
2023-11-30 08:30:00	SPY	ETF	456.1	456.65	455.81	455.8899	264450.0
2023-11-30 09:00:00	SPY	ETF	455.88	455.88	455.39	455.48	266588.0
2023-11-30 09:30:00	SPY	ETF	455.49	455.71	454.14	455.2	5649926.0
2023-11-30 10:00:00	SPY	ETF	455.2	455.6	454.27	454.8	3873893.0
2023-11-30 10:30:00	SPY	ETF	454.81	455.34	454.01	454.93	3973140.0
2023-11-30 11:00:00	SPY	ETF	454.92	455.18	454.26	454.4	3039506.0
2023-11-30 11:30:00	SPY	ETF	454.41	454.51	453.78	453.81	2851861.0
2023-11-30 12:00:00	SPY	ETF	453.82	454.4	453.5	453.5701	2595969.0
2023-11-30 12:30:00	SPY	ETF	453.57	454.32	453.48	454.1198	1940584.0
2023-11-30 13:00:00	SPY	ETF	454.11	454.145	453.62	453.63	1586308.0
2023-11-30 13:30:00	SPY	ETF	453.6499	454.05	453.34	453.924	1778983.0
2023-11-30 14:00:00	SPY	ETF	453.92	454.55	453.89	454.358	2330321.0
2023-11-30 14:30:00	SPY	ETF	454.36	455.15	454.15	455.1	2846137.0
2023-11-30 15:00:00	SPY	ETF	455.1	455.135	453.84	454.11	3182106.0
2023-11-30 15:30:00	SPY	ETF	454.11	456.76	454.045	456.31	18803643.0
2023-11-30 16:00:00	SPY	ETF	456.31	456.5	454.0131	456.27	5674497.0
2023-11-30 16:30:00	SPY	ETF	456.25	456.4	455.99	456.06	279059.0
2023-11-30 17:00:00	SPY	ETF	456.06	456.11	455.9	456.08	91744.0
2023-11-30 17:30:00	SPY	ETF	456.11	456.11	455.89	456.02	25268.0
2023-11-30 18:00:00	SPY	ETF	455.95	456.17	455.92	456.15	42531.0
2023-11-30 18:30:00	SPY	ETF	456.12	456.16	456.09	456.09	17524.0
2023-11-30 19:00:00	SPY	ETF	456.1	456.19	456.03	456.19	4264.0
2023-11-30 19:30:00	SPY	ETF	456.17	456.18	456.02	456.18	21968.0
2023-11-30 04:00:00	QQQ	ETF	390.21	390.73	390.21	390.73	14382.0
2023-11-30 04:30:00	QQQ	ETF	390.67	390.67	390.37	390.41	2973.0
2023-11-30 05:00:00	QQQ	ETF	390.57	390.72	390.48	390.72	15978.0
2023-11-30 05:30:00	QQQ	ETF	390.72	390.93	390.7	390.85	30663.0
2023-11-30 06:00:00	QQQ	ETF	390.71	390.83	390.67	390.8	2694.0
2023-11-30 06:30:00	QQQ	ETF	390.75	390.77	390.6	390.6	18600.0
2023-11-30 07:00:00	QQQ	ETF	390.57	391.04	390.57	391.04	53328.0
2023-11-30 07:30:00	QQQ	ETF	391.05	391.2	391.0	391.12	26080.0
2023-11-30 08:00:00	QQQ	ETF	390.64	391.31	390.102	391.2801	108153.0
2023-11-30 08:30:00	QQQ	ETF	391.35	391.82	390.5	390.52	312344.0
2023-11-30 09:00:00	QQQ	ETF	390.52	390.54	389.97	390.06	373928.0
2023-11-30 09:30:00	QQQ	ETF	390.1	390.55	388.01	388.75	4536149.0
2023-11-30 10:00:00	QQQ	ETF	388.75	389.3	387.37	388.07	4056772.0
2023-11-30 10:30:00	QQQ	ETF	388.09	388.49	386.46	387.37	2950321.0
2023-11-30 11:00:00	QQQ	ETF	387.365	387.63	386.68	386.76	1846791.0
2023-11-30 11:30:00	QQQ	ETF	386.76	386.87	386.05	386.07	1913748.0
2023-11-30 12:00:00	QQQ	ETF	386.08	386.8578	385.93	386.35	1488505.0
2023-11-30 12:30:00	QQQ	ETF	386.33	387.175	386.29	387.01	1265524.0

> showing 50 of 30,051 rows — these rows as CSV

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