PREVIEW / etf_30min / 2023-01-11

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-01-11.parquet
  size:    690 KB
  rows:    27,700

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-01-11 04:00:00	SPY	ETF	390.45	391.6	390.36	391.59	12251.0
2023-01-11 04:30:00	SPY	ETF	391.49	391.49	391.24	391.3	11183.0
2023-01-11 05:00:00	SPY	ETF	391.42	391.94	391.4	391.53	18176.0
2023-01-11 05:30:00	SPY	ETF	391.55	391.55	391.1	391.3	13359.0
2023-01-11 06:00:00	SPY	ETF	391.28	391.37	391.1	391.26	5759.0
2023-01-11 06:30:00	SPY	ETF	391.34	391.75	391.2	391.38	34395.0
2023-01-11 07:00:00	SPY	ETF	391.43	391.5	390.77	391.08	121332.0
2023-01-11 07:30:00	SPY	ETF	391.06	391.56	391.06	391.4	91505.0
2023-01-11 08:00:00	SPY	ETF	391.32	392.1	390.2	391.85	191223.0
2023-01-11 08:30:00	SPY	ETF	391.91	392.25	391.49	392.16	288799.0
2023-01-11 09:00:00	SPY	ETF	392.19	392.51	391.75	392.23	323249.0
2023-01-11 09:30:00	SPY	ETF	392.23	393.1594	391.8	392.31	5197280.0
2023-01-11 10:00:00	SPY	ETF	392.31	393.08	392.035	393.04	3355495.0
2023-01-11 10:30:00	SPY	ETF	393.05	393.06	391.38	391.5801	3753583.0
2023-01-11 11:00:00	SPY	ETF	391.595	392.74	391.514	392.61	2705082.0
2023-01-11 11:30:00	SPY	ETF	392.62	393.045	392.32	392.74	1991522.0
2023-01-11 12:00:00	SPY	ETF	392.77	393.63	392.765	393.445	2626088.0
2023-01-11 12:30:00	SPY	ETF	393.45	393.54	392.96	393.189	2089845.0
2023-01-11 13:00:00	SPY	ETF	393.202	394.28	392.945	393.835	2734929.0
2023-01-11 13:30:00	SPY	ETF	393.845	394.12	393.39	393.64	2041635.0
2023-01-11 14:00:00	SPY	ETF	393.65	393.99	393.18	393.81	2102630.0
2023-01-11 14:30:00	SPY	ETF	393.83	394.56	393.765	394.3082	2240196.0
2023-01-11 15:00:00	SPY	ETF	394.3	394.92	394.23	394.575	4361717.0
2023-01-11 15:30:00	SPY	ETF	394.5815	395.6	394.03	395.5	9414838.0
2023-01-11 16:00:00	SPY	ETF	395.5	395.55	395.34	395.49	3414414.0
2023-01-11 16:30:00	SPY	ETF	395.45	395.68	395.45	395.68	170017.0
2023-01-11 17:00:00	SPY	ETF	395.57	395.8499	395.57	395.76	80530.0
2023-01-11 17:30:00	SPY	ETF	395.78	395.83	395.72	395.75	35160.0
2023-01-11 18:00:00	SPY	ETF	395.73	395.73	395.39	395.46	90044.0
2023-01-11 18:30:00	SPY	ETF	395.45	395.46	395.3	395.35	53196.0
2023-01-11 19:00:00	SPY	ETF	395.35	395.42	395.14	395.29	35141.0
2023-01-11 19:30:00	SPY	ETF	395.26	395.36	395.09	395.33	72175.0
2023-01-11 04:00:00	QQQ	ETF	272.77	273.7	272.39	273.56	63101.0
2023-01-11 04:30:00	QQQ	ETF	273.46	273.53	273.27	273.32	15066.0
2023-01-11 05:00:00	QQQ	ETF	273.46	273.8	273.35	273.51	14026.0
2023-01-11 05:30:00	QQQ	ETF	273.48	273.48	273.07	273.18	7584.0
2023-01-11 06:00:00	QQQ	ETF	273.2	273.24	272.98	273.19	18942.0
2023-01-11 06:30:00	QQQ	ETF	273.38	273.76	273.2	273.27	18472.0
2023-01-11 07:00:00	QQQ	ETF	273.33	273.5	272.82	273.06	96732.0
2023-01-11 07:30:00	QQQ	ETF	272.93	273.444	272.93	273.27	80197.0
2023-01-11 08:00:00	QQQ	ETF	273.28	273.94	272.01	273.72	233465.0
2023-01-11 08:30:00	QQQ	ETF	273.71	274.0	273.25	273.89	166818.0
2023-01-11 09:00:00	QQQ	ETF	273.9	274.13	273.47	273.92	421627.0
2023-01-11 09:30:00	QQQ	ETF	273.94	274.85	273.12	274.23	4729915.0
2023-01-11 10:00:00	QQQ	ETF	274.26	275.46	273.84	275.43	2745897.0
2023-01-11 10:30:00	QQQ	ETF	275.45	275.48	273.65	273.85	2685295.0
2023-01-11 11:00:00	QQQ	ETF	273.86	275.16	273.79	275.0	1877085.0
2023-01-11 11:30:00	QQQ	ETF	275.01	275.3696	274.73	275.16	1497784.0
2023-01-11 12:00:00	QQQ	ETF	275.19	276.1685	275.16	275.93	1711479.0
2023-01-11 12:30:00	QQQ	ETF	275.94	276.06	275.5001	275.755	1266320.0

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

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