PREVIEW / etf_30min / 2023-04-10

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-04-10.parquet
  size:    698 KB
  rows:    27,896

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-04-10 04:00:00	SPY	ETF	409.07	409.16	408.95	408.95	24386.0
2023-04-10 04:30:00	SPY	ETF	408.97	409.2	408.97	409.2	9799.0
2023-04-10 05:00:00	SPY	ETF	409.22	409.35	409.18	409.34	7706.0
2023-04-10 05:30:00	SPY	ETF	409.38	409.49	409.34	409.34	3431.0
2023-04-10 06:00:00	SPY	ETF	409.35	409.46	409.31	409.35	5436.0
2023-04-10 06:30:00	SPY	ETF	409.35	409.46	409.31	409.33	2922.0
2023-04-10 07:00:00	SPY	ETF	409.29	409.32	408.6	408.62	25061.0
2023-04-10 07:30:00	SPY	ETF	408.59	408.59	408.25	408.45	77011.0
2023-04-10 08:00:00	SPY	ETF	408.9598	409.31	406.92	407.1	198990.0
2023-04-10 08:30:00	SPY	ETF	407.09	407.13	406.75	406.81	106162.0
2023-04-10 09:00:00	SPY	ETF	406.78	406.99	406.32	406.6	236219.0
2023-04-10 09:30:00	SPY	ETF	406.6	406.84	405.97	406.2	6359437.0
2023-04-10 10:00:00	SPY	ETF	406.2	407.15	406.02	406.48	4335047.0
2023-04-10 10:30:00	SPY	ETF	406.5	407.39	406.475	406.68	3167657.0
2023-04-10 11:00:00	SPY	ETF	406.71	407.59	406.71	407.385	2466291.0
2023-04-10 11:30:00	SPY	ETF	407.39	407.785	406.95	407.01	2396520.0
2023-04-10 12:00:00	SPY	ETF	407.02	407.0233	406.29	406.9007	3015023.0
2023-04-10 12:30:00	SPY	ETF	406.9	408.34	406.9	408.3	3137421.0
2023-04-10 13:00:00	SPY	ETF	408.31	408.82	408.24	408.68	3127470.0
2023-04-10 13:30:00	SPY	ETF	408.68	408.9	408.19	408.64	2938223.0
2023-04-10 14:00:00	SPY	ETF	408.62	409.06	408.36	408.75	2144478.0
2023-04-10 14:30:00	SPY	ETF	408.76	409.13	408.4	409.07	2197902.0
2023-04-10 15:00:00	SPY	ETF	409.08	409.26	408.72	408.73	2523799.0
2023-04-10 15:30:00	SPY	ETF	408.73	409.69	408.64	409.66	7456204.0
2023-04-10 16:00:00	SPY	ETF	409.66	410.07	409.45	409.98	3138689.0
2023-04-10 16:30:00	SPY	ETF	409.98	410.07	409.61	409.89	163941.0
2023-04-10 17:00:00	SPY	ETF	409.85	410.0	409.61	409.9	65107.0
2023-04-10 17:30:00	SPY	ETF	409.92	409.95	409.8	409.8	29414.0
2023-04-10 18:00:00	SPY	ETF	409.77	410.0	409.72	409.99	50672.0
2023-04-10 18:30:00	SPY	ETF	410.01	410.04	409.9	409.941	12607.0
2023-04-10 19:00:00	SPY	ETF	409.93	410.09	409.93	410.08	9514.0
2023-04-10 19:30:00	SPY	ETF	410.04	410.1896	409.97	410.18	19840.0
2023-04-10 04:00:00	QQQ	ETF	317.25	317.46	317.13	317.21	46838.0
2023-04-10 04:30:00	QQQ	ETF	317.16	317.4	317.16	317.4	11968.0
2023-04-10 05:00:00	QQQ	ETF	317.41	317.79	317.35	317.7	9367.0
2023-04-10 05:30:00	QQQ	ETF	317.73	317.9	317.69	317.74	22739.0
2023-04-10 06:00:00	QQQ	ETF	317.75	317.99	317.69	317.77	26784.0
2023-04-10 06:30:00	QQQ	ETF	317.78	317.87	317.65	317.65	14196.0
2023-04-10 07:00:00	QQQ	ETF	317.73	317.73	316.56	316.6	69242.0
2023-04-10 07:30:00	QQQ	ETF	316.57	316.65	316.25	316.65	111808.0
2023-04-10 08:00:00	QQQ	ETF	317.49	317.65	315.42	315.5	202226.0
2023-04-10 08:30:00	QQQ	ETF	315.5	315.73	315.29	315.47	182310.0
2023-04-10 09:00:00	QQQ	ETF	315.45	315.68	314.89	315.06	212175.0
2023-04-10 09:30:00	QQQ	ETF	315.06	315.24	313.25	313.715	5952135.0
2023-04-10 10:00:00	QQQ	ETF	313.69	314.5	313.33	313.8601	3364800.0
2023-04-10 10:30:00	QQQ	ETF	313.88	315.02	313.85	314.46	2409764.0
2023-04-10 11:00:00	QQQ	ETF	314.48	315.78	314.48	315.5796	2168991.0
2023-04-10 11:30:00	QQQ	ETF	315.6	316.16	315.23	315.26	1979548.0
2023-04-10 12:00:00	QQQ	ETF	315.26	315.28	314.35	315.13	2449336.0
2023-04-10 12:30:00	QQQ	ETF	315.125	316.8492	315.1	316.705	1978383.0

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

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