PREVIEW / etf_30min / 2021-08-20

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-08-20.parquet
  size:    609 KB
  rows:    22,687

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-08-20 04:00:00	SPY	ETF	437.57	438.07	437.15	437.52	23050.0
2021-08-20 04:30:00	SPY	ETF	437.4	437.98	437.36	437.96	6376.0
2021-08-20 05:00:00	SPY	ETF	437.73	438.2	437.63	438.19	16400.0
2021-08-20 05:30:00	SPY	ETF	438.3	438.65	437.99	438.08	18359.0
2021-08-20 06:00:00	SPY	ETF	438.08	438.35	437.84	438.2	12800.0
2021-08-20 06:30:00	SPY	ETF	438.23	438.3	438.04	438.08	88942.0
2021-08-20 07:00:00	SPY	ETF	438.08	438.33	437.58	438.26	116079.0
2021-08-20 07:30:00	SPY	ETF	438.29	438.57	437.96	437.96	201214.0
2021-08-20 08:00:00	SPY	ETF	438.0101	440.239	437.0	438.37	178619.0
2021-08-20 08:30:00	SPY	ETF	438.38	439.65	438.23	439.65	255536.0
2021-08-20 09:00:00	SPY	ETF	439.67	440.64	439.5	440.2	542799.0
2021-08-20 09:30:00	SPY	ETF	440.23	442.08	439.71	441.845	7118360.0
2021-08-20 10:00:00	SPY	ETF	441.85	442.95	441.74	442.55	5748026.0
2021-08-20 10:30:00	SPY	ETF	442.5516	443.01	442.05	442.19	3534594.0
2021-08-20 11:00:00	SPY	ETF	442.17	442.585	442.01	442.19	2606499.0
2021-08-20 11:30:00	SPY	ETF	442.18	442.78	441.961	442.43	2550419.0
2021-08-20 12:00:00	SPY	ETF	442.44	443.26	442.33	443.24	2246143.0
2021-08-20 12:30:00	SPY	ETF	443.23	443.55	443.17	443.22	2190977.0
2021-08-20 13:00:00	SPY	ETF	443.22	443.54	443.19	443.215	1376579.0
2021-08-20 13:30:00	SPY	ETF	443.22	443.33	442.72	442.78	2184512.0
2021-08-20 14:00:00	SPY	ETF	442.79	443.21	442.52	442.65	2610031.0
2021-08-20 14:30:00	SPY	ETF	442.66	442.88	442.46	442.83	2007063.0
2021-08-20 15:00:00	SPY	ETF	442.83	443.39	442.72	443.365	2983846.0
2021-08-20 15:30:00	SPY	ETF	443.365	443.71	443.19	443.33	9706698.0
2021-08-20 16:00:00	SPY	ETF	443.33	443.3945	443.0	443.25	2816709.0
2021-08-20 16:30:00	SPY	ETF	443.25	443.48	443.22	443.45	276499.0
2021-08-20 17:00:00	SPY	ETF	443.32	443.56	443.31	443.56	22181.0
2021-08-20 17:30:00	SPY	ETF	443.53	443.58	443.38	443.54	39441.0
2021-08-20 18:00:00	SPY	ETF	443.53	443.55	443.45	443.54	1377.0
2021-08-20 18:30:00	SPY	ETF	443.46	443.5	443.46	443.47	3035.0
2021-08-20 19:00:00	SPY	ETF	443.49	443.62	443.49	443.62	9406.0
2021-08-20 19:30:00	SPY	ETF	443.59	443.65	443.5101	443.63	8314.0
2021-08-20 04:00:00	QQQ	ETF	362.96	363.08	362.4	362.58	28465.0
2021-08-20 04:30:00	QQQ	ETF	362.55	363.04	362.48	362.88	15415.0
2021-08-20 05:00:00	QQQ	ETF	363.0	363.3	362.64	363.3	12200.0
2021-08-20 05:30:00	QQQ	ETF	363.25	363.51	363.06	363.13	17398.0
2021-08-20 06:00:00	QQQ	ETF	363.17	363.28	362.85	363.17	19463.0
2021-08-20 06:30:00	QQQ	ETF	363.04	363.26	362.97	363.08	5359.0
2021-08-20 07:00:00	QQQ	ETF	363.08	363.34	362.74	363.34	41918.0
2021-08-20 07:30:00	QQQ	ETF	363.33	363.6	363.27	363.27	19241.0
2021-08-20 08:00:00	QQQ	ETF	362.73	364.232	362.73	363.87	67578.0
2021-08-20 08:30:00	QQQ	ETF	363.93	364.67	363.84	364.67	92205.0
2021-08-20 09:00:00	QQQ	ETF	364.7	365.41	364.53	365.05	323479.0
2021-08-20 09:30:00	QQQ	ETF	365.05	366.83	364.74	366.7	5703656.0
2021-08-20 10:00:00	QQQ	ETF	366.7	367.915	366.61	367.45	3341716.0
2021-08-20 10:30:00	QQQ	ETF	367.46	368.08	367.28	367.35	2244669.0
2021-08-20 11:00:00	QQQ	ETF	367.32	367.45	366.84	366.91	1656496.0
2021-08-20 11:30:00	QQQ	ETF	366.88	367.37	365.74	366.11	1836574.0
2021-08-20 12:00:00	QQQ	ETF	366.1	367.08	365.94	367.06	1424982.0
2021-08-20 12:30:00	QQQ	ETF	367.07	367.46	367.06	367.315	1054626.0

> showing 50 of 22,687 rows — these rows as CSV

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