PREVIEW / etf_30min / 2021-08-16

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-08-16.parquet
  size:    612 KB
  rows:    23,122

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-16 04:00:00	SPY	ETF	445.2	445.26	445.04	445.07	2321.0
2021-08-16 04:30:00	SPY	ETF	445.0	445.15	445.0	445.05	34596.0
2021-08-16 05:00:00	SPY	ETF	444.97	445.02	444.92	444.96	15096.0
2021-08-16 05:30:00	SPY	ETF	444.99	445.01	444.71	444.89	4551.0
2021-08-16 06:00:00	SPY	ETF	444.7	444.7	443.84	443.97	21759.0
2021-08-16 06:30:00	SPY	ETF	444.12	444.85	444.12	444.79	48474.0
2021-08-16 07:00:00	SPY	ETF	444.81	444.97	444.63	444.67	81461.0
2021-08-16 07:30:00	SPY	ETF	444.67	444.69	444.34	444.55	52838.0
2021-08-16 08:00:00	SPY	ETF	444.53	446.274	443.9204	444.17	122205.0
2021-08-16 08:30:00	SPY	ETF	444.24	444.44	444.15	444.29	124642.0
2021-08-16 09:00:00	SPY	ETF	444.29	444.62	444.25	444.53	164466.0
2021-08-16 09:30:00	SPY	ETF	444.54	444.75	443.0801	443.39	6644635.0
2021-08-16 10:00:00	SPY	ETF	443.39	444.13	442.92	443.1	5419715.0
2021-08-16 10:30:00	SPY	ETF	443.1	443.52	442.87	443.13	3474078.0
2021-08-16 11:00:00	SPY	ETF	443.12	443.83	443.07	443.7549	3033241.0
2021-08-16 11:30:00	SPY	ETF	443.75	444.4	443.69	444.18	2614747.0
2021-08-16 12:00:00	SPY	ETF	444.19	444.66	444.13	444.47	1900353.0
2021-08-16 12:30:00	SPY	ETF	444.48	444.93	444.28	444.885	1817872.0
2021-08-16 13:00:00	SPY	ETF	444.8801	445.27	444.805	445.16	1988201.0
2021-08-16 13:30:00	SPY	ETF	445.17	445.66	445.123	445.65	2186963.0
2021-08-16 14:00:00	SPY	ETF	445.65	446.0	445.52	445.7301	1990921.0
2021-08-16 14:30:00	SPY	ETF	445.735	446.42	445.735	446.11	2372752.0
2021-08-16 15:00:00	SPY	ETF	446.105	446.63	446.021	446.5	2422316.0
2021-08-16 15:30:00	SPY	ETF	446.5	447.11	446.215	447.02	8864490.0
2021-08-16 16:00:00	SPY	ETF	447.02	447.25	446.88	446.93	2305138.0
2021-08-16 16:30:00	SPY	ETF	446.92	446.97	446.61	446.8	263097.0
2021-08-16 17:00:00	SPY	ETF	446.84	446.97	446.82	446.86	468953.0
2021-08-16 17:30:00	SPY	ETF	446.85	446.91	446.85	446.87	11089.0
2021-08-16 18:00:00	SPY	ETF	446.85	446.85	446.56	446.68	131102.0
2021-08-16 18:30:00	SPY	ETF	446.65	446.66	446.49	446.65	129472.0
2021-08-16 19:00:00	SPY	ETF	446.63	446.69	446.57	446.68	8385.0
2021-08-16 19:30:00	SPY	ETF	446.68	446.81	446.66	446.74	20378.0
2021-08-16 04:00:00	QQQ	ETF	368.43	368.55	368.38	368.51	8149.0
2021-08-16 04:30:00	QQQ	ETF	368.48	368.48	368.29	368.31	7908.0
2021-08-16 05:00:00	QQQ	ETF	368.34	368.37	368.25	368.32	5432.0
2021-08-16 05:30:00	QQQ	ETF	368.33	368.33	368.04	368.24	9756.0
2021-08-16 06:00:00	QQQ	ETF	368.19	368.25	367.25	367.54	37036.0
2021-08-16 06:30:00	QQQ	ETF	367.6	367.93	367.57	367.87	18194.0
2021-08-16 07:00:00	QQQ	ETF	367.94	368.11	367.75	367.77	33573.0
2021-08-16 07:30:00	QQQ	ETF	367.77	367.79	367.4	367.57	26423.0
2021-08-16 08:00:00	QQQ	ETF	368.04	369.096	367.27	367.43	82108.0
2021-08-16 08:30:00	QQQ	ETF	367.35	367.7	367.35	367.46	76133.0
2021-08-16 09:00:00	QQQ	ETF	367.5	367.82	367.39	367.67	131853.0
2021-08-16 09:30:00	QQQ	ETF	367.67	368.45	366.24	366.505	3718951.0
2021-08-16 10:00:00	QQQ	ETF	366.48	366.72	364.3	364.48	4748098.0
2021-08-16 10:30:00	QQQ	ETF	364.49	364.92	363.7	364.0999	3820598.0
2021-08-16 11:00:00	QQQ	ETF	364.08	364.88	363.99	364.71	2256520.0
2021-08-16 11:30:00	QQQ	ETF	364.71	365.91	364.605	365.48	2220242.0
2021-08-16 12:00:00	QQQ	ETF	365.48	366.25	365.345	365.82	1329061.0
2021-08-16 12:30:00	QQQ	ETF	365.83	366.459	365.6	366.29	884480.0

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

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