PREVIEW / etf_30min / 2023-10-26

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-10-26.parquet
  size:    733 KB
  rows:    29,743

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-10-26 04:00:00	SPY	ETF	414.88	415.43	414.75	414.86	33320.0
2023-10-26 04:30:00	SPY	ETF	415.0	415.24	414.91	415.04	5190.0
2023-10-26 05:00:00	SPY	ETF	415.2	415.7	414.75	415.68	37386.0
2023-10-26 05:30:00	SPY	ETF	415.7	415.75	415.17	415.17	10087.0
2023-10-26 06:00:00	SPY	ETF	415.15	415.7	414.95	415.57	100360.0
2023-10-26 06:30:00	SPY	ETF	415.63	415.75	414.85	414.85	17752.0
2023-10-26 07:00:00	SPY	ETF	414.93	414.96	414.23	414.381	121688.0
2023-10-26 07:30:00	SPY	ETF	414.34	414.85	414.06	414.77	130096.0
2023-10-26 08:00:00	SPY	ETF	414.38	415.7204	414.0	415.15	373210.0
2023-10-26 08:30:00	SPY	ETF	415.02	416.78	414.43	416.64	703110.0
2023-10-26 09:00:00	SPY	ETF	416.65	417.0	416.42	416.44	610837.0
2023-10-26 09:30:00	SPY	ETF	416.45	417.325	415.25	415.39	8577951.0
2023-10-26 10:00:00	SPY	ETF	415.38	415.818	414.45	415.4	7551809.0
2023-10-26 10:30:00	SPY	ETF	415.4	416.88	414.32	416.34	6102611.0
2023-10-26 11:00:00	SPY	ETF	416.34	416.6	414.2	414.38	5053236.0
2023-10-26 11:30:00	SPY	ETF	414.38	414.93	413.89	414.52	3906830.0
2023-10-26 12:00:00	SPY	ETF	414.5	414.51	412.295	413.0091	6703517.0
2023-10-26 12:30:00	SPY	ETF	413.0	413.19	412.14	412.185	4579103.0
2023-10-26 13:00:00	SPY	ETF	412.185	413.21	411.97	412.24	5118782.0
2023-10-26 13:30:00	SPY	ETF	412.25	413.72	411.6	413.6201	5681904.0
2023-10-26 14:00:00	SPY	ETF	413.63	414.3	413.34	414.21	4606468.0
2023-10-26 14:30:00	SPY	ETF	414.215	415.55	413.89	415.55	5286651.0
2023-10-26 15:00:00	SPY	ETF	415.55	415.94	414.155	414.19	6291452.0
2023-10-26 15:30:00	SPY	ETF	414.19	414.28	412.285	412.59	16972647.0
2023-10-26 16:00:00	SPY	ETF	412.58	415.3844	411.88	413.41	4831979.0
2023-10-26 16:30:00	SPY	ETF	413.4	413.47	412.45	412.87	742540.0
2023-10-26 17:00:00	SPY	ETF	412.81	413.06	412.6618	412.77	131432.0
2023-10-26 17:30:00	SPY	ETF	412.75	414.0	412.74	413.75	69786.0
2023-10-26 18:00:00	SPY	ETF	413.6	414.45	413.6	414.2	141470.0
2023-10-26 18:30:00	SPY	ETF	414.3	414.43	414.13	414.33	34993.0
2023-10-26 19:00:00	SPY	ETF	414.33	414.75	414.33	414.65	25864.0
2023-10-26 19:30:00	SPY	ETF	414.65	414.94	414.58	414.83	39008.0
2023-10-26 04:00:00	QQQ	ETF	346.88	347.84	346.12	346.71	122017.0
2023-10-26 04:30:00	QQQ	ETF	346.79	347.21	346.75	346.93	37357.0
2023-10-26 05:00:00	QQQ	ETF	347.06	347.5	346.5	347.44	73929.0
2023-10-26 05:30:00	QQQ	ETF	347.35	347.56	347.0	347.08	44536.0
2023-10-26 06:00:00	QQQ	ETF	347.14	347.7	346.83	347.64	52561.0
2023-10-26 06:30:00	QQQ	ETF	347.6	347.83	347.05	347.05	96238.0
2023-10-26 07:00:00	QQQ	ETF	347.06	347.13	346.48	346.74	187847.0
2023-10-26 07:30:00	QQQ	ETF	346.71	347.01	346.29	346.99	118836.0
2023-10-26 08:00:00	QQQ	ETF	347.01	350.602	345.26	347.54	438424.0
2023-10-26 08:30:00	QQQ	ETF	347.24	348.91	346.7	348.74	910051.0
2023-10-26 09:00:00	QQQ	ETF	348.7	349.36	348.6	349.04	672348.0
2023-10-26 09:30:00	QQQ	ETF	349.12	350.07	346.54	346.9509	8309757.0
2023-10-26 10:00:00	QQQ	ETF	346.9599	347.12	345.47	346.63	6004753.0
2023-10-26 10:30:00	QQQ	ETF	346.63	348.24	345.4112	347.49	4786604.0
2023-10-26 11:00:00	QQQ	ETF	347.49	347.6	345.03	345.18	3614532.0
2023-10-26 11:30:00	QQQ	ETF	345.19	345.85	344.4799	345.42	3164120.0
2023-10-26 12:00:00	QQQ	ETF	345.4	345.59	342.85	343.61	4657131.0
2023-10-26 12:30:00	QQQ	ETF	343.62	343.72	342.46	342.62	2972605.0

> showing 50 of 29,743 rows — these rows as CSV

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