PREVIEW / etf_30min / 2021-08-02

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-08-02.parquet
  size:    627 KB
  rows:    23,636

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-02 04:00:00	SPY	ETF	440.6	441.3	440.6	440.86	21190.0
2021-08-02 04:30:00	SPY	ETF	440.97	441.1	440.95	441.1	3799.0
2021-08-02 05:00:00	SPY	ETF	441.08	441.09	440.99	441.08	1300.0
2021-08-02 05:30:00	SPY	ETF	441.14	441.27	441.14	441.21	1468.0
2021-08-02 06:00:00	SPY	ETF	441.02	441.09	440.78	440.92	12592.0
2021-08-02 06:30:00	SPY	ETF	440.93	440.97	440.01	440.03	49088.0
2021-08-02 07:00:00	SPY	ETF	439.99	440.46	439.75	440.18	121025.0
2021-08-02 07:30:00	SPY	ETF	440.17	440.51	440.17	440.48	57638.0
2021-08-02 08:00:00	SPY	ETF	440.03	441.35	439.86	440.18	147615.0
2021-08-02 08:30:00	SPY	ETF	440.22	440.25	440.01	440.19	27731.0
2021-08-02 09:00:00	SPY	ETF	440.2	440.39	439.96	440.33	213263.0
2021-08-02 09:30:00	SPY	ETF	440.34	440.93	440.07	440.23	6027298.0
2021-08-02 10:00:00	SPY	ETF	440.22	440.76	439.68	440.44	3644356.0
2021-08-02 10:30:00	SPY	ETF	440.445	440.66	439.95	439.98	3192418.0
2021-08-02 11:00:00	SPY	ETF	439.985	440.4	439.8363	440.25	1790637.0
2021-08-02 11:30:00	SPY	ETF	440.25	440.33	438.77	438.8411	2826221.0
2021-08-02 12:00:00	SPY	ETF	438.84	438.85	438.19	438.56	3996364.0
2021-08-02 12:30:00	SPY	ETF	438.56	439.16	438.4327	438.815	2341458.0
2021-08-02 13:00:00	SPY	ETF	438.82	439.22	438.71	438.9081	2307165.0
2021-08-02 13:30:00	SPY	ETF	438.905	439.01	438.16	438.56	2123919.0
2021-08-02 14:00:00	SPY	ETF	438.56	438.97	438.4	438.695	1821449.0
2021-08-02 14:30:00	SPY	ETF	438.69	438.9381	438.57	438.7799	2047511.0
2021-08-02 15:00:00	SPY	ETF	438.78	438.9	438.07	438.135	3004599.0
2021-08-02 15:30:00	SPY	ETF	438.1401	438.22	437.21	437.58	8715130.0
2021-08-02 16:00:00	SPY	ETF	437.59	437.97	437.53	437.9	1940497.0
2021-08-02 16:30:00	SPY	ETF	437.9	437.97	437.86	437.94	102951.0
2021-08-02 17:00:00	SPY	ETF	437.94	437.97	437.83	437.87	64482.0
2021-08-02 17:30:00	SPY	ETF	437.9	437.95	437.85	437.91	20955.0
2021-08-02 18:00:00	SPY	ETF	437.91	438.0	437.86	437.87	63558.0
2021-08-02 18:30:00	SPY	ETF	437.59	438.34	437.59	438.24	25277.0
2021-08-02 19:00:00	SPY	ETF	438.24	438.24	438.1	438.15	19385.0
2021-08-02 19:30:00	SPY	ETF	438.17	438.27	437.94	438.17	23313.0
2021-08-02 04:00:00	QQQ	ETF	366.02	366.64	366.02	366.42	40288.0
2021-08-02 04:30:00	QQQ	ETF	366.43	366.61	366.43	366.59	38785.0
2021-08-02 05:00:00	QQQ	ETF	366.61	366.61	366.41	366.48	24593.0
2021-08-02 05:30:00	QQQ	ETF	366.55	366.72	366.48	366.66	21806.0
2021-08-02 06:00:00	QQQ	ETF	366.65	366.65	366.21	366.52	37710.0
2021-08-02 06:30:00	QQQ	ETF	366.51	366.51	365.66	365.77	48953.0
2021-08-02 07:00:00	QQQ	ETF	365.72	366.19	365.66	366.03	93042.0
2021-08-02 07:30:00	QQQ	ETF	366.05	366.41	365.98	366.34	60588.0
2021-08-02 08:00:00	QQQ	ETF	366.0096	366.75	364.843	366.09	127010.0
2021-08-02 08:30:00	QQQ	ETF	366.1	366.36	366.04	366.14	100930.0
2021-08-02 09:00:00	QQQ	ETF	366.17	366.42	366.01	366.35	162950.0
2021-08-02 09:30:00	QQQ	ETF	366.28	366.71	364.11	365.09	3785753.0
2021-08-02 10:00:00	QQQ	ETF	365.07	366.2	364.27	365.875	2437217.0
2021-08-02 10:30:00	QQQ	ETF	365.85	366.389	365.41	366.2602	1297090.0
2021-08-02 11:00:00	QQQ	ETF	366.27	366.84	365.9	366.69	1273053.0
2021-08-02 11:30:00	QQQ	ETF	366.68	366.88	365.57	365.65	1328186.0
2021-08-02 12:00:00	QQQ	ETF	365.66	365.67	364.69	365.2562	1521037.0
2021-08-02 12:30:00	QQQ	ETF	365.26	365.77	365.16	365.38	959744.0

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

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