PREVIEW / etf_30min / 2003-04-23

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-04-23.parquet
  size:    23 KB
  rows:    683

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
2003-04-23 08:00:00	SPY	ETF	91.76	91.81	91.73	91.77	11800.0
2003-04-23 08:30:00	SPY	ETF	91.72	91.72	91.49	91.51	30300.0
2003-04-23 09:00:00	SPY	ETF	91.46	91.63	91.4	91.61	40700.0
2003-04-23 09:30:00	SPY	ETF	91.62	91.85	91.43	91.76	5881500.0
2003-04-23 10:00:00	SPY	ETF	91.77	91.79	91.24	91.3	4640800.0
2003-04-23 10:30:00	SPY	ETF	91.31	91.87	91.26	91.66	3633500.0
2003-04-23 11:00:00	SPY	ETF	91.66	91.8	91.45	91.7	1880900.0
2003-04-23 11:30:00	SPY	ETF	91.69	91.88	91.6	91.86	2062600.0
2003-04-23 12:00:00	SPY	ETF	91.85	92.13	91.75	92.09	2825600.0
2003-04-23 12:30:00	SPY	ETF	92.05	92.3	92.03	92.23	2982500.0
2003-04-23 13:00:00	SPY	ETF	92.24	92.3	91.87	91.9	1803600.0
2003-04-23 13:30:00	SPY	ETF	91.9	92.05	91.64	91.72	2438900.0
2003-04-23 14:00:00	SPY	ETF	91.72	91.9	91.54	91.88	2806200.0
2003-04-23 14:30:00	SPY	ETF	91.89	92.2	91.8	92.09	1839100.0
2003-04-23 15:00:00	SPY	ETF	92.12	92.27	91.92	92.17	1832700.0
2003-04-23 15:30:00	SPY	ETF	92.15	92.33	92.06	92.2	3878500.0
2003-04-23 16:00:00	SPY	ETF	92.19	92.35	92.13	92.15	1867900.0
2003-04-23 16:30:00	SPY	ETF	92.13	92.22	92.1	92.16	64800.0
2003-04-23 17:00:00	SPY	ETF	92.17	92.18	92.1	92.1	40900.0
2003-04-23 17:30:00	SPY	ETF	92.12	92.12	92.05	92.05	17800.0
2003-04-23 18:00:00	SPY	ETF	92.08	92.08	92.03	92.03	2800.0
2003-04-23 18:30:00	SPY	ETF	92.03	92.03	92.03	92.03	800.0
2003-04-23 19:00:00	SPY	ETF	92.04	92.1	92.04	92.1	1400.0
2003-04-23 19:30:00	SPY	ETF	92.05	92.13	92.0	92.06	2100.0
2003-04-23 08:00:00	QQQ	ETF	27.56	27.59	27.56	27.57	40700.0
2003-04-23 08:30:00	QQQ	ETF	27.58	27.58	27.5	27.5	139500.0
2003-04-23 09:00:00	QQQ	ETF	27.51	27.52	27.48	27.5	55000.0
2003-04-23 09:30:00	QQQ	ETF	27.5	27.53	27.31	27.49	11105400.0
2003-04-23 10:00:00	QQQ	ETF	27.49	27.5	27.26	27.31	5873000.0
2003-04-23 10:30:00	QQQ	ETF	27.31	27.57	27.29	27.49	6528900.0
2003-04-23 11:00:00	QQQ	ETF	27.5	27.58	27.4	27.53	5504200.0
2003-04-23 11:30:00	QQQ	ETF	27.53	27.6	27.47	27.59	3259300.0
2003-04-23 12:00:00	QQQ	ETF	27.59	27.72	27.57	27.67	3415000.0
2003-04-23 12:30:00	QQQ	ETF	27.67	27.75	27.65	27.72	2828600.0
2003-04-23 13:00:00	QQQ	ETF	27.72	27.73	27.53	27.54	3894700.0
2003-04-23 13:30:00	QQQ	ETF	27.55	27.61	27.38	27.46	3819000.0
2003-04-23 14:00:00	QQQ	ETF	27.47	27.58	27.41	27.53	3521100.0
2003-04-23 14:30:00	QQQ	ETF	27.54	27.65	27.51	27.62	3167900.0
2003-04-23 15:00:00	QQQ	ETF	27.62	27.7	27.54	27.62	2914600.0
2003-04-23 15:30:00	QQQ	ETF	27.62	27.71	27.61	27.65	5969900.0
2003-04-23 16:00:00	QQQ	ETF	27.67	27.7	27.59	27.6	1256800.0
2003-04-23 16:30:00	QQQ	ETF	27.59	27.67	27.55	27.66	276100.0
2003-04-23 17:00:00	QQQ	ETF	27.66	27.68	27.61	27.61	63500.0
2003-04-23 17:30:00	QQQ	ETF	27.61	27.62	27.58	27.6	184800.0
2003-04-23 18:00:00	QQQ	ETF	27.62	27.62	27.6	27.6	10900.0
2003-04-23 18:30:00	QQQ	ETF	27.59	27.59	27.56	27.58	6300.0
2003-04-23 19:00:00	QQQ	ETF	27.6	27.61	27.58	27.61	6100.0
2003-04-23 19:30:00	QQQ	ETF	27.61	27.62	27.6	27.61	4600.0
2003-04-23 09:30:00	IWM	ETF	38.975	39.19	38.975	39.19	524200.0
2003-04-23 10:00:00	IWM	ETF	39.075	39.15	38.985	39.055	185600.0

> showing 50 of 683 rows — these rows as CSV

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