PREVIEW / etf_1hour / 2010-09-02

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-09-02.parquet
  size:    163 KB
  rows:    4,981

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
2010-09-02 04:00:00	SPY	ETF	108.42	108.65	108.35	108.46	1920.0
2010-09-02 05:00:00	SPY	ETF	108.68	108.73	108.68	108.73	1400.0
2010-09-02 06:00:00	SPY	ETF	108.65	108.65	108.46	108.51	83995.0
2010-09-02 07:00:00	SPY	ETF	108.59	109.01	108.57	108.78	560177.0
2010-09-02 08:00:00	SPY	ETF	108.73	108.98	108.39	108.84	2546452.0
2010-09-02 09:00:00	SPY	ETF	108.83	108.95	108.49	108.9	23689706.0
2010-09-02 10:00:00	SPY	ETF	108.91	109.15	108.66	109.07	35178997.0
2010-09-02 11:00:00	SPY	ETF	109.07	109.2	108.72	108.95	19304880.0
2010-09-02 12:00:00	SPY	ETF	108.95	109.1	108.82	108.84	11748885.0
2010-09-02 13:00:00	SPY	ETF	108.84	109.01	108.78	108.96	7241110.0
2010-09-02 14:00:00	SPY	ETF	108.96	109.26	108.92	109.111	13288021.0
2010-09-02 15:00:00	SPY	ETF	109.11	109.49	109.02	109.46	33829139.0
2010-09-02 16:00:00	SPY	ETF	109.46	109.59	108.615	109.5	5255981.0
2010-09-02 17:00:00	SPY	ETF	109.5	109.55	109.41	109.42	1316484.0
2010-09-02 18:00:00	SPY	ETF	109.44	109.47	109.41	109.45	68771.0
2010-09-02 19:00:00	SPY	ETF	109.46	109.46	109.31	109.36	121844.0
2010-09-02 04:00:00	QQQ	ETF	44.71	44.8	44.71	44.72	5445.0
2010-09-02 05:00:00	QQQ	ETF	44.71	44.82	44.71	44.82	5100.0
2010-09-02 06:00:00	QQQ	ETF	44.72	44.75	44.72	44.74	4978.0
2010-09-02 07:00:00	QQQ	ETF	44.75	44.94	44.75	44.79	5653.0
2010-09-02 08:00:00	QQQ	ETF	44.81	44.91	44.76	44.87	451911.0
2010-09-02 09:00:00	QQQ	ETF	44.87	44.97	44.73	44.95	6227425.0
2010-09-02 10:00:00	QQQ	ETF	44.955	45.1	44.84	45.08	8624339.0
2010-09-02 11:00:00	QQQ	ETF	45.085	45.135	44.99	45.07	4310702.0
2010-09-02 12:00:00	QQQ	ETF	45.08	45.14	44.99	45.02	5171318.0
2010-09-02 13:00:00	QQQ	ETF	45.023	45.08	44.9901	45.07	1836831.0
2010-09-02 14:00:00	QQQ	ETF	45.07	45.22	45.06	45.13	4500883.0
2010-09-02 15:00:00	QQQ	ETF	45.125	45.28	45.08	45.27	7097999.0
2010-09-02 16:00:00	QQQ	ETF	45.27	45.3139	45.088	45.24	2895476.0
2010-09-02 17:00:00	QQQ	ETF	45.25	45.29	45.23	45.28	98048.0
2010-09-02 18:00:00	QQQ	ETF	45.28	45.28	45.23	45.24	57180.0
2010-09-02 19:00:00	QQQ	ETF	45.22	45.24	45.19	45.21	25137.0
2010-09-02 04:00:00	IWM	ETF	62.48	62.48	62.48	62.48	166.0
2010-09-02 05:00:00	IWM	ETF	62.5	62.5	62.5	62.5	100.0
2010-09-02 06:00:00	IWM	ETF	62.39	62.41	62.39	62.41	1300.0
2010-09-02 07:00:00	IWM	ETF	62.47	62.76	62.47	62.58	37984.0
2010-09-02 08:00:00	IWM	ETF	62.55	62.88	62.45	62.6	223995.0
2010-09-02 09:00:00	IWM	ETF	62.59	62.79	62.2742	62.78	4112389.0
2010-09-02 10:00:00	IWM	ETF	62.77	63.04	62.62	62.96	7800601.0
2010-09-02 11:00:00	IWM	ETF	62.9581	63.03	62.7	62.74	3621444.0
2010-09-02 12:00:00	IWM	ETF	62.75	62.91	62.59	62.62	6337507.0
2010-09-02 13:00:00	IWM	ETF	62.62	62.8	62.57	62.78	2207613.0
2010-09-02 14:00:00	IWM	ETF	62.79	63.07	62.77	63.0	3347707.0
2010-09-02 15:00:00	IWM	ETF	63.0	63.38	62.93	63.22	7203480.0
2010-09-02 16:00:00	IWM	ETF	63.22	63.35	62.5738	63.3	5318456.0
2010-09-02 17:00:00	IWM	ETF	63.31	63.32	62.5737	63.29	3011484.0
2010-09-02 18:00:00	IWM	ETF	63.3	63.32	63.3	63.31	8850.0
2010-09-02 19:00:00	IWM	ETF	63.26	63.28	63.24	63.24	5610.0
2010-09-02 07:00:00	DIA	ETF	102.92	102.92	102.92	102.92	100.0
2010-09-02 08:00:00	DIA	ETF	102.92	103.05	102.83	103.04	12240.0

> showing 50 of 4,981 rows — these rows as CSV

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