PREVIEW / etf_30min / 2021-08-12

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-08-12.parquet
  size:    593 KB
  rows:    22,276

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-12 04:00:00	SPY	ETF	443.66	443.66	443.53	443.53	2463.0
2021-08-12 04:30:00	SPY	ETF	443.73	443.78	443.73	443.78	2540.0
2021-08-12 05:00:00	SPY	ETF	443.78	443.78	443.66	443.77	800.0
2021-08-12 05:30:00	SPY	ETF	443.73	443.83	443.73	443.83	1062.0
2021-08-12 06:00:00	SPY	ETF	443.8	443.82	443.76	443.8	3801.0
2021-08-12 06:30:00	SPY	ETF	443.8	444.04	443.8	443.93	26662.0
2021-08-12 07:00:00	SPY	ETF	443.92	444.04	443.88	443.92	24815.0
2021-08-12 07:30:00	SPY	ETF	443.93	443.98	443.9	443.9	37657.0
2021-08-12 08:00:00	SPY	ETF	443.91	444.072	443.61	443.72	87807.0
2021-08-12 08:30:00	SPY	ETF	443.68	443.76	443.44	443.53	150188.0
2021-08-12 09:00:00	SPY	ETF	443.51	443.75	443.45	443.63	118232.0
2021-08-12 09:30:00	SPY	ETF	443.62	443.62	442.89	443.135	4128404.0
2021-08-12 10:00:00	SPY	ETF	443.14	443.43	442.66	443.42	2559985.0
2021-08-12 10:30:00	SPY	ETF	443.41	443.77	443.36	443.75	2547886.0
2021-08-12 11:00:00	SPY	ETF	443.75	443.87	443.38	443.76	2012305.0
2021-08-12 11:30:00	SPY	ETF	443.76	444.11	443.66	443.8858	1594473.0
2021-08-12 12:00:00	SPY	ETF	443.88	444.37	443.88	444.305	1806067.0
2021-08-12 12:30:00	SPY	ETF	444.3	444.45	444.26	444.335	1371351.0
2021-08-12 13:00:00	SPY	ETF	444.33	444.34	444.12	444.3291	908343.0
2021-08-12 13:30:00	SPY	ETF	444.3228	444.5	444.29	444.358	998330.0
2021-08-12 14:00:00	SPY	ETF	444.355	444.65	444.27	444.57	1327996.0
2021-08-12 14:30:00	SPY	ETF	444.57	444.9	444.535	444.8518	1461871.0
2021-08-12 15:00:00	SPY	ETF	444.85	445.08	444.85	445.025	1818241.0
2021-08-12 15:30:00	SPY	ETF	445.03	445.2572	444.78	445.07	6102693.0
2021-08-12 16:00:00	SPY	ETF	445.07	445.11	444.8429	445.05	1827022.0
2021-08-12 16:30:00	SPY	ETF	445.05	445.23	445.05	445.2	343266.0
2021-08-12 17:00:00	SPY	ETF	445.17	445.26	445.1	445.17	23571.0
2021-08-12 17:30:00	SPY	ETF	445.15	445.25	445.09	445.15	28584.0
2021-08-12 18:00:00	SPY	ETF	445.15	445.15	444.96	444.98	13142.0
2021-08-12 18:30:00	SPY	ETF	445.11	445.11	444.98	445.02	2425.0
2021-08-12 19:00:00	SPY	ETF	445.0	445.01	444.97	445.01	6484.0
2021-08-12 19:30:00	SPY	ETF	445.03	445.03	444.87	444.9	16441.0
2021-08-12 04:00:00	QQQ	ETF	365.6	365.76	365.56	365.76	3271.0
2021-08-12 04:30:00	QQQ	ETF	365.78	365.96	365.78	365.83	7363.0
2021-08-12 05:00:00	QQQ	ETF	365.86	365.92	365.74	365.92	6926.0
2021-08-12 05:30:00	QQQ	ETF	365.83	365.83	365.72	365.79	1680.0
2021-08-12 06:00:00	QQQ	ETF	365.95	366.21	365.87	366.18	4565.0
2021-08-12 06:30:00	QQQ	ETF	366.2	366.49	366.2	366.38	22568.0
2021-08-12 07:00:00	QQQ	ETF	366.31	366.37	366.11	366.23	79597.0
2021-08-12 07:30:00	QQQ	ETF	366.31	366.43	366.28	366.28	33921.0
2021-08-12 08:00:00	QQQ	ETF	366.34	366.484	366.07	366.25	70058.0
2021-08-12 08:30:00	QQQ	ETF	366.05	366.11	365.38	365.44	256821.0
2021-08-12 09:00:00	QQQ	ETF	365.44	365.77	365.35	365.66	73924.0
2021-08-12 09:30:00	QQQ	ETF	365.68	365.8	364.42	365.12	3944537.0
2021-08-12 10:00:00	QQQ	ETF	365.11	366.235	364.295	366.18	3017671.0
2021-08-12 10:30:00	QQQ	ETF	366.19	367.04	366.19	366.98	1590181.0
2021-08-12 11:00:00	QQQ	ETF	366.98	367.07	366.56	366.8	1372168.0
2021-08-12 11:30:00	QQQ	ETF	366.79	367.52	366.76	367.14	1415078.0
2021-08-12 12:00:00	QQQ	ETF	367.15	367.255	366.825	366.89	1058628.0
2021-08-12 12:30:00	QQQ	ETF	366.9	367.06	366.645	366.76	723858.0

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

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