PREVIEW / etf_1hour / 2005-11-17

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-11-17.parquet
  size:    35 KB
  rows:    1,055

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-11-17 06:00:00	SPY	ETF	123.77	123.8	123.77	123.8	700.0
2005-11-17 07:00:00	SPY	ETF	123.8	123.92	123.79	123.85	136500.0
2005-11-17 08:00:00	SPY	ETF	123.85	123.95	123.77	123.85	728600.0
2005-11-17 09:00:00	SPY	ETF	123.83	123.9	123.68	123.76	6485800.0
2005-11-17 10:00:00	SPY	ETF	123.78	124.04	123.62	123.74	9724400.0
2005-11-17 11:00:00	SPY	ETF	123.75	123.91	123.59	123.85	3909600.0
2005-11-17 12:00:00	SPY	ETF	123.84	124.0	123.77	123.95	4307200.0
2005-11-17 13:00:00	SPY	ETF	123.95	124.07	123.82	124.0	3244300.0
2005-11-17 14:00:00	SPY	ETF	124.0	124.35	123.94	124.2	12104000.0
2005-11-17 15:00:00	SPY	ETF	124.19	124.62	124.17	124.54	12844800.0
2005-11-17 16:00:00	SPY	ETF	124.53	124.68	124.46	124.55	1060700.0
2005-11-17 17:00:00	SPY	ETF	124.55	124.59	124.54	124.59	38100.0
2005-11-17 18:00:00	SPY	ETF	124.59	124.65	124.59	124.65	75900.0
2005-11-17 19:00:00	SPY	ETF	124.63	124.64	124.63	124.64	2200.0
2005-11-17 09:00:00	QQQ	ETF	40.91	40.94	40.88	40.9	7639900.0
2005-11-17 10:00:00	QQQ	ETF	40.9	41.06	40.85	40.9	14763000.0
2005-11-17 11:00:00	QQQ	ETF	40.9	40.98	40.85	40.93	9252600.0
2005-11-17 12:00:00	QQQ	ETF	40.93	41.02	40.91	40.98	7378700.0
2005-11-17 13:00:00	QQQ	ETF	40.98	41.02	40.92	41.0	6806800.0
2005-11-17 14:00:00	QQQ	ETF	41.0	41.05	40.96	41.0	12656500.0
2005-11-17 15:00:00	QQQ	ETF	41.0	41.32	41.0	41.31	27045400.0
2005-11-17 08:00:00	IWM	ETF	65.5	65.56	65.45	65.48	232700.0
2005-11-17 09:00:00	IWM	ETF	65.52	65.8	65.31	65.78	3695000.0
2005-11-17 10:00:00	IWM	ETF	65.79	65.83	65.49	65.61	2732200.0
2005-11-17 11:00:00	IWM	ETF	65.61	65.85	65.51	65.75	1459900.0
2005-11-17 12:00:00	IWM	ETF	65.75	66.02	65.69	65.96	3768200.0
2005-11-17 13:00:00	IWM	ETF	65.96	66.06	65.8	66.04	1165600.0
2005-11-17 14:00:00	IWM	ETF	66.05	66.23	66.01	66.18	2451600.0
2005-11-17 15:00:00	IWM	ETF	66.19	66.4	66.11	66.4	5471100.0
2005-11-17 16:00:00	IWM	ETF	66.45	66.45	66.33	66.35	328800.0
2005-11-17 17:00:00	IWM	ETF	66.31	66.39	66.31	66.39	75700.0
2005-11-17 19:00:00	IWM	ETF	66.38	66.38	66.38	66.38	1000.0
2005-11-17 07:00:00	DIA	ETF	107.25	107.28	107.25	107.28	2700.0
2005-11-17 08:00:00	DIA	ETF	107.28	107.3	107.23	107.24	19900.0
2005-11-17 09:00:00	DIA	ETF	107.15	107.23	106.97	106.98	574700.0
2005-11-17 10:00:00	DIA	ETF	106.98	107.21	106.8912	106.9812	654300.0
2005-11-17 11:00:00	DIA	ETF	106.97	107.07	106.86	107.0012	397800.0
2005-11-17 12:00:00	DIA	ETF	107.0	107.13	106.95	107.021	428600.0
2005-11-17 13:00:00	DIA	ETF	107.02	107.05	106.92	107.0	383600.0
2005-11-17 14:00:00	DIA	ETF	106.9999	107.34	106.97	107.21	965100.0
2005-11-17 15:00:00	DIA	ETF	107.22	107.48	107.1501	107.361	1448600.0
2005-11-17 16:00:00	DIA	ETF	107.36	107.43	107.34	107.38	408800.0
2005-11-17 19:00:00	DIA	ETF	107.38	107.38	107.38	107.38	100.0
2005-11-17 08:00:00	GLD	ETF	48.07	48.41	47.91	48.35	152100.0
2005-11-17 09:00:00	GLD	ETF	48.4	48.46	48.17	48.38	755600.0
2005-11-17 10:00:00	GLD	ETF	48.38	48.58	48.36	48.42	758500.0
2005-11-17 11:00:00	GLD	ETF	48.42	48.51	48.26	48.44	396600.0
2005-11-17 12:00:00	GLD	ETF	48.45	48.49	48.35	48.48	348900.0
2005-11-17 13:00:00	GLD	ETF	48.48	48.52	48.4	48.4	231000.0
2005-11-17 14:00:00	GLD	ETF	48.45	48.5	48.31	48.34	304700.0

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

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