PREVIEW / etf_30min / 2023-02-23

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-02-23.parquet
  size:    681 KB
  rows:    27,120

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-23 04:00:00	SPY	ETF	400.53	401.0	399.82	400.24	17260.0
2023-02-23 04:30:00	SPY	ETF	400.22	400.35	399.9	400.2	4512.0
2023-02-23 05:00:00	SPY	ETF	400.27	400.38	400.17	400.2	12938.0
2023-02-23 05:30:00	SPY	ETF	400.25	400.25	399.96	400.25	12721.0
2023-02-23 06:00:00	SPY	ETF	400.48	400.64	399.98	400.16	16296.0
2023-02-23 06:30:00	SPY	ETF	400.14	400.72	400.08	400.72	205364.0
2023-02-23 07:00:00	SPY	ETF	400.7	400.87	400.41	400.82	189915.0
2023-02-23 07:30:00	SPY	ETF	400.85	400.85	400.4	400.691	272555.0
2023-02-23 08:00:00	SPY	ETF	400.55	401.13	400.11	400.95	285646.0
2023-02-23 08:30:00	SPY	ETF	400.9	401.24	399.85	400.64	652159.0
2023-02-23 09:00:00	SPY	ETF	400.55	401.64	400.47	401.54	972932.0
2023-02-23 09:30:00	SPY	ETF	401.56	402.2	400.76	401.815	9636198.0
2023-02-23 10:00:00	SPY	ETF	401.82	402.18	400.51	401.04	4977953.0
2023-02-23 10:30:00	SPY	ETF	401.05	401.3	398.85	399.17	6303336.0
2023-02-23 11:00:00	SPY	ETF	399.16	399.65	397.75	397.96	6392434.0
2023-02-23 11:30:00	SPY	ETF	397.97	398.21	396.4	396.47	6204596.0
2023-02-23 12:00:00	SPY	ETF	396.47	397.195	396.25	396.835	4616757.0
2023-02-23 12:30:00	SPY	ETF	396.84	397.63	396.6017	397.57	3259533.0
2023-02-23 13:00:00	SPY	ETF	397.5899	398.0	397.03	397.66	2848257.0
2023-02-23 13:30:00	SPY	ETF	397.65	398.42	397.29	398.195	3570415.0
2023-02-23 14:00:00	SPY	ETF	398.19	400.03	397.89	399.87	5510951.0
2023-02-23 14:30:00	SPY	ETF	399.87	400.62	399.84	400.12	5474331.0
2023-02-23 15:00:00	SPY	ETF	400.12	401.45	400.115	401.3895	4996815.0
2023-02-23 15:30:00	SPY	ETF	401.39	401.62	400.41	400.65	9994163.0
2023-02-23 16:00:00	SPY	ETF	400.64	400.76	400.24	400.35	2872429.0
2023-02-23 16:30:00	SPY	ETF	400.34	400.66	400.27	400.32	168472.0
2023-02-23 17:00:00	SPY	ETF	400.36	400.55	400.35	400.5	94822.0
2023-02-23 17:30:00	SPY	ETF	400.51	400.51	400.42	400.43	12923.0
2023-02-23 18:00:00	SPY	ETF	400.42	400.42	399.95	399.98	79762.0
2023-02-23 18:30:00	SPY	ETF	400.05	400.15	399.96	400.0	67396.0
2023-02-23 19:00:00	SPY	ETF	400.0	400.48	399.89	400.46	177808.0
2023-02-23 19:30:00	SPY	ETF	400.4	400.65	400.35	400.57	31407.0
2023-02-23 04:00:00	QQQ	ETF	296.6	297.25	295.55	296.26	76472.0
2023-02-23 04:30:00	QQQ	ETF	296.17	296.37	295.89	296.16	10698.0
2023-02-23 05:00:00	QQQ	ETF	296.2	296.37	296.17	296.3	5139.0
2023-02-23 05:30:00	QQQ	ETF	296.15	296.43	296.14	296.43	11304.0
2023-02-23 06:00:00	QQQ	ETF	296.46	296.75	296.24	296.37	18953.0
2023-02-23 06:30:00	QQQ	ETF	296.28	296.92	296.28	296.78	92826.0
2023-02-23 07:00:00	QQQ	ETF	296.88	297.17	296.61	297.1	257220.0
2023-02-23 07:30:00	QQQ	ETF	297.11	297.18	296.81	297.06	92588.0
2023-02-23 08:00:00	QQQ	ETF	297.03	297.48	296.1996	297.2	273725.0
2023-02-23 08:30:00	QQQ	ETF	297.2	297.55	296.36	297.23	572963.0
2023-02-23 09:00:00	QQQ	ETF	297.21	298.15	297.2	297.92	588214.0
2023-02-23 09:30:00	QQQ	ETF	297.96	298.13	296.62	297.46	6991359.0
2023-02-23 10:00:00	QQQ	ETF	297.48	297.83	295.85	296.47	4613303.0
2023-02-23 10:30:00	QQQ	ETF	296.47	296.8	294.33	294.6006	4449526.0
2023-02-23 11:00:00	QQQ	ETF	294.57	295.1205	293.6	293.83	3616232.0
2023-02-23 11:30:00	QQQ	ETF	293.84	294.08	292.59	292.634	4150538.0
2023-02-23 12:00:00	QQQ	ETF	292.65	293.53	292.55	293.355	2861847.0
2023-02-23 12:30:00	QQQ	ETF	293.36	293.87	293.175	293.79	2312839.0

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

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