PREVIEW / etf_30min / 2021-08-05

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-08-05.parquet
  size:    596 KB
  rows:    22,453

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-05 04:00:00	SPY	ETF	439.8	439.8	439.59	439.68	4210.0
2021-08-05 04:30:00	SPY	ETF	439.71	439.97	439.6	439.88	19205.0
2021-08-05 05:00:00	SPY	ETF	439.98	440.23	439.98	440.11	3500.0
2021-08-05 05:30:00	SPY	ETF	440.17	440.47	440.08	440.38	10149.0
2021-08-05 06:00:00	SPY	ETF	440.39	440.39	439.94	439.99	33157.0
2021-08-05 06:30:00	SPY	ETF	440.01	440.12	439.86	439.95	19091.0
2021-08-05 07:00:00	SPY	ETF	439.94	440.0	439.8	439.86	117307.0
2021-08-05 07:30:00	SPY	ETF	439.88	440.22	439.86	440.15	103750.0
2021-08-05 08:00:00	SPY	ETF	439.8801	440.25	439.82	440.15	113310.0
2021-08-05 08:30:00	SPY	ETF	440.13	440.27	439.73	439.84	106706.0
2021-08-05 09:00:00	SPY	ETF	439.86	440.22	439.79	440.21	141385.0
2021-08-05 09:30:00	SPY	ETF	440.22	440.81	439.88	440.795	4727329.0
2021-08-05 10:00:00	SPY	ETF	440.8	440.89	440.33	440.46	2484447.0
2021-08-05 10:30:00	SPY	ETF	440.465	441.075	440.4	440.975	1782392.0
2021-08-05 11:00:00	SPY	ETF	440.98	441.11	440.81	441.05	1543579.0
2021-08-05 11:30:00	SPY	ETF	441.04	441.13	440.775	440.8831	1380024.0
2021-08-05 12:00:00	SPY	ETF	440.89	441.02	440.74	440.805	1405395.0
2021-08-05 12:30:00	SPY	ETF	440.805	440.89	440.44	440.45	924859.0
2021-08-05 13:00:00	SPY	ETF	440.455	440.8	440.41	440.7425	1099728.0
2021-08-05 13:30:00	SPY	ETF	440.74	441.0	440.71	440.98	940793.0
2021-08-05 14:00:00	SPY	ETF	440.99	441.14	440.79	440.8201	1636932.0
2021-08-05 14:30:00	SPY	ETF	440.82	440.96	440.67	440.74	1551286.0
2021-08-05 15:00:00	SPY	ETF	440.74	440.965	440.65	440.845	1826479.0
2021-08-05 15:30:00	SPY	ETF	440.8379	441.85	440.79	441.76	6104441.0
2021-08-05 16:00:00	SPY	ETF	441.77	441.77	441.48	441.58	2148818.0
2021-08-05 16:30:00	SPY	ETF	441.61	441.71	439.1133	441.68	289203.0
2021-08-05 17:00:00	SPY	ETF	441.7	441.7	441.6	441.65	20390.0
2021-08-05 17:30:00	SPY	ETF	441.66	441.74	441.59	441.6	39338.0
2021-08-05 18:00:00	SPY	ETF	441.6	441.63	441.51	441.51	29568.0
2021-08-05 18:30:00	SPY	ETF	441.76	441.76	441.43	441.46	19336.0
2021-08-05 19:00:00	SPY	ETF	441.46	441.46	441.38	441.38	6267.0
2021-08-05 19:30:00	SPY	ETF	441.38	441.41	441.31	441.31	27030.0
2021-08-05 04:00:00	QQQ	ETF	367.91	367.93	367.75	367.89	12840.0
2021-08-05 04:30:00	QQQ	ETF	367.86	368.0	367.86	367.98	25569.0
2021-08-05 05:00:00	QQQ	ETF	367.92	368.15	367.92	368.1	10889.0
2021-08-05 05:30:00	QQQ	ETF	368.2	368.48	368.09	368.44	12402.0
2021-08-05 06:00:00	QQQ	ETF	368.35	368.53	368.27	368.3	21898.0
2021-08-05 06:30:00	QQQ	ETF	368.24	368.39	368.2	368.24	15037.0
2021-08-05 07:00:00	QQQ	ETF	368.23	368.33	368.1	368.21	18511.0
2021-08-05 07:30:00	QQQ	ETF	368.25	368.53	368.25	368.44	18457.0
2021-08-05 08:00:00	QQQ	ETF	368.44	368.52	367.57	368.23	31010.0
2021-08-05 08:30:00	QQQ	ETF	368.13	368.28	367.95	368.03	46554.0
2021-08-05 09:00:00	QQQ	ETF	368.0	368.22	367.98	368.14	64640.0
2021-08-05 09:30:00	QQQ	ETF	368.14	368.84	367.45	368.74	2972714.0
2021-08-05 10:00:00	QQQ	ETF	368.75	368.9368	368.21	368.7617	1850146.0
2021-08-05 10:30:00	QQQ	ETF	368.76	369.42	368.51	369.2499	1593276.0
2021-08-05 11:00:00	QQQ	ETF	369.25	369.75	369.205	369.3782	1397248.0
2021-08-05 11:30:00	QQQ	ETF	369.4	369.63	369.13	369.2992	913961.0
2021-08-05 12:00:00	QQQ	ETF	369.29	369.41	369.0301	369.31	960855.0
2021-08-05 12:30:00	QQQ	ETF	369.32	369.47	369.05	369.105	664509.0

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

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