PREVIEW / etf_30min / 2023-05-04

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-05-04.parquet
  size:    683 KB
  rows:    27,827

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-05-04 04:00:00	SPY	ETF	408.73	408.77	408.07	408.35	36727.0
2023-05-04 04:30:00	SPY	ETF	408.27	408.32	407.85	407.92	19752.0
2023-05-04 05:00:00	SPY	ETF	408.2	408.33	407.82	408.02	11337.0
2023-05-04 05:30:00	SPY	ETF	408.0	408.17	407.52	407.69	16301.0
2023-05-04 06:00:00	SPY	ETF	407.65	407.9	407.08	407.77	41036.0
2023-05-04 06:30:00	SPY	ETF	407.7	407.8	406.74	407.03	122252.0
2023-05-04 07:00:00	SPY	ETF	407.11	407.11	406.53	406.91	193942.0
2023-05-04 07:30:00	SPY	ETF	406.93	407.18	406.7	406.84	112926.0
2023-05-04 08:00:00	SPY	ETF	406.84	409.06	406.15	406.85	461683.0
2023-05-04 08:30:00	SPY	ETF	406.5	407.52	406.48	406.96	478054.0
2023-05-04 09:00:00	SPY	ETF	406.95	407.42	406.69	406.93	227447.0
2023-05-04 09:30:00	SPY	ETF	406.93	407.27	404.89	405.6	8475814.0
2023-05-04 10:00:00	SPY	ETF	405.61	405.97	404.0	404.0199	7561556.0
2023-05-04 10:30:00	SPY	ETF	404.03	405.75	403.86	404.87	7045014.0
2023-05-04 11:00:00	SPY	ETF	404.86	406.5201	404.59	405.24	5709153.0
2023-05-04 11:30:00	SPY	ETF	405.24	405.47	404.21	404.3601	3750914.0
2023-05-04 12:00:00	SPY	ETF	404.34	405.45	403.74	405.425	3831878.0
2023-05-04 12:30:00	SPY	ETF	405.43	405.85	404.68	405.82	3000045.0
2023-05-04 13:00:00	SPY	ETF	405.84	407.16	405.58	406.5299	4821093.0
2023-05-04 13:30:00	SPY	ETF	406.53	406.99	405.585	406.132	3563343.0
2023-05-04 14:00:00	SPY	ETF	406.15	406.2586	405.15	405.1601	2883150.0
2023-05-04 14:30:00	SPY	ETF	405.155	405.59	404.625	405.2491	3539782.0
2023-05-04 15:00:00	SPY	ETF	405.2401	406.25	404.58	405.295	4611574.0
2023-05-04 15:30:00	SPY	ETF	405.295	406.31	404.79	405.17	9039582.0
2023-05-04 16:00:00	SPY	ETF	405.17	405.3	404.64	405.0	3352643.0
2023-05-04 16:30:00	SPY	ETF	405.01	405.87	404.84	404.9	472596.0
2023-05-04 17:00:00	SPY	ETF	404.94	405.3	404.77	405.3	204485.0
2023-05-04 17:30:00	SPY	ETF	405.2704	405.45	405.13	405.25	88718.0
2023-05-04 18:00:00	SPY	ETF	405.25	406.22	405.23	406.05	102359.0
2023-05-04 18:30:00	SPY	ETF	406.06	406.28	405.86	406.28	31853.0
2023-05-04 19:00:00	SPY	ETF	406.28	406.35	406.07	406.35	25829.0
2023-05-04 19:30:00	SPY	ETF	406.4	406.5	406.2	406.25	28122.0
2023-05-04 04:00:00	QQQ	ETF	318.55	318.7	317.99	318.42	85185.0
2023-05-04 04:30:00	QQQ	ETF	318.24	318.41	318.11	318.32	17744.0
2023-05-04 05:00:00	QQQ	ETF	318.47	318.5	318.05	318.18	9403.0
2023-05-04 05:30:00	QQQ	ETF	318.05	318.08	317.72	317.89	26025.0
2023-05-04 06:00:00	QQQ	ETF	317.8	318.18	317.55	318.16	29142.0
2023-05-04 06:30:00	QQQ	ETF	318.12	318.19	317.54	317.76	92866.0
2023-05-04 07:00:00	QQQ	ETF	317.72	317.75	317.24	317.45	134225.0
2023-05-04 07:30:00	QQQ	ETF	317.43	317.65	317.29	317.43	68869.0
2023-05-04 08:00:00	QQQ	ETF	317.7001	319.0	316.55	317.07	260758.0
2023-05-04 08:30:00	QQQ	ETF	317.1	317.48	316.87	316.97	263432.0
2023-05-04 09:00:00	QQQ	ETF	316.96	317.56	316.89	317.07	250367.0
2023-05-04 09:30:00	QQQ	ETF	317.06	317.13	315.72	316.07	5135703.0
2023-05-04 10:00:00	QQQ	ETF	316.075	316.68	315.19	315.276	3801744.0
2023-05-04 10:30:00	QQQ	ETF	315.275	316.63	315.115	316.14	3594076.0
2023-05-04 11:00:00	QQQ	ETF	316.14	317.67	316.01	316.771	3441834.0
2023-05-04 11:30:00	QQQ	ETF	316.76	317.1	315.926	316.2899	2405980.0
2023-05-04 12:00:00	QQQ	ETF	316.28	316.92	315.815	316.9	1582979.0
2023-05-04 12:30:00	QQQ	ETF	316.9	317.27	316.3	317.24	1388997.0

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

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