PREVIEW / etf_30min / 2023-09-28

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-09-28.parquet
  size:    713 KB
  rows:    28,366

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-09-28 04:00:00	SPY	ETF	426.28	426.36	425.62	425.65	27904.0
2023-09-28 04:30:00	SPY	ETF	425.78	426.3	425.6	425.89	9752.0
2023-09-28 05:00:00	SPY	ETF	425.88	425.88	424.95	425.32	38739.0
2023-09-28 05:30:00	SPY	ETF	425.31	426.56	425.14	426.56	17392.0
2023-09-28 06:00:00	SPY	ETF	426.52	426.82	426.13	426.28	42261.0
2023-09-28 06:30:00	SPY	ETF	426.34	426.73	426.19	426.5	58565.0
2023-09-28 07:00:00	SPY	ETF	426.5	426.5	425.89	425.95	182096.0
2023-09-28 07:30:00	SPY	ETF	425.92	425.92	425.3	425.87	248361.0
2023-09-28 08:00:00	SPY	ETF	425.87	427.03	425.1496	426.69	410382.0
2023-09-28 08:30:00	SPY	ETF	426.5	427.54	425.13	425.46	1101341.0
2023-09-28 09:00:00	SPY	ETF	425.42	426.16	425.26	425.48	743534.0
2023-09-28 09:30:00	SPY	ETF	425.48	426.77	424.87	426.7	6386593.0
2023-09-28 10:00:00	SPY	ETF	426.72	427.2599	425.95	426.39	5287816.0
2023-09-28 10:30:00	SPY	ETF	426.38	427.56	425.32	427.36	5496447.0
2023-09-28 11:00:00	SPY	ETF	427.35	428.31	426.97	428.305	5410391.0
2023-09-28 11:30:00	SPY	ETF	428.31	429.615	428.28	429.44	6839770.0
2023-09-28 12:00:00	SPY	ETF	429.44	430.23	428.99	430.13	4902799.0
2023-09-28 12:30:00	SPY	ETF	430.13	430.2499	428.57	428.92	4663969.0
2023-09-28 13:00:00	SPY	ETF	428.94	429.27	428.29	428.47	3421514.0
2023-09-28 13:30:00	SPY	ETF	428.47	428.51	427.66	428.155	3955876.0
2023-09-28 14:00:00	SPY	ETF	428.17	429.105	427.84	428.85	3205462.0
2023-09-28 14:30:00	SPY	ETF	428.87	428.91	427.47	428.385	3835127.0
2023-09-28 15:00:00	SPY	ETF	428.39	429.765	428.241	429.69	3699186.0
2023-09-28 15:30:00	SPY	ETF	429.695	429.76	427.97	428.53	10011327.0
2023-09-28 16:00:00	SPY	ETF	428.53	428.7995	427.205	428.68	1790334.0
2023-09-28 16:30:00	SPY	ETF	428.68	429.05	425.9452	428.92	829926.0
2023-09-28 17:00:00	SPY	ETF	428.99	428.99	428.53	428.67	60998.0
2023-09-28 17:30:00	SPY	ETF	428.67	428.75	428.6	428.75	79559.0
2023-09-28 18:00:00	SPY	ETF	428.75	429.31	428.75	429.09	210990.0
2023-09-28 18:30:00	SPY	ETF	429.08	429.13	428.99	429.02	26918.0
2023-09-28 19:00:00	SPY	ETF	429.04	429.06	428.81	428.82	25173.0
2023-09-28 19:30:00	SPY	ETF	428.85	428.85	428.61	428.67	34820.0
2023-09-28 04:00:00	QQQ	ETF	355.17	355.34	354.52	354.52	28368.0
2023-09-28 04:30:00	QQQ	ETF	354.6	355.13	354.53	354.65	14086.0
2023-09-28 05:00:00	QQQ	ETF	354.62	354.62	353.75	354.06	37984.0
2023-09-28 05:30:00	QQQ	ETF	354.2	355.18	353.98	355.18	51485.0
2023-09-28 06:00:00	QQQ	ETF	355.05	355.29	354.64	354.83	23902.0
2023-09-28 06:30:00	QQQ	ETF	354.87	355.17	354.65	354.97	80367.0
2023-09-28 07:00:00	QQQ	ETF	354.97	354.98	354.37	354.43	112537.0
2023-09-28 07:30:00	QQQ	ETF	354.44	354.44	353.83	354.27	134102.0
2023-09-28 08:00:00	QQQ	ETF	354.6	356.04	353.85	355.15	417608.0
2023-09-28 08:30:00	QQQ	ETF	355.0	356.08	353.72	353.98	1377793.0
2023-09-28 09:00:00	QQQ	ETF	354.19	354.7	353.83	354.08	521505.0
2023-09-28 09:30:00	QQQ	ETF	354.1	355.47	353.24	355.3	6476911.0
2023-09-28 10:00:00	QQQ	ETF	355.31	356.02	354.5873	354.88	3118245.0
2023-09-28 10:30:00	QQQ	ETF	354.89	356.37	353.79	356.21	3120449.0
2023-09-28 11:00:00	QQQ	ETF	356.2	357.31	355.62	357.31	3078364.0
2023-09-28 11:30:00	QQQ	ETF	357.32	359.32	357.28	359.2501	3845988.0
2023-09-28 12:00:00	QQQ	ETF	359.27	360.17	358.94	360.055	2865911.0
2023-09-28 12:30:00	QQQ	ETF	360.07	360.155	358.51	358.81	2580481.0

> showing 50 of 28,366 rows — these rows as CSV

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