PREVIEW / etf_30min / 2023-03-09

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-03-09.parquet
  size:    692 KB
  rows:    27,845

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-03-09 04:00:00	SPY	ETF	398.18	398.22	397.79	397.85	15884.0
2023-03-09 04:30:00	SPY	ETF	397.89	398.01	397.48	397.52	17495.0
2023-03-09 05:00:00	SPY	ETF	397.48	397.69	397.42	397.6	15327.0
2023-03-09 05:30:00	SPY	ETF	397.72	398.07	397.7	398.05	13317.0
2023-03-09 06:00:00	SPY	ETF	398.06	398.34	397.99	398.34	19009.0
2023-03-09 06:30:00	SPY	ETF	398.28	398.45	398.22	398.28	31453.0
2023-03-09 07:00:00	SPY	ETF	398.38	398.41	397.8	397.98	85075.0
2023-03-09 07:30:00	SPY	ETF	398.0	398.16	397.5	397.91	180906.0
2023-03-09 08:00:00	SPY	ETF	397.91	398.61	397.5296	397.85	243233.0
2023-03-09 08:30:00	SPY	ETF	397.95	399.75	397.95	399.7	805522.0
2023-03-09 09:00:00	SPY	ETF	399.65	400.29	399.65	399.75	426127.0
2023-03-09 09:30:00	SPY	ETF	399.76	401.48	399.38	400.78	6169881.0
2023-03-09 10:00:00	SPY	ETF	400.77	401.275	399.4101	400.11	5058739.0
2023-03-09 10:30:00	SPY	ETF	400.12	401.08	399.9	399.96	3821032.0
2023-03-09 11:00:00	SPY	ETF	399.96	400.05	399.22	399.25	4177290.0
2023-03-09 11:30:00	SPY	ETF	399.27	399.7	399.04	399.09	2993314.0
2023-03-09 12:00:00	SPY	ETF	399.1	399.25	398.15	399.1804	3986887.0
2023-03-09 12:30:00	SPY	ETF	399.18	399.3	397.7299	397.92	3410662.0
2023-03-09 13:00:00	SPY	ETF	397.94	398.24	396.18	396.4699	4634768.0
2023-03-09 13:30:00	SPY	ETF	396.45	396.535	394.78	395.17	6822980.0
2023-03-09 14:00:00	SPY	ETF	395.18	395.43	394.28	394.7307	6495041.0
2023-03-09 14:30:00	SPY	ETF	394.73	394.92	393.3701	393.43	6292139.0
2023-03-09 15:00:00	SPY	ETF	393.43	393.72	390.53	391.465	11418513.0
2023-03-09 15:30:00	SPY	ETF	391.47	393.0	391.2	391.59	19364023.0
2023-03-09 16:00:00	SPY	ETF	391.59	391.98	390.92	390.93	4930371.0
2023-03-09 16:30:00	SPY	ETF	390.93	391.5785	390.92	391.45	460261.0
2023-03-09 17:00:00	SPY	ETF	391.48	391.48	391.01	391.01	181581.0
2023-03-09 17:30:00	SPY	ETF	391.04	391.37	391.0	391.37	111510.0
2023-03-09 18:00:00	SPY	ETF	391.37	391.4	390.22	390.84	204307.0
2023-03-09 18:30:00	SPY	ETF	390.879	390.92	390.5	390.74	105437.0
2023-03-09 19:00:00	SPY	ETF	390.73	390.89	390.0	390.08	84927.0
2023-03-09 19:30:00	SPY	ETF	390.13	390.55	390.04	390.11	117564.0
2023-03-09 04:00:00	QQQ	ETF	296.73	296.73	296.1	296.23	26027.0
2023-03-09 04:30:00	QQQ	ETF	296.2	296.42	295.89	295.91	24405.0
2023-03-09 05:00:00	QQQ	ETF	295.9	296.09	295.7	295.85	41403.0
2023-03-09 05:30:00	QQQ	ETF	296.02	296.26	296.02	296.17	27248.0
2023-03-09 06:00:00	QQQ	ETF	296.24	296.46	296.15	296.41	19572.0
2023-03-09 06:30:00	QQQ	ETF	296.4	296.65	296.34	296.65	68025.0
2023-03-09 07:00:00	QQQ	ETF	296.62	296.7	296.169	296.5	109177.0
2023-03-09 07:30:00	QQQ	ETF	296.55	296.6	296.17	296.42	154208.0
2023-03-09 08:00:00	QQQ	ETF	296.3182	298.043	296.08	296.3446	267293.0
2023-03-09 08:30:00	QQQ	ETF	296.43	298.62	296.43	298.56	809816.0
2023-03-09 09:00:00	QQQ	ETF	298.58	299.06	298.32	298.34	386531.0
2023-03-09 09:30:00	QQQ	ETF	298.34	300.61	297.96	300.305	5463806.0
2023-03-09 10:00:00	QQQ	ETF	300.32	300.98	299.22	299.91	4260225.0
2023-03-09 10:30:00	QQQ	ETF	299.94	300.78	299.6	299.68	2680302.0
2023-03-09 11:00:00	QQQ	ETF	299.69	300.03	299.195	299.25	2496174.0
2023-03-09 11:30:00	QQQ	ETF	299.26	299.97	299.22	299.31	2118478.0
2023-03-09 12:00:00	QQQ	ETF	299.32	299.4	298.26	299.328	3051039.0
2023-03-09 12:30:00	QQQ	ETF	299.33	299.46	297.65	298.0596	2425168.0

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

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