PREVIEW / etf_30min / 2006-01-23

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-01-23.parquet
  size:    59 KB
  rows:    2,174

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
2006-01-23 04:30:00	SPY	ETF	126.39	126.41	126.39	126.41	500.0
2006-01-23 05:00:00	SPY	ETF	126.39	126.4	126.39	126.4	8500.0
2006-01-23 05:30:00	SPY	ETF	126.4	126.4	126.36	126.36	1000.0
2006-01-23 06:30:00	SPY	ETF	126.16	126.16	126.16	126.16	1500.0
2006-01-23 07:00:00	SPY	ETF	126.14	126.3	126.14	126.3	24100.0
2006-01-23 07:30:00	SPY	ETF	126.3	126.42	126.3	126.35	213500.0
2006-01-23 08:00:00	SPY	ETF	126.42	126.42	126.14	126.4	940400.0
2006-01-23 08:30:00	SPY	ETF	126.39	126.44	125.95	126.28	642000.0
2006-01-23 09:00:00	SPY	ETF	126.28	126.31	126.23	126.23	295600.0
2006-01-23 09:30:00	SPY	ETF	126.21	126.44	126.18	126.24	8414000.0
2006-01-23 10:00:00	SPY	ETF	126.24	126.5	126.13	126.43	6065400.0
2006-01-23 10:30:00	SPY	ETF	126.43	126.53	126.19	126.5	3882300.0
2006-01-23 11:00:00	SPY	ETF	126.49	126.67	126.43	126.66	4013600.0
2006-01-23 11:30:00	SPY	ETF	126.64	126.82	126.64	126.72	3207300.0
2006-01-23 12:00:00	SPY	ETF	126.73	126.78	126.39	126.47	2872800.0
2006-01-23 12:30:00	SPY	ETF	126.47	126.55	126.2	126.27	2935300.0
2006-01-23 13:00:00	SPY	ETF	126.29	126.65	126.26	126.6	2832600.0
2006-01-23 13:30:00	SPY	ETF	126.59	126.66	126.34	126.37	2368300.0
2006-01-23 14:00:00	SPY	ETF	126.37	126.64	126.2	126.33	3727400.0
2006-01-23 14:30:00	SPY	ETF	126.33	126.5	126.14	126.49	2666600.0
2006-01-23 15:00:00	SPY	ETF	126.5	126.58	126.31	126.46	2698200.0
2006-01-23 15:30:00	SPY	ETF	126.46	126.67	126.28	126.33	3786600.0
2006-01-23 16:00:00	SPY	ETF	126.32	126.47	126.28	126.38	10983700.0
2006-01-23 16:30:00	SPY	ETF	126.41	126.42	126.3	126.3	643800.0
2006-01-23 17:00:00	SPY	ETF	126.29	126.36	126.29	126.36	16700.0
2006-01-23 17:30:00	SPY	ETF	126.36	126.36	126.28	126.28	1500.0
2006-01-23 18:00:00	SPY	ETF	126.32	126.36	126.27	126.34	77400.0
2006-01-23 18:30:00	SPY	ETF	126.3	126.3	126.3	126.3	100.0
2006-01-23 19:00:00	SPY	ETF	126.33	126.44	126.33	126.44	4100.0
2006-01-23 19:30:00	SPY	ETF	126.45	126.47	126.44	126.47	4700.0
2006-01-23 09:30:00	QQQ	ETF	41.37	41.38	41.1	41.11	15406300.0
2006-01-23 10:00:00	QQQ	ETF	41.11	41.32	41.08	41.29	12862900.0
2006-01-23 10:30:00	QQQ	ETF	41.3	41.3	41.13	41.28	6136900.0
2006-01-23 11:00:00	QQQ	ETF	41.28	41.36	41.22	41.36	4194900.0
2006-01-23 11:30:00	QQQ	ETF	41.36	41.45	41.35	41.4	11880400.0
2006-01-23 12:00:00	QQQ	ETF	41.41	41.41	41.2	41.26	3798100.0
2006-01-23 12:30:00	QQQ	ETF	41.27	41.32	41.15	41.2	4221000.0
2006-01-23 13:00:00	QQQ	ETF	41.21	41.35	41.2	41.31	2338200.0
2006-01-23 13:30:00	QQQ	ETF	41.32	41.34	41.17	41.18	3851100.0
2006-01-23 14:00:00	QQQ	ETF	41.18	41.26	41.08	41.15	3815200.0
2006-01-23 14:30:00	QQQ	ETF	41.16	41.25	41.09	41.24	3995800.0
2006-01-23 15:00:00	QQQ	ETF	41.23	41.28	41.17	41.24	3713300.0
2006-01-23 15:30:00	QQQ	ETF	41.24	41.28	41.19	41.26	6591900.0
2006-01-23 08:00:00	IWM	ETF	70.26	70.36	70.26	70.36	33100.0
2006-01-23 08:30:00	IWM	ETF	70.3	70.35	70.26	70.26	18400.0
2006-01-23 09:00:00	IWM	ETF	70.26	70.29	70.25	70.25	36600.0
2006-01-23 09:30:00	IWM	ETF	70.25	70.31	70.1	70.1	5013200.0
2006-01-23 10:00:00	IWM	ETF	70.09	70.12	70.0	70.06	6134900.0
2006-01-23 10:30:00	IWM	ETF	70.06	70.2	69.99	70.19	2525500.0
2006-01-23 11:00:00	IWM	ETF	70.19	70.32	70.15	70.32	1295000.0

> showing 50 of 2,174 rows — these rows as CSV

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