PREVIEW / etf_30min / 2005-07-18

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-07-18.parquet
  size:    42 KB
  rows:    1,569

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-07-18 07:00:00	SPY	ETF	122.6	122.61	122.58	122.58	8000.0
2005-07-18 07:30:00	SPY	ETF	122.56	122.6	122.56	122.6	9400.0
2005-07-18 08:00:00	SPY	ETF	122.57	122.63	122.57	122.61	148300.0
2005-07-18 08:30:00	SPY	ETF	122.61	122.61	122.58	122.6	48900.0
2005-07-18 09:00:00	SPY	ETF	122.58	122.58	122.5	122.52	100600.0
2005-07-18 09:30:00	SPY	ETF	122.5	122.63	122.33	122.39	9809900.0
2005-07-18 10:00:00	SPY	ETF	122.38	122.58	122.2	122.54	14873800.0
2005-07-18 10:30:00	SPY	ETF	122.54	122.63	122.39	122.47	3261200.0
2005-07-18 11:00:00	SPY	ETF	122.46	122.62	122.41	122.44	2211400.0
2005-07-18 11:30:00	SPY	ETF	122.44	122.55	122.35	122.44	2304600.0
2005-07-18 12:00:00	SPY	ETF	122.43	122.49	122.3	122.45	1393200.0
2005-07-18 12:30:00	SPY	ETF	122.44	122.5	122.39	122.46	679000.0
2005-07-18 13:00:00	SPY	ETF	122.47	122.48	122.27	122.31	1055600.0
2005-07-18 13:30:00	SPY	ETF	122.281	122.57	122.281	122.44	1298700.0
2005-07-18 14:00:00	SPY	ETF	122.46	122.52	122.4	122.44	1184200.0
2005-07-18 14:30:00	SPY	ETF	122.44	122.52	122.27	122.35	3689000.0
2005-07-18 15:00:00	SPY	ETF	122.36	122.42	122.25	122.32	3304300.0
2005-07-18 15:30:00	SPY	ETF	122.32	122.37	122.05	122.17	3428800.0
2005-07-18 16:00:00	SPY	ETF	122.2	122.5	122.1	122.41	2455300.0
2005-07-18 16:30:00	SPY	ETF	122.41	122.55	122.4	122.55	340500.0
2005-07-18 17:00:00	SPY	ETF	122.53	122.56	122.52	122.52	31700.0
2005-07-18 17:30:00	SPY	ETF	122.55	122.55	122.52	122.53	5800.0
2005-07-18 18:00:00	SPY	ETF	122.53	122.54	122.49	122.5	69300.0
2005-07-18 18:30:00	SPY	ETF	122.49	122.51	122.49	122.49	39000.0
2005-07-18 19:00:00	SPY	ETF	122.48	122.52	122.48	122.52	3000.0
2005-07-18 19:30:00	SPY	ETF	122.5	122.5	122.48	122.48	500.0
2005-07-18 09:30:00	QQQ	ETF	38.78	38.83	38.69	38.75	9826900.0
2005-07-18 10:00:00	QQQ	ETF	38.74	38.87	38.69	38.86	8813000.0
2005-07-18 10:30:00	QQQ	ETF	38.85	38.89	38.74	38.77	5419700.0
2005-07-18 11:00:00	QQQ	ETF	38.77	38.83	38.75	38.76	2986100.0
2005-07-18 11:30:00	QQQ	ETF	38.76	38.78	38.71	38.73	2975700.0
2005-07-18 12:00:00	QQQ	ETF	38.73	38.8	38.69	38.74	4883100.0
2005-07-18 12:30:00	QQQ	ETF	38.74	38.8	38.71	38.79	2399200.0
2005-07-18 13:00:00	QQQ	ETF	38.78	38.79	38.7	38.72	2513000.0
2005-07-18 13:30:00	QQQ	ETF	38.72	38.82	38.7	38.78	3282000.0
2005-07-18 14:00:00	QQQ	ETF	38.79	38.8	38.75	38.77	1947500.0
2005-07-18 14:30:00	QQQ	ETF	38.77	38.79	38.71	38.74	1713800.0
2005-07-18 15:00:00	QQQ	ETF	38.74	38.8	38.72	38.75	2502000.0
2005-07-18 15:30:00	QQQ	ETF	38.75	38.76	38.71	38.72	5066400.0
2005-07-18 08:00:00	IWM	ETF	65.95	65.95	65.86	65.86	60300.0
2005-07-18 08:30:00	IWM	ETF	65.89	65.89	65.89	65.89	500.0
2005-07-18 09:00:00	IWM	ETF	65.93	65.93	65.9	65.93	4000.0
2005-07-18 09:30:00	IWM	ETF	65.91	66.08	65.59	65.69	3694200.0
2005-07-18 10:00:00	IWM	ETF	65.67	65.75	65.53	65.72	1075000.0
2005-07-18 10:30:00	IWM	ETF	65.71	65.78	65.43	65.5	970100.0
2005-07-18 11:00:00	IWM	ETF	65.51	65.72	65.45	65.55	981500.0
2005-07-18 11:30:00	IWM	ETF	65.54	65.58	65.43	65.54	696200.0
2005-07-18 12:00:00	IWM	ETF	65.54	65.6	65.37	65.58	985600.0
2005-07-18 12:30:00	IWM	ETF	65.58	65.61	65.5	65.6	370700.0
2005-07-18 13:00:00	IWM	ETF	65.61	65.65	65.51	65.54	659000.0

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

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