PREVIEW / etf_30min / 2023-08-04

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-08-04.parquet
  size:    713 KB
  rows:    28,020

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-08-04 04:00:00	SPY	ETF	450.86	451.51	450.86	451.0	49753.0
2023-08-04 04:30:00	SPY	ETF	450.98	450.98	450.55	450.66	10920.0
2023-08-04 05:00:00	SPY	ETF	450.73	451.27	450.73	451.27	9341.0
2023-08-04 05:30:00	SPY	ETF	451.18	451.18	450.68	450.77	4878.0
2023-08-04 06:00:00	SPY	ETF	450.56	450.64	450.45	450.59	32689.0
2023-08-04 06:30:00	SPY	ETF	450.58	450.63	449.88	449.88	19551.0
2023-08-04 07:00:00	SPY	ETF	449.97	449.97	449.47	449.47	114348.0
2023-08-04 07:30:00	SPY	ETF	449.38	449.59	448.9	449.28	62180.0
2023-08-04 08:00:00	SPY	ETF	450.61	451.4104	448.86	449.75	338453.0
2023-08-04 08:30:00	SPY	ETF	449.21	450.9	448.31	450.52	1367284.0
2023-08-04 09:00:00	SPY	ETF	450.52	450.95	450.37	450.67	430818.0
2023-08-04 09:30:00	SPY	ETF	450.72	451.87	450.15	450.2993	6542145.0
2023-08-04 10:00:00	SPY	ETF	450.2999	450.51	448.77	450.43	5525197.0
2023-08-04 10:30:00	SPY	ETF	450.43	451.4399	450.42	451.3	4079443.0
2023-08-04 11:00:00	SPY	ETF	451.3	451.59	451.14	451.55	2502074.0
2023-08-04 11:30:00	SPY	ETF	451.555	451.93	451.1305	451.83	3033934.0
2023-08-04 12:00:00	SPY	ETF	451.82	452.51	451.52	452.4988	2586464.0
2023-08-04 12:30:00	SPY	ETF	452.5	452.895	452.25	452.74	2618010.0
2023-08-04 13:00:00	SPY	ETF	452.7301	452.785	451.41	451.66	3116760.0
2023-08-04 13:30:00	SPY	ETF	451.66	451.8471	450.62	450.76	3193389.0
2023-08-04 14:00:00	SPY	ETF	450.755	450.755	447.91	448.19	8290682.0
2023-08-04 14:30:00	SPY	ETF	448.1988	448.485	446.76	447.1098	6313928.0
2023-08-04 15:00:00	SPY	ETF	447.1	447.72	446.67	447.1099	4848578.0
2023-08-04 15:30:00	SPY	ETF	447.11	447.36	446.27	446.8	13463029.0
2023-08-04 16:00:00	SPY	ETF	446.79	447.13	446.0	446.91	5651833.0
2023-08-04 16:30:00	SPY	ETF	446.9	446.98	446.65	446.73	141419.0
2023-08-04 17:00:00	SPY	ETF	446.66	446.85	446.65	446.71	93950.0
2023-08-04 17:30:00	SPY	ETF	446.75	446.8	446.71	446.7999	51841.0
2023-08-04 18:00:00	SPY	ETF	446.76	446.81	446.76	446.81	16082.0
2023-08-04 18:30:00	SPY	ETF	446.8	446.89	446.72	446.84	17549.0
2023-08-04 19:00:00	SPY	ETF	446.8	446.91	446.61	446.85	17042.0
2023-08-04 19:30:00	SPY	ETF	446.7	446.91	446.7	446.82	12343.0
2023-08-04 04:00:00	QQQ	ETF	375.87	376.86	375.87	376.21	33184.0
2023-08-04 04:30:00	QQQ	ETF	376.22	376.22	375.76	375.95	39864.0
2023-08-04 05:00:00	QQQ	ETF	376.13	376.54	376.03	376.49	21490.0
2023-08-04 05:30:00	QQQ	ETF	376.4	376.44	375.95	376.12	13086.0
2023-08-04 06:00:00	QQQ	ETF	375.92	376.06	375.77	375.86	6156.0
2023-08-04 06:30:00	QQQ	ETF	375.9	376.0	375.06	375.2	25698.0
2023-08-04 07:00:00	QQQ	ETF	375.25	375.25	374.45	374.46	60674.0
2023-08-04 07:30:00	QQQ	ETF	374.42	374.71	373.85	374.35	139400.0
2023-08-04 08:00:00	QQQ	ETF	374.809	376.71	373.93	374.73	238880.0
2023-08-04 08:30:00	QQQ	ETF	374.49	376.32	373.12	375.8	1374358.0
2023-08-04 09:00:00	QQQ	ETF	375.82	376.22	375.39	375.75	325440.0
2023-08-04 09:30:00	QQQ	ETF	375.75	377.47	374.02	374.2	7229959.0
2023-08-04 10:00:00	QQQ	ETF	374.24	374.9899	372.88	374.67	4709471.0
2023-08-04 10:30:00	QQQ	ETF	374.64	376.14	374.61	375.905	2739465.0
2023-08-04 11:00:00	QQQ	ETF	375.91	376.715	375.76	376.49	1820548.0
2023-08-04 11:30:00	QQQ	ETF	376.49	377.4	376.03	377.17	2023102.0
2023-08-04 12:00:00	QQQ	ETF	377.14	377.67	376.61	377.63	1705798.0
2023-08-04 12:30:00	QQQ	ETF	377.64	378.1	377.425	377.735	1640904.0

> showing 50 of 28,020 rows — these rows as CSV

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