PREVIEW / etf_30min / 2023-11-03

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-11-03.parquet
  size:    742 KB
  rows:    29,850

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-03 04:00:00	SPY	ETF	430.35	430.35	430.09	430.1	27570.0
2023-11-03 04:30:00	SPY	ETF	430.1	430.34	430.08	430.22	7425.0
2023-11-03 05:00:00	SPY	ETF	430.15	430.15	429.84	429.95	10381.0
2023-11-03 05:30:00	SPY	ETF	429.97	430.26	429.93	430.25	12328.0
2023-11-03 06:00:00	SPY	ETF	430.23	430.35	430.12	430.12	12976.0
2023-11-03 06:30:00	SPY	ETF	430.16	430.19	430.04	430.15	51850.0
2023-11-03 07:00:00	SPY	ETF	430.01	430.3	429.9	430.3	59264.0
2023-11-03 07:30:00	SPY	ETF	430.25	430.55	430.17	430.55	48017.0
2023-11-03 08:00:00	SPY	ETF	430.55	430.8	429.9204	430.4	364183.0
2023-11-03 08:30:00	SPY	ETF	430.55	433.29	430.55	432.79	1790700.0
2023-11-03 09:00:00	SPY	ETF	432.79	433.52	432.45	433.11	945101.0
2023-11-03 09:30:00	SPY	ETF	433.11	435.0	433.01	434.64	8219150.0
2023-11-03 10:00:00	SPY	ETF	434.67	435.48	433.44	433.86	7241342.0
2023-11-03 10:30:00	SPY	ETF	433.87	434.2	433.21	434.155	6062965.0
2023-11-03 11:00:00	SPY	ETF	434.16	434.36	433.53	433.95	3100884.0
2023-11-03 11:30:00	SPY	ETF	433.99	435.2	433.99	434.975	3548709.0
2023-11-03 12:00:00	SPY	ETF	434.98	435.7302	434.86	435.555	3360296.0
2023-11-03 12:30:00	SPY	ETF	435.56	435.85	435.4	435.75	3440804.0
2023-11-03 13:00:00	SPY	ETF	435.74	435.9	434.841	435.1	3664942.0
2023-11-03 13:30:00	SPY	ETF	435.1	435.85	434.92	435.65	3229179.0
2023-11-03 14:00:00	SPY	ETF	435.645	435.75	435.01	435.73	2945892.0
2023-11-03 14:30:00	SPY	ETF	435.74	436.175	435.48	436.095	3475003.0
2023-11-03 15:00:00	SPY	ETF	436.1	436.29	435.32	435.47	4810755.0
2023-11-03 15:30:00	SPY	ETF	435.47	435.53	434.66	434.67	14063399.0
2023-11-03 16:00:00	SPY	ETF	434.67	435.12	434.0	435.12	3362507.0
2023-11-03 16:30:00	SPY	ETF	435.09	435.13	435.03	435.03	162006.0
2023-11-03 17:00:00	SPY	ETF	435.03	435.07	434.91	434.91	45069.0
2023-11-03 17:30:00	SPY	ETF	434.98	435.04	434.9303	434.95	20357.0
2023-11-03 18:00:00	SPY	ETF	434.96	435.14	434.95	435.1	11899.0
2023-11-03 18:30:00	SPY	ETF	435.05	435.1	435.05	435.05	1788.0
2023-11-03 19:00:00	SPY	ETF	435.05	435.27	435.05	435.27	4807.0
2023-11-03 19:30:00	SPY	ETF	435.21	435.29	434.9902	435.29	24543.0
2023-11-03 04:00:00	QQQ	ETF	362.2	362.32	362.05	362.08	50264.0
2023-11-03 04:30:00	QQQ	ETF	362.07	362.35	362.07	362.15	51696.0
2023-11-03 05:00:00	QQQ	ETF	362.14	362.16	361.91	361.98	20458.0
2023-11-03 05:30:00	QQQ	ETF	362.02	362.33	361.94	362.25	23882.0
2023-11-03 06:00:00	QQQ	ETF	362.25	362.36	362.2	362.2	7045.0
2023-11-03 06:30:00	QQQ	ETF	362.12	362.25	362.01	362.13	34963.0
2023-11-03 07:00:00	QQQ	ETF	362.14	362.32	361.87	362.32	48387.0
2023-11-03 07:30:00	QQQ	ETF	362.23	362.86	362.22	362.84	72094.0
2023-11-03 08:00:00	QQQ	ETF	362.11	362.86	361.88	362.48	266510.0
2023-11-03 08:30:00	QQQ	ETF	362.9	365.12	362.5	364.62	1657829.0
2023-11-03 09:00:00	QQQ	ETF	364.64	364.81	364.0	364.75	553913.0
2023-11-03 09:30:00	QQQ	ETF	364.75	366.885	364.52	366.54	6282957.0
2023-11-03 10:00:00	QQQ	ETF	366.55	367.4	364.78	365.35	4791892.0
2023-11-03 10:30:00	QQQ	ETF	365.36	366.2899	365.05	366.22	2931866.0
2023-11-03 11:00:00	QQQ	ETF	366.25	366.46	365.57	366.04	1938988.0
2023-11-03 11:30:00	QQQ	ETF	366.06	367.28	366.01	366.97	2616915.0
2023-11-03 12:00:00	QQQ	ETF	366.98	368.12	366.79	367.925	2565035.0
2023-11-03 12:30:00	QQQ	ETF	367.93	368.19	367.82	368.02	1946394.0

> showing 50 of 29,850 rows — these rows as CSV

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