PREVIEW / etf_30min / 2023-12-08

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-12-08.parquet
  size:    760 KB
  rows:    30,236

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-12-08 04:00:00	SPY	ETF	458.02	458.55	458.02	458.4	31914.0
2023-12-08 04:30:00	SPY	ETF	458.4	458.45	458.38	458.42	3085.0
2023-12-08 05:00:00	SPY	ETF	458.49	458.69	458.36	458.69	8496.0
2023-12-08 05:30:00	SPY	ETF	458.65	458.74	458.65	458.65	4690.0
2023-12-08 06:00:00	SPY	ETF	458.62	458.62	458.39	458.39	1790.0
2023-12-08 06:30:00	SPY	ETF	458.45	458.49	457.75	457.75	18830.0
2023-12-08 07:00:00	SPY	ETF	457.85	457.95	457.38	457.88	62243.0
2023-12-08 07:30:00	SPY	ETF	457.9	457.9	457.62	457.76	24062.0
2023-12-08 08:00:00	SPY	ETF	457.53	458.6704	457.21	457.42	219275.0
2023-12-08 08:30:00	SPY	ETF	457.53	458.31	455.63	457.52	1366808.0
2023-12-08 09:00:00	SPY	ETF	457.53	457.82	457.0	457.46	512100.0
2023-12-08 09:30:00	SPY	ETF	457.46	458.74	457.21	458.2	5301734.0
2023-12-08 10:00:00	SPY	ETF	458.6	460.42	458.22	459.86	6193025.0
2023-12-08 10:30:00	SPY	ETF	459.86	460.06	458.58	460.01	4520460.0
2023-12-08 11:00:00	SPY	ETF	460.02	460.11	458.21	458.69	4694849.0
2023-12-08 11:30:00	SPY	ETF	458.7025	458.94	457.84	458.24	3388730.0
2023-12-08 12:00:00	SPY	ETF	458.24	458.92	457.535	458.8	2464333.0
2023-12-08 12:30:00	SPY	ETF	458.8	459.14	458.57	459.04	2118254.0
2023-12-08 13:00:00	SPY	ETF	459.04	459.59	458.89	459.45	2182036.0
2023-12-08 13:30:00	SPY	ETF	459.45	459.57	459.05	459.4999	2119191.0
2023-12-08 14:00:00	SPY	ETF	459.5	459.98	459.44	459.93	2390524.0
2023-12-08 14:30:00	SPY	ETF	459.93	460.47	459.8	460.3799	3118965.0
2023-12-08 15:00:00	SPY	ETF	460.38	460.44	459.9	460.3807	3791832.0
2023-12-08 15:30:00	SPY	ETF	460.38	460.745	460.05	460.13	11058322.0
2023-12-08 16:00:00	SPY	ETF	460.13	460.22	459.8	460.17	2767790.0
2023-12-08 16:30:00	SPY	ETF	460.18	460.24	460.11	460.11	1157836.0
2023-12-08 17:00:00	SPY	ETF	460.1897	460.1999	460.0	460.0	20630.0
2023-12-08 17:30:00	SPY	ETF	460.04	460.35	460.04	460.35	23944.0
2023-12-08 18:00:00	SPY	ETF	460.35	460.4	460.26	460.3699	31566.0
2023-12-08 18:30:00	SPY	ETF	460.37	460.47	460.36	460.41	18089.0
2023-12-08 19:00:00	SPY	ETF	460.45	460.5	460.4	460.5	20606.0
2023-12-08 19:30:00	SPY	ETF	460.5	460.7	460.45	460.59	40894.0
2023-12-08 04:00:00	QQQ	ETF	389.92	390.39	389.91	390.38	15209.0
2023-12-08 04:30:00	QQQ	ETF	390.38	390.46	390.3	390.43	16104.0
2023-12-08 05:00:00	QQQ	ETF	390.42	390.62	390.22	390.6	9784.0
2023-12-08 05:30:00	QQQ	ETF	390.59	390.72	390.58	390.58	4388.0
2023-12-08 06:00:00	QQQ	ETF	390.56	390.56	390.25	390.25	6128.0
2023-12-08 06:30:00	QQQ	ETF	390.17	390.19	389.59	389.66	25975.0
2023-12-08 07:00:00	QQQ	ETF	389.73	389.81	389.05	389.71	50678.0
2023-12-08 07:30:00	QQQ	ETF	389.73	389.8	389.4	389.45	57914.0
2023-12-08 08:00:00	QQQ	ETF	389.42	390.722	388.91	389.2	216010.0
2023-12-08 08:30:00	QQQ	ETF	389.5	389.65	387.08	388.93	1078147.0
2023-12-08 09:00:00	QQQ	ETF	388.91	389.27	388.28	388.581	436964.0
2023-12-08 09:30:00	QQQ	ETF	388.67	390.4	388.4801	389.6428	6235111.0
2023-12-08 10:00:00	QQQ	ETF	389.67	392.51	389.665	392.15	4227620.0
2023-12-08 10:30:00	QQQ	ETF	392.17	392.39	390.2701	392.325	3590035.0
2023-12-08 11:00:00	QQQ	ETF	392.34	392.47	390.4287	391.06	2925031.0
2023-12-08 11:30:00	QQQ	ETF	391.07	391.265	390.0	390.41	2176251.0
2023-12-08 12:00:00	QQQ	ETF	390.4	391.28	389.5214	391.0801	2087307.0
2023-12-08 12:30:00	QQQ	ETF	391.09	391.45	390.74	391.4	1381001.0

> showing 50 of 30,236 rows — these rows as CSV

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