PREVIEW / etf_30min / 2021-07-29

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-07-29.parquet
  size:    610 KB
  rows:    23,066

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-29 04:00:00	SPY	ETF	438.93	439.46	438.93	439.22	2499.0
2021-07-29 04:30:00	SPY	ETF	439.33	439.52	439.33	439.41	1243.0
2021-07-29 05:00:00	SPY	ETF	439.43	439.45	439.43	439.45	5123.0
2021-07-29 05:30:00	SPY	ETF	439.33	439.79	439.33	439.79	1650.0
2021-07-29 06:00:00	SPY	ETF	439.67	439.84	439.67	439.69	5045.0
2021-07-29 06:30:00	SPY	ETF	439.7	439.71	439.18	439.5	7745.0
2021-07-29 07:00:00	SPY	ETF	439.61	439.75	439.28	439.4	110675.0
2021-07-29 07:30:00	SPY	ETF	439.39	439.59	439.24	439.59	63778.0
2021-07-29 08:00:00	SPY	ETF	439.53	440.0	439.089	439.71	146032.0
2021-07-29 08:30:00	SPY	ETF	439.71	439.78	439.48	439.73	116965.0
2021-07-29 09:00:00	SPY	ETF	439.75	440.05	439.72	439.84	159429.0
2021-07-29 09:30:00	SPY	ETF	439.83	441.1	439.81	440.76	5329384.0
2021-07-29 10:00:00	SPY	ETF	440.76	440.97	440.38	440.97	2544192.0
2021-07-29 10:30:00	SPY	ETF	440.97	441.5	440.835	441.5	3172381.0
2021-07-29 11:00:00	SPY	ETF	441.5	441.7	441.11	441.175	3525510.0
2021-07-29 11:30:00	SPY	ETF	441.175	441.485	441.1301	441.21	2230966.0
2021-07-29 12:00:00	SPY	ETF	441.2	441.745	441.18	441.6	1505686.0
2021-07-29 12:30:00	SPY	ETF	441.59	441.71	441.25	441.3619	1161256.0
2021-07-29 13:00:00	SPY	ETF	441.37	441.78	441.34	441.72	1230334.0
2021-07-29 13:30:00	SPY	ETF	441.71	441.8	441.42	441.52	1236789.0
2021-07-29 14:00:00	SPY	ETF	441.52	441.63	441.24	441.301	1409690.0
2021-07-29 14:30:00	SPY	ETF	441.31	441.37	440.95	441.14	1689222.0
2021-07-29 15:00:00	SPY	ETF	441.15	441.155	440.87	440.91	2682264.0
2021-07-29 15:30:00	SPY	ETF	440.91	441.07	440.65	440.68	5672290.0
2021-07-29 16:00:00	SPY	ETF	440.68	440.92	439.94	439.99	2341566.0
2021-07-29 16:30:00	SPY	ETF	440.01	440.65	438.97	439.2	561941.0
2021-07-29 17:00:00	SPY	ETF	439.05	439.56	439.0	439.3	94245.0
2021-07-29 17:30:00	SPY	ETF	439.23	440.7	438.8	438.85	299902.0
2021-07-29 18:00:00	SPY	ETF	438.85	439.5	438.85	439.25	90202.0
2021-07-29 18:30:00	SPY	ETF	440.65	440.65	439.0	439.12	38230.0
2021-07-29 19:00:00	SPY	ETF	439.1	439.18	438.61	438.78	30214.0
2021-07-29 19:30:00	SPY	ETF	438.74	438.8	438.14	438.2	36086.0
2021-07-29 04:00:00	QQQ	ETF	366.0	366.0	365.405	365.6	30835.0
2021-07-29 04:30:00	QQQ	ETF	365.53	365.67	365.53	365.58	8976.0
2021-07-29 05:00:00	QQQ	ETF	365.6	365.61	365.49	365.61	2720.0
2021-07-29 05:30:00	QQQ	ETF	365.65	365.85	365.65	365.84	8000.0
2021-07-29 06:00:00	QQQ	ETF	365.67	365.78	365.53	365.61	6055.0
2021-07-29 06:30:00	QQQ	ETF	365.54	365.57	364.77	365.09	52410.0
2021-07-29 07:00:00	QQQ	ETF	365.07	365.44	365.07	365.21	99062.0
2021-07-29 07:30:00	QQQ	ETF	365.2	365.61	365.11	365.61	61790.0
2021-07-29 08:00:00	QQQ	ETF	364.8496	366.104	364.7496	365.71	124874.0
2021-07-29 08:30:00	QQQ	ETF	365.78	366.13	365.3	365.47	145647.0
2021-07-29 09:00:00	QQQ	ETF	365.56	365.62	365.25	365.25	91822.0
2021-07-29 09:30:00	QQQ	ETF	365.25	367.59	365.25	366.96	3809291.0
2021-07-29 10:00:00	QQQ	ETF	366.97	367.21	366.17	367.21	1706919.0
2021-07-29 10:30:00	QQQ	ETF	367.21	367.595	366.8408	367.37	1357151.0
2021-07-29 11:00:00	QQQ	ETF	367.38	367.6794	367.18	367.31	1002076.0
2021-07-29 11:30:00	QQQ	ETF	367.35	367.58	366.81	366.905	836855.0
2021-07-29 12:00:00	QQQ	ETF	366.89	367.57	366.87	367.335	896750.0
2021-07-29 12:30:00	QQQ	ETF	367.35	367.388	366.72	366.95	732819.0

> showing 50 of 23,066 rows — these rows as CSV

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