PREVIEW / etf_30min / 2023-08-31

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-08-31.parquet
  size:    705 KB
  rows:    27,578

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-08-31 04:00:00	SPY	ETF	451.93	451.97	451.42	451.79	12000.0
2023-08-31 04:30:00	SPY	ETF	451.8	451.86	451.67	451.86	7140.0
2023-08-31 05:00:00	SPY	ETF	451.93	451.93	451.22	451.46	18997.0
2023-08-31 05:30:00	SPY	ETF	451.49	451.54	451.23	451.32	2240.0
2023-08-31 06:00:00	SPY	ETF	451.47	451.71	451.46	451.69	6975.0
2023-08-31 06:30:00	SPY	ETF	451.74	451.79	451.53	451.67	7076.0
2023-08-31 07:00:00	SPY	ETF	451.55	451.85	451.33	451.8	10533.0
2023-08-31 07:30:00	SPY	ETF	451.8	452.59	451.8	452.4	58747.0
2023-08-31 08:00:00	SPY	ETF	452.559	452.76	451.33	452.65	207097.0
2023-08-31 08:30:00	SPY	ETF	452.61	452.96	452.0	452.22	308562.0
2023-08-31 09:00:00	SPY	ETF	452.22	452.22	451.37	451.61	128537.0
2023-08-31 09:30:00	SPY	ETF	451.65	452.55	451.39	452.43	4397129.0
2023-08-31 10:00:00	SPY	ETF	452.43	452.68	451.82	452.66	3216071.0
2023-08-31 10:30:00	SPY	ETF	452.67	452.83	451.81	452.34	2952744.0
2023-08-31 11:00:00	SPY	ETF	452.35	452.37	451.58	452.08	2341282.0
2023-08-31 11:30:00	SPY	ETF	452.07	452.12	451.45	451.9	2144618.0
2023-08-31 12:00:00	SPY	ETF	451.91	452.25	451.08	451.34	2291708.0
2023-08-31 12:30:00	SPY	ETF	451.34	451.48	450.36	450.965	3244391.0
2023-08-31 13:00:00	SPY	ETF	450.97	451.7996	450.77	451.755	2218368.0
2023-08-31 13:30:00	SPY	ETF	451.76	451.87	451.13	451.46	2084865.0
2023-08-31 14:00:00	SPY	ETF	451.47	452.19	451.415	451.96	2410531.0
2023-08-31 14:30:00	SPY	ETF	451.97	452.035	450.7801	450.88	3399363.0
2023-08-31 15:00:00	SPY	ETF	450.865	451.5	450.815	451.135	3429577.0
2023-08-31 15:30:00	SPY	ETF	451.15	451.68	450.16	450.28	12100529.0
2023-08-31 16:00:00	SPY	ETF	450.26	451.9451	450.24	450.63	3961733.0
2023-08-31 16:30:00	SPY	ETF	450.64	450.7	450.54	450.56	208509.0
2023-08-31 17:00:00	SPY	ETF	450.52	450.65	450.48	450.65	43693.0
2023-08-31 17:30:00	SPY	ETF	450.6	450.645	450.46	450.5	15062.0
2023-08-31 18:00:00	SPY	ETF	450.5	450.59	450.33	450.48	28941.0
2023-08-31 18:30:00	SPY	ETF	450.48	450.5	450.38	450.44	23215.0
2023-08-31 19:00:00	SPY	ETF	450.52	450.6	450.49	450.6	3343.0
2023-08-31 19:30:00	SPY	ETF	450.64	450.7	450.6	450.67	20777.0
2023-08-31 04:00:00	QQQ	ETF	377.43	377.55	377.22	377.32	23832.0
2023-08-31 04:30:00	QQQ	ETF	377.3	377.34	377.17	377.23	5306.0
2023-08-31 05:00:00	QQQ	ETF	377.25	377.25	376.26	376.57	53371.0
2023-08-31 05:30:00	QQQ	ETF	376.57	376.66	376.32	376.35	4731.0
2023-08-31 06:00:00	QQQ	ETF	376.35	376.84	376.35	376.81	12143.0
2023-08-31 06:30:00	QQQ	ETF	376.86	376.9	376.68	376.68	12773.0
2023-08-31 07:00:00	QQQ	ETF	376.69	377.17	376.48	377.15	44602.0
2023-08-31 07:30:00	QQQ	ETF	377.2	377.819	377.2	377.64	132511.0
2023-08-31 08:00:00	QQQ	ETF	376.6791	377.95	376.3296	377.88	209481.0
2023-08-31 08:30:00	QQQ	ETF	377.81	378.1892	377.0	377.34	364269.0
2023-08-31 09:00:00	QQQ	ETF	377.28	377.36	376.67	376.96	167923.0
2023-08-31 09:30:00	QQQ	ETF	376.94	378.775	376.86	378.75	4337929.0
2023-08-31 10:00:00	QQQ	ETF	378.77	379.416	378.05	379.4	2453277.0
2023-08-31 10:30:00	QQQ	ETF	379.41	379.719	378.33	379.13	2048001.0
2023-08-31 11:00:00	QQQ	ETF	379.131	379.33	378.16	378.75	1819068.0
2023-08-31 11:30:00	QQQ	ETF	378.73	378.94	378.09	378.7	1347025.0
2023-08-31 12:00:00	QQQ	ETF	378.7	379.12	377.55	377.95	1541363.0
2023-08-31 12:30:00	QQQ	ETF	377.96	378.16	376.96	377.77	1616880.0

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

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