PREVIEW / etf_30min / 2022-03-23

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-03-23.parquet
  size:    675 KB
  rows:    26,559

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-03-23 04:00:00	SPY	ETF	449.66	449.71	448.6	448.74	15267.0
2022-03-23 04:30:00	SPY	ETF	448.68	449.23	448.65	449.1	10626.0
2022-03-23 05:00:00	SPY	ETF	449.03	449.14	448.86	448.89	6359.0
2022-03-23 05:30:00	SPY	ETF	448.6	448.62	447.9	447.99	10572.0
2022-03-23 06:00:00	SPY	ETF	448.07	448.28	447.92	447.92	2494.0
2022-03-23 06:30:00	SPY	ETF	447.87	448.22	447.62	447.99	15141.0
2022-03-23 07:00:00	SPY	ETF	448.02	448.19	447.68	447.7	49560.0
2022-03-23 07:30:00	SPY	ETF	447.72	448.01	447.15	447.6	122138.0
2022-03-23 08:00:00	SPY	ETF	447.3999	450.3	447.1799	447.7	210042.0
2022-03-23 08:30:00	SPY	ETF	447.66	447.72	446.8	447.13	183656.0
2022-03-23 09:00:00	SPY	ETF	447.08	447.54	446.85	446.9	186814.0
2022-03-23 09:30:00	SPY	ETF	446.91	447.31	445.64	446.08	6401772.0
2022-03-23 10:00:00	SPY	ETF	446.07	447.89	445.69	447.5255	5021017.0
2022-03-23 10:30:00	SPY	ETF	447.53	447.98	446.6	447.2235	2934380.0
2022-03-23 11:00:00	SPY	ETF	447.24	448.18	447.14	448.03	2520515.0
2022-03-23 11:30:00	SPY	ETF	448.03	448.09	447.33	447.76	1988240.0
2022-03-23 12:00:00	SPY	ETF	447.76	448.49	446.38	447.33	3339802.0
2022-03-23 12:30:00	SPY	ETF	447.33	447.66	446.13	446.82	2593759.0
2022-03-23 13:00:00	SPY	ETF	446.79	446.91	444.92	445.07	2873362.0
2022-03-23 13:30:00	SPY	ETF	445.06	445.87	444.76	445.78	2975916.0
2022-03-23 14:00:00	SPY	ETF	445.79	445.94	444.71	445.91	2939128.0
2022-03-23 14:30:00	SPY	ETF	445.89	446.3	445.15	445.3005	2848416.0
2022-03-23 15:00:00	SPY	ETF	445.31	445.978	444.9101	445.72	3554469.0
2022-03-23 15:30:00	SPY	ETF	445.71	445.89	443.79	443.84	11980575.0
2022-03-23 16:00:00	SPY	ETF	443.84	444.7	443.66	443.88	4305688.0
2022-03-23 16:30:00	SPY	ETF	443.93	444.08	443.8	444.0	215293.0
2022-03-23 17:00:00	SPY	ETF	443.98	443.98	443.4	443.84	82501.0
2022-03-23 17:30:00	SPY	ETF	443.85	443.94	443.8	443.85	57313.0
2022-03-23 18:00:00	SPY	ETF	444.0	444.14	443.78	444.11	77553.0
2022-03-23 18:30:00	SPY	ETF	444.12	444.25	444.03	444.1	16429.0
2022-03-23 19:00:00	SPY	ETF	444.12	444.5	444.1	444.43	22706.0
2022-03-23 19:30:00	SPY	ETF	444.43	444.4699	444.2	444.34	18792.0
2022-03-23 04:00:00	QQQ	ETF	357.04	357.06	356.07	356.1	20435.0
2022-03-23 04:30:00	QQQ	ETF	356.1	356.57	356.1	356.5	13256.0
2022-03-23 05:00:00	QQQ	ETF	356.5	356.59	356.14	356.29	36741.0
2022-03-23 05:30:00	QQQ	ETF	356.09	356.09	355.32	355.5	51404.0
2022-03-23 06:00:00	QQQ	ETF	355.46	355.62	355.1	355.22	16743.0
2022-03-23 06:30:00	QQQ	ETF	355.03	355.37	354.69	354.97	82683.0
2022-03-23 07:00:00	QQQ	ETF	355.0	355.22	354.43	354.49	157447.0
2022-03-23 07:30:00	QQQ	ETF	354.5	354.83	354.0	354.32	198930.0
2022-03-23 08:00:00	QQQ	ETF	354.92	357.0	354.0	354.57	241627.0
2022-03-23 08:30:00	QQQ	ETF	354.56	356.96	353.75	353.94	270003.0
2022-03-23 09:00:00	QQQ	ETF	353.94	354.67	353.87	353.99	384488.0
2022-03-23 09:30:00	QQQ	ETF	353.99	354.34	352.26	353.02	8965173.0
2022-03-23 10:00:00	QQQ	ETF	352.99	355.58	352.34	355.055	5962571.0
2022-03-23 10:30:00	QQQ	ETF	355.06	355.88	353.89	355.38	3519635.0
2022-03-23 11:00:00	QQQ	ETF	355.38	356.65	355.14	356.3305	2796874.0
2022-03-23 11:30:00	QQQ	ETF	356.34	356.96	355.95	356.93	2068901.0
2022-03-23 12:00:00	QQQ	ETF	356.94	357.66	355.23	356.2801	3399852.0
2022-03-23 12:30:00	QQQ	ETF	356.28	356.63	354.76	355.62	2183660.0

> showing 50 of 26,559 rows — these rows as CSV

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