PREVIEW / etf_30min / 2023-09-14

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-09-14.parquet
  size:    701 KB
  rows:    27,611

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-14 04:00:00	SPY	ETF	447.19	447.75	447.16	447.21	6024.0
2023-09-14 04:30:00	SPY	ETF	447.54	447.87	447.53	447.71	2166.0
2023-09-14 05:00:00	SPY	ETF	447.63	448.08	447.63	448.08	6285.0
2023-09-14 05:30:00	SPY	ETF	448.03	448.03	447.83	447.96	3290.0
2023-09-14 06:00:00	SPY	ETF	448.02	448.38	447.95	448.19	28251.0
2023-09-14 06:30:00	SPY	ETF	448.2	448.57	448.2	448.4	57011.0
2023-09-14 07:00:00	SPY	ETF	448.53	448.68	448.31	448.38	73492.0
2023-09-14 07:30:00	SPY	ETF	448.38	448.49	448.07	448.12	74118.0
2023-09-14 08:00:00	SPY	ETF	448.13	448.82	447.6	448.58	194851.0
2023-09-14 08:30:00	SPY	ETF	448.23	448.96	447.69	448.8	490198.0
2023-09-14 09:00:00	SPY	ETF	448.75	449.59	448.69	449.07	773298.0
2023-09-14 09:30:00	SPY	ETF	449.07	449.31	448.0696	448.915	6268699.0
2023-09-14 10:00:00	SPY	ETF	448.93	449.1	447.715	448.52	4434682.0
2023-09-14 10:30:00	SPY	ETF	448.53	449.6	448.485	449.488	4948399.0
2023-09-14 11:00:00	SPY	ETF	449.48	450.03	449.46	449.495	3942576.0
2023-09-14 11:30:00	SPY	ETF	449.5	449.93	449.03	449.895	3346412.0
2023-09-14 12:00:00	SPY	ETF	449.895	450.49	449.74	450.075	2995611.0
2023-09-14 12:30:00	SPY	ETF	450.07	450.68	449.97	450.63	2518694.0
2023-09-14 13:00:00	SPY	ETF	450.63	450.63	450.23	450.36	1929523.0
2023-09-14 13:30:00	SPY	ETF	450.37	450.66	450.14	450.15	2216617.0
2023-09-14 14:00:00	SPY	ETF	450.15	450.37	449.98	450.03	2328888.0
2023-09-14 14:30:00	SPY	ETF	450.03	450.62	449.925	450.575	2181154.0
2023-09-14 15:00:00	SPY	ETF	450.58	451.08	450.28	450.32	3760310.0
2023-09-14 15:30:00	SPY	ETF	450.31	450.65	450.1129	450.39	11884515.0
2023-09-14 16:00:00	SPY	ETF	450.395	450.9504	450.26	450.95	3216510.0
2023-09-14 16:30:00	SPY	ETF	450.96	451.05	450.341	450.7	590499.0
2023-09-14 17:00:00	SPY	ETF	450.66	450.8	450.36	450.72	412262.0
2023-09-14 17:30:00	SPY	ETF	450.74	450.75	450.64	450.64	11327.0
2023-09-14 18:00:00	SPY	ETF	450.64	450.74	450.57	450.6899	37680.0
2023-09-14 18:30:00	SPY	ETF	450.6704	450.74	450.65	450.68	5206.0
2023-09-14 19:00:00	SPY	ETF	450.64	450.79	450.6	450.79	8819.0
2023-09-14 19:30:00	SPY	ETF	450.79	450.87	450.64	450.67	28143.0
2023-09-14 04:00:00	QQQ	ETF	375.57	375.57	374.76	374.87	18558.0
2023-09-14 04:30:00	QQQ	ETF	374.99	375.72	374.99	375.52	11113.0
2023-09-14 05:00:00	QQQ	ETF	375.45	375.72	375.31	375.72	5328.0
2023-09-14 05:30:00	QQQ	ETF	375.7	375.7	375.26	375.4	7649.0
2023-09-14 06:00:00	QQQ	ETF	375.49	375.95	375.49	375.86	42678.0
2023-09-14 06:30:00	QQQ	ETF	375.82	376.14	375.81	375.93	11533.0
2023-09-14 07:00:00	QQQ	ETF	375.93	376.29	375.83	375.9	68366.0
2023-09-14 07:30:00	QQQ	ETF	375.9	376.0	375.55	375.72	39477.0
2023-09-14 08:00:00	QQQ	ETF	375.9104	376.37	374.49	376.09	141781.0
2023-09-14 08:30:00	QQQ	ETF	376.08	376.25	374.77	375.92	394699.0
2023-09-14 09:00:00	QQQ	ETF	376.0	376.63	375.72	375.97	310443.0
2023-09-14 09:30:00	QQQ	ETF	375.99	376.44	374.0	375.1	4499482.0
2023-09-14 10:00:00	QQQ	ETF	375.1	375.23	373.89	375.08	2738126.0
2023-09-14 10:30:00	QQQ	ETF	375.09	377.17	375.04	376.805	4072669.0
2023-09-14 11:00:00	QQQ	ETF	376.81	377.78	376.81	376.96	2543963.0
2023-09-14 11:30:00	QQQ	ETF	376.97	377.44	376.16	377.43	2189819.0
2023-09-14 12:00:00	QQQ	ETF	377.42	377.88	376.925	377.17	1762501.0
2023-09-14 12:30:00	QQQ	ETF	377.17	378.13	376.77	378.04	1982695.0

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

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