PREVIEW / etf_30min / 2023-02-24

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-02-24.parquet
  size:    682 KB
  rows:    27,435

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-24 04:00:00	SPY	ETF	399.8	399.93	399.58	399.65	10958.0
2023-02-24 04:30:00	SPY	ETF	399.63	399.67	399.41	399.42	34095.0
2023-02-24 05:00:00	SPY	ETF	399.37	399.63	399.21	399.37	17237.0
2023-02-24 05:30:00	SPY	ETF	399.26	399.29	398.97	399.18	8730.0
2023-02-24 06:00:00	SPY	ETF	399.1	399.1	398.41	398.52	25048.0
2023-02-24 06:30:00	SPY	ETF	398.47	398.6	398.07	398.25	50758.0
2023-02-24 07:00:00	SPY	ETF	398.27	398.34	397.98	398.23	56733.0
2023-02-24 07:30:00	SPY	ETF	398.16	398.31	397.95	398.05	106416.0
2023-02-24 08:00:00	SPY	ETF	398.09	400.48	397.55	397.6	495991.0
2023-02-24 08:30:00	SPY	ETF	397.6	397.8221	395.17	395.7	1231420.0
2023-02-24 09:00:00	SPY	ETF	395.67	395.89	395.05	395.43	653285.0
2023-02-24 09:30:00	SPY	ETF	395.41	396.47	394.16	394.49	9773314.0
2023-02-24 10:00:00	SPY	ETF	394.48	395.4	393.85	394.28	8720606.0
2023-02-24 10:30:00	SPY	ETF	394.29	394.78	393.64	394.1	5772344.0
2023-02-24 11:00:00	SPY	ETF	394.11	395.64	393.98	395.35	5039611.0
2023-02-24 11:30:00	SPY	ETF	395.37	396.6981	395.0	395.88	6492188.0
2023-02-24 12:00:00	SPY	ETF	395.88	396.11	395.245	395.556	3831032.0
2023-02-24 12:30:00	SPY	ETF	395.57	395.95	394.56	394.66	3467805.0
2023-02-24 13:00:00	SPY	ETF	394.66	395.3384	394.2914	395.12	3196591.0
2023-02-24 13:30:00	SPY	ETF	395.13	395.88	394.52	395.58	3639775.0
2023-02-24 14:00:00	SPY	ETF	395.59	396.208	395.37	395.77	4002548.0
2023-02-24 14:30:00	SPY	ETF	395.78	397.06	395.12	396.81	4065717.0
2023-02-24 15:00:00	SPY	ETF	396.79	397.25	396.275	396.42	4857386.0
2023-02-24 15:30:00	SPY	ETF	396.41	396.59	395.05	396.39	16901136.0
2023-02-24 16:00:00	SPY	ETF	396.4	398.0	396.08	396.38	3643466.0
2023-02-24 16:30:00	SPY	ETF	396.36	396.4	396.3	396.3	260807.0
2023-02-24 17:00:00	SPY	ETF	396.3	396.43	396.2846	396.35	41574.0
2023-02-24 17:30:00	SPY	ETF	396.33	396.35	396.33	396.34	2824.0
2023-02-24 18:00:00	SPY	ETF	396.31	396.35	396.31	396.35	1561.0
2023-02-24 18:30:00	SPY	ETF	396.35	396.38	396.25	396.38	6716.0
2023-02-24 19:00:00	SPY	ETF	396.31	396.31	396.3	396.3	1447.0
2023-02-24 19:30:00	SPY	ETF	396.31	396.34	396.0	396.2	26779.0
2023-02-24 04:00:00	QQQ	ETF	295.2	295.68	295.09	295.17	38447.0
2023-02-24 04:30:00	QQQ	ETF	295.1	295.2	294.9	294.91	21570.0
2023-02-24 05:00:00	QQQ	ETF	294.9	295.1	294.6	294.74	18820.0
2023-02-24 05:30:00	QQQ	ETF	294.72	294.86	294.55	294.77	14889.0
2023-02-24 06:00:00	QQQ	ETF	294.71	294.74	294.19	294.33	22486.0
2023-02-24 06:30:00	QQQ	ETF	294.3	294.38	293.9	294.28	102274.0
2023-02-24 07:00:00	QQQ	ETF	294.3	294.5	294.05	294.44	141887.0
2023-02-24 07:30:00	QQQ	ETF	294.34	294.5	294.19	294.25	79407.0
2023-02-24 08:00:00	QQQ	ETF	294.25	297.042	293.9196	294.15	399199.0
2023-02-24 08:30:00	QQQ	ETF	294.07	294.07	291.28	291.86	1601423.0
2023-02-24 09:00:00	QQQ	ETF	291.84	292.11	291.27	291.75	626785.0
2023-02-24 09:30:00	QQQ	ETF	291.76	292.97	290.82	291.31	9407059.0
2023-02-24 10:00:00	QQQ	ETF	291.28	291.73	290.3	290.91	6857725.0
2023-02-24 10:30:00	QQQ	ETF	290.91	291.02	290.05	290.35	4111088.0
2023-02-24 11:00:00	QQQ	ETF	290.36	291.57	290.06	291.25	3837322.0
2023-02-24 11:30:00	QQQ	ETF	291.27	292.34	290.72	291.67	4544650.0
2023-02-24 12:00:00	QQQ	ETF	291.68	291.85	290.96	291.22	2323689.0
2023-02-24 12:30:00	QQQ	ETF	291.25	291.5283	290.39	290.55	2273996.0

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

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