PREVIEW / etf_30min / 2005-04-18

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-04-18.parquet
  size:    47 KB
  rows:    1,589

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-04-18 04:00:00	SPY	ETF	113.48	113.48	113.48	113.48	1000.0
2005-04-18 07:00:00	SPY	ETF	113.67	113.82	113.64	113.8	76200.0
2005-04-18 07:30:00	SPY	ETF	114.01	114.22	113.99	114.2	432400.0
2005-04-18 08:00:00	SPY	ETF	114.2	114.43	114.2	114.34	375100.0
2005-04-18 08:30:00	SPY	ETF	114.34	114.36	114.28	114.28	106600.0
2005-04-18 09:00:00	SPY	ETF	114.26	114.27	114.13	114.15	129300.0
2005-04-18 09:30:00	SPY	ETF	114.12	114.48	113.96	114.38	16838700.0
2005-04-18 10:00:00	SPY	ETF	114.38	114.8	114.3	114.56	17993800.0
2005-04-18 10:30:00	SPY	ETF	114.55	114.69	114.2	114.57	9462500.0
2005-04-18 11:00:00	SPY	ETF	114.55	114.82	114.3	114.39	5345400.0
2005-04-18 11:30:00	SPY	ETF	114.4	114.67	114.02	114.21	6228500.0
2005-04-18 12:00:00	SPY	ETF	114.21	114.3	114.08	114.26	3089500.0
2005-04-18 12:30:00	SPY	ETF	114.26	114.89	114.24	114.75	6841300.0
2005-04-18 13:00:00	SPY	ETF	114.74	114.96	114.55	114.71	5109200.0
2005-04-18 13:30:00	SPY	ETF	114.71	114.78	114.3	114.65	2745600.0
2005-04-18 14:00:00	SPY	ETF	114.64	114.9	114.41	114.51	3671400.0
2005-04-18 14:30:00	SPY	ETF	114.51	114.59	114.28	114.56	4212300.0
2005-04-18 15:00:00	SPY	ETF	114.55	114.88	114.48	114.87	4962600.0
2005-04-18 15:30:00	SPY	ETF	114.86	114.94	114.58	114.6	8054900.0
2005-04-18 16:00:00	SPY	ETF	114.6	114.7	114.33	114.52	948200.0
2005-04-18 16:30:00	SPY	ETF	114.57	114.75	114.57	114.75	207600.0
2005-04-18 17:00:00	SPY	ETF	114.75	114.75	114.7	114.75	6800.0
2005-04-18 17:30:00	SPY	ETF	114.75	114.85	114.5	114.75	114300.0
2005-04-18 18:00:00	SPY	ETF	114.75	114.77	114.75	114.77	500.0
2005-04-18 18:30:00	SPY	ETF	114.8	114.8	114.8	114.8	2000.0
2005-04-18 19:00:00	SPY	ETF	114.76	114.8	114.76	114.8	1000.0
2005-04-18 19:30:00	SPY	ETF	114.8	114.8	114.79	114.79	900.0
2005-04-18 09:30:00	QQQ	ETF	34.74	34.88	34.64	34.85	20517600.0
2005-04-18 10:00:00	QQQ	ETF	34.85	35.1	34.81	34.85	13130500.0
2005-04-18 10:30:00	QQQ	ETF	34.85	34.91	34.69	34.87	7803900.0
2005-04-18 11:00:00	QQQ	ETF	34.86	34.97	34.78	34.81	8083000.0
2005-04-18 11:30:00	QQQ	ETF	34.8	34.82	34.65	34.7	5976200.0
2005-04-18 12:00:00	QQQ	ETF	34.7	34.75	34.66	34.74	4682300.0
2005-04-18 12:30:00	QQQ	ETF	34.75	34.93	34.71	34.89	5277900.0
2005-04-18 13:00:00	QQQ	ETF	34.88	34.95	34.77	34.86	6271000.0
2005-04-18 13:30:00	QQQ	ETF	34.86	34.88	34.77	34.81	3921400.0
2005-04-18 14:00:00	QQQ	ETF	34.81	34.92	34.7	34.75	6102700.0
2005-04-18 14:30:00	QQQ	ETF	34.75	34.78	34.66	34.76	4991000.0
2005-04-18 15:00:00	QQQ	ETF	34.75	34.89	34.73	34.89	4945900.0
2005-04-18 15:30:00	QQQ	ETF	34.88	34.91	34.74	34.74	7705300.0
2005-04-18 07:30:00	IWM	ETF	57.595	57.75	57.595	57.75	24400.0
2005-04-18 08:00:00	IWM	ETF	57.775	57.905	57.75	57.875	52000.0
2005-04-18 08:30:00	IWM	ETF	57.89	57.89	57.845	57.89	55400.0
2005-04-18 09:00:00	IWM	ETF	57.89	57.89	57.67	57.67	37600.0
2005-04-18 09:30:00	IWM	ETF	57.71	57.95	57.31	57.68	6851000.0
2005-04-18 10:00:00	IWM	ETF	57.675	58.21	57.435	57.975	7115600.0
2005-04-18 10:30:00	IWM	ETF	57.975	58.185	57.74	57.975	2452600.0
2005-04-18 11:00:00	IWM	ETF	57.975	58.085	57.7	57.745	1769400.0
2005-04-18 11:30:00	IWM	ETF	57.7445	57.75	57.57	57.695	2535600.0
2005-04-18 12:00:00	IWM	ETF	57.69	57.815	57.66	57.8	559000.0

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

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