PREVIEW / etf_30min / 2005-05-20

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-05-20.parquet
  size:    42 KB
  rows:    1,471

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
2005-05-20 07:00:00	SPY	ETF	119.15	119.18	119.14	119.14	30600.0
2005-05-20 07:30:00	SPY	ETF	119.16	119.16	119.08	119.08	18900.0
2005-05-20 08:00:00	SPY	ETF	119.1	119.11	119.06	119.11	15200.0
2005-05-20 08:30:00	SPY	ETF	119.13	119.14	119.09	119.14	21100.0
2005-05-20 09:00:00	SPY	ETF	119.17	119.42	119.17	119.36	123400.0
2005-05-20 09:30:00	SPY	ETF	119.34	119.39	118.93	119.1	6965500.0
2005-05-20 10:00:00	SPY	ETF	119.1	119.19	118.9	119.0	3798800.0
2005-05-20 10:30:00	SPY	ETF	119.005	119.16	118.91	119.06	4056900.0
2005-05-20 11:00:00	SPY	ETF	119.05	119.11	118.81	118.82	3517100.0
2005-05-20 11:30:00	SPY	ETF	118.82	118.98	118.74	118.97	5819500.0
2005-05-20 12:00:00	SPY	ETF	118.96	119.09	118.85	119.05	2186800.0
2005-05-20 12:30:00	SPY	ETF	119.06	119.14	118.95	119.1	1586800.0
2005-05-20 13:00:00	SPY	ETF	119.1	119.15	118.9	119.03	2066000.0
2005-05-20 13:30:00	SPY	ETF	119.03	119.24	119.0	119.11	1828600.0
2005-05-20 14:00:00	SPY	ETF	119.12	119.34	119.12	119.24	2070800.0
2005-05-20 14:30:00	SPY	ETF	119.24	119.34	119.11	119.15	1906200.0
2005-05-20 15:00:00	SPY	ETF	119.14	119.22	119.03	119.21	2001400.0
2005-05-20 15:30:00	SPY	ETF	119.21	119.29	119.12	119.15	5955600.0
2005-05-20 16:00:00	SPY	ETF	119.14	119.2	119.1	119.15	617400.0
2005-05-20 16:30:00	SPY	ETF	119.19	119.28	119.17	119.19	10400.0
2005-05-20 17:00:00	SPY	ETF	119.2	119.33	119.2	119.33	17200.0
2005-05-20 17:30:00	SPY	ETF	119.2	119.2	119.17	119.17	5700.0
2005-05-20 09:30:00	QQQ	ETF	37.45	37.48	37.35	37.41	9334300.0
2005-05-20 10:00:00	QQQ	ETF	37.41	37.5	37.4	37.43	6248500.0
2005-05-20 10:30:00	QQQ	ETF	37.43	37.59	37.43	37.55	6619800.0
2005-05-20 11:00:00	QQQ	ETF	37.55	37.56	37.48	37.49	4245500.0
2005-05-20 11:30:00	QQQ	ETF	37.49	37.56	37.46	37.55	3967300.0
2005-05-20 12:00:00	QQQ	ETF	37.56	37.6	35.56	37.57	3269000.0
2005-05-20 12:30:00	QQQ	ETF	37.57	37.58	37.5	37.57	2822100.0
2005-05-20 13:00:00	QQQ	ETF	37.56	37.6	37.47	37.53	3105200.0
2005-05-20 13:30:00	QQQ	ETF	37.52	37.61	37.51	37.55	2767500.0
2005-05-20 14:00:00	QQQ	ETF	37.55	37.66	37.55	37.63	4561700.0
2005-05-20 14:30:00	QQQ	ETF	37.63	37.69	37.62	37.65	5403200.0
2005-05-20 15:00:00	QQQ	ETF	37.65	37.65	37.6	37.64	3507500.0
2005-05-20 15:30:00	QQQ	ETF	37.64	37.67	37.63	37.66	5393700.0
2005-05-20 07:30:00	IWM	ETF	60.545	60.545	60.545	60.545	200.0
2005-05-20 09:00:00	IWM	ETF	60.65	60.7	60.645	60.65	4000.0
2005-05-20 09:30:00	IWM	ETF	60.65	60.72	60.32	60.445	2504000.0
2005-05-20 10:00:00	IWM	ETF	60.36	60.52	60.305	60.435	2179600.0
2005-05-20 10:30:00	IWM	ETF	60.435	60.485	60.3	60.335	2985400.0
2005-05-20 11:00:00	IWM	ETF	60.315	60.355	60.19	60.205	864400.0
2005-05-20 11:30:00	IWM	ETF	60.21	60.33	60.185	60.315	1028400.0
2005-05-20 12:00:00	IWM	ETF	60.315	60.44	60.26	60.41	684600.0
2005-05-20 12:30:00	IWM	ETF	60.42	60.56	60.32	60.535	1393800.0
2005-05-20 13:00:00	IWM	ETF	60.54	60.575	60.43	60.5	1460000.0
2005-05-20 13:30:00	IWM	ETF	60.495	60.56	60.455	60.515	1847600.0
2005-05-20 14:00:00	IWM	ETF	60.52	60.665	60.52	60.625	1207800.0
2005-05-20 14:30:00	IWM	ETF	60.64	60.72	60.545	60.6	1503400.0
2005-05-20 15:00:00	IWM	ETF	60.6	60.66	60.525	60.635	1491400.0
2005-05-20 15:30:00	IWM	ETF	60.63	60.64	60.53	60.565	2697000.0

> showing 50 of 1,471 rows — these rows as CSV

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