PREVIEW / etf_30min / 2021-09-13

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-09-13.parquet
  size:    616 KB
  rows:    23,401

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-09-13 04:00:00	SPY	ETF	447.0	447.7	447.0	447.63	170444.0
2021-09-13 04:30:00	SPY	ETF	447.56	447.59	447.25	447.36	11649.0
2021-09-13 05:00:00	SPY	ETF	447.43	447.53	447.35	447.51	4481.0
2021-09-13 05:30:00	SPY	ETF	447.52	447.56	447.39	447.52	17250.0
2021-09-13 06:00:00	SPY	ETF	447.55	447.99	447.55	447.97	50559.0
2021-09-13 06:30:00	SPY	ETF	447.95	448.29	447.95	448.1	101697.0
2021-09-13 07:00:00	SPY	ETF	448.07	448.1	447.8	447.84	176680.0
2021-09-13 07:30:00	SPY	ETF	447.83	447.94	447.68	447.94	54307.0
2021-09-13 08:00:00	SPY	ETF	448.0001	448.2096	445.774	448.1	276122.0
2021-09-13 08:30:00	SPY	ETF	448.11	448.45	447.93	448.39	346185.0
2021-09-13 09:00:00	SPY	ETF	448.4	448.78	448.18	448.65	570390.0
2021-09-13 09:30:00	SPY	ETF	448.65	448.92	446.77	447.22	8038987.0
2021-09-13 10:00:00	SPY	ETF	447.2	447.45	445.47	446.03	6107159.0
2021-09-13 10:30:00	SPY	ETF	446.01	447.09	445.52	446.69	4590784.0
2021-09-13 11:00:00	SPY	ETF	446.71	446.87	444.87	445.83	4743395.0
2021-09-13 11:30:00	SPY	ETF	445.825	446.285	445.31	445.4	2936950.0
2021-09-13 12:00:00	SPY	ETF	445.39	446.19	445.11	445.84	2795692.0
2021-09-13 12:30:00	SPY	ETF	445.85	446.17	445.36	446.07	2309787.0
2021-09-13 13:00:00	SPY	ETF	446.07	446.36	445.16	445.3	2169462.0
2021-09-13 13:30:00	SPY	ETF	445.3	445.39	444.71	444.92	2319582.0
2021-09-13 14:00:00	SPY	ETF	444.94	445.3	444.2701	444.46	3093571.0
2021-09-13 14:30:00	SPY	ETF	444.485	445.04	444.14	444.87	2871378.0
2021-09-13 15:00:00	SPY	ETF	444.86	446.06	444.11	446.02	5693059.0
2021-09-13 15:30:00	SPY	ETF	446.02	446.58	445.41	446.5599	11431187.0
2021-09-13 16:00:00	SPY	ETF	446.55	447.2	446.1667	447.14	2628435.0
2021-09-13 16:30:00	SPY	ETF	447.14	447.32	446.58	447.23	453017.0
2021-09-13 17:00:00	SPY	ETF	447.22	447.22	447.16	447.16	44349.0
2021-09-13 17:30:00	SPY	ETF	447.1701	447.21	447.14	447.17	28993.0
2021-09-13 18:00:00	SPY	ETF	447.17	447.31	446.97	447.31	74700.0
2021-09-13 18:30:00	SPY	ETF	446.58	447.44	446.58	447.31	27805.0
2021-09-13 19:00:00	SPY	ETF	447.36	447.44	447.1	447.18	23706.0
2021-09-13 19:30:00	SPY	ETF	447.17	447.3	447.1	447.22	28429.0
2021-09-13 04:00:00	QQQ	ETF	377.0	378.07	377.0	378.0	23435.0
2021-09-13 04:30:00	QQQ	ETF	378.04	378.05	377.77	377.89	12722.0
2021-09-13 05:00:00	QQQ	ETF	377.87	378.0	377.85	378.0	4714.0
2021-09-13 05:30:00	QQQ	ETF	377.91	377.97	377.87	377.97	7068.0
2021-09-13 06:00:00	QQQ	ETF	377.95	378.26	377.95	378.26	21081.0
2021-09-13 06:30:00	QQQ	ETF	378.31	378.48	378.31	378.44	21773.0
2021-09-13 07:00:00	QQQ	ETF	378.44	378.5	378.25	378.25	51842.0
2021-09-13 07:30:00	QQQ	ETF	378.27	378.38	378.13	378.35	43263.0
2021-09-13 08:00:00	QQQ	ETF	378.3899	378.7	375.95	378.6	149348.0
2021-09-13 08:30:00	QQQ	ETF	378.66	378.77	378.47	378.73	103498.0
2021-09-13 09:00:00	QQQ	ETF	378.78	379.08	378.65	378.99	172121.0
2021-09-13 09:30:00	QQQ	ETF	378.99	379.43	376.29	376.54	6079292.0
2021-09-13 10:00:00	QQQ	ETF	376.535	378.0	374.57	375.2409	6667960.0
2021-09-13 10:30:00	QQQ	ETF	375.259	376.58	374.7504	376.07	3406587.0
2021-09-13 11:00:00	QQQ	ETF	376.08	376.45	374.275	375.06	2727481.0
2021-09-13 11:30:00	QQQ	ETF	375.05	375.8	374.71	374.7982	1542512.0
2021-09-13 12:00:00	QQQ	ETF	374.815	376.23	374.55	375.9401	1626242.0
2021-09-13 12:30:00	QQQ	ETF	375.93	376.5699	375.542	376.45	1429920.0

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

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