PREVIEW / etf_30min / 2023-02-28

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-02-28.parquet
  size:    685 KB
  rows:    26,829

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-02-28 04:00:00	SPY	ETF	397.1	397.42	396.8	396.86	26218.0
2023-02-28 04:30:00	SPY	ETF	396.84	397.32	396.8	397.32	11528.0
2023-02-28 05:00:00	SPY	ETF	397.31	397.7	397.28	397.67	18749.0
2023-02-28 05:30:00	SPY	ETF	397.72	398.19	397.72	398.11	12016.0
2023-02-28 06:00:00	SPY	ETF	398.24	398.41	398.09	398.24	25480.0
2023-02-28 06:30:00	SPY	ETF	398.28	398.94	398.03	398.65	85995.0
2023-02-28 07:00:00	SPY	ETF	398.7	399.29	398.56	399.29	75750.0
2023-02-28 07:30:00	SPY	ETF	399.28	399.3	398.85	399.07	54823.0
2023-02-28 08:00:00	SPY	ETF	398.76	399.29	396.5	398.63	310250.0
2023-02-28 08:30:00	SPY	ETF	398.64	398.68	397.85	398.51	305915.0
2023-02-28 09:00:00	SPY	ETF	398.48	398.54	397.19	397.23	303676.0
2023-02-28 09:30:00	SPY	ETF	397.23	398.03	396.45	397.34	6655184.0
2023-02-28 10:00:00	SPY	ETF	397.35	398.29	396.89	397.18	5424222.0
2023-02-28 10:30:00	SPY	ETF	397.21	397.72	396.59	397.3293	3713565.0
2023-02-28 11:00:00	SPY	ETF	397.32	398.4	397.32	397.89	3933125.0
2023-02-28 11:30:00	SPY	ETF	397.89	398.045	397.15	397.41	2826780.0
2023-02-28 12:00:00	SPY	ETF	397.41	398.54	397.41	398.34	2640995.0
2023-02-28 12:30:00	SPY	ETF	398.34	399.044	397.92	398.83	2887503.0
2023-02-28 13:00:00	SPY	ETF	398.8299	399.195	398.66	399.014	2506443.0
2023-02-28 13:30:00	SPY	ETF	399.02	399.28	398.65	398.94	2362921.0
2023-02-28 14:00:00	SPY	ETF	398.955	399.22	398.29	398.3306	3301325.0
2023-02-28 14:30:00	SPY	ETF	398.345	398.62	397.69	397.8076	4327269.0
2023-02-28 15:00:00	SPY	ETF	397.805	397.83	397.0	397.0707	5959493.0
2023-02-28 15:30:00	SPY	ETF	397.075	397.415	396.18	396.2	14900862.0
2023-02-28 16:00:00	SPY	ETF	396.19	397.6441	395.5	395.78	6895949.0
2023-02-28 16:30:00	SPY	ETF	395.83	396.06	395.68	395.89	265438.0
2023-02-28 17:00:00	SPY	ETF	395.87	395.98	395.87	395.93	26699.0
2023-02-28 17:30:00	SPY	ETF	395.93	395.97	395.78	395.8	81811.0
2023-02-28 18:00:00	SPY	ETF	395.8	396.009	395.5	395.5	48581.0
2023-02-28 18:30:00	SPY	ETF	395.52	395.6	395.19	395.3	44534.0
2023-02-28 19:00:00	SPY	ETF	395.36	395.36	394.79	394.79	106178.0
2023-02-28 19:30:00	SPY	ETF	394.78	394.99	394.77	394.82	74417.0
2023-02-28 04:00:00	QQQ	ETF	293.33	293.73	293.17	293.19	19416.0
2023-02-28 04:30:00	QQQ	ETF	293.15	293.49	293.12	293.42	15283.0
2023-02-28 05:00:00	QQQ	ETF	293.4	293.88	293.4	293.88	21789.0
2023-02-28 05:30:00	QQQ	ETF	293.83	294.24	293.83	294.2	28274.0
2023-02-28 06:00:00	QQQ	ETF	294.15	294.47	294.15	294.38	10016.0
2023-02-28 06:30:00	QQQ	ETF	294.22	294.96	294.17	294.71	54083.0
2023-02-28 07:00:00	QQQ	ETF	294.74	295.451	294.65	295.43	143160.0
2023-02-28 07:30:00	QQQ	ETF	295.39	295.41	294.95	295.26	90738.0
2023-02-28 08:00:00	QQQ	ETF	294.73	295.4	292.92	294.46	236823.0
2023-02-28 08:30:00	QQQ	ETF	294.51	294.54	293.79	294.3	331966.0
2023-02-28 09:00:00	QQQ	ETF	294.3	294.4	293.26	293.26	337905.0
2023-02-28 09:30:00	QQQ	ETF	293.3	294.68	292.96	294.208	4721755.0
2023-02-28 10:00:00	QQQ	ETF	294.21	294.96	293.46	293.64	3570160.0
2023-02-28 10:30:00	QQQ	ETF	293.66	294.25	293.07	293.77	2750035.0
2023-02-28 11:00:00	QQQ	ETF	293.81	294.755	293.78	294.31	2444871.0
2023-02-28 11:30:00	QQQ	ETF	294.31	294.39	293.61	294.07	1961710.0
2023-02-28 12:00:00	QQQ	ETF	294.09	295.07	294.09	294.87	1754501.0
2023-02-28 12:30:00	QQQ	ETF	294.88	295.62	294.55	295.42	2106917.0

> showing 50 of 26,829 rows — these rows as CSV

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