PREVIEW / etf_30min / 2023-09-26

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-09-26.parquet
  size:    715 KB
  rows:    28,203

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-26 04:00:00	SPY	ETF	430.21	430.82	429.77	430.62	30434.0
2023-09-26 04:30:00	SPY	ETF	430.51	430.52	430.15	430.3	8196.0
2023-09-26 05:00:00	SPY	ETF	430.31	430.32	429.8	430.08	17549.0
2023-09-26 05:30:00	SPY	ETF	430.33	430.5	429.72	429.73	20023.0
2023-09-26 06:00:00	SPY	ETF	429.87	430.19	429.87	430.15	70868.0
2023-09-26 06:30:00	SPY	ETF	430.16	430.58	430.09	430.58	16014.0
2023-09-26 07:00:00	SPY	ETF	430.56	430.71	429.87	430.66	60624.0
2023-09-26 07:30:00	SPY	ETF	430.62	430.91	430.38	430.56	114401.0
2023-09-26 08:00:00	SPY	ETF	430.58	431.03	428.91	430.43	213928.0
2023-09-26 08:30:00	SPY	ETF	430.44	430.44	429.08	429.67	261267.0
2023-09-26 09:00:00	SPY	ETF	429.62	429.69	429.03	429.09	383406.0
2023-09-26 09:30:00	SPY	ETF	429.09	429.82	428.53	428.7	6847330.0
2023-09-26 10:00:00	SPY	ETF	428.69	428.94	426.9917	427.93	8081643.0
2023-09-26 10:30:00	SPY	ETF	427.93	428.71	427.55	428.025	5435626.0
2023-09-26 11:00:00	SPY	ETF	428.01	428.24	426.76	426.78	3942006.0
2023-09-26 11:30:00	SPY	ETF	426.78	427.43	426.63	427.1	4802942.0
2023-09-26 12:00:00	SPY	ETF	427.11	427.77	426.87	427.64	3308831.0
2023-09-26 12:30:00	SPY	ETF	427.62	427.965	427.43	427.56	2411810.0
2023-09-26 13:00:00	SPY	ETF	427.57	427.98	426.97	426.98	3260083.0
2023-09-26 13:30:00	SPY	ETF	426.97	427.2	426.01	426.71	4608932.0
2023-09-26 14:00:00	SPY	ETF	426.73	426.74	425.8	425.9043	3979413.0
2023-09-26 14:30:00	SPY	ETF	425.9	426.18	425.47	425.82	3901700.0
2023-09-26 15:00:00	SPY	ETF	425.815	426.04	425.02	425.24	5583789.0
2023-09-26 15:30:00	SPY	ETF	425.24	426.04	425.08	425.83	12270763.0
2023-09-26 16:00:00	SPY	ETF	425.83	429.5678	425.7864	426.45	4513758.0
2023-09-26 16:30:00	SPY	ETF	426.41	426.439	426.36	426.42	110215.0
2023-09-26 17:00:00	SPY	ETF	426.44	426.57	426.38	426.43	32894.0
2023-09-26 17:30:00	SPY	ETF	426.45	426.51	426.43	426.51	24836.0
2023-09-26 18:00:00	SPY	ETF	426.54	426.6	426.21	426.32	57427.0
2023-09-26 18:30:00	SPY	ETF	426.33	426.4	426.18	426.25	31973.0
2023-09-26 19:00:00	SPY	ETF	426.25	426.55	426.25	426.46	13699.0
2023-09-26 19:30:00	SPY	ETF	426.48	426.61	426.37	426.55	30425.0
2023-09-26 04:00:00	QQQ	ETF	357.58	358.49	357.5	358.14	60792.0
2023-09-26 04:30:00	QQQ	ETF	358.11	358.11	357.63	357.86	43958.0
2023-09-26 05:00:00	QQQ	ETF	357.86	357.86	357.36	357.64	32938.0
2023-09-26 05:30:00	QQQ	ETF	357.8	358.03	357.3	357.36	11371.0
2023-09-26 06:00:00	QQQ	ETF	357.45	357.92	357.42	357.79	20554.0
2023-09-26 06:30:00	QQQ	ETF	357.81	358.15	357.73	358.15	12596.0
2023-09-26 07:00:00	QQQ	ETF	358.11	358.3	357.45	358.26	45058.0
2023-09-26 07:30:00	QQQ	ETF	358.24	358.52	358.02	358.19	128447.0
2023-09-26 08:00:00	QQQ	ETF	358.3	359.879	356.53	358.09	134608.0
2023-09-26 08:30:00	QQQ	ETF	357.96	357.97	357.34	357.48	213012.0
2023-09-26 09:00:00	QQQ	ETF	357.5	357.5	356.9	357.05	271518.0
2023-09-26 09:30:00	QQQ	ETF	356.99	357.54	355.5739	355.7499	5229506.0
2023-09-26 10:00:00	QQQ	ETF	355.72	356.12	354.63	355.62	5439065.0
2023-09-26 10:30:00	QQQ	ETF	355.62	356.58	355.37	355.69	3539908.0
2023-09-26 11:00:00	QQQ	ETF	355.69	355.89	354.7	354.72	2246566.0
2023-09-26 11:30:00	QQQ	ETF	354.72	355.6	354.63	354.94	2494372.0
2023-09-26 12:00:00	QQQ	ETF	354.95	355.77	354.59	355.64	1781672.0
2023-09-26 12:30:00	QQQ	ETF	355.6305	355.99	355.44	355.53	1608044.0

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

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