PREVIEW / etf_1hour / 2006-11-30

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-11-30.parquet
  size:    58 KB
  rows:    1,815

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-11-30 07:00:00	SPY	ETF	140.65	140.71	140.65	140.7	28400.0
2006-11-30 08:00:00	SPY	ETF	140.7	140.82	140.43	140.51	2024100.0
2006-11-30 09:00:00	SPY	ETF	140.52	140.69	140.25	140.49	9305600.0
2006-11-30 10:00:00	SPY	ETF	140.49	140.67	139.76	140.15	19708700.0
2006-11-30 11:00:00	SPY	ETF	140.14	140.24	139.8	139.94	9690100.0
2006-11-30 12:00:00	SPY	ETF	139.95	140.3	139.94	140.17	5523400.0
2006-11-30 13:00:00	SPY	ETF	140.17	140.67	140.16	140.25	11940600.0
2006-11-30 14:00:00	SPY	ETF	140.26	140.97	140.25	140.9	10381000.0
2006-11-30 15:00:00	SPY	ETF	140.9	141.05	140.45	140.45	11086100.0
2006-11-30 16:00:00	SPY	ETF	140.45	140.56	140.42	140.46	2210900.0
2006-11-30 17:00:00	SPY	ETF	140.45	140.48	140.36	140.39	292200.0
2006-11-30 18:00:00	SPY	ETF	140.4	140.45	140.4	140.45	3100.0
2006-11-30 19:00:00	SPY	ETF	140.47	140.47	140.45	140.47	400.0
2006-11-30 09:00:00	QQQ	ETF	44.05	44.17	43.94	44.13	17758700.0
2006-11-30 10:00:00	QQQ	ETF	44.08	44.13	43.79	43.98	29097800.0
2006-11-30 11:00:00	QQQ	ETF	43.98	44.08	43.85	43.94	14980700.0
2006-11-30 12:00:00	QQQ	ETF	43.95	44.08	43.93	44.0	8233700.0
2006-11-30 13:00:00	QQQ	ETF	44.0	44.28	43.99	44.07	13709200.0
2006-11-30 14:00:00	QQQ	ETF	44.07	44.25	44.06	44.22	8684400.0
2006-11-30 15:00:00	QQQ	ETF	44.22	44.26	44.02	44.05	19143100.0
2006-11-30 07:00:00	IWM	ETF	78.15	78.15	78.15	78.15	100.0
2006-11-30 08:00:00	IWM	ETF	78.34	78.35	77.94	78.0	1459300.0
2006-11-30 09:00:00	IWM	ETF	78.01	78.32	77.81	78.18	5555300.0
2006-11-30 10:00:00	IWM	ETF	78.19	78.19	77.5	77.93	14723500.0
2006-11-30 11:00:00	IWM	ETF	77.93	78.02	77.68	77.9	4899800.0
2006-11-30 12:00:00	IWM	ETF	77.9	78.21	77.9	78.11	4839600.0
2006-11-30 13:00:00	IWM	ETF	78.1	78.41	78.03	78.12	3852400.0
2006-11-30 14:00:00	IWM	ETF	78.12	78.6	78.1	78.56	8966400.0
2006-11-30 15:00:00	IWM	ETF	78.56	78.58	78.09	78.09	8433500.0
2006-11-30 16:00:00	IWM	ETF	78.09	78.24	77.93	77.96	3405600.0
2006-11-30 17:00:00	IWM	ETF	78.06	78.14	78.0	78.0	458100.0
2006-11-30 05:00:00	DIA	ETF	123.13	123.13	123.13	123.13	100.0
2006-11-30 08:00:00	DIA	ETF	122.59	122.68	122.35	122.39	53000.0
2006-11-30 09:00:00	DIA	ETF	122.4	122.55	122.18	122.38	1152100.0
2006-11-30 10:00:00	DIA	ETF	122.38	122.38	121.74	121.91	2757100.0
2006-11-30 11:00:00	DIA	ETF	121.93	122.0	121.63	121.69	1076300.0
2006-11-30 12:00:00	DIA	ETF	121.7	121.93	121.7	121.84	525100.0
2006-11-30 13:00:00	DIA	ETF	121.84	122.33	121.81	121.97	1110300.0
2006-11-30 14:00:00	DIA	ETF	121.96	122.55	121.93	122.5	973200.0
2006-11-30 15:00:00	DIA	ETF	122.5	122.77	122.22	122.22	3168600.0
2006-11-30 16:00:00	DIA	ETF	122.21	122.31	122.21	122.22	559600.0
2006-11-30 17:00:00	DIA	ETF	122.22	122.22	122.22	122.22	1050000.0
2006-11-30 19:00:00	DIA	ETF	122.28	122.28	122.28	122.28	300.0
2006-11-30 07:00:00	GLD	ETF	63.49	63.61	63.49	63.61	21900.0
2006-11-30 08:00:00	GLD	ETF	63.61	64.19	63.59	64.01	401900.0
2006-11-30 09:00:00	GLD	ETF	64.0	64.1	63.9	64.05	1200300.0
2006-11-30 10:00:00	GLD	ETF	64.05	64.36	64.04	64.28	1248100.0
2006-11-30 11:00:00	GLD	ETF	64.29	64.4	63.99	64.2	1060200.0
2006-11-30 12:00:00	GLD	ETF	64.2001	64.29	64.15	64.29	566600.0
2006-11-30 13:00:00	GLD	ETF	64.3	64.34	64.15	64.25	431000.0

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

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