PREVIEW / etf_30min / 2023-05-26

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-05-26.parquet
  size:    685 KB
  rows:    27,353

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-26 04:00:00	SPY	ETF	413.84	414.49	413.8	414.29	7721.0
2023-05-26 04:30:00	SPY	ETF	414.32	414.5	414.12	414.48	4376.0
2023-05-26 05:00:00	SPY	ETF	414.4	414.4	413.86	414.15	10094.0
2023-05-26 05:30:00	SPY	ETF	413.98	414.15	413.84	414.12	51367.0
2023-05-26 06:00:00	SPY	ETF	414.1	414.57	413.89	414.57	71734.0
2023-05-26 06:30:00	SPY	ETF	414.51	415.51	414.47	415.34	40885.0
2023-05-26 07:00:00	SPY	ETF	415.44	415.72	415.33	415.7	44702.0
2023-05-26 07:30:00	SPY	ETF	415.62	415.84	415.48	415.71	90576.0
2023-05-26 08:00:00	SPY	ETF	415.4893	415.83	413.81	415.47	92622.0
2023-05-26 08:30:00	SPY	ETF	415.44	415.9	414.28	415.33	522633.0
2023-05-26 09:00:00	SPY	ETF	415.3	415.79	415.23	415.33	197438.0
2023-05-26 09:30:00	SPY	ETF	415.33	417.41	415.25	417.02	6714987.0
2023-05-26 10:00:00	SPY	ETF	417.0	419.1999	416.88	419.1919	6016448.0
2023-05-26 10:30:00	SPY	ETF	419.2	419.81	418.8835	419.36	6565968.0
2023-05-26 11:00:00	SPY	ETF	419.37	419.72	418.2799	418.55	4710900.0
2023-05-26 11:30:00	SPY	ETF	418.55	419.465	418.52	419.05	3077175.0
2023-05-26 12:00:00	SPY	ETF	419.06	419.83	418.97	419.83	3137029.0
2023-05-26 12:30:00	SPY	ETF	419.83	419.97	419.595	419.72	2618976.0
2023-05-26 13:00:00	SPY	ETF	419.725	420.03	419.29	419.62	2463548.0
2023-05-26 13:30:00	SPY	ETF	419.64	419.84	419.15	419.565	2281748.0
2023-05-26 14:00:00	SPY	ETF	419.57	419.93	419.05	419.8	2190039.0
2023-05-26 14:30:00	SPY	ETF	419.8	420.49	419.76	420.12	2797104.0
2023-05-26 15:00:00	SPY	ETF	420.13	420.77	420.02	420.1599	4192576.0
2023-05-26 15:30:00	SPY	ETF	420.16	420.49	419.78	419.98	12598252.0
2023-05-26 16:00:00	SPY	ETF	419.98	420.72	419.96	420.56	4730693.0
2023-05-26 16:30:00	SPY	ETF	420.56	420.67	420.02	420.55	262593.0
2023-05-26 17:00:00	SPY	ETF	420.56	420.58	420.02	420.37	27251.0
2023-05-26 17:30:00	SPY	ETF	420.36	420.38	420.08	420.29	40552.0
2023-05-26 18:00:00	SPY	ETF	420.29	420.3	420.02	420.02	88451.0
2023-05-26 18:30:00	SPY	ETF	420.13	420.37	420.13	420.35	3973.0
2023-05-26 19:00:00	SPY	ETF	420.4	420.45	420.38	420.45	5851.0
2023-05-26 19:30:00	SPY	ETF	420.4	421.0	420.4	420.49	24391.0
2023-05-26 04:00:00	QQQ	ETF	339.39	339.9	339.3	339.88	8951.0
2023-05-26 04:30:00	QQQ	ETF	340.0	340.15	339.73	340.04	8509.0
2023-05-26 05:00:00	QQQ	ETF	340.09	340.09	339.68	339.82	6597.0
2023-05-26 05:30:00	QQQ	ETF	339.8	339.91	339.71	339.82	6039.0
2023-05-26 06:00:00	QQQ	ETF	339.72	340.05	339.51	340.05	7642.0
2023-05-26 06:30:00	QQQ	ETF	340.05	340.86	340.05	340.8	19468.0
2023-05-26 07:00:00	QQQ	ETF	340.8	341.23	340.7	341.119	41401.0
2023-05-26 07:30:00	QQQ	ETF	341.1	341.38	341.04	341.04	89024.0
2023-05-26 08:00:00	QQQ	ETF	340.76	341.38	339.03	340.96	156744.0
2023-05-26 08:30:00	QQQ	ETF	340.8	341.28	339.82	340.86	495340.0
2023-05-26 09:00:00	QQQ	ETF	340.83	341.18	340.69	340.77	196025.0
2023-05-26 09:30:00	QQQ	ETF	340.76	343.31	340.66	343.12	5634010.0
2023-05-26 10:00:00	QQQ	ETF	343.14	345.27	343.09	345.21	4603567.0
2023-05-26 10:30:00	QQQ	ETF	345.22	346.84	345.0	346.49	5277475.0
2023-05-26 11:00:00	QQQ	ETF	346.49	346.81	345.625	346.27	4276813.0
2023-05-26 11:30:00	QQQ	ETF	346.28	347.61	346.27	347.245	3408392.0
2023-05-26 12:00:00	QQQ	ETF	347.25	347.75	347.09	347.7034	2149299.0
2023-05-26 12:30:00	QQQ	ETF	347.7	348.23	347.455	348.05	2535933.0

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

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