PREVIEW / etf_1hour / 2006-03-02

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-03-02.parquet
  size:    40 KB
  rows:    1,241

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-03-02 07:00:00	SPY	ETF	129.17	129.18	129.1	129.17	56000.0
2006-03-02 08:00:00	SPY	ETF	129.12	129.2	129.05	129.05	1659400.0
2006-03-02 09:00:00	SPY	ETF	129.06	129.08	128.69	128.71	9299100.0
2006-03-02 10:00:00	SPY	ETF	128.71	129.21	128.64	129.11	10714700.0
2006-03-02 11:00:00	SPY	ETF	129.11	129.42	128.96	129.05	7552800.0
2006-03-02 12:00:00	SPY	ETF	129.05	129.08	128.61	128.8088	8160000.0
2006-03-02 13:00:00	SPY	ETF	128.81	129.05	128.73	129.0	5291300.0
2006-03-02 14:00:00	SPY	ETF	129.0	129.08	128.82	129.04	3543400.0
2006-03-02 15:00:00	SPY	ETF	129.03	129.35	129.02	129.22	7109000.0
2006-03-02 16:00:00	SPY	ETF	129.23	129.41	129.19	129.35	1038500.0
2006-03-02 17:00:00	SPY	ETF	129.37	129.4	129.1868	129.35	9200.0
2006-03-02 18:00:00	SPY	ETF	129.34	129.34	129.3	129.3	2200.0
2006-03-02 19:00:00	SPY	ETF	129.31	129.31	129.29	129.29	6400.0
2006-03-02 09:00:00	QQQ	ETF	41.55	41.63	41.5	41.53	9908800.0
2006-03-02 10:00:00	QQQ	ETF	41.53	41.76	41.51	41.71	11123900.0
2006-03-02 11:00:00	QQQ	ETF	41.71	41.84	41.57	41.59	12426500.0
2006-03-02 12:00:00	QQQ	ETF	41.59	41.61	41.41	41.5	9987300.0
2006-03-02 13:00:00	QQQ	ETF	41.5	41.64	41.47	41.61	5886500.0
2006-03-02 14:00:00	QQQ	ETF	41.61	41.63	41.45	41.53	5850100.0
2006-03-02 15:00:00	QQQ	ETF	41.53	41.72	41.53	41.7	10522000.0
2006-03-02 08:00:00	IWM	ETF	73.77	73.8	73.7	73.71	16600.0
2006-03-02 09:00:00	IWM	ETF	73.72	73.72	73.32	73.32	5705700.0
2006-03-02 10:00:00	IWM	ETF	73.32	73.82	73.25	73.78	7072400.0
2006-03-02 11:00:00	IWM	ETF	73.77	73.89	73.5	73.52	3794700.0
2006-03-02 12:00:00	IWM	ETF	73.53	73.58	73.09	73.24	6335100.0
2006-03-02 13:00:00	IWM	ETF	73.24	73.35	73.16	73.31	3539300.0
2006-03-02 14:00:00	IWM	ETF	73.31	73.45	73.11	73.41	4365400.0
2006-03-02 15:00:00	IWM	ETF	73.42	73.64	73.41	73.62	5328500.0
2006-03-02 16:00:00	IWM	ETF	73.64	73.8	73.5	73.67	224300.0
2006-03-02 17:00:00	IWM	ETF	73.77	73.77	73.77	73.77	100.0
2006-03-02 08:00:00	DIA	ETF	110.32	110.36	110.23	110.23	4100.0
2006-03-02 09:00:00	DIA	ETF	110.2	110.27	110.0	110.03	637000.0
2006-03-02 10:00:00	DIA	ETF	110.08	110.35	109.94	110.24	863800.0
2006-03-02 11:00:00	DIA	ETF	110.25	110.5	110.1	110.14	888900.0
2006-03-02 12:00:00	DIA	ETF	110.15	110.16	109.82	110.03	1010600.0
2006-03-02 13:00:00	DIA	ETF	110.02	110.19	109.98	110.12	500100.0
2006-03-02 14:00:00	DIA	ETF	110.15	110.23	110.02	110.16	333000.0
2006-03-02 15:00:00	DIA	ETF	110.16	110.4024	110.15	110.33	748000.0
2006-03-02 16:00:00	DIA	ETF	110.31	110.41	110.31	110.38	10500.0
2006-03-02 19:00:00	DIA	ETF	110.38	110.38	110.38	110.38	500.0
2006-03-02 07:00:00	GLD	ETF	56.14	56.14	56.08	56.08	4000.0
2006-03-02 08:00:00	GLD	ETF	56.11	56.18	56.0	56.18	32800.0
2006-03-02 09:00:00	GLD	ETF	56.2	56.3	56.14	56.17	424400.0
2006-03-02 10:00:00	GLD	ETF	56.17	56.28	55.99	56.25	350500.0
2006-03-02 11:00:00	GLD	ETF	56.27	56.35	56.04	56.1216	451500.0
2006-03-02 12:00:00	GLD	ETF	56.13	56.53	56.11	56.45	544300.0
2006-03-02 13:00:00	GLD	ETF	56.46	56.74	56.46	56.67	1035500.0
2006-03-02 14:00:00	GLD	ETF	56.66	56.82	56.66	56.76	462600.0
2006-03-02 15:00:00	GLD	ETF	56.76	56.82	56.65	56.73	523500.0
2006-03-02 16:00:00	GLD	ETF	56.71	56.77	56.71	56.77	20800.0

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

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