PREVIEW / etf_30min / 2021-11-09

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-11-09.parquet
  size:    633 KB
  rows:    24,705

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
2021-11-09 04:00:00	SPY	ETF	468.62	468.99	468.62	468.78	7135.0
2021-11-09 04:30:00	SPY	ETF	468.84	469.09	468.79	469.02	2331.0
2021-11-09 05:00:00	SPY	ETF	469.01	469.28	469.01	469.15	15579.0
2021-11-09 05:30:00	SPY	ETF	469.13	469.15	469.05	469.12	2974.0
2021-11-09 06:00:00	SPY	ETF	469.08	469.26	468.99	469.15	9710.0
2021-11-09 06:30:00	SPY	ETF	469.08	469.15	469.04	469.05	13331.0
2021-11-09 07:00:00	SPY	ETF	469.07	469.14	468.93	469.05	32045.0
2021-11-09 07:30:00	SPY	ETF	469.05	469.05	468.27	468.4	85891.0
2021-11-09 08:00:00	SPY	ETF	469.0404	469.1001	467.9	468.69	144767.0
2021-11-09 08:30:00	SPY	ETF	468.8	469.25	468.79	469.07	166827.0
2021-11-09 09:00:00	SPY	ETF	469.13	469.41	469.05	469.34	130189.0
2021-11-09 09:30:00	SPY	ETF	469.32	469.57	466.46	466.95	6114146.0
2021-11-09 10:00:00	SPY	ETF	466.95	467.56	466.15	467.2	6231480.0
2021-11-09 10:30:00	SPY	ETF	467.2	467.98	467.11	467.26	2861789.0
2021-11-09 11:00:00	SPY	ETF	467.26	467.64	466.31	466.69	2368882.0
2021-11-09 11:30:00	SPY	ETF	466.68	467.495	466.43	466.59	1794515.0
2021-11-09 12:00:00	SPY	ETF	466.56	466.87	465.88	466.42	2787280.0
2021-11-09 12:30:00	SPY	ETF	466.41	467.19	466.28	466.66	2064801.0
2021-11-09 13:00:00	SPY	ETF	466.66	467.13	466.4008	466.58	1435683.0
2021-11-09 13:30:00	SPY	ETF	466.58	466.86	465.94	466.17	1449005.0
2021-11-09 14:00:00	SPY	ETF	466.1682	467.06	466.04	466.69	1872409.0
2021-11-09 14:30:00	SPY	ETF	466.68	467.1697	466.56	467.14	1147776.0
2021-11-09 15:00:00	SPY	ETF	467.14	467.19	466.6	466.81	1609765.0
2021-11-09 15:30:00	SPY	ETF	466.81	467.495	466.53	467.39	5057979.0
2021-11-09 16:00:00	SPY	ETF	467.39	467.44	466.94	466.94	1502912.0
2021-11-09 16:30:00	SPY	ETF	466.95	467.38	466.95	467.01	496746.0
2021-11-09 17:00:00	SPY	ETF	466.89	467.14	466.89	466.95	17089.0
2021-11-09 17:30:00	SPY	ETF	466.93	467.09	466.93	467.06	20816.0
2021-11-09 18:00:00	SPY	ETF	467.03	467.03	466.69	466.79	69569.0
2021-11-09 18:30:00	SPY	ETF	466.74	466.91	466.66	466.73	23452.0
2021-11-09 19:00:00	SPY	ETF	466.76	466.99	466.6	466.64	30487.0
2021-11-09 19:30:00	SPY	ETF	466.67	466.71	466.42	466.48	62316.0
2021-11-09 04:00:00	QQQ	ETF	398.0	398.5	398.0	398.41	77521.0
2021-11-09 04:30:00	QQQ	ETF	398.42	398.61	398.33	398.61	214779.0
2021-11-09 05:00:00	QQQ	ETF	398.55	398.84	398.55	398.65	47524.0
2021-11-09 05:30:00	QQQ	ETF	398.7	398.83	398.59	398.8	5285.0
2021-11-09 06:00:00	QQQ	ETF	398.78	399.08	398.68	398.9	26387.0
2021-11-09 06:30:00	QQQ	ETF	398.86	398.88	398.76	398.76	13761.0
2021-11-09 07:00:00	QQQ	ETF	398.7	398.91	398.61	398.74	88322.0
2021-11-09 07:30:00	QQQ	ETF	398.71	398.79	398.21	398.45	87018.0
2021-11-09 08:00:00	QQQ	ETF	398.67	398.9804	397.3	398.85	136199.0
2021-11-09 08:30:00	QQQ	ETF	398.77	399.47	398.77	399.18	161778.0
2021-11-09 09:00:00	QQQ	ETF	399.16	399.43	399.1	399.2	76384.0
2021-11-09 09:30:00	QQQ	ETF	399.16	399.57	394.84	395.54	7345107.0
2021-11-09 10:00:00	QQQ	ETF	395.52	396.45	394.67	395.94	7797259.0
2021-11-09 10:30:00	QQQ	ETF	395.92	397.0	395.86	396.13	2738043.0
2021-11-09 11:00:00	QQQ	ETF	396.13	396.68	395.16	395.78	2556010.0
2021-11-09 11:30:00	QQQ	ETF	395.77	396.76	395.58	395.785	2608791.0
2021-11-09 12:00:00	QQQ	ETF	395.76	395.83	394.55	395.14	2700963.0
2021-11-09 12:30:00	QQQ	ETF	395.14	395.97	394.77	395.11	2214724.0

> showing 50 of 24,705 rows — these rows as CSV

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