PREVIEW / etf_30min / 2023-08-25

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-08-25.parquet
  size:    676 KB
  rows:    27,029

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-08-25 04:00:00	SPY	ETF	437.48	438.24	437.48	438.02	23838.0
2023-08-25 04:30:00	SPY	ETF	438.06	438.16	437.71	437.99	6612.0
2023-08-25 05:00:00	SPY	ETF	438.03	438.13	437.69	438.13	4631.0
2023-08-25 05:30:00	SPY	ETF	437.82	437.98	437.46	437.46	5881.0
2023-08-25 06:00:00	SPY	ETF	437.65	438.26	437.65	438.15	45804.0
2023-08-25 06:30:00	SPY	ETF	438.19	438.3	438.09	438.2	5061.0
2023-08-25 07:00:00	SPY	ETF	438.2	438.3	438.0	438.04	69449.0
2023-08-25 07:30:00	SPY	ETF	438.07	438.16	437.82	438.14	62507.0
2023-08-25 08:00:00	SPY	ETF	438.1606	438.85	436.68	438.69	825174.0
2023-08-25 08:30:00	SPY	ETF	438.7	439.08	438.64	438.81	461940.0
2023-08-25 09:00:00	SPY	ETF	438.78	438.84	438.07	438.69	202837.0
2023-08-25 09:30:00	SPY	ETF	438.68	439.4999	438.53	439.09	4805551.0
2023-08-25 10:00:00	SPY	ETF	439.06	441.2	437.17	437.59	11402757.0
2023-08-25 10:30:00	SPY	ETF	437.59	437.88	435.14	435.25	7921521.0
2023-08-25 11:00:00	SPY	ETF	435.25	438.1	435.0	438.03	7384045.0
2023-08-25 11:30:00	SPY	ETF	438.045	438.7699	436.69	437.0	6023254.0
2023-08-25 12:00:00	SPY	ETF	437.0	438.84	436.94	438.83	3924013.0
2023-08-25 12:30:00	SPY	ETF	438.84	439.1	437.93	438.67	3798104.0
2023-08-25 13:00:00	SPY	ETF	438.672	439.1	437.62	438.11	3971516.0
2023-08-25 13:30:00	SPY	ETF	438.14	438.6	437.37	438.5696	3062526.0
2023-08-25 14:00:00	SPY	ETF	438.565	440.43	438.43	440.3785	4494225.0
2023-08-25 14:30:00	SPY	ETF	440.38	440.88	439.77	440.78	4245222.0
2023-08-25 15:00:00	SPY	ETF	440.79	441.3	440.31	440.93	4331332.0
2023-08-25 15:30:00	SPY	ETF	440.93	441.17	439.53	439.95	12738302.0
2023-08-25 16:00:00	SPY	ETF	439.94	440.27	439.0	439.98	3028421.0
2023-08-25 16:30:00	SPY	ETF	439.98	440.06	439.71	439.81	172646.0
2023-08-25 17:00:00	SPY	ETF	439.72	439.99	439.72	439.99	77134.0
2023-08-25 17:30:00	SPY	ETF	439.97	439.97	439.89	439.92	12534.0
2023-08-25 18:00:00	SPY	ETF	439.92	439.92	439.65	439.7	17846.0
2023-08-25 18:30:00	SPY	ETF	439.7	439.8	439.7	439.8	300.0
2023-08-25 19:00:00	SPY	ETF	439.78	439.85	439.73	439.85	2343.0
2023-08-25 19:30:00	SPY	ETF	439.82	439.89	439.8	439.85	6696.0
2023-08-25 04:00:00	QQQ	ETF	360.73	361.86	360.72	361.68	60963.0
2023-08-25 04:30:00	QQQ	ETF	361.67	361.79	361.28	361.57	16313.0
2023-08-25 05:00:00	QQQ	ETF	361.44	361.59	361.21	361.59	28176.0
2023-08-25 05:30:00	QQQ	ETF	361.64	361.66	361.0	361.1	11696.0
2023-08-25 06:00:00	QQQ	ETF	361.22	361.83	361.14	361.7	21908.0
2023-08-25 06:30:00	QQQ	ETF	361.63	361.83	361.5	361.7	26464.0
2023-08-25 07:00:00	QQQ	ETF	361.61	361.78	361.25	361.33	162825.0
2023-08-25 07:30:00	QQQ	ETF	361.36	361.64	361.1	361.62	65210.0
2023-08-25 08:00:00	QQQ	ETF	361.69	362.25	359.4	362.15	205016.0
2023-08-25 08:30:00	QQQ	ETF	362.1901	362.6	362.0101	362.1201	167041.0
2023-08-25 09:00:00	QQQ	ETF	362.13	362.16	361.66	362.06	121464.0
2023-08-25 09:30:00	QQQ	ETF	362.07	363.495	361.98	363.32	5460774.0
2023-08-25 10:00:00	QQQ	ETF	363.31	365.74	361.45	361.8528	9406495.0
2023-08-25 10:30:00	QQQ	ETF	361.86	362.33	358.63	358.73	6179240.0
2023-08-25 11:00:00	QQQ	ETF	358.75	361.27	358.58	361.2	4423935.0
2023-08-25 11:30:00	QQQ	ETF	361.191	361.94	359.59	359.9	3820150.0
2023-08-25 12:00:00	QQQ	ETF	359.85	361.72	359.8	361.7	2725983.0
2023-08-25 12:30:00	QQQ	ETF	361.71	362.11	360.94	361.75	2602240.0

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

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