PREVIEW / etf_30min / 2021-10-18

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-10-18.parquet
  size:    628 KB
  rows:    24,196

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-10-18 04:00:00	SPY	ETF	445.1	445.62	444.35	444.75	68104.0
2021-10-18 04:30:00	SPY	ETF	444.76	444.76	444.38	444.41	12571.0
2021-10-18 05:00:00	SPY	ETF	444.37	444.43	444.08	444.41	19245.0
2021-10-18 05:30:00	SPY	ETF	444.57	444.57	444.11	444.19	2350.0
2021-10-18 06:00:00	SPY	ETF	444.19	444.32	443.7	444.07	15900.0
2021-10-18 06:30:00	SPY	ETF	444.08	444.42	444.08	444.24	33371.0
2021-10-18 07:00:00	SPY	ETF	444.16	445.02	444.16	445.02	195091.0
2021-10-18 07:30:00	SPY	ETF	445.04	445.04	444.43	444.51	103863.0
2021-10-18 08:00:00	SPY	ETF	443.9596	446.204	443.75	444.1	202258.0
2021-10-18 08:30:00	SPY	ETF	444.1	444.27	443.25	443.55	314381.0
2021-10-18 09:00:00	SPY	ETF	443.58	444.02	443.49	443.97	253946.0
2021-10-18 09:30:00	SPY	ETF	443.97	445.49	443.27	445.29	6683728.0
2021-10-18 10:00:00	SPY	ETF	445.3	445.77	445.1	445.72	2848189.0
2021-10-18 10:30:00	SPY	ETF	445.73	446.05	445.19	445.83	2513703.0
2021-10-18 11:00:00	SPY	ETF	445.82	446.99	445.79	446.465	2816041.0
2021-10-18 11:30:00	SPY	ETF	446.47	446.925	446.37	446.7941	1824589.0
2021-10-18 12:00:00	SPY	ETF	446.7899	447.02	446.6	446.77	1352213.0
2021-10-18 12:30:00	SPY	ETF	446.76	446.9	446.42	446.57	1111808.0
2021-10-18 13:00:00	SPY	ETF	446.58	446.9	446.52	446.8	917571.0
2021-10-18 13:30:00	SPY	ETF	446.81	446.9299	446.63	446.69	1020843.0
2021-10-18 14:00:00	SPY	ETF	446.69	446.79	446.45	446.73	2007013.0
2021-10-18 14:30:00	SPY	ETF	446.73	447.09	446.59	446.94	1772414.0
2021-10-18 15:00:00	SPY	ETF	446.94	447.36	446.78	447.0701	2884094.0
2021-10-18 15:30:00	SPY	ETF	447.07	447.55	446.85	447.2225	10645232.0
2021-10-18 16:00:00	SPY	ETF	447.23	447.28	447.05	447.1	3319771.0
2021-10-18 16:30:00	SPY	ETF	447.11	447.2	447.07	447.12	72333.0
2021-10-18 17:00:00	SPY	ETF	447.2	447.3	447.17	447.22	43182.0
2021-10-18 17:30:00	SPY	ETF	447.26	447.28	447.19	447.21	236059.0
2021-10-18 18:00:00	SPY	ETF	447.19	447.22	446.94	446.98	46519.0
2021-10-18 18:30:00	SPY	ETF	447.04	447.04	446.79	446.8	24961.0
2021-10-18 19:00:00	SPY	ETF	446.88	446.94	446.8	446.93	31639.0
2021-10-18 19:30:00	SPY	ETF	446.95	447.37	446.95	447.29	28680.0
2021-10-18 04:00:00	QQQ	ETF	368.23	368.23	367.08	367.78	34245.0
2021-10-18 04:30:00	QQQ	ETF	367.67	367.77	367.52	367.61	30601.0
2021-10-18 05:00:00	QQQ	ETF	367.58	367.71	367.25	367.69	77109.0
2021-10-18 05:30:00	QQQ	ETF	367.79	367.79	367.36	367.44	12120.0
2021-10-18 06:00:00	QQQ	ETF	367.38	367.53	366.85	367.15	28626.0
2021-10-18 06:30:00	QQQ	ETF	367.27	367.53	367.16	367.4	17917.0
2021-10-18 07:00:00	QQQ	ETF	367.39	368.61	367.39	368.61	82623.0
2021-10-18 07:30:00	QQQ	ETF	368.59	368.63	368.06	368.13	62750.0
2021-10-18 08:00:00	QQQ	ETF	367.8201	369.216	366.95	367.83	191174.0
2021-10-18 08:30:00	QQQ	ETF	367.87	368.1	366.9301	367.31	218555.0
2021-10-18 09:00:00	QQQ	ETF	367.34	367.65	367.17	367.6	151957.0
2021-10-18 09:30:00	QQQ	ETF	367.6	369.32	366.99	369.08	3764109.0
2021-10-18 10:00:00	QQQ	ETF	369.08	369.63	368.87	369.42	1752631.0
2021-10-18 10:30:00	QQQ	ETF	369.43	369.905	368.79	369.81	1797991.0
2021-10-18 11:00:00	QQQ	ETF	369.8195	370.69	369.8195	370.4013	2071324.0
2021-10-18 11:30:00	QQQ	ETF	370.41	371.02	370.32	370.7599	1362638.0
2021-10-18 12:00:00	QQQ	ETF	370.77	371.045	370.66	370.92	970729.0
2021-10-18 12:30:00	QQQ	ETF	370.92	371.19	370.82	371.06	937178.0

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

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