PREVIEW / etf_30min / 2022-11-02

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-11-02.parquet
  size:    680 KB
  rows:    27,537

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-11-02 04:00:00	SPY	ETF	385.05	386.13	385.05	386.12	15183.0
2022-11-02 04:30:00	SPY	ETF	385.97	386.14	385.69	385.7	9858.0
2022-11-02 05:00:00	SPY	ETF	385.72	385.9	384.62	384.74	6630.0
2022-11-02 05:30:00	SPY	ETF	384.74	384.91	384.74	384.78	670.0
2022-11-02 06:00:00	SPY	ETF	385.05	385.05	384.83	384.83	5125.0
2022-11-02 06:30:00	SPY	ETF	384.88	384.88	384.25	384.57	43699.0
2022-11-02 07:00:00	SPY	ETF	384.54	384.91	384.36	384.7	42855.0
2022-11-02 07:30:00	SPY	ETF	384.82	385.16	384.79	385.08	43821.0
2022-11-02 08:00:00	SPY	ETF	385.08	385.9696	383.71	384.28	317473.0
2022-11-02 08:30:00	SPY	ETF	384.33	384.72	383.54	384.17	331268.0
2022-11-02 09:00:00	SPY	ETF	384.17	384.37	383.83	383.9	123040.0
2022-11-02 09:30:00	SPY	ETF	383.9	384.06	382.41	382.44	4177447.0
2022-11-02 10:00:00	SPY	ETF	382.44	383.07	382.11	382.27	3220071.0
2022-11-02 10:30:00	SPY	ETF	382.29	383.12	382.15	382.75	1978078.0
2022-11-02 11:00:00	SPY	ETF	382.76	383.07	382.27	382.64	1813793.0
2022-11-02 11:30:00	SPY	ETF	382.65	383.1021	382.43	382.71	1774407.0
2022-11-02 12:00:00	SPY	ETF	382.7	382.885	381.75	381.755	1956938.0
2022-11-02 12:30:00	SPY	ETF	381.7571	382.6901	381.39	382.48	2417367.0
2022-11-02 13:00:00	SPY	ETF	382.48	382.51	382.0	382.16	1552043.0
2022-11-02 13:30:00	SPY	ETF	382.15	383.94	382.055	383.325	3379006.0
2022-11-02 14:00:00	SPY	ETF	383.3281	388.0	382.09	387.87	14339183.0
2022-11-02 14:30:00	SPY	ETF	387.88	388.63	378.96	380.49	21619520.0
2022-11-02 15:00:00	SPY	ETF	380.515	383.19	376.25	377.09	12103293.0
2022-11-02 15:30:00	SPY	ETF	377.074	377.54	374.84	374.87	17522568.0
2022-11-02 16:00:00	SPY	ETF	374.87	382.1875	374.16	374.92	6682895.0
2022-11-02 16:30:00	SPY	ETF	374.92	375.4	374.87	374.95	445233.0
2022-11-02 17:00:00	SPY	ETF	374.93	375.02	374.82	374.95	143768.0
2022-11-02 17:30:00	SPY	ETF	374.95	375.0	374.8004	374.8004	54094.0
2022-11-02 18:00:00	SPY	ETF	374.84	375.16	373.88	374.51	165030.0
2022-11-02 18:30:00	SPY	ETF	374.51	374.67	374.14	374.28	56705.0
2022-11-02 19:00:00	SPY	ETF	374.22	374.35	373.8	373.92	73931.0
2022-11-02 19:30:00	SPY	ETF	373.91	374.31	373.9	374.08	52273.0
2022-11-02 04:00:00	QQQ	ETF	275.55	276.49	275.55	276.43	41479.0
2022-11-02 04:30:00	QQQ	ETF	276.36	276.43	276.07	276.12	42181.0
2022-11-02 05:00:00	QQQ	ETF	276.16	276.24	275.3	275.33	19242.0
2022-11-02 05:30:00	QQQ	ETF	275.3	275.67	275.3	275.65	10697.0
2022-11-02 06:00:00	QQQ	ETF	275.64	275.78	275.5	275.54	17501.0
2022-11-02 06:30:00	QQQ	ETF	275.54	275.54	275.1	275.42	37830.0
2022-11-02 07:00:00	QQQ	ETF	275.47	275.64	275.2	275.48	31518.0
2022-11-02 07:30:00	QQQ	ETF	275.52	275.73	275.5	275.6	62530.0
2022-11-02 08:00:00	QQQ	ETF	275.63	276.4296	274.25	275.13	329980.0
2022-11-02 08:30:00	QQQ	ETF	275.09	275.57	274.61	275.18	430463.0
2022-11-02 09:00:00	QQQ	ETF	275.1	275.28	274.87	275.04	136527.0
2022-11-02 09:30:00	QQQ	ETF	275.08	275.32	273.64	273.8523	3184264.0
2022-11-02 10:00:00	QQQ	ETF	273.87	274.56	273.38	273.57	1866396.0
2022-11-02 10:30:00	QQQ	ETF	273.5901	274.03	273.24	273.605	1393636.0
2022-11-02 11:00:00	QQQ	ETF	273.62	273.78	272.53	272.73	1152460.0
2022-11-02 11:30:00	QQQ	ETF	272.75	273.05	272.56	272.77	1011586.0
2022-11-02 12:00:00	QQQ	ETF	272.78	272.98	271.99	272.01	1153377.0
2022-11-02 12:30:00	QQQ	ETF	272.0	273.01	271.71	272.7699	1534956.0

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

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