PREVIEW / etf_30min / 2005-08-11

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-08-11.parquet
  size:    47 KB
  rows:    1,641

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-08-11 07:00:00	SPY	ETF	123.5	123.53	123.5	123.53	89200.0
2005-08-11 07:30:00	SPY	ETF	123.52	123.52	123.46	123.46	5500.0
2005-08-11 08:00:00	SPY	ETF	123.47	123.5	123.28	123.3	329300.0
2005-08-11 08:30:00	SPY	ETF	123.34	123.34	123.22	123.29	181700.0
2005-08-11 09:00:00	SPY	ETF	123.29	123.31	123.26	123.27	82800.0
2005-08-11 09:30:00	SPY	ETF	123.27	123.51	123.24	123.42	5535800.0
2005-08-11 10:00:00	SPY	ETF	123.43	124.03	123.36	123.92	6636100.0
2005-08-11 10:30:00	SPY	ETF	123.92	123.94	123.73	123.83	3339100.0
2005-08-11 11:00:00	SPY	ETF	123.84	123.94	123.56	123.63	4874000.0
2005-08-11 11:30:00	SPY	ETF	123.63	123.63	123.4	123.53	3716400.0
2005-08-11 12:00:00	SPY	ETF	123.51	123.62	123.14	123.19	7075200.0
2005-08-11 12:30:00	SPY	ETF	123.19	123.34	123.14	123.33	2100000.0
2005-08-11 13:00:00	SPY	ETF	123.32	123.48	123.27	123.422	3343100.0
2005-08-11 13:30:00	SPY	ETF	123.43	123.43	123.19	123.3	1903100.0
2005-08-11 14:00:00	SPY	ETF	123.29	123.35	123.01	123.19	2145900.0
2005-08-11 14:30:00	SPY	ETF	123.18	123.46	123.17	123.35	1977000.0
2005-08-11 15:00:00	SPY	ETF	123.36	124.0	123.27	123.8	4772800.0
2005-08-11 15:30:00	SPY	ETF	123.78	123.99	123.77	123.97	5258500.0
2005-08-11 16:00:00	SPY	ETF	124.03	124.03	123.75	123.8	2270300.0
2005-08-11 16:30:00	SPY	ETF	123.79	123.82	123.72	123.73	126700.0
2005-08-11 17:00:00	SPY	ETF	123.75	123.76	123.72	123.73	209200.0
2005-08-11 17:30:00	SPY	ETF	123.76	123.79	123.76	123.78	4700.0
2005-08-11 18:00:00	SPY	ETF	123.77	123.79	123.76	123.77	8100.0
2005-08-11 18:30:00	SPY	ETF	123.82	123.82	123.82	123.82	700.0
2005-08-11 19:00:00	SPY	ETF	123.8	123.82	123.77	123.82	26500.0
2005-08-11 19:30:00	SPY	ETF	123.82	123.82	123.82	123.82	500.0
2005-08-11 09:30:00	QQQ	ETF	39.13	39.25	39.1	39.13	10331700.0
2005-08-11 10:00:00	QQQ	ETF	39.12	39.54	39.12	39.5	13514500.0
2005-08-11 10:30:00	QQQ	ETF	39.5	39.51	39.4	39.46	8915500.0
2005-08-11 11:00:00	QQQ	ETF	39.46	39.49	39.3	39.33	4926500.0
2005-08-11 11:30:00	QQQ	ETF	39.33	39.38	39.26	39.34	5327600.0
2005-08-11 12:00:00	QQQ	ETF	39.34	39.38	39.15	39.17	7880500.0
2005-08-11 12:30:00	QQQ	ETF	39.17	39.49	39.15	39.23	4378600.0
2005-08-11 13:00:00	QQQ	ETF	39.23	39.28	39.21	39.25	4727400.0
2005-08-11 13:30:00	QQQ	ETF	39.26	39.27	39.21	39.25	2711900.0
2005-08-11 14:00:00	QQQ	ETF	39.25	39.26	39.15	39.22	3713400.0
2005-08-11 14:30:00	QQQ	ETF	39.22	39.34	39.22	39.29	3524200.0
2005-08-11 15:00:00	QQQ	ETF	39.29	39.44	39.25	39.39	4374700.0
2005-08-11 15:30:00	QQQ	ETF	39.38	39.47	39.38	39.44	6489300.0
2005-08-11 07:30:00	IWM	ETF	65.78	65.78	65.78	65.78	200.0
2005-08-11 08:30:00	IWM	ETF	65.68	65.68	65.6	65.6	102000.0
2005-08-11 09:00:00	IWM	ETF	65.61	65.61	65.58	65.6	51700.0
2005-08-11 09:30:00	IWM	ETF	65.57	65.71	65.55	65.67	1852500.0
2005-08-11 10:00:00	IWM	ETF	65.67	66.27	65.662	66.19	3547900.0
2005-08-11 10:30:00	IWM	ETF	66.19	66.2	65.97	66.11	1070300.0
2005-08-11 11:00:00	IWM	ETF	66.12	66.16	65.91	65.97	922800.0
2005-08-11 11:30:00	IWM	ETF	65.96	65.97	65.77	65.83	1605700.0
2005-08-11 12:00:00	IWM	ETF	65.83	65.92	65.63	65.64	948200.0
2005-08-11 12:30:00	IWM	ETF	65.64	65.79	65.62	65.78	737000.0
2005-08-11 13:00:00	IWM	ETF	65.78	65.89	65.75	65.83	738900.0

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

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