PREVIEW / etf_30min / 2023-11-16

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-11-16.parquet
  size:    740 KB
  rows:    29,658

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
2023-11-16 04:00:00	SPY	ETF	449.69	450.07	449.41	449.74	55084.0
2023-11-16 04:30:00	SPY	ETF	449.73	449.75	449.51	449.51	7665.0
2023-11-16 05:00:00	SPY	ETF	449.52	449.88	449.42	449.88	5701.0
2023-11-16 05:30:00	SPY	ETF	449.88	449.94	449.58	449.66	5438.0
2023-11-16 06:00:00	SPY	ETF	449.7	449.84	449.66	449.76	7388.0
2023-11-16 06:30:00	SPY	ETF	449.78	449.78	449.49	449.71	15362.0
2023-11-16 07:00:00	SPY	ETF	449.78	449.78	448.87	448.98	118207.0
2023-11-16 07:30:00	SPY	ETF	448.99	449.291	448.93	448.95	121771.0
2023-11-16 08:00:00	SPY	ETF	449.4901	449.75	448.75	449.16	145564.0
2023-11-16 08:30:00	SPY	ETF	449.29	450.18	449.0	450.12	527783.0
2023-11-16 09:00:00	SPY	ETF	450.14	450.14	448.92	449.22	246096.0
2023-11-16 09:30:00	SPY	ETF	449.23	450.47	449.13	450.355	4089577.0
2023-11-16 10:00:00	SPY	ETF	450.37	450.56	449.28	449.95	3811737.0
2023-11-16 10:30:00	SPY	ETF	449.95	450.305	448.76	449.025	4963006.0
2023-11-16 11:00:00	SPY	ETF	449.03	449.2799	448.28	448.32	4019056.0
2023-11-16 11:30:00	SPY	ETF	448.33	448.91	448.12	448.749	3631917.0
2023-11-16 12:00:00	SPY	ETF	448.76	449.39	448.63	449.255	2614406.0
2023-11-16 12:30:00	SPY	ETF	449.26	449.915	449.1	449.4701	2776755.0
2023-11-16 13:00:00	SPY	ETF	449.48	449.61	448.885	449.41	2382228.0
2023-11-16 13:30:00	SPY	ETF	449.42	449.525	448.58	448.9297	2465378.0
2023-11-16 14:00:00	SPY	ETF	448.93	449.28	448.79	448.935	1945502.0
2023-11-16 14:30:00	SPY	ETF	448.93	449.84	448.91	449.58	3289382.0
2023-11-16 15:00:00	SPY	ETF	449.58	449.72	449.335	449.61	3114886.0
2023-11-16 15:30:00	SPY	ETF	449.62	450.32	449.4728	450.21	8969086.0
2023-11-16 16:00:00	SPY	ETF	450.21	450.5	450.15	450.48	2239440.0
2023-11-16 16:30:00	SPY	ETF	450.48	450.85	450.23	450.76	380082.0
2023-11-16 17:00:00	SPY	ETF	450.75	450.76	450.62	450.68	52865.0
2023-11-16 17:30:00	SPY	ETF	450.7	450.7	450.63	450.63	8558.0
2023-11-16 18:00:00	SPY	ETF	450.67	450.67	450.37	450.42	47813.0
2023-11-16 18:30:00	SPY	ETF	450.42	450.46	450.23	450.38	58103.0
2023-11-16 19:00:00	SPY	ETF	450.38	450.5	450.3	450.37	15724.0
2023-11-16 19:30:00	SPY	ETF	450.4	450.61	450.4	450.54	23124.0
2023-11-16 04:00:00	QQQ	ETF	385.0	385.37	384.76	385.21	48420.0
2023-11-16 04:30:00	QQQ	ETF	385.16	385.18	384.92	384.99	14710.0
2023-11-16 05:00:00	QQQ	ETF	384.89	385.26	384.89	385.26	19161.0
2023-11-16 05:30:00	QQQ	ETF	385.28	385.3	385.16	385.16	7912.0
2023-11-16 06:00:00	QQQ	ETF	385.18	385.26	385.05	385.22	17466.0
2023-11-16 06:30:00	QQQ	ETF	385.21	385.23	384.88	385.06	17104.0
2023-11-16 07:00:00	QQQ	ETF	385.05	385.09	384.34	384.48	66910.0
2023-11-16 07:30:00	QQQ	ETF	384.5	384.78	384.41	384.45	143146.0
2023-11-16 08:00:00	QQQ	ETF	384.43	385.909	384.15	384.45	237478.0
2023-11-16 08:30:00	QQQ	ETF	384.49	385.63	384.49	385.63	428562.0
2023-11-16 09:00:00	QQQ	ETF	385.57	385.57	384.57	384.8	340723.0
2023-11-16 09:30:00	QQQ	ETF	384.84	385.985	384.21	385.7701	5257208.0
2023-11-16 10:00:00	QQQ	ETF	385.78	386.17	384.73	385.44	2865234.0
2023-11-16 10:30:00	QQQ	ETF	385.46	385.88	383.98	384.5201	3063177.0
2023-11-16 11:00:00	QQQ	ETF	384.53	384.845	383.85	383.91	3153170.0
2023-11-16 11:30:00	QQQ	ETF	383.91	384.85	383.56	384.6	2596044.0
2023-11-16 12:00:00	QQQ	ETF	384.61	385.52	384.47	385.44	2178038.0
2023-11-16 12:30:00	QQQ	ETF	385.44	386.09	385.3	385.63	1827360.0

> showing 50 of 29,658 rows — these rows as CSV

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