PREVIEW / etf_1hour / 2001-11-09

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-11-09.parquet
  size:    13 KB
  rows:    269

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
2001-11-09 09:00:00	SPY	ETF	112.25	112.59	111.74	111.92	3196700.0
2001-11-09 10:00:00	SPY	ETF	111.88	112.9	111.44	112.31	5296000.0
2001-11-09 11:00:00	SPY	ETF	112.32	112.44	111.86	112.23	1639900.0
2001-11-09 12:00:00	SPY	ETF	112.21	112.48	112.02	112.43	1307500.0
2001-11-09 13:00:00	SPY	ETF	112.43	112.79	112.42	112.56	1111900.0
2001-11-09 14:00:00	SPY	ETF	112.52	112.64	112.18	112.36	952200.0
2001-11-09 15:00:00	SPY	ETF	112.37	112.62	112.23	112.44	1263600.0
2001-11-09 16:00:00	SPY	ETF	112.45	112.72	112.17	112.55	1037700.0
2001-11-09 17:00:00	SPY	ETF	112.55	112.6	112.55	112.6	600.0
2001-11-09 09:00:00	QQQ	ETF	37.59	37.95	37.34	37.53	11201600.0
2001-11-09 10:00:00	QQQ	ETF	37.47	37.98	37.12	37.7	18959600.0
2001-11-09 11:00:00	QQQ	ETF	37.78	37.78	37.4	37.6	6986600.0
2001-11-09 12:00:00	QQQ	ETF	37.6	37.89	37.45	37.86	6835700.0
2001-11-09 13:00:00	QQQ	ETF	37.88	38.08	37.79	37.86	8421500.0
2001-11-09 14:00:00	QQQ	ETF	37.86	37.98	37.56	37.69	7359700.0
2001-11-09 15:00:00	QQQ	ETF	37.7	37.87	37.57	37.69	9674000.0
2001-11-09 16:00:00	QQQ	ETF	37.7	37.76	37.6	37.72	3475400.0
2001-11-09 17:00:00	QQQ	ETF	37.74	37.95	37.74	37.85	22000.0
2001-11-09 18:00:00	QQQ	ETF	37.93	38.0	37.88	37.9	9200.0
2001-11-09 09:00:00	IWM	ETF	43.53	43.745	43.53	43.575	51200.0
2001-11-09 10:00:00	IWM	ETF	43.55	43.695	43.415	43.565	36600.0
2001-11-09 11:00:00	IWM	ETF	43.665	43.69	43.45	43.69	28600.0
2001-11-09 12:00:00	IWM	ETF	43.54	43.61	43.5	43.565	12600.0
2001-11-09 13:00:00	IWM	ETF	43.62	43.73	43.575	43.675	13600.0
2001-11-09 14:00:00	IWM	ETF	43.715	43.715	43.535	43.535	51400.0
2001-11-09 15:00:00	IWM	ETF	43.59	43.725	43.54	43.55	211000.0
2001-11-09 16:00:00	IWM	ETF	43.64	43.7	43.64	43.7	15600.0
2001-11-09 09:00:00	DIA	ETF	95.77	96.22	95.5	95.65	567900.0
2001-11-09 10:00:00	DIA	ETF	95.64	96.5	95.28	96.05	521900.0
2001-11-09 11:00:00	DIA	ETF	96.05	96.05	95.58	95.86	250700.0
2001-11-09 12:00:00	DIA	ETF	95.86	96.05	95.7	96.02	40400.0
2001-11-09 13:00:00	DIA	ETF	96.02	96.3	96.0	96.16	381800.0
2001-11-09 14:00:00	DIA	ETF	96.15	96.27	95.89	96.04	142300.0
2001-11-09 15:00:00	DIA	ETF	96.08	96.29	95.98	96.14	558500.0
2001-11-09 16:00:00	DIA	ETF	96.17	96.5	96.13	96.33	269500.0
2001-11-09 18:00:00	DIA	ETF	96.07	96.07	96.05	96.05	500.0

> showing 36 of 269 rows — these rows as CSV

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