PREVIEW / etf_30min / 2023-06-09

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-06-09.parquet
  size:    684 KB
  rows:    27,016

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-06-09 04:00:00	SPY	ETF	428.41	428.55	428.23	428.55	17256.0
2023-06-09 04:30:00	SPY	ETF	428.62	428.87	428.41	428.87	14133.0
2023-06-09 05:00:00	SPY	ETF	428.84	429.14	428.84	429.14	10872.0
2023-06-09 05:30:00	SPY	ETF	429.1	429.1	428.62	428.7	12204.0
2023-06-09 06:00:00	SPY	ETF	428.75	428.83	428.44	428.83	84808.0
2023-06-09 06:30:00	SPY	ETF	428.61	428.79	428.5	428.7	13199.0
2023-06-09 07:00:00	SPY	ETF	428.7	429.1	428.7	429.04	26401.0
2023-06-09 07:30:00	SPY	ETF	429.0	429.35	428.91	429.14	102213.0
2023-06-09 08:00:00	SPY	ETF	428.6703	429.53	428.0	429.23	227384.0
2023-06-09 08:30:00	SPY	ETF	429.2	429.6399	429.09	429.6399	101424.0
2023-06-09 09:00:00	SPY	ETF	429.66	429.98	429.43	429.98	173890.0
2023-06-09 09:30:00	SPY	ETF	429.96	431.3	429.92	430.94	6918803.0
2023-06-09 10:00:00	SPY	ETF	430.94	431.9	430.94	431.79	5311392.0
2023-06-09 10:30:00	SPY	ETF	431.79	431.99	430.5	431.095	5904755.0
2023-06-09 11:00:00	SPY	ETF	431.11	431.63	429.7	429.87	4976048.0
2023-06-09 11:30:00	SPY	ETF	429.86	430.25	429.3	429.4499	4963765.0
2023-06-09 12:00:00	SPY	ETF	429.46	429.92	428.88	429.205	3398165.0
2023-06-09 12:30:00	SPY	ETF	429.21	429.83	428.87	429.8	2384934.0
2023-06-09 13:00:00	SPY	ETF	429.82	430.16	429.64	430.155	2534206.0
2023-06-09 13:30:00	SPY	ETF	430.1526	430.62	430.11	430.58	2807731.0
2023-06-09 14:00:00	SPY	ETF	430.59	430.78	430.19	430.42	2368885.0
2023-06-09 14:30:00	SPY	ETF	430.43	430.46	429.87	430.25	2513130.0
2023-06-09 15:00:00	SPY	ETF	430.28	430.5	429.73	430.13	2687614.0
2023-06-09 15:30:00	SPY	ETF	430.12	430.3	429.6	429.89	8731361.0
2023-06-09 16:00:00	SPY	ETF	429.89	430.31	429.88	430.29	2481544.0
2023-06-09 16:30:00	SPY	ETF	430.29	430.33	429.91	429.91	121769.0
2023-06-09 17:00:00	SPY	ETF	429.9	430.04	429.9	429.98	15374.0
2023-06-09 17:30:00	SPY	ETF	429.94	430.07	429.91	429.97	18912.0
2023-06-09 18:00:00	SPY	ETF	429.97	429.98	429.92	429.95	4337.0
2023-06-09 18:30:00	SPY	ETF	429.94	430.01	429.94	429.98	14252.0
2023-06-09 19:00:00	SPY	ETF	429.96	430.02	429.96	430.02	604.0
2023-06-09 19:30:00	SPY	ETF	430.03	430.06	429.96	430.03	20130.0
2023-06-09 04:00:00	QQQ	ETF	352.66	352.94	352.54	352.94	15565.0
2023-06-09 04:30:00	QQQ	ETF	352.94	353.21	352.86	353.15	7525.0
2023-06-09 05:00:00	QQQ	ETF	353.27	353.49	353.23	353.43	9479.0
2023-06-09 05:30:00	QQQ	ETF	353.54	353.54	352.99	353.04	5924.0
2023-06-09 06:00:00	QQQ	ETF	353.12	353.43	352.97	353.43	9282.0
2023-06-09 06:30:00	QQQ	ETF	353.31	353.34	352.75	353.02	18001.0
2023-06-09 07:00:00	QQQ	ETF	353.05	353.64	353.05	353.48	34839.0
2023-06-09 07:30:00	QQQ	ETF	353.43	353.81	353.39	353.56	29007.0
2023-06-09 08:00:00	QQQ	ETF	353.0816	354.22	352.47	353.77	199989.0
2023-06-09 08:30:00	QQQ	ETF	353.8	354.49	353.8	354.4	222546.0
2023-06-09 09:00:00	QQQ	ETF	354.36	354.69	354.14	354.61	276109.0
2023-06-09 09:30:00	QQQ	ETF	354.63	357.21	354.52	356.84	6138759.0
2023-06-09 10:00:00	QQQ	ETF	356.87	357.66	356.61	357.23	4011435.0
2023-06-09 10:30:00	QQQ	ETF	357.23	357.47	354.59	355.3	4522812.0
2023-06-09 11:00:00	QQQ	ETF	355.31	356.61	354.3201	354.38	3500681.0
2023-06-09 11:30:00	QQQ	ETF	354.38	354.99	353.8914	353.9	3050481.0
2023-06-09 12:00:00	QQQ	ETF	353.92	354.58	353.21	353.58	2335575.0
2023-06-09 12:30:00	QQQ	ETF	353.5825	354.43	353.03	354.41	1860308.0

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

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