PREVIEW / etf_30min / 2021-07-23

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-07-23.parquet
  size:    603 KB
  rows:    22,888

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-07-23 04:00:00	SPY	ETF	437.22	437.22	437.07	437.09	57988.0
2021-07-23 04:30:00	SPY	ETF	437.11	437.37	437.1	437.3	5937.0
2021-07-23 05:00:00	SPY	ETF	437.27	437.43	437.25	437.38	8405.0
2021-07-23 05:30:00	SPY	ETF	437.37	437.65	437.37	437.61	3245.0
2021-07-23 06:00:00	SPY	ETF	437.47	437.56	437.43	437.52	19519.0
2021-07-23 06:30:00	SPY	ETF	437.53	437.63	437.5	437.57	20010.0
2021-07-23 07:00:00	SPY	ETF	437.57	437.59	437.15	437.2	61071.0
2021-07-23 07:30:00	SPY	ETF	437.23	437.43	437.2	437.4	40949.0
2021-07-23 08:00:00	SPY	ETF	437.5699	438.0	437.0	437.61	141036.0
2021-07-23 08:30:00	SPY	ETF	437.61	437.65	437.25	437.33	83855.0
2021-07-23 09:00:00	SPY	ETF	437.32	437.61	437.16	437.53	201954.0
2021-07-23 09:30:00	SPY	ETF	437.53	437.65	436.79	436.98	5563535.0
2021-07-23 10:00:00	SPY	ETF	436.975	437.58	436.95	437.555	3401038.0
2021-07-23 10:30:00	SPY	ETF	437.5519	438.38	437.4	438.3099	3403185.0
2021-07-23 11:00:00	SPY	ETF	438.3	439.27	438.27	439.235	3512837.0
2021-07-23 11:30:00	SPY	ETF	439.235	439.5	438.72	438.73	3701641.0
2021-07-23 12:00:00	SPY	ETF	438.74	439.23	438.71	439.0389	2396908.0
2021-07-23 12:30:00	SPY	ETF	439.04	439.375	438.93	439.351	1605276.0
2021-07-23 13:00:00	SPY	ETF	439.36	440.04	439.3499	439.8201	2391660.0
2021-07-23 13:30:00	SPY	ETF	439.815	440.0	439.51	439.77	1812167.0
2021-07-23 14:00:00	SPY	ETF	439.765	440.0	439.58	439.739	2109697.0
2021-07-23 14:30:00	SPY	ETF	439.74	439.86	439.58	439.74	2019999.0
2021-07-23 15:00:00	SPY	ETF	439.74	439.775	439.16	439.62	2440692.0
2021-07-23 15:30:00	SPY	ETF	439.615	440.3	439.3	439.89	8448031.0
2021-07-23 16:00:00	SPY	ETF	439.89	439.94	439.59	439.66	2867212.0
2021-07-23 16:30:00	SPY	ETF	439.65	439.94	439.36	439.39	196485.0
2021-07-23 17:00:00	SPY	ETF	439.4401	439.65	439.4401	439.48	33574.0
2021-07-23 17:30:00	SPY	ETF	439.48	439.48	439.22	439.25	27587.0
2021-07-23 18:00:00	SPY	ETF	439.3	439.37	439.25	439.3	4755.0
2021-07-23 18:30:00	SPY	ETF	439.94	439.94	439.25	439.32	7434.0
2021-07-23 19:00:00	SPY	ETF	439.31	439.36	439.26	439.36	2324.0
2021-07-23 19:30:00	SPY	ETF	439.34	439.37	439.2	439.26	10649.0
2021-07-23 04:00:00	QQQ	ETF	365.47	365.79	365.42	365.66	23227.0
2021-07-23 04:30:00	QQQ	ETF	365.7	365.84	365.55	365.55	12403.0
2021-07-23 05:00:00	QQQ	ETF	365.65	365.75	365.65	365.71	3723.0
2021-07-23 05:30:00	QQQ	ETF	365.74	366.0	365.74	365.78	14776.0
2021-07-23 06:00:00	QQQ	ETF	365.76	365.78	365.66	365.71	7861.0
2021-07-23 06:30:00	QQQ	ETF	365.66	365.75	365.6	365.63	9671.0
2021-07-23 07:00:00	QQQ	ETF	365.67	365.71	365.21	365.25	55304.0
2021-07-23 07:30:00	QQQ	ETF	365.24	365.25	365.05	365.21	46251.0
2021-07-23 08:00:00	QQQ	ETF	365.69	365.7596	365.06	365.21	83205.0
2021-07-23 08:30:00	QQQ	ETF	365.2	365.34	364.93	364.99	91198.0
2021-07-23 09:00:00	QQQ	ETF	364.9699	365.3	364.83	365.29	127180.0
2021-07-23 09:30:00	QQQ	ETF	365.31	365.5	364.04	365.08	3092793.0
2021-07-23 10:00:00	QQQ	ETF	365.08	365.76	364.95	365.56	1745751.0
2021-07-23 10:30:00	QQQ	ETF	365.569	366.12	365.4701	366.01	1599065.0
2021-07-23 11:00:00	QQQ	ETF	366.02	367.075	365.82	367.045	1375868.0
2021-07-23 11:30:00	QQQ	ETF	367.05	367.585	367.02	367.32	1715370.0
2021-07-23 12:00:00	QQQ	ETF	367.33	367.62	367.06	367.29	1133746.0
2021-07-23 12:30:00	QQQ	ETF	367.3	367.6796	367.18	367.65	839505.0

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

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