PREVIEW / etf_30min / 2005-06-23

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-06-23.parquet
  size:    46 KB
  rows:    1,611

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-06-23 07:00:00	SPY	ETF	121.49	121.49	121.47	121.47	3800.0
2005-06-23 07:30:00	SPY	ETF	121.55	121.55	121.38	121.4	53100.0
2005-06-23 08:00:00	SPY	ETF	121.38	121.43	121.35	121.37	85400.0
2005-06-23 08:30:00	SPY	ETF	121.38	121.42	121.27	121.29	98400.0
2005-06-23 09:00:00	SPY	ETF	121.29	121.36	121.28	121.29	23000.0
2005-06-23 09:30:00	SPY	ETF	121.32	121.41	121.21	121.3	4633100.0
2005-06-23 10:00:00	SPY	ETF	121.28	121.38	121.05	121.16	4136500.0
2005-06-23 10:30:00	SPY	ETF	121.17	121.28	121.01	121.17	3040300.0
2005-06-23 11:00:00	SPY	ETF	121.17	121.5	121.14	121.38	3258400.0
2005-06-23 11:30:00	SPY	ETF	121.38	121.6	121.35	121.42	4915500.0
2005-06-23 12:00:00	SPY	ETF	121.41	121.57	121.28	121.35	1310800.0
2005-06-23 12:30:00	SPY	ETF	121.36	121.46	121.27	121.31	1445400.0
2005-06-23 13:00:00	SPY	ETF	121.3	121.33	121.13	121.16	3306800.0
2005-06-23 13:30:00	SPY	ETF	121.16	121.19	120.35	120.6	10888100.0
2005-06-23 14:00:00	SPY	ETF	120.6	120.8	120.48	120.57	4532300.0
2005-06-23 14:30:00	SPY	ETF	120.59	120.73	120.4	120.53	4003200.0
2005-06-23 15:00:00	SPY	ETF	120.53	120.54	120.07	120.18	6168700.0
2005-06-23 15:30:00	SPY	ETF	120.18	120.27	119.97	120.0	6666900.0
2005-06-23 16:00:00	SPY	ETF	120.0	120.0	119.85	119.86	2114300.0
2005-06-23 16:30:00	SPY	ETF	119.88	119.9	119.83	119.83	279600.0
2005-06-23 17:00:00	SPY	ETF	119.83	119.85	119.79	119.85	317300.0
2005-06-23 17:30:00	SPY	ETF	119.85	119.92	119.84	119.87	23900.0
2005-06-23 18:00:00	SPY	ETF	119.87	119.9	119.87	119.9	5300.0
2005-06-23 18:30:00	SPY	ETF	119.86	119.89	119.86	119.87	2500.0
2005-06-23 19:30:00	SPY	ETF	119.86	119.87	119.86	119.87	3100.0
2005-06-23 09:30:00	QQQ	ETF	37.89	38.03	37.78	37.96	13098600.0
2005-06-23 10:00:00	QQQ	ETF	37.95	37.98	37.77	37.82	6623200.0
2005-06-23 10:30:00	QQQ	ETF	37.82	37.83	37.72	37.81	6205300.0
2005-06-23 11:00:00	QQQ	ETF	37.81	38.02	37.78	37.98	7553200.0
2005-06-23 11:30:00	QQQ	ETF	37.98	38.18	37.97	38.11	12120000.0
2005-06-23 12:00:00	QQQ	ETF	38.11	38.12	38.04	38.05	4324100.0
2005-06-23 12:30:00	QQQ	ETF	38.05	38.07	37.99	38.01	2276800.0
2005-06-23 13:00:00	QQQ	ETF	38.0	38.02	37.89	37.89	5565000.0
2005-06-23 13:30:00	QQQ	ETF	37.89	37.89	37.45	37.53	21892800.0
2005-06-23 14:00:00	QQQ	ETF	37.53	37.6	37.48	37.57	7485400.0
2005-06-23 14:30:00	QQQ	ETF	37.56	37.62	37.49	37.55	5455600.0
2005-06-23 15:00:00	QQQ	ETF	37.55	37.57	37.4	37.41	8599700.0
2005-06-23 15:30:00	QQQ	ETF	37.42	37.44	37.33	37.37	12813100.0
2005-06-23 08:00:00	IWM	ETF	63.9	63.9	63.9	63.9	100.0
2005-06-23 09:00:00	IWM	ETF	63.93	63.93	63.93	63.93	100.0
2005-06-23 09:30:00	IWM	ETF	63.91	64.0	63.8	63.94	1198600.0
2005-06-23 10:00:00	IWM	ETF	63.95	63.96	63.73	63.83	1064800.0
2005-06-23 10:30:00	IWM	ETF	63.83	63.86	63.7	63.82	689700.0
2005-06-23 11:00:00	IWM	ETF	63.81	63.99	63.75	63.92	1060600.0
2005-06-23 11:30:00	IWM	ETF	63.93	64.11	63.93	63.99	490100.0
2005-06-23 12:00:00	IWM	ETF	64.0	64.0	63.92	63.92	490300.0
2005-06-23 12:30:00	IWM	ETF	63.9	63.96	63.84	63.84	568400.0
2005-06-23 13:00:00	IWM	ETF	63.84	63.87	63.8	63.85	417300.0
2005-06-23 13:30:00	IWM	ETF	63.85	63.88	63.28	63.39	2289100.0
2005-06-23 14:00:00	IWM	ETF	63.38	63.53	63.31	63.41	1449300.0

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

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