PREVIEW / etf_30min / 2023-10-31

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-10-31.parquet
  size:    722 KB
  rows:    28,909

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-31 04:00:00	SPY	ETF	414.7	415.38	414.47	415.31	36530.0
2023-10-31 04:30:00	SPY	ETF	415.29	416.26	415.26	416.19	20454.0
2023-10-31 05:00:00	SPY	ETF	416.15	416.2	415.49	415.58	26064.0
2023-10-31 05:30:00	SPY	ETF	415.62	416.47	415.62	416.36	20158.0
2023-10-31 06:00:00	SPY	ETF	416.48	416.83	416.34	416.5	22586.0
2023-10-31 06:30:00	SPY	ETF	416.5	416.73	416.36	416.55	25551.0
2023-10-31 07:00:00	SPY	ETF	416.58	416.88	416.36	416.8	42666.0
2023-10-31 07:30:00	SPY	ETF	416.85	416.86	416.44	416.5	61804.0
2023-10-31 08:00:00	SPY	ETF	416.48	416.99	413.83	416.88	201332.0
2023-10-31 08:30:00	SPY	ETF	416.61	416.7	415.8	416.07	368965.0
2023-10-31 09:00:00	SPY	ETF	416.11	416.44	415.71	416.18	235294.0
2023-10-31 09:30:00	SPY	ETF	416.18	416.37	414.28	414.7636	5241680.0
2023-10-31 10:00:00	SPY	ETF	414.76	416.271	414.21	415.745	4920008.0
2023-10-31 10:30:00	SPY	ETF	415.74	416.56	414.815	416.31	4511857.0
2023-10-31 11:00:00	SPY	ETF	416.32	416.58	415.6002	415.71	3149939.0
2023-10-31 11:30:00	SPY	ETF	415.735	416.46	415.4	416.45	2959958.0
2023-10-31 12:00:00	SPY	ETF	416.44	416.485	415.215	415.91	2909581.0
2023-10-31 12:30:00	SPY	ETF	415.92	416.85	415.295	416.73	3505499.0
2023-10-31 13:00:00	SPY	ETF	416.74	417.16	416.33	416.97	2868113.0
2023-10-31 13:30:00	SPY	ETF	416.98	417.935	416.975	417.8431	3953969.0
2023-10-31 14:00:00	SPY	ETF	417.86	418.07	417.08	417.08	3894852.0
2023-10-31 14:30:00	SPY	ETF	417.09	418.23	417.07	418.105	3393856.0
2023-10-31 15:00:00	SPY	ETF	418.11	418.53	417.9301	418.242	3984628.0
2023-10-31 15:30:00	SPY	ETF	418.255	418.51	417.58	418.23	12412012.0
2023-10-31 16:00:00	SPY	ETF	418.23	418.33	415.69	417.37	4323785.0
2023-10-31 16:30:00	SPY	ETF	417.35	417.4	417.23	417.4	366967.0
2023-10-31 17:00:00	SPY	ETF	418.2	418.2	417.3	417.49	1218173.0
2023-10-31 17:30:00	SPY	ETF	417.46	417.6	417.38	417.5	26846.0
2023-10-31 18:00:00	SPY	ETF	417.6	417.69	417.24	417.33	32156.0
2023-10-31 18:30:00	SPY	ETF	417.32	417.52	417.31	417.52	8531.0
2023-10-31 19:00:00	SPY	ETF	417.53	417.53	417.2	417.25	11898.0
2023-10-31 19:30:00	SPY	ETF	417.24	417.34	417.13	417.28	35277.0
2023-10-31 04:00:00	QQQ	ETF	347.66	348.19	347.43	348.16	41811.0
2023-10-31 04:30:00	QQQ	ETF	348.22	349.17	348.12	349.17	42899.0
2023-10-31 05:00:00	QQQ	ETF	349.03	349.15	348.29	348.37	10779.0
2023-10-31 05:30:00	QQQ	ETF	348.4	349.21	348.39	349.13	100315.0
2023-10-31 06:00:00	QQQ	ETF	349.05	349.65	349.05	349.39	40574.0
2023-10-31 06:30:00	QQQ	ETF	349.44	349.45	349.17	349.34	24194.0
2023-10-31 07:00:00	QQQ	ETF	349.4	349.89	349.27	349.7	83217.0
2023-10-31 07:30:00	QQQ	ETF	349.75	349.8	349.33	349.41	81489.0
2023-10-31 08:00:00	QQQ	ETF	349.41	350.05	346.92	349.93	211136.0
2023-10-31 08:30:00	QQQ	ETF	349.78	349.79	348.84	349.04	329780.0
2023-10-31 09:00:00	QQQ	ETF	349.1	349.53	348.5855	349.24	386455.0
2023-10-31 09:30:00	QQQ	ETF	349.23	349.45	346.62	347.335	5205525.0
2023-10-31 10:00:00	QQQ	ETF	347.31	349.1465	346.87	348.68	3766075.0
2023-10-31 10:30:00	QQQ	ETF	348.68	349.54	347.43	349.165	3098924.0
2023-10-31 11:00:00	QQQ	ETF	349.18	349.58	348.205	348.27	1822059.0
2023-10-31 11:30:00	QQQ	ETF	348.28	349.12	347.96	349.1199	2001148.0
2023-10-31 12:00:00	QQQ	ETF	349.115	349.1658	348.03	348.68	2006978.0
2023-10-31 12:30:00	QQQ	ETF	348.68	349.74	348.1	349.63	2497631.0

> showing 50 of 28,909 rows — these rows as CSV

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