PREVIEW / etf_30min / 2023-03-17

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-03-17.parquet
  size:    680 KB
  rows:    27,488

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-03-17 04:00:00	SPY	ETF	395.02	395.98	394.9	395.8	102072.0
2023-03-17 04:30:00	SPY	ETF	395.77	395.8	394.77	394.95	24681.0
2023-03-17 05:00:00	SPY	ETF	394.93	395.64	394.75	394.94	62244.0
2023-03-17 05:30:00	SPY	ETF	394.94	395.26	394.62	394.92	34311.0
2023-03-17 06:00:00	SPY	ETF	394.9	394.94	393.95	394.32	105192.0
2023-03-17 06:30:00	SPY	ETF	394.28	394.5	394.01	394.04	53551.0
2023-03-17 07:00:00	SPY	ETF	394.12	394.22	393.45	393.51	347824.0
2023-03-17 07:30:00	SPY	ETF	393.46	393.84	393.02	393.61	250041.0
2023-03-17 08:00:00	SPY	ETF	393.21	395.4204	391.61	391.9	766766.0
2023-03-17 08:30:00	SPY	ETF	391.89	392.43	390.83	391.45	891132.0
2023-03-17 09:00:00	SPY	ETF	391.47	393.24	391.47	393.2	895641.0
2023-03-17 09:30:00	SPY	ETF	393.22	394.17	392.24	392.8	11650927.0
2023-03-17 10:00:00	SPY	ETF	392.83	394.4	390.534	391.22	8550411.0
2023-03-17 10:30:00	SPY	ETF	391.2101	391.44	389.44	390.23	9383017.0
2023-03-17 11:00:00	SPY	ETF	390.23	390.985	389.01	389.55	5925416.0
2023-03-17 11:30:00	SPY	ETF	389.57	390.25	388.56	389.5799	5148746.0
2023-03-17 12:00:00	SPY	ETF	389.59	390.85	389.51	390.72	4584469.0
2023-03-17 12:30:00	SPY	ETF	390.73	391.78	389.9	390.37	4623531.0
2023-03-17 13:00:00	SPY	ETF	390.374	391.61	390.196	390.93	3699941.0
2023-03-17 13:30:00	SPY	ETF	390.91	391.47	390.21	391.0088	3258622.0
2023-03-17 14:00:00	SPY	ETF	391.03	391.46	388.89	389.07	4925160.0
2023-03-17 14:30:00	SPY	ETF	389.09	390.05	388.55	389.65	4999038.0
2023-03-17 15:00:00	SPY	ETF	389.64	390.87	389.2	390.754	6135267.0
2023-03-17 15:30:00	SPY	ETF	390.75	390.79	389.44	390.11	12224663.0
2023-03-17 16:00:00	SPY	ETF	390.12	390.83	389.99	390.25	5286612.0
2023-03-17 16:30:00	SPY	ETF	390.24	390.37	389.99	390.12	1793051.0
2023-03-17 17:00:00	SPY	ETF	390.18	391.0	389.91	391.0	407584.0
2023-03-17 17:30:00	SPY	ETF	391.0	391.2	389.99	391.07	949249.0
2023-03-17 18:00:00	SPY	ETF	391.15	391.3	389.99	391.3	178356.0
2023-03-17 18:30:00	SPY	ETF	391.22	391.22	389.99	390.98	210185.0
2023-03-17 19:00:00	SPY	ETF	390.98	391.19	390.86	390.86	31972.0
2023-03-17 19:30:00	SPY	ETF	390.87	391.1	390.24	391.1	22890.0
2023-03-17 04:00:00	QQQ	ETF	307.45	307.89	307.17	307.75	195844.0
2023-03-17 04:30:00	QQQ	ETF	307.75	307.82	306.98	307.14	82167.0
2023-03-17 05:00:00	QQQ	ETF	307.38	307.52	306.7	307.17	78529.0
2023-03-17 05:30:00	QQQ	ETF	307.07	307.35	306.88	307.2	16121.0
2023-03-17 06:00:00	QQQ	ETF	307.21	307.28	306.75	307.07	19534.0
2023-03-17 06:30:00	QQQ	ETF	307.13	307.34	307.02	307.02	22389.0
2023-03-17 07:00:00	QQQ	ETF	307.03	307.27	306.76	306.85	107547.0
2023-03-17 07:30:00	QQQ	ETF	306.82	307.41	306.5	307.33	139177.0
2023-03-17 08:00:00	QQQ	ETF	307.03	308.03	305.68	305.8	370116.0
2023-03-17 08:30:00	QQQ	ETF	305.81	306.3	305.52	305.91	565018.0
2023-03-17 09:00:00	QQQ	ETF	305.92	307.1	305.9	306.78	669007.0
2023-03-17 09:30:00	QQQ	ETF	306.72	308.03	306.31	307.6301	6636744.0
2023-03-17 10:00:00	QQQ	ETF	307.68	309.15	305.81	306.2	6338804.0
2023-03-17 10:30:00	QQQ	ETF	306.205	306.59	304.23	305.16	5379135.0
2023-03-17 11:00:00	QQQ	ETF	305.15	305.72	303.68	304.27	3505329.0
2023-03-17 11:30:00	QQQ	ETF	304.28	304.92	303.37	304.45	2603398.0
2023-03-17 12:00:00	QQQ	ETF	304.47	305.35	304.22	305.12	2652435.0
2023-03-17 12:30:00	QQQ	ETF	305.12	306.07	304.44	305.01	2717549.0

> showing 50 of 27,488 rows — these rows as CSV

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