PREVIEW / etf_30min / 2021-08-04

all etf 30-min files

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

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-04 04:00:00	SPY	ETF	440.56	440.69	440.38	440.68	2914.0
2021-08-04 04:30:00	SPY	ETF	440.7	440.7	440.7	440.7	100.0
2021-08-04 05:00:00	SPY	ETF	440.74	440.79	440.66	440.72	2038.0
2021-08-04 05:30:00	SPY	ETF	440.7	440.9	440.7	440.8	3042.0
2021-08-04 06:00:00	SPY	ETF	440.79	440.83	440.72	440.8	1980.0
2021-08-04 06:30:00	SPY	ETF	440.9	441.0	440.78	440.82	4286.0
2021-08-04 07:00:00	SPY	ETF	440.83	440.84	440.55	440.59	66333.0
2021-08-04 07:30:00	SPY	ETF	440.59	440.59	440.27	440.28	43923.0
2021-08-04 08:00:00	SPY	ETF	440.7499	440.84	439.67	439.76	207822.0
2021-08-04 08:30:00	SPY	ETF	439.81	440.04	439.39	439.75	332874.0
2021-08-04 09:00:00	SPY	ETF	439.7	439.89	439.41	439.78	198127.0
2021-08-04 09:30:00	SPY	ETF	439.77	440.196	439.47	439.91	5443950.0
2021-08-04 10:00:00	SPY	ETF	439.93	440.405	439.655	439.75	3416032.0
2021-08-04 10:30:00	SPY	ETF	439.75	440.04	439.04	439.42	3187570.0
2021-08-04 11:00:00	SPY	ETF	439.42	439.91	439.15	439.2658	2087594.0
2021-08-04 11:30:00	SPY	ETF	439.27	439.485	438.73	439.4199	2769949.0
2021-08-04 12:00:00	SPY	ETF	439.41	439.719	439.2	439.3	1784449.0
2021-08-04 12:30:00	SPY	ETF	439.31	439.595	439.2	439.57	1325262.0
2021-08-04 13:00:00	SPY	ETF	439.57	440.12	439.56	439.86	1476546.0
2021-08-04 13:30:00	SPY	ETF	439.86	439.99	439.63	439.83	1211069.0
2021-08-04 14:00:00	SPY	ETF	439.84	440.17	439.75	440.0758	1735843.0
2021-08-04 14:30:00	SPY	ETF	440.075	440.28	439.6	439.6943	2210341.0
2021-08-04 15:00:00	SPY	ETF	439.7	439.89	439.355	439.71	2097240.0
2021-08-04 15:30:00	SPY	ETF	439.72	439.91	438.97	439.01	5449399.0
2021-08-04 16:00:00	SPY	ETF	439.02	439.27	438.97	439.12	1958783.0
2021-08-04 16:30:00	SPY	ETF	439.16	439.27	439.09	439.22	131461.0
2021-08-04 17:00:00	SPY	ETF	439.44	439.44	439.08	439.08	75406.0
2021-08-04 17:30:00	SPY	ETF	439.08	439.2	439.03	439.18	46743.0
2021-08-04 18:00:00	SPY	ETF	439.18	439.4	439.06	439.4	100025.0
2021-08-04 18:30:00	SPY	ETF	438.98	439.49	438.98	439.45	12365.0
2021-08-04 19:00:00	SPY	ETF	439.41	439.41	439.25	439.26	10334.0
2021-08-04 19:30:00	SPY	ETF	439.29	439.38	439.25	439.33	16166.0
2021-08-04 04:00:00	QQQ	ETF	367.0	367.02	366.69	366.85	11909.0
2021-08-04 04:30:00	QQQ	ETF	366.9	367.07	366.87	367.07	12379.0
2021-08-04 05:00:00	QQQ	ETF	366.97	367.11	366.87	366.89	14588.0
2021-08-04 05:30:00	QQQ	ETF	366.86	367.05	366.84	366.96	4140.0
2021-08-04 06:00:00	QQQ	ETF	366.97	367.14	366.97	367.1	16175.0
2021-08-04 06:30:00	QQQ	ETF	367.11	367.2	366.99	367.01	17538.0
2021-08-04 07:00:00	QQQ	ETF	366.99	367.05	366.78	366.78	39016.0
2021-08-04 07:30:00	QQQ	ETF	366.79	366.79	366.48	366.57	24310.0
2021-08-04 08:00:00	QQQ	ETF	366.58	367.25	366.21	366.43	255121.0
2021-08-04 08:30:00	QQQ	ETF	366.45	366.61	366.1	366.39	181799.0
2021-08-04 09:00:00	QQQ	ETF	366.38	366.75	366.22	366.75	73965.0
2021-08-04 09:30:00	QQQ	ETF	366.76	367.38	366.14	367.06	4100050.0
2021-08-04 10:00:00	QQQ	ETF	367.07	367.26	365.78	366.13	3338577.0
2021-08-04 10:30:00	QQQ	ETF	366.14	366.77	365.63	366.45	2444075.0
2021-08-04 11:00:00	QQQ	ETF	366.46	367.04	366.11	366.3	1445585.0
2021-08-04 11:30:00	QQQ	ETF	366.32	367.07	366.01	367.0699	1385012.0
2021-08-04 12:00:00	QQQ	ETF	367.0698	367.38	366.7982	367.115	1052583.0
2021-08-04 12:30:00	QQQ	ETF	367.14	367.31	366.845	367.27	613207.0

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

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