PREVIEW / etf_30min / 2023-10-30

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-10-30.parquet
  size:    732 KB
  rows:    29,206

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-30 04:00:00	SPY	ETF	412.42	413.38	412.42	413.2	27989.0
2023-10-30 04:30:00	SPY	ETF	413.08	413.16	412.66	412.99	14007.0
2023-10-30 05:00:00	SPY	ETF	413.0	413.67	413.0	413.4	16562.0
2023-10-30 05:30:00	SPY	ETF	413.4	413.45	413.14	413.4	9592.0
2023-10-30 06:00:00	SPY	ETF	413.5	413.52	413.12	413.18	52493.0
2023-10-30 06:30:00	SPY	ETF	413.18	413.55	413.05	413.29	11993.0
2023-10-30 07:00:00	SPY	ETF	413.25	413.48	413.14	413.15	105171.0
2023-10-30 07:30:00	SPY	ETF	413.21	413.85	413.19	413.63	152938.0
2023-10-30 08:00:00	SPY	ETF	413.42	413.85	412.28	413.13	158522.0
2023-10-30 08:30:00	SPY	ETF	413.15	413.23	412.86	413.14	134908.0
2023-10-30 09:00:00	SPY	ETF	413.14	413.68	413.08	413.54	225806.0
2023-10-30 09:30:00	SPY	ETF	413.54	415.345	413.53	414.9	6735004.0
2023-10-30 10:00:00	SPY	ETF	414.895	415.03	412.63	412.99	7091408.0
2023-10-30 10:30:00	SPY	ETF	412.99	413.55	412.22	413.02	5011200.0
2023-10-30 11:00:00	SPY	ETF	413.03	414.05	412.43	412.93	3731874.0
2023-10-30 11:30:00	SPY	ETF	412.955	414.05	412.9	413.985	3025789.0
2023-10-30 12:00:00	SPY	ETF	413.97	414.2599	413.3	413.345	2569412.0
2023-10-30 12:30:00	SPY	ETF	413.35	413.98	412.61	413.2196	2793375.0
2023-10-30 13:00:00	SPY	ETF	413.23	415.1912	412.96	415.03	2855439.0
2023-10-30 13:30:00	SPY	ETF	415.04	415.72	414.62	415.68	4208499.0
2023-10-30 14:00:00	SPY	ETF	415.68	415.73	415.01	415.27	4327915.0
2023-10-30 14:30:00	SPY	ETF	415.26	416.295	415.25	415.83	3295444.0
2023-10-30 15:00:00	SPY	ETF	415.84	416.68	415.57	416.22	5596791.0
2023-10-30 15:30:00	SPY	ETF	416.23	416.41	415.46	415.58	13095097.0
2023-10-30 16:00:00	SPY	ETF	415.59	415.69	412.9081	415.36	3534036.0
2023-10-30 16:30:00	SPY	ETF	415.35	415.43	415.16	415.43	165738.0
2023-10-30 17:00:00	SPY	ETF	415.36	415.42	415.21	415.37	53519.0
2023-10-30 17:30:00	SPY	ETF	415.38	415.45	415.25	415.36	40424.0
2023-10-30 18:00:00	SPY	ETF	415.34	415.38	415.11	415.37	59945.0
2023-10-30 18:30:00	SPY	ETF	415.34	415.39	415.28	415.32	6732.0
2023-10-30 19:00:00	SPY	ETF	415.28	415.38	415.2	415.29	7950.0
2023-10-30 19:30:00	SPY	ETF	415.33	415.4	415.13	415.18	20732.0
2023-10-30 04:00:00	QQQ	ETF	348.04	348.25	347.7	347.86	33832.0
2023-10-30 04:30:00	QQQ	ETF	347.72	347.88	347.58	347.76	57992.0
2023-10-30 05:00:00	QQQ	ETF	347.86	348.5	347.86	348.17	12750.0
2023-10-30 05:30:00	QQQ	ETF	348.31	348.31	348.03	348.19	6541.0
2023-10-30 06:00:00	QQQ	ETF	348.15	348.2	347.87	347.94	7672.0
2023-10-30 06:30:00	QQQ	ETF	347.94	348.15	347.8	347.99	24816.0
2023-10-30 07:00:00	QQQ	ETF	347.93	348.15	347.861	347.861	74253.0
2023-10-30 07:30:00	QQQ	ETF	347.93	348.49	347.92	348.21	87712.0
2023-10-30 08:00:00	QQQ	ETF	347.99	348.4504	345.568	347.8399	216283.0
2023-10-30 08:30:00	QQQ	ETF	347.84	347.94	347.3804	347.7	146891.0
2023-10-30 09:00:00	QQQ	ETF	347.73	347.91	347.33	347.82	272791.0
2023-10-30 09:30:00	QQQ	ETF	347.83	350.54	347.11	349.91	5933998.0
2023-10-30 10:00:00	QQQ	ETF	349.915	350.1	347.0395	347.292	5412682.0
2023-10-30 10:30:00	QQQ	ETF	347.29	347.98	346.45	347.3588	4076797.0
2023-10-30 11:00:00	QQQ	ETF	347.37	348.62	346.82	347.2699	2874220.0
2023-10-30 11:30:00	QQQ	ETF	347.27	348.64	347.14	348.57	2003213.0
2023-10-30 12:00:00	QQQ	ETF	348.56	348.66	347.36	347.435	1947945.0
2023-10-30 12:30:00	QQQ	ETF	347.42	347.99	346.55	347.01	2069135.0

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

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