PREVIEW / etf_30min / 2023-07-25

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-07-25.parquet
  size:    719 KB
  rows:    28,384

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-07-25 04:00:00	SPY	ETF	454.41	455.05	454.34	455.04	29787.0
2023-07-25 04:30:00	SPY	ETF	455.05	455.2	455.03	455.07	26574.0
2023-07-25 05:00:00	SPY	ETF	454.99	455.01	454.82	454.88	6089.0
2023-07-25 05:30:00	SPY	ETF	454.79	454.92	454.79	454.89	2832.0
2023-07-25 06:00:00	SPY	ETF	454.88	454.88	454.45	454.52	2464.0
2023-07-25 06:30:00	SPY	ETF	454.53	454.7	454.44	454.65	14261.0
2023-07-25 07:00:00	SPY	ETF	454.65	454.92	454.65	454.92	27977.0
2023-07-25 07:30:00	SPY	ETF	454.85	454.85	454.64	454.77	16811.0
2023-07-25 08:00:00	SPY	ETF	454.8191	455.1796	454.18	454.52	81541.0
2023-07-25 08:30:00	SPY	ETF	454.52	454.59	454.3	454.34	31231.0
2023-07-25 09:00:00	SPY	ETF	454.3	454.3	453.84	453.91	119068.0
2023-07-25 09:30:00	SPY	ETF	453.92	455.13	453.87	454.785	4196171.0
2023-07-25 10:00:00	SPY	ETF	454.8199	455.05	454.45	454.7547	2527770.0
2023-07-25 10:30:00	SPY	ETF	454.745	454.85	454.41	454.6	2248129.0
2023-07-25 11:00:00	SPY	ETF	454.61	455.09	454.525	454.98	1602928.0
2023-07-25 11:30:00	SPY	ETF	455.0	455.6005	454.96	455.39	3055383.0
2023-07-25 12:00:00	SPY	ETF	455.385	455.59	455.215	455.375	1775759.0
2023-07-25 12:30:00	SPY	ETF	455.37	455.89	455.27	455.8899	1559291.0
2023-07-25 13:00:00	SPY	ETF	455.9	456.12	455.53	455.99	2332835.0
2023-07-25 13:30:00	SPY	ETF	455.995	456.13	455.763	455.82	1513973.0
2023-07-25 14:00:00	SPY	ETF	455.825	456.465	455.7	456.38	2255623.0
2023-07-25 14:30:00	SPY	ETF	456.385	456.735	455.77	455.8299	2991193.0
2023-07-25 15:00:00	SPY	ETF	455.825	456.275	455.76	455.98	2076376.0
2023-07-25 15:30:00	SPY	ETF	455.98	456.11	455.32	455.41	8605684.0
2023-07-25 16:00:00	SPY	ETF	455.4	456.35	454.95	456.13	3305772.0
2023-07-25 16:30:00	SPY	ETF	456.1104	456.41	456.02	456.33	327677.0
2023-07-25 17:00:00	SPY	ETF	456.35	456.379	456.0	456.07	51880.0
2023-07-25 17:30:00	SPY	ETF	456.1	456.38	455.9	456.25	41416.0
2023-07-25 18:00:00	SPY	ETF	456.25	456.43	455.0	455.3	125787.0
2023-07-25 18:30:00	SPY	ETF	455.25	455.37	455.1	455.24	18643.0
2023-07-25 19:00:00	SPY	ETF	455.22	455.31	455.11	455.3	21982.0
2023-07-25 19:30:00	SPY	ETF	455.22	455.39	455.21	455.3101	33205.0
2023-07-25 04:00:00	QQQ	ETF	376.94	377.59	376.87	377.58	32980.0
2023-07-25 04:30:00	QQQ	ETF	377.58	377.82	377.49	377.73	17886.0
2023-07-25 05:00:00	QQQ	ETF	377.71	377.78	377.6	377.76	5514.0
2023-07-25 05:30:00	QQQ	ETF	377.68	377.86	377.54	377.74	6148.0
2023-07-25 06:00:00	QQQ	ETF	377.68	377.68	377.2	377.28	28531.0
2023-07-25 06:30:00	QQQ	ETF	377.32	377.33	377.02	377.26	26578.0
2023-07-25 07:00:00	QQQ	ETF	377.28	377.6	377.26	377.6	35641.0
2023-07-25 07:30:00	QQQ	ETF	377.61	377.63	377.34	377.58	19026.0
2023-07-25 08:00:00	QQQ	ETF	377.43	377.8496	376.3	377.41	82358.0
2023-07-25 08:30:00	QQQ	ETF	377.43	377.52	377.28	377.35	67838.0
2023-07-25 09:00:00	QQQ	ETF	377.28	377.32	376.77	376.92	98881.0
2023-07-25 09:30:00	QQQ	ETF	376.95	378.85	376.93	378.71	3563869.0
2023-07-25 10:00:00	QQQ	ETF	378.76	378.91	377.861	377.88	2095681.0
2023-07-25 10:30:00	QQQ	ETF	377.89	378.09	377.29	377.53	1928335.0
2023-07-25 11:00:00	QQQ	ETF	377.53	378.56	377.47	378.39	1249638.0
2023-07-25 11:30:00	QQQ	ETF	378.39	379.25	378.32	378.85	1453743.0
2023-07-25 12:00:00	QQQ	ETF	378.85	379.13	378.535	378.8	1292679.0
2023-07-25 12:30:00	QQQ	ETF	378.795	379.54	378.51	379.4982	1112647.0

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

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