PREVIEW / etf_30min / 2023-05-15

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-05-15.parquet
  size:    665 KB
  rows:    26,887

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-15 04:00:00	SPY	ETF	413.18	413.5	412.34	413.35	92607.0
2023-05-15 04:30:00	SPY	ETF	413.45	413.45	412.91	412.95	15532.0
2023-05-15 05:00:00	SPY	ETF	412.96	413.27	412.95	413.24	17955.0
2023-05-15 05:30:00	SPY	ETF	413.24	413.28	412.94	413.0	16004.0
2023-05-15 06:00:00	SPY	ETF	413.1	413.26	412.88	413.2	15650.0
2023-05-15 06:30:00	SPY	ETF	413.19	413.35	413.19	413.28	19463.0
2023-05-15 07:00:00	SPY	ETF	413.28	413.33	413.1	413.14	116829.0
2023-05-15 07:30:00	SPY	ETF	413.15	413.36	413.02	413.14	87453.0
2023-05-15 08:00:00	SPY	ETF	413.22	413.4504	411.05	412.89	176560.0
2023-05-15 08:30:00	SPY	ETF	413.0	413.03	412.37	412.43	238176.0
2023-05-15 09:00:00	SPY	ETF	412.36	412.5	412.13	412.22	146721.0
2023-05-15 09:30:00	SPY	ETF	412.22	412.29	410.78	410.84	4783472.0
2023-05-15 10:00:00	SPY	ETF	410.85	411.2299	410.23	411.02	4388196.0
2023-05-15 10:30:00	SPY	ETF	411.015	411.98	410.97	411.4213	3345242.0
2023-05-15 11:00:00	SPY	ETF	411.435	412.19	411.36	411.98	2578568.0
2023-05-15 11:30:00	SPY	ETF	411.97	412.21	411.56	411.98	2451445.0
2023-05-15 12:00:00	SPY	ETF	411.99	412.11	411.69	411.945	1547041.0
2023-05-15 12:30:00	SPY	ETF	411.94	412.8	411.81	412.76	2520707.0
2023-05-15 13:00:00	SPY	ETF	412.77	413.43	412.22	412.292	3496253.0
2023-05-15 13:30:00	SPY	ETF	412.305	412.42	411.57	412.3	2861135.0
2023-05-15 14:00:00	SPY	ETF	412.31	412.679	412.13	412.2391	2318915.0
2023-05-15 14:30:00	SPY	ETF	412.23	412.8	412.14	412.43	1930334.0
2023-05-15 15:00:00	SPY	ETF	412.43	412.83	412.37	412.76	1644210.0
2023-05-15 15:30:00	SPY	ETF	412.755	413.03	412.45	413.01	6233135.0
2023-05-15 16:00:00	SPY	ETF	413.01	413.02	412.76	412.85	1928731.0
2023-05-15 16:30:00	SPY	ETF	412.85	412.87	412.67	412.73	124319.0
2023-05-15 17:00:00	SPY	ETF	412.65	413.01	412.65	412.89	35373.0
2023-05-15 17:30:00	SPY	ETF	412.84	412.9	412.74	412.75	22600.0
2023-05-15 18:00:00	SPY	ETF	412.74	412.9	412.6	412.84	28922.0
2023-05-15 18:30:00	SPY	ETF	412.8	412.8	412.67	412.7	19179.0
2023-05-15 19:00:00	SPY	ETF	412.69	412.77	412.67	412.68	9944.0
2023-05-15 19:30:00	SPY	ETF	412.67	412.67	412.52	412.56	35099.0
2023-05-15 04:00:00	QQQ	ETF	326.04	326.06	325.73	326.06	24391.0
2023-05-15 04:30:00	QQQ	ETF	326.06	326.12	325.82	325.82	9585.0
2023-05-15 05:00:00	QQQ	ETF	325.9	326.09	325.88	326.08	75819.0
2023-05-15 05:30:00	QQQ	ETF	326.13	326.25	325.77	325.88	12438.0
2023-05-15 06:00:00	QQQ	ETF	325.87	325.94	325.6	325.86	114388.0
2023-05-15 06:30:00	QQQ	ETF	325.86	326.0	325.86	325.92	15995.0
2023-05-15 07:00:00	QQQ	ETF	325.9	325.97	325.67	325.93	60979.0
2023-05-15 07:30:00	QQQ	ETF	325.94	326.1	325.73	325.84	80200.0
2023-05-15 08:00:00	QQQ	ETF	325.94	326.1604	324.88	325.68	143879.0
2023-05-15 08:30:00	QQQ	ETF	325.84	325.91	325.47	325.73	213533.0
2023-05-15 09:00:00	QQQ	ETF	325.66	325.86	325.45	325.52	190279.0
2023-05-15 09:30:00	QQQ	ETF	325.51	325.81	324.52	324.56	3527322.0
2023-05-15 10:00:00	QQQ	ETF	324.57	324.8611	323.96	324.313	2354377.0
2023-05-15 10:30:00	QQQ	ETF	324.29	325.37	324.22	324.76	1998559.0
2023-05-15 11:00:00	QQQ	ETF	324.755	326.02	324.72	325.8399	1480644.0
2023-05-15 11:30:00	QQQ	ETF	325.84	326.29	325.56	326.25	1964625.0
2023-05-15 12:00:00	QQQ	ETF	326.26	326.33	325.795	325.9799	1149770.0
2023-05-15 12:30:00	QQQ	ETF	325.98	326.42	325.73	326.4051	1032485.0

> showing 50 of 26,887 rows — these rows as CSV

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