PREVIEW / etf_30min / 2023-04-14

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-04-14.parquet
  size:    678 KB
  rows:    27,051

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-14 04:00:00	SPY	ETF	413.28	413.28	412.79	412.86	12440.0
2023-04-14 04:30:00	SPY	ETF	412.84	412.91	412.66	412.79	7538.0
2023-04-14 05:00:00	SPY	ETF	412.69	412.94	412.65	412.82	5658.0
2023-04-14 05:30:00	SPY	ETF	412.86	412.96	412.75	412.86	11789.0
2023-04-14 06:00:00	SPY	ETF	412.75	412.86	412.42	412.86	16310.0
2023-04-14 06:30:00	SPY	ETF	412.81	413.24	412.58	413.1	97124.0
2023-04-14 07:00:00	SPY	ETF	413.07	413.68	412.98	413.29	352242.0
2023-04-14 07:30:00	SPY	ETF	413.29	413.38	413.07	413.27	161079.0
2023-04-14 08:00:00	SPY	ETF	413.2508	413.85	412.5	413.53	287737.0
2023-04-14 08:30:00	SPY	ETF	413.65	413.999	412.41	412.91	407726.0
2023-04-14 09:00:00	SPY	ETF	412.84	413.0	412.52	412.82	378118.0
2023-04-14 09:30:00	SPY	ETF	412.82	415.09	412.77	414.8264	6687480.0
2023-04-14 10:00:00	SPY	ETF	414.79	414.97	412.14	412.3384	7679518.0
2023-04-14 10:30:00	SPY	ETF	412.35	412.76	411.71	412.22	4385622.0
2023-04-14 11:00:00	SPY	ETF	412.24	412.46	411.48	411.58	3545046.0
2023-04-14 11:30:00	SPY	ETF	411.58	411.9	411.27	411.7714	2988426.0
2023-04-14 12:00:00	SPY	ETF	411.785	411.85	411.0	411.15	3189622.0
2023-04-14 12:30:00	SPY	ETF	411.14	411.15	410.13	410.35	3851187.0
2023-04-14 13:00:00	SPY	ETF	410.35	411.54	410.28	410.6077	2944234.0
2023-04-14 13:30:00	SPY	ETF	410.61	411.15	410.06	411.02	3185512.0
2023-04-14 14:00:00	SPY	ETF	411.03	411.92	410.69	411.89	2894457.0
2023-04-14 14:30:00	SPY	ETF	411.89	412.19	411.67	412.0821	3160517.0
2023-04-14 15:00:00	SPY	ETF	412.09	412.095	410.65	411.794	4438256.0
2023-04-14 15:30:00	SPY	ETF	411.8	412.785	411.69	412.49	8155336.0
2023-04-14 16:00:00	SPY	ETF	412.49	413.275	412.46	413.2	2613931.0
2023-04-14 16:30:00	SPY	ETF	413.19	413.7	412.46	413.36	584096.0
2023-04-14 17:00:00	SPY	ETF	413.47	413.47	412.92	412.94	183819.0
2023-04-14 17:30:00	SPY	ETF	413.04	413.08	412.9642	413.0	20604.0
2023-04-14 18:00:00	SPY	ETF	413.04	413.1	413.0	413.05	5265.0
2023-04-14 18:30:00	SPY	ETF	413.02	413.08	413.02	413.03	678.0
2023-04-14 19:00:00	SPY	ETF	413.08	413.1	413.05	413.1	3888.0
2023-04-14 19:30:00	SPY	ETF	413.06	413.15	413.06	413.15	7654.0
2023-04-14 04:00:00	QQQ	ETF	318.86	319.27	318.57	318.72	9498.0
2023-04-14 04:30:00	QQQ	ETF	318.63	318.67	318.58	318.63	4767.0
2023-04-14 05:00:00	QQQ	ETF	318.6	318.64	318.37	318.43	7336.0
2023-04-14 05:30:00	QQQ	ETF	318.41	318.52	318.14	318.14	7380.0
2023-04-14 06:00:00	QQQ	ETF	318.25	318.32	317.84	318.22	28374.0
2023-04-14 06:30:00	QQQ	ETF	318.23	318.35	317.15	317.54	114564.0
2023-04-14 07:00:00	QQQ	ETF	317.53	317.82	317.32	317.79	114231.0
2023-04-14 07:30:00	QQQ	ETF	317.87	317.89	317.5	317.67	153242.0
2023-04-14 08:00:00	QQQ	ETF	317.49	319.409	317.27	318.05	312248.0
2023-04-14 08:30:00	QQQ	ETF	318.2	318.9	316.62	317.15	733688.0
2023-04-14 09:00:00	QQQ	ETF	317.11	317.58	317.0	317.58	241084.0
2023-04-14 09:30:00	QQQ	ETF	317.59	320.26	317.42	319.88	5493538.0
2023-04-14 10:00:00	QQQ	ETF	319.81	320.36	317.41	317.61	5570006.0
2023-04-14 10:30:00	QQQ	ETF	317.67	317.9799	317.01	317.65	2857684.0
2023-04-14 11:00:00	QQQ	ETF	317.66	318.32	317.14	317.48	2589509.0
2023-04-14 11:30:00	QQQ	ETF	317.49	317.64	316.88	317.3294	1962504.0
2023-04-14 12:00:00	QQQ	ETF	317.33	317.34	316.57	316.83	1586183.0
2023-04-14 12:30:00	QQQ	ETF	316.82	316.82	315.61	315.925	2023308.0

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

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