PREVIEW / etf_30min / 2005-07-06

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-07-06.parquet
  size:    44 KB
  rows:    1,577

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-06 07:00:00	SPY	ETF	120.55	120.55	120.55	120.55	15000.0
2005-07-06 07:30:00	SPY	ETF	120.58	120.6	120.54	120.59	46200.0
2005-07-06 08:00:00	SPY	ETF	120.54	120.54	120.45	120.47	99100.0
2005-07-06 08:30:00	SPY	ETF	120.43	120.5	120.43	120.46	26200.0
2005-07-06 09:00:00	SPY	ETF	120.46	120.48	120.41	120.41	185500.0
2005-07-06 09:30:00	SPY	ETF	120.39	120.59	120.35	120.51	3958800.0
2005-07-06 10:00:00	SPY	ETF	120.51	120.65	120.17	120.21	7433400.0
2005-07-06 10:30:00	SPY	ETF	120.21	120.35	120.14	120.32	5819600.0
2005-07-06 11:00:00	SPY	ETF	120.32	120.39	120.18	120.27	1972600.0
2005-07-06 11:30:00	SPY	ETF	120.24	120.38	120.18	120.33	2373000.0
2005-07-06 12:00:00	SPY	ETF	120.32	120.34	119.97	120.02	2379300.0
2005-07-06 12:30:00	SPY	ETF	120.02	120.04	119.86	119.99	3133000.0
2005-07-06 13:00:00	SPY	ETF	119.99	120.22	119.98	120.18	2514900.0
2005-07-06 13:30:00	SPY	ETF	120.18	120.28	120.1	120.19	1043100.0
2005-07-06 14:00:00	SPY	ETF	120.19	120.21	119.7	119.75	3695200.0
2005-07-06 14:30:00	SPY	ETF	119.75	119.77	119.48	119.59	5788200.0
2005-07-06 15:00:00	SPY	ETF	119.59	119.79	119.54	119.78	4991400.0
2005-07-06 15:30:00	SPY	ETF	119.77	119.78	119.45	119.49	5859000.0
2005-07-06 16:00:00	SPY	ETF	119.48	119.949	119.41	119.46	278900.0
2005-07-06 16:30:00	SPY	ETF	119.46	119.48	119.44	119.44	111100.0
2005-07-06 17:00:00	SPY	ETF	119.45	119.49	119.43	119.43	1363100.0
2005-07-06 17:30:00	SPY	ETF	119.45	119.45	119.45	119.45	500.0
2005-07-06 18:00:00	SPY	ETF	119.47	119.48	119.46	119.46	5400.0
2005-07-06 18:30:00	SPY	ETF	119.47	119.47	119.47	119.47	200.0
2005-07-06 19:00:00	SPY	ETF	119.45	119.45	119.45	119.45	400.0
2005-07-06 19:30:00	SPY	ETF	119.45	119.45	119.43	119.43	1300.0
2005-07-06 09:30:00	QQQ	ETF	37.03	37.17	37.0	37.11	9688200.0
2005-07-06 10:00:00	QQQ	ETF	37.11	37.19	37.01	37.05	8902300.0
2005-07-06 10:30:00	QQQ	ETF	37.05	37.13	37.01	37.11	4160900.0
2005-07-06 11:00:00	QQQ	ETF	37.02	37.16	37.02	37.13	2679400.0
2005-07-06 11:30:00	QQQ	ETF	37.13	37.18	37.12	37.15	2586300.0
2005-07-06 12:00:00	QQQ	ETF	37.15	37.17	37.02	37.05	2862000.0
2005-07-06 12:30:00	QQQ	ETF	37.04	37.08	36.99	37.06	2708700.0
2005-07-06 13:00:00	QQQ	ETF	37.06	37.22	37.06	37.19	9460100.0
2005-07-06 13:30:00	QQQ	ETF	37.19	37.28	37.16	37.22	5618800.0
2005-07-06 14:00:00	QQQ	ETF	37.22	37.23	37.02	37.04	6700200.0
2005-07-06 14:30:00	QQQ	ETF	37.03	37.04	36.86	36.97	8779600.0
2005-07-06 15:00:00	QQQ	ETF	36.97	37.05	36.94	37.04	4234800.0
2005-07-06 15:30:00	QQQ	ETF	37.03	37.04	36.88	36.93	6974600.0
2005-07-06 08:00:00	IWM	ETF	64.99	65.03	64.99	65.03	1000.0
2005-07-06 08:30:00	IWM	ETF	65.0	65.0	64.99	64.99	10800.0
2005-07-06 09:30:00	IWM	ETF	65.01	65.06	64.86	65.03	1556500.0
2005-07-06 10:00:00	IWM	ETF	65.03	65.14	64.72	64.73	4421000.0
2005-07-06 10:30:00	IWM	ETF	64.74	64.81	64.65	64.77	1629300.0
2005-07-06 11:00:00	IWM	ETF	64.76	64.83	64.65	64.72	1706600.0
2005-07-06 11:30:00	IWM	ETF	64.73	64.89	64.73	64.85	2103200.0
2005-07-06 12:00:00	IWM	ETF	64.85	64.86	64.61	64.64	742300.0
2005-07-06 12:30:00	IWM	ETF	64.64	64.7	64.55	64.69	592700.0
2005-07-06 13:00:00	IWM	ETF	64.69	64.85	64.69	64.81	711400.0
2005-07-06 13:30:00	IWM	ETF	64.81	64.88	64.76	64.85	946100.0

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

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