PREVIEW / etf_1hour / 2006-10-09

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-10-09.parquet
  size:    53 KB
  rows:    1,694

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-10-09 06:00:00	SPY	ETF	134.82	134.82	134.81	134.81	26000.0
2006-10-09 07:00:00	SPY	ETF	134.9	134.9	134.7	134.71	154700.0
2006-10-09 08:00:00	SPY	ETF	134.7	134.81	134.61	134.81	357600.0
2006-10-09 09:00:00	SPY	ETF	134.82	135.0	134.77	134.89	4013800.0
2006-10-09 10:00:00	SPY	ETF	134.89	134.98	134.64	134.86	7141900.0
2006-10-09 11:00:00	SPY	ETF	134.85	135.08	134.77	134.95	7627900.0
2006-10-09 12:00:00	SPY	ETF	134.95	135.1	134.95	134.99	3628000.0
2006-10-09 13:00:00	SPY	ETF	134.99	135.22	134.9591	135.02	4698200.0
2006-10-09 14:00:00	SPY	ETF	135.02	135.3	135.0	135.2	4003600.0
2006-10-09 15:00:00	SPY	ETF	135.2	135.24	134.95	135.06	6135800.0
2006-10-09 16:00:00	SPY	ETF	135.05	135.12	135.01	135.09	776700.0
2006-10-09 17:00:00	SPY	ETF	135.1	135.11	135.03	135.03	73300.0
2006-10-09 18:00:00	SPY	ETF	135.1	135.1	135.01	135.01	1100.0
2006-10-09 09:00:00	QQQ	ETF	41.37	41.47	41.32	41.45	7467100.0
2006-10-09 10:00:00	QQQ	ETF	41.46	41.48	41.33	41.46	8743700.0
2006-10-09 11:00:00	QQQ	ETF	41.46	41.65	41.4	41.58	11989000.0
2006-10-09 12:00:00	QQQ	ETF	41.59	41.65	41.56	41.6	4225800.0
2006-10-09 13:00:00	QQQ	ETF	41.59	41.71	41.58	41.61	6345000.0
2006-10-09 14:00:00	QQQ	ETF	41.6	41.74	41.6	41.69	6163700.0
2006-10-09 15:00:00	QQQ	ETF	41.69	41.7	41.52	41.54	12824400.0
2006-10-09 07:00:00	IWM	ETF	73.5	73.5	73.3	73.3	200.0
2006-10-09 08:00:00	IWM	ETF	73.5	73.5	73.22	73.27	68300.0
2006-10-09 09:00:00	IWM	ETF	73.3	73.46	73.11	73.28	2591800.0
2006-10-09 10:00:00	IWM	ETF	73.27	73.4	73.06	73.36	2505500.0
2006-10-09 11:00:00	IWM	ETF	73.35	73.78	73.27	73.63	5752700.0
2006-10-09 12:00:00	IWM	ETF	73.63	73.87	73.59	73.74	2987500.0
2006-10-09 13:00:00	IWM	ETF	73.74	74.02	73.72	73.84	3346800.0
2006-10-09 14:00:00	IWM	ETF	73.85	74.14	73.83	74.02	3068700.0
2006-10-09 15:00:00	IWM	ETF	74.01	74.02	73.76	73.93	5337300.0
2006-10-09 16:00:00	IWM	ETF	73.93	74.09	73.9	74.01	95500.0
2006-10-09 17:00:00	IWM	ETF	74.01	74.05	74.01	74.05	300.0
2006-10-09 18:00:00	IWM	ETF	74.0	74.0	74.0	74.0	200.0
2006-10-09 19:00:00	IWM	ETF	73.99	73.99	73.99	73.99	1500.0
2006-10-09 07:00:00	DIA	ETF	118.23	118.23	118.23	118.23	200.0
2006-10-09 08:00:00	DIA	ETF	118.28	118.3	118.27	118.3	4800.0
2006-10-09 09:00:00	DIA	ETF	118.3	118.43	118.25	118.34	416100.0
2006-10-09 10:00:00	DIA	ETF	118.32	118.38	118.1	118.32	837400.0
2006-10-09 11:00:00	DIA	ETF	118.32	118.52	118.27	118.41	475600.0
2006-10-09 12:00:00	DIA	ETF	118.41	118.53	118.4	118.43	162000.0
2006-10-09 13:00:00	DIA	ETF	118.42	118.59	118.4	118.4	366000.0
2006-10-09 14:00:00	DIA	ETF	118.41	118.74	118.41	118.66	434700.0
2006-10-09 15:00:00	DIA	ETF	118.65	118.65	118.4	118.6	672600.0
2006-10-09 16:00:00	DIA	ETF	118.57	118.65	118.57	118.6	18800.0
2006-10-09 17:00:00	DIA	ETF	118.61	118.61	118.61	118.61	500.0
2006-10-09 19:00:00	DIA	ETF	118.58	118.62	118.58	118.62	600.0
2006-10-09 08:00:00	GLD	ETF	57.32	57.49	57.16	57.39	50800.0
2006-10-09 09:00:00	GLD	ETF	57.41	57.47	57.25	57.27	587300.0
2006-10-09 10:00:00	GLD	ETF	57.28	57.39	57.1	57.15	467000.0
2006-10-09 11:00:00	GLD	ETF	57.15	57.27	56.72	56.94	451700.0
2006-10-09 12:00:00	GLD	ETF	56.93	57.37	56.89	57.36	338300.0

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

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