PREVIEW / etf_1hour / 2005-02-07

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-02-07.parquet
  size:    28 KB
  rows:    836

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-02-07 08:00:00	SPY	ETF	120.32	120.32	120.22	120.26	26800.0
2005-02-07 09:00:00	SPY	ETF	120.24	120.44	120.15	120.44	7976100.0
2005-02-07 10:00:00	SPY	ETF	120.44	120.52	120.25	120.44	10790800.0
2005-02-07 11:00:00	SPY	ETF	120.45	120.52	120.28	120.28	6047800.0
2005-02-07 12:00:00	SPY	ETF	120.28	120.38	120.12	120.32	3920800.0
2005-02-07 13:00:00	SPY	ETF	120.34	120.42	119.98	120.0	5457200.0
2005-02-07 14:00:00	SPY	ETF	119.98	120.31	119.96	120.24	3062000.0
2005-02-07 15:00:00	SPY	ETF	120.24	120.345	120.16	120.23	6613100.0
2005-02-07 16:00:00	SPY	ETF	120.25	120.35	120.05	120.11	647800.0
2005-02-07 17:00:00	SPY	ETF	120.09	120.12	120.09	120.1	15300.0
2005-02-07 18:00:00	SPY	ETF	120.1	120.14	120.1	120.14	2400.0
2005-02-07 19:00:00	SPY	ETF	120.1	120.1	120.1	120.1	3100.0
2005-02-07 09:00:00	QQQ	ETF	37.81	37.89	37.75	37.87	10835900.0
2005-02-07 10:00:00	QQQ	ETF	37.88	37.91	37.63	37.76	15408400.0
2005-02-07 11:00:00	QQQ	ETF	37.76	37.8	37.66	37.68	7205000.0
2005-02-07 12:00:00	QQQ	ETF	37.68	37.7	37.6	37.68	5933500.0
2005-02-07 13:00:00	QQQ	ETF	37.69	37.69	37.52	37.52	7258900.0
2005-02-07 14:00:00	QQQ	ETF	37.52	37.66	37.52	37.64	5250200.0
2005-02-07 15:00:00	QQQ	ETF	37.64	37.7	37.59	37.65	12497700.0
2005-02-07 09:00:00	IWM	ETF	63.525	63.745	63.525	63.745	2105000.0
2005-02-07 10:00:00	IWM	ETF	63.745	63.775	63.53	63.685	2281800.0
2005-02-07 11:00:00	IWM	ETF	63.695	63.75	63.575	63.6	425200.0
2005-02-07 12:00:00	IWM	ETF	63.6	63.6	63.4	63.505	1896800.0
2005-02-07 13:00:00	IWM	ETF	63.5	63.53	63.105	63.105	2083800.0
2005-02-07 14:00:00	IWM	ETF	63.105	63.365	63.09	63.335	928000.0
2005-02-07 15:00:00	IWM	ETF	63.33	63.45	63.3	63.38	2133600.0
2005-02-07 16:00:00	IWM	ETF	63.385	63.45	63.33	63.33	260000.0
2005-02-07 08:00:00	DIA	ETF	107.08	107.08	107.0	107.0	1500.0
2005-02-07 09:00:00	DIA	ETF	107.0	107.12	106.91	107.12	627900.0
2005-02-07 10:00:00	DIA	ETF	107.12	107.24	107.01	107.18	500700.0
2005-02-07 11:00:00	DIA	ETF	107.2	107.27	107.13	107.16	477800.0
2005-02-07 12:00:00	DIA	ETF	107.16	107.2	107.02	107.17	485900.0
2005-02-07 13:00:00	DIA	ETF	107.17	107.18	106.95	106.96	488100.0
2005-02-07 14:00:00	DIA	ETF	106.95	107.17	106.95	107.12	716100.0
2005-02-07 15:00:00	DIA	ETF	107.12	107.2	107.01	107.07	379200.0
2005-02-07 16:00:00	DIA	ETF	107.08	107.08	106.98	107.0	16400.0
2005-02-07 17:00:00	DIA	ETF	107.0	107.0	107.0	107.0	100.0
2005-02-07 09:00:00	GLD	ETF	41.55	41.55	41.42	41.47	107200.0
2005-02-07 10:00:00	GLD	ETF	41.45	41.51	41.416	41.47	261400.0
2005-02-07 11:00:00	GLD	ETF	41.47	41.48	41.26	41.26	182700.0
2005-02-07 12:00:00	GLD	ETF	41.28	41.35	41.21	41.33	425800.0
2005-02-07 13:00:00	GLD	ETF	41.33	41.39	41.29	41.35	195700.0
2005-02-07 14:00:00	GLD	ETF	41.36	41.39	41.34	41.36	248800.0
2005-02-07 15:00:00	GLD	ETF	41.35	41.37	41.29	41.33	270500.0
2005-02-07 08:00:00	TLT	ETF	92.74	92.74	92.74	92.74	700.0
2005-02-07 09:00:00	TLT	ETF	92.71	92.93	92.7	92.904	236600.0
2005-02-07 10:00:00	TLT	ETF	92.94	92.98	92.92	92.95	67400.0
2005-02-07 11:00:00	TLT	ETF	92.94	93.08	92.93	93.08	205000.0
2005-02-07 12:00:00	TLT	ETF	93.1	93.34	93.07	93.26	212100.0
2005-02-07 13:00:00	TLT	ETF	93.27	93.36	93.23	93.34	40600.0

> showing 50 of 836 rows — these rows as CSV

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