PREVIEW / etf_30min / 2022-05-13

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-05-13.parquet
  size:    682 KB
  rows:    27,296

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
2022-05-13 04:00:00	SPY	ETF	396.25	397.09	396.0	396.99	55063.0
2022-05-13 04:30:00	SPY	ETF	396.99	397.07	396.11	396.51	22049.0
2022-05-13 05:00:00	SPY	ETF	396.71	397.3	396.63	396.79	27151.0
2022-05-13 05:30:00	SPY	ETF	396.8	396.8	395.83	396.18	39569.0
2022-05-13 06:00:00	SPY	ETF	396.17	396.51	395.75	396.35	17901.0
2022-05-13 06:30:00	SPY	ETF	396.3	396.99	396.3	396.71	20110.0
2022-05-13 07:00:00	SPY	ETF	396.8	396.93	396.32	396.59	48313.0
2022-05-13 07:30:00	SPY	ETF	396.64	398.36	396.5	398.12	166049.0
2022-05-13 08:00:00	SPY	ETF	398.18	398.35	395.46	397.69	326859.0
2022-05-13 08:30:00	SPY	ETF	397.63	398.3	397.63	397.74	258662.0
2022-05-13 09:00:00	SPY	ETF	397.75	397.82	396.45	396.7	683581.0
2022-05-13 09:30:00	SPY	ETF	396.71	399.07	395.61	398.64	8756179.0
2022-05-13 10:00:00	SPY	ETF	398.64	401.49	398.4601	400.98	9043026.0
2022-05-13 10:30:00	SPY	ETF	400.97	401.45	399.35	400.89	5182820.0
2022-05-13 11:00:00	SPY	ETF	400.91	401.63	400.255	401.55	4231604.0
2022-05-13 11:30:00	SPY	ETF	401.56	401.79	400.79	401.57	3392381.0
2022-05-13 12:00:00	SPY	ETF	401.58	403.18	401.4401	402.2489	4143168.0
2022-05-13 12:30:00	SPY	ETF	402.25	402.78	400.691	401.76	3433302.0
2022-05-13 13:00:00	SPY	ETF	401.765	402.17	400.6	400.88	3625045.0
2022-05-13 13:30:00	SPY	ETF	400.89	401.325	399.12	399.35	4453755.0
2022-05-13 14:00:00	SPY	ETF	399.34	399.35	397.18	398.14	5807532.0
2022-05-13 14:30:00	SPY	ETF	398.12	400.6	398.11	400.55	4576746.0
2022-05-13 15:00:00	SPY	ETF	400.56	402.42	400.32	402.37	4444513.0
2022-05-13 15:30:00	SPY	ETF	402.36	402.55	399.88	401.69	12327596.0
2022-05-13 16:00:00	SPY	ETF	401.66	401.82	400.69	401.5601	4647155.0
2022-05-13 16:30:00	SPY	ETF	401.57	401.72	400.92	400.92	366925.0
2022-05-13 17:00:00	SPY	ETF	401.01	401.61	400.92	401.55	185727.0
2022-05-13 17:30:00	SPY	ETF	401.6	401.6	401.51	401.6	23730.0
2022-05-13 18:00:00	SPY	ETF	401.6	401.6	401.28	401.5	27893.0
2022-05-13 18:30:00	SPY	ETF	401.58	401.66	401.51	401.61	29000.0
2022-05-13 19:00:00	SPY	ETF	401.65	401.76	401.64	401.76	21384.0
2022-05-13 19:30:00	SPY	ETF	401.76	401.8	401.0	401.6	59486.0
2022-05-13 04:00:00	QQQ	ETF	295.16	296.71	295.0	296.59	134119.0
2022-05-13 04:30:00	QQQ	ETF	296.44	296.55	295.64	296.04	57494.0
2022-05-13 05:00:00	QQQ	ETF	296.1	296.75	296.01	296.01	55434.0
2022-05-13 05:30:00	QQQ	ETF	296.14	296.48	295.5	295.88	94721.0
2022-05-13 06:00:00	QQQ	ETF	295.92	296.05	295.31	295.89	56791.0
2022-05-13 06:30:00	QQQ	ETF	295.82	296.38	295.72	296.2	67582.0
2022-05-13 07:00:00	QQQ	ETF	296.2	296.4	295.81	296.01	165062.0
2022-05-13 07:30:00	QQQ	ETF	295.9	297.52	295.89	297.32	332353.0
2022-05-13 08:00:00	QQQ	ETF	295.9999	297.5	294.5	296.91	466408.0
2022-05-13 08:30:00	QQQ	ETF	296.94	297.28	296.77	296.82	288681.0
2022-05-13 09:00:00	QQQ	ETF	296.77	296.9	295.54	295.75	559815.0
2022-05-13 09:30:00	QQQ	ETF	295.72	299.29	294.0825	298.45	9067646.0
2022-05-13 10:00:00	QQQ	ETF	298.44	300.74	298.31	300.29	5471717.0
2022-05-13 10:30:00	QQQ	ETF	300.33	300.85	299.04	300.38	4220841.0
2022-05-13 11:00:00	QQQ	ETF	300.385	301.16	299.49	301.06	3441704.0
2022-05-13 11:30:00	QQQ	ETF	301.07	301.46	300.4	301.28	2231356.0
2022-05-13 12:00:00	QQQ	ETF	301.27	302.97	301.11	302.14	2851324.0
2022-05-13 12:30:00	QQQ	ETF	302.16	302.83	300.85	301.8301	2638354.0

> showing 50 of 27,296 rows — these rows as CSV

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