PREVIEW / etf_30min / 2022-10-10

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-10-10.parquet
  size:    666 KB
  rows:    26,932

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-10-10 04:00:00	SPY	ETF	361.44	361.6	360.43	360.43	58165.0
2022-10-10 04:30:00	SPY	ETF	360.41	360.9	360.1	360.76	17559.0
2022-10-10 05:00:00	SPY	ETF	360.76	361.81	360.76	361.75	23136.0
2022-10-10 05:30:00	SPY	ETF	361.9	362.52	361.57	362.42	31819.0
2022-10-10 06:00:00	SPY	ETF	362.56	362.69	361.8	361.86	34003.0
2022-10-10 06:30:00	SPY	ETF	361.98	362.09	361.5	361.68	26603.0
2022-10-10 07:00:00	SPY	ETF	361.68	362.74	361.68	362.71	106590.0
2022-10-10 07:30:00	SPY	ETF	362.71	362.74	362.11	362.27	84158.0
2022-10-10 08:00:00	SPY	ETF	362.13	362.71	361.25	362.64	171665.0
2022-10-10 08:30:00	SPY	ETF	362.64	364.2	362.39	364.121	289528.0
2022-10-10 09:00:00	SPY	ETF	364.2	364.43	363.91	363.93	371307.0
2022-10-10 09:30:00	SPY	ETF	363.97	364.21	361.54	361.65	5945075.0
2022-10-10 10:00:00	SPY	ETF	361.64	363.0	360.955	362.49	4370354.0
2022-10-10 10:30:00	SPY	ETF	362.51	362.965	359.66	360.21	5387300.0
2022-10-10 11:00:00	SPY	ETF	360.2	361.1	359.3	360.34	3713842.0
2022-10-10 11:30:00	SPY	ETF	360.35	361.47	359.77	360.79	2672165.0
2022-10-10 12:00:00	SPY	ETF	360.8	360.99	358.88	359.0501	3001110.0
2022-10-10 12:30:00	SPY	ETF	359.04	359.36	358.35	358.37	2719749.0
2022-10-10 13:00:00	SPY	ETF	358.35	359.125	357.67	358.98	3998763.0
2022-10-10 13:30:00	SPY	ETF	358.97	362.37	358.91	361.498	5588252.0
2022-10-10 14:00:00	SPY	ETF	361.48	361.64	359.94	360.6325	3116352.0
2022-10-10 14:30:00	SPY	ETF	360.62	361.76	360.25	360.5401	3090905.0
2022-10-10 15:00:00	SPY	ETF	360.555	361.975	360.05	360.7584	3436912.0
2022-10-10 15:30:00	SPY	ETF	360.81	361.73	360.03	360.07	7189202.0
2022-10-10 16:00:00	SPY	ETF	360.08	360.57	360.02	360.34	2392369.0
2022-10-10 16:30:00	SPY	ETF	360.34	360.51	360.02	360.45	411784.0
2022-10-10 17:00:00	SPY	ETF	360.37	360.57	360.35	360.39	34608.0
2022-10-10 17:30:00	SPY	ETF	360.352	360.42	360.17	360.22	78788.0
2022-10-10 18:00:00	SPY	ETF	360.25	360.65	360.13	360.65	60223.0
2022-10-10 18:30:00	SPY	ETF	360.64	360.8	360.45	360.7	79609.0
2022-10-10 19:00:00	SPY	ETF	360.7	361.25	360.68	360.95	37827.0
2022-10-10 19:30:00	SPY	ETF	361.0	361.14	360.79	360.9	30571.0
2022-10-10 04:00:00	QQQ	ETF	267.75	268.0	266.8	266.94	139344.0
2022-10-10 04:30:00	QQQ	ETF	266.88	267.24	266.6	267.19	28226.0
2022-10-10 05:00:00	QQQ	ETF	267.25	267.89	267.25	267.89	32796.0
2022-10-10 05:30:00	QQQ	ETF	267.85	268.61	267.67	268.47	55838.0
2022-10-10 06:00:00	QQQ	ETF	268.54	268.65	267.83	267.89	42401.0
2022-10-10 06:30:00	QQQ	ETF	267.85	268.09	267.56	267.7	26806.0
2022-10-10 07:00:00	QQQ	ETF	267.72	268.66	267.71	268.66	138352.0
2022-10-10 07:30:00	QQQ	ETF	268.65	268.7	268.17	268.37	104077.0
2022-10-10 08:00:00	QQQ	ETF	268.1	268.7	267.38	268.43	243964.0
2022-10-10 08:30:00	QQQ	ETF	268.45	269.75	268.24	269.73	383256.0
2022-10-10 09:00:00	QQQ	ETF	269.74	269.9	269.24	269.24	383403.0
2022-10-10 09:30:00	QQQ	ETF	269.31	269.7	266.71	266.98	5675404.0
2022-10-10 10:00:00	QQQ	ETF	267.0	268.3	266.26	267.62	3714316.0
2022-10-10 10:30:00	QQQ	ETF	267.59	267.979	265.0504	265.48	4285000.0
2022-10-10 11:00:00	QQQ	ETF	265.47	266.38	264.89	265.87	2613469.0
2022-10-10 11:30:00	QQQ	ETF	265.87	267.11	265.5	266.37	2428205.0
2022-10-10 12:00:00	QQQ	ETF	266.37	266.37	264.62	264.75	2571431.0
2022-10-10 12:30:00	QQQ	ETF	264.72	265.0791	264.38	264.39	2369558.0

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

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