PREVIEW / etf_30min / 2021-07-08

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-07-08.parquet
  size:    623 KB
  rows:    24,397

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-08 04:00:00	SPY	ETF	431.09	433.02	429.75	430.11	54495.0
2021-07-08 04:30:00	SPY	ETF	429.9	430.57	429.75	430.4	76207.0
2021-07-08 05:00:00	SPY	ETF	430.41	430.51	429.13	429.78	156464.0
2021-07-08 05:30:00	SPY	ETF	429.89	430.2	429.42	429.51	66460.0
2021-07-08 06:00:00	SPY	ETF	429.29	429.29	427.6	427.93	379472.0
2021-07-08 06:30:00	SPY	ETF	427.82	429.0	427.69	428.97	191685.0
2021-07-08 07:00:00	SPY	ETF	428.97	429.25	428.56	429.14	352709.0
2021-07-08 07:30:00	SPY	ETF	429.01	429.05	428.15	428.31	539938.0
2021-07-08 08:00:00	SPY	ETF	428.31	433.69	427.49	428.77	632025.0
2021-07-08 08:30:00	SPY	ETF	428.71	429.18	428.28	428.58	605335.0
2021-07-08 09:00:00	SPY	ETF	428.65	428.79	428.15	428.78	381689.0
2021-07-08 09:30:00	SPY	ETF	428.78	429.595	427.61	429.45	12222215.0
2021-07-08 10:00:00	SPY	ETF	429.45	429.46	427.52	428.96	7392968.0
2021-07-08 10:30:00	SPY	ETF	428.97	429.1715	427.86	428.14	6522464.0
2021-07-08 11:00:00	SPY	ETF	428.15	430.01	427.98	429.9	4882279.0
2021-07-08 11:30:00	SPY	ETF	429.9	431.1	429.53	430.93	4093119.0
2021-07-08 12:00:00	SPY	ETF	430.91	431.25	430.645	431.11	2994205.0
2021-07-08 12:30:00	SPY	ETF	431.1	431.73	431.08	431.55	2611905.0
2021-07-08 13:00:00	SPY	ETF	431.55	431.64	430.86	431.41	2876930.0
2021-07-08 13:30:00	SPY	ETF	431.41	431.58	430.87	430.98	2309798.0
2021-07-08 14:00:00	SPY	ETF	430.99	431.04	430.01	430.17	3096736.0
2021-07-08 14:30:00	SPY	ETF	430.18	430.5	429.83	430.27	3354744.0
2021-07-08 15:00:00	SPY	ETF	430.26	430.61	429.588	430.16	4765140.0
2021-07-08 15:30:00	SPY	ETF	430.17	430.98	429.145	430.95	14132701.0
2021-07-08 16:00:00	SPY	ETF	430.94	434.4301	430.2	430.53	4104662.0
2021-07-08 16:30:00	SPY	ETF	430.51	430.59	430.43	430.54	153797.0
2021-07-08 17:00:00	SPY	ETF	430.38	430.52	430.38	430.51	23671.0
2021-07-08 17:30:00	SPY	ETF	430.51	430.57	430.46	430.56	16915.0
2021-07-08 18:00:00	SPY	ETF	430.52	430.68	430.37	430.68	43470.0
2021-07-08 18:30:00	SPY	ETF	430.59	430.59	430.2399	430.3	27398.0
2021-07-08 19:00:00	SPY	ETF	430.3	430.56	430.29	430.55	17759.0
2021-07-08 19:30:00	SPY	ETF	430.55	430.68	430.23	430.26	25199.0
2021-07-08 04:00:00	QQQ	ETF	360.5	360.5	356.97	357.08	95125.0
2021-07-08 04:30:00	QQQ	ETF	357.04	357.54	356.89	357.23	56881.0
2021-07-08 05:00:00	QQQ	ETF	357.23	357.32	356.2	356.54	39508.0
2021-07-08 05:30:00	QQQ	ETF	356.73	357.11	356.25	356.42	280098.0
2021-07-08 06:00:00	QQQ	ETF	356.32	356.36	355.21	355.52	224087.0
2021-07-08 06:30:00	QQQ	ETF	355.48	356.73	355.35	356.72	216882.0
2021-07-08 07:00:00	QQQ	ETF	356.73	356.86	356.12	356.35	286350.0
2021-07-08 07:30:00	QQQ	ETF	356.35	356.35	355.49	355.59	249344.0
2021-07-08 08:00:00	QQQ	ETF	356.0304	360.0	354.57	355.52	411092.0
2021-07-08 08:30:00	QQQ	ETF	355.5	356.19	355.3	355.798	412190.0
2021-07-08 09:00:00	QQQ	ETF	355.83	356.32	355.4	355.74	328263.0
2021-07-08 09:30:00	QQQ	ETF	355.74	356.88	354.42	356.78	9039725.0
2021-07-08 10:00:00	QQQ	ETF	356.77	357.1	355.33	356.93	4134890.0
2021-07-08 10:30:00	QQQ	ETF	356.92	357.24	355.32	355.36	2922393.0
2021-07-08 11:00:00	QQQ	ETF	355.41	357.1	355.04	356.95	2397213.0
2021-07-08 11:30:00	QQQ	ETF	356.95	357.97	356.23	357.81	2352136.0
2021-07-08 12:00:00	QQQ	ETF	357.81	358.24	357.38	358.17	1426672.0
2021-07-08 12:30:00	QQQ	ETF	358.17	358.87	358.14	358.54	1628808.0

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

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