PREVIEW / etf_30min / 2023-05-17

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-05-17.parquet
  size:    687 KB
  rows:    27,448

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-05-17 04:00:00	SPY	ETF	410.76	411.41	410.73	411.31	18198.0
2023-05-17 04:30:00	SPY	ETF	411.31	411.45	411.25	411.25	12005.0
2023-05-17 05:00:00	SPY	ETF	411.4	411.4	411.14	411.35	9677.0
2023-05-17 05:30:00	SPY	ETF	411.25	411.6	411.17	411.58	15369.0
2023-05-17 06:00:00	SPY	ETF	411.48	411.6	411.4	411.6	57743.0
2023-05-17 06:30:00	SPY	ETF	411.6	411.67	411.18	411.65	56931.0
2023-05-17 07:00:00	SPY	ETF	411.64	412.01	411.64	411.79	121977.0
2023-05-17 07:30:00	SPY	ETF	411.79	411.94	411.61	411.79	99591.0
2023-05-17 08:00:00	SPY	ETF	411.7005	411.95	410.3	411.6	203621.0
2023-05-17 08:30:00	SPY	ETF	411.58	412.18	411.14	412.16	159417.0
2023-05-17 09:00:00	SPY	ETF	412.18	412.46	410.25	412.37	395668.0
2023-05-17 09:30:00	SPY	ETF	412.35	412.41	410.635	410.78	5539700.0
2023-05-17 10:00:00	SPY	ETF	410.78	411.77	410.64	411.73	3531739.0
2023-05-17 10:30:00	SPY	ETF	411.73	411.93	411.53	411.88	2228635.0
2023-05-17 11:00:00	SPY	ETF	411.88	412.835	411.21	412.12	4976779.0
2023-05-17 11:30:00	SPY	ETF	412.12	412.76	411.93	412.59	3097518.0
2023-05-17 12:00:00	SPY	ETF	412.58	412.9	412.42	412.86	1966406.0
2023-05-17 12:30:00	SPY	ETF	412.86	414.66	412.86	414.43	5267961.0
2023-05-17 13:00:00	SPY	ETF	414.43	415.35	414.43	415.22	5636093.0
2023-05-17 13:30:00	SPY	ETF	415.22	415.855	415.145	415.75	4808386.0
2023-05-17 14:00:00	SPY	ETF	415.76	415.83	415.03	415.2099	3088346.0
2023-05-17 14:30:00	SPY	ETF	415.21	415.3209	414.51	414.57	3271328.0
2023-05-17 15:00:00	SPY	ETF	414.56	415.4174	414.45	414.6581	4464091.0
2023-05-17 15:30:00	SPY	ETF	414.65	415.51	414.47	415.21	11091656.0
2023-05-17 16:00:00	SPY	ETF	415.19	415.29	414.95	415.09	3265643.0
2023-05-17 16:30:00	SPY	ETF	415.09	415.23	415.0	415.07	164760.0
2023-05-17 17:00:00	SPY	ETF	414.95	415.3	414.95	415.21	57569.0
2023-05-17 17:30:00	SPY	ETF	415.21	415.22	415.17	415.18	86867.0
2023-05-17 18:00:00	SPY	ETF	415.18	415.18	414.78	415.0	202328.0
2023-05-17 18:30:00	SPY	ETF	414.99	415.03	414.8999	414.93	17410.0
2023-05-17 19:00:00	SPY	ETF	414.92	414.94	414.84	414.9	10444.0
2023-05-17 19:30:00	SPY	ETF	414.97	415.0	414.88	414.97	24778.0
2023-05-17 04:00:00	QQQ	ETF	327.33	327.96	327.31	327.8	21456.0
2023-05-17 04:30:00	QQQ	ETF	327.87	327.88	327.7	327.8	10651.0
2023-05-17 05:00:00	QQQ	ETF	327.8	327.8	327.54	327.69	5191.0
2023-05-17 05:30:00	QQQ	ETF	327.69	327.9	327.53	327.89	7585.0
2023-05-17 06:00:00	QQQ	ETF	327.88	327.88	327.6	327.66	4212.0
2023-05-17 06:30:00	QQQ	ETF	327.6	327.8	327.42	327.79	26681.0
2023-05-17 07:00:00	QQQ	ETF	327.79	328.1	327.78	327.95	72533.0
2023-05-17 07:30:00	QQQ	ETF	328.0	328.05	327.84	328.0	54477.0
2023-05-17 08:00:00	QQQ	ETF	327.8591	328.1018	326.915	327.68	118584.0
2023-05-17 08:30:00	QQQ	ETF	327.62	328.15	327.52	328.15	130377.0
2023-05-17 09:00:00	QQQ	ETF	328.14	328.25	327.89	328.25	278391.0
2023-05-17 09:30:00	QQQ	ETF	328.24	328.61	327.04	327.14	4791202.0
2023-05-17 10:00:00	QQQ	ETF	327.13	328.17	327.1	328.01	2271577.0
2023-05-17 10:30:00	QQQ	ETF	328.02	328.585	327.96	328.5	2147966.0
2023-05-17 11:00:00	QQQ	ETF	328.51	329.14	327.78	328.55	2775426.0
2023-05-17 11:30:00	QQQ	ETF	328.55	329.11	328.375	328.96	1688355.0
2023-05-17 12:00:00	QQQ	ETF	328.96	328.985	328.56	328.92	1017870.0
2023-05-17 12:30:00	QQQ	ETF	328.94	330.41	328.91	330.18	3398998.0

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

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