PREVIEW / etf_30min / 2022-04-21

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-04-21.parquet
  size:    682 KB
  rows:    26,982

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-04-21 04:00:00	SPY	ETF	447.94	448.43	447.85	448.05	22118.0
2022-04-21 04:30:00	SPY	ETF	448.09	448.37	447.98	448.36	6761.0
2022-04-21 05:00:00	SPY	ETF	448.38	448.38	447.73	448.12	5937.0
2022-04-21 05:30:00	SPY	ETF	448.0	448.0	447.55	447.73	6817.0
2022-04-21 06:00:00	SPY	ETF	447.73	448.09	447.61	448.09	56476.0
2022-04-21 06:30:00	SPY	ETF	448.14	448.41	448.1	448.2	100353.0
2022-04-21 07:00:00	SPY	ETF	448.35	448.72	447.97	448.72	162305.0
2022-04-21 07:30:00	SPY	ETF	448.7	448.8	448.36	448.7	121143.0
2022-04-21 08:00:00	SPY	ETF	448.67	448.85	446.23	448.4	201921.0
2022-04-21 08:30:00	SPY	ETF	448.47	448.86	448.06	448.81	276948.0
2022-04-21 09:00:00	SPY	ETF	448.83	448.9	448.41	448.55	413644.0
2022-04-21 09:30:00	SPY	ETF	448.54	450.01	448.54	449.36	6158536.0
2022-04-21 10:00:00	SPY	ETF	449.38	449.42	447.86	448.6918	4343867.0
2022-04-21 10:30:00	SPY	ETF	448.72	448.95	446.92	447.29	3369518.0
2022-04-21 11:00:00	SPY	ETF	447.29	447.64	446.39	446.6899	3124915.0
2022-04-21 11:30:00	SPY	ETF	446.67	446.76	444.67	444.7	3598539.0
2022-04-21 12:00:00	SPY	ETF	444.71	445.0601	443.49	443.63	4052193.0
2022-04-21 12:30:00	SPY	ETF	443.64	444.41	442.63	442.6687	3244229.0
2022-04-21 13:00:00	SPY	ETF	442.66	443.36	441.36	443.265	5714008.0
2022-04-21 13:30:00	SPY	ETF	443.27	443.62	441.55	441.75	3642590.0
2022-04-21 14:00:00	SPY	ETF	441.73	441.73	440.341	440.71	5251685.0
2022-04-21 14:30:00	SPY	ETF	440.69	441.925	438.85	439.22	5139822.0
2022-04-21 15:00:00	SPY	ETF	439.23	439.71	437.865	439.48	6198130.0
2022-04-21 15:30:00	SPY	ETF	439.47	439.56	437.1	438.04	12925219.0
2022-04-21 16:00:00	SPY	ETF	438.02	438.2	437.25	437.62	3035640.0
2022-04-21 16:30:00	SPY	ETF	437.67	438.08	437.5	437.58	189400.0
2022-04-21 17:00:00	SPY	ETF	437.79	437.81	437.51	437.7	45188.0
2022-04-21 17:30:00	SPY	ETF	437.66	437.73	437.55	437.73	12947.0
2022-04-21 18:00:00	SPY	ETF	437.71	437.9	437.38	437.76	61979.0
2022-04-21 18:30:00	SPY	ETF	437.8	438.12	437.79	437.79	15351.0
2022-04-21 19:00:00	SPY	ETF	437.75	437.75	437.42	437.53	18670.0
2022-04-21 19:30:00	SPY	ETF	437.58	437.74	436.8	436.95	61930.0
2022-04-21 04:00:00	QQQ	ETF	344.64	345.2	344.64	344.78	33083.0
2022-04-21 04:30:00	QQQ	ETF	344.78	345.19	344.78	345.17	16530.0
2022-04-21 05:00:00	QQQ	ETF	345.3	345.3	344.69	344.81	9500.0
2022-04-21 05:30:00	QQQ	ETF	344.7	344.7	344.28	344.35	8937.0
2022-04-21 06:00:00	QQQ	ETF	344.26	344.81	344.13	344.81	75818.0
2022-04-21 06:30:00	QQQ	ETF	344.88	345.12	344.84	344.87	45192.0
2022-04-21 07:00:00	QQQ	ETF	345.0	345.45	344.48	345.42	109932.0
2022-04-21 07:30:00	QQQ	ETF	345.5	345.56	345.01	345.5	154604.0
2022-04-21 08:00:00	QQQ	ETF	344.88	345.68	341.465	345.1	191328.0
2022-04-21 08:30:00	QQQ	ETF	345.0	345.5	344.61	345.48	208433.0
2022-04-21 09:00:00	QQQ	ETF	345.45	345.55	345.0	345.18	239597.0
2022-04-21 09:30:00	QQQ	ETF	345.17	347.87	344.983	345.93	7717055.0
2022-04-21 10:00:00	QQQ	ETF	345.94	346.23	343.77	345.15	4878183.0
2022-04-21 10:30:00	QQQ	ETF	345.17	345.64	342.59	343.27	3660084.0
2022-04-21 11:00:00	QQQ	ETF	343.26	343.975	342.62	342.93	3557091.0
2022-04-21 11:30:00	QQQ	ETF	342.92	343.15	340.1	340.12	3963569.0
2022-04-21 12:00:00	QQQ	ETF	340.15	340.635	339.32	339.49	3244169.0
2022-04-21 12:30:00	QQQ	ETF	339.5	340.33	338.69	338.8765	3148992.0

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

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