PREVIEW / etf_1hour / 2010-06-03

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-06-03.parquet
  size:    161 KB
  rows:    4,914

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-06-03 04:00:00	SPY	ETF	110.87	110.95	110.83	110.9	11300.0
2010-06-03 05:00:00	SPY	ETF	110.83	110.85	110.7	110.83	13700.0
2010-06-03 06:00:00	SPY	ETF	110.83	110.83	110.45	110.45	27896.0
2010-06-03 07:00:00	SPY	ETF	110.47	110.67	110.41	110.59	1629843.0
2010-06-03 08:00:00	SPY	ETF	110.55	110.8	110.35	110.7	4168797.0
2010-06-03 09:00:00	SPY	ETF	110.71	111.06	110.43	111.01	28581819.0
2010-06-03 10:00:00	SPY	ETF	111.04	111.06	110.16	110.61	37109739.0
2010-06-03 11:00:00	SPY	ETF	110.62	110.81	110.32	110.46	22491993.0
2010-06-03 12:00:00	SPY	ETF	110.45	110.5	109.58	109.9	29979986.0
2010-06-03 13:00:00	SPY	ETF	109.91	110.26	109.74	110.05	18456331.0
2010-06-03 14:00:00	SPY	ETF	110.05	110.68	109.93	110.57	27669838.0
2010-06-03 15:00:00	SPY	ETF	110.57	110.87	110.24	110.71	41366986.0
2010-06-03 16:00:00	SPY	ETF	110.71	110.94	109.92	110.72	9019212.0
2010-06-03 17:00:00	SPY	ETF	110.71	110.84	110.53	110.65	4742177.0
2010-06-03 18:00:00	SPY	ETF	110.65	110.7	110.58	110.64	103764.0
2010-06-03 19:00:00	SPY	ETF	110.65	110.77	110.63	110.69	65790.0
2010-06-03 04:00:00	QQQ	ETF	46.51	46.51	46.47	46.47	300.0
2010-06-03 05:00:00	QQQ	ETF	46.46	46.49	46.46	46.49	6400.0
2010-06-03 06:00:00	QQQ	ETF	46.48	46.48	46.39	46.39	44200.0
2010-06-03 07:00:00	QQQ	ETF	46.32	46.39	46.31	46.32	18215.0
2010-06-03 08:00:00	QQQ	ETF	46.31	46.41	46.28	46.34	2677065.0
2010-06-03 09:00:00	QQQ	ETF	46.34	46.66	46.32	46.6401	13450082.0
2010-06-03 10:00:00	QQQ	ETF	46.64	46.645	46.26	46.5	14380167.0
2010-06-03 11:00:00	QQQ	ETF	46.5	46.62	46.41	46.53	8736164.0
2010-06-03 12:00:00	QQQ	ETF	46.52	46.54	46.08	46.29	11052466.0
2010-06-03 13:00:00	QQQ	ETF	46.29	46.48	46.2	46.39	8814166.0
2010-06-03 14:00:00	QQQ	ETF	46.3975	46.65	46.34	46.57	11131904.0
2010-06-03 15:00:00	QQQ	ETF	46.58	46.77	46.44	46.67	14583830.0
2010-06-03 16:00:00	QQQ	ETF	46.66	46.76	46.2912	46.6	8218901.0
2010-06-03 17:00:00	QQQ	ETF	46.61	46.64	46.55	46.59	82303.0
2010-06-03 18:00:00	QQQ	ETF	46.62	46.62	46.57	46.61	34329.0
2010-06-03 19:00:00	QQQ	ETF	46.61	46.65	46.61	46.65	6298.0
2010-06-03 04:00:00	IWM	ETF	66.4	66.4	66.4	66.4	100.0
2010-06-03 05:00:00	IWM	ETF	66.29	66.4	66.29	66.35	10400.0
2010-06-03 06:00:00	IWM	ETF	66.24	66.25	66.24	66.25	9998.0
2010-06-03 07:00:00	IWM	ETF	66.22	66.3	66.14	66.16	154862.0
2010-06-03 08:00:00	IWM	ETF	66.18	66.72	66.01	66.2	1948953.0
2010-06-03 09:00:00	IWM	ETF	66.22	66.889	66.13	66.88	8894999.0
2010-06-03 10:00:00	IWM	ETF	66.88	66.91	66.13	66.67	12640305.0
2010-06-03 11:00:00	IWM	ETF	66.68	66.9	66.4	66.65	6668723.0
2010-06-03 12:00:00	IWM	ETF	66.64	66.65	65.87	66.1	7600624.0
2010-06-03 13:00:00	IWM	ETF	66.11	66.32	65.92	66.13	5079353.0
2010-06-03 14:00:00	IWM	ETF	66.14	66.87	66.05	66.72	9444147.0
2010-06-03 15:00:00	IWM	ETF	66.73	67.09	66.52	66.89	12197122.0
2010-06-03 16:00:00	IWM	ETF	66.89	67.06	66.146	66.91	2333325.0
2010-06-03 17:00:00	IWM	ETF	66.92	66.92	66.8	66.8	27400.0
2010-06-03 18:00:00	IWM	ETF	66.8	66.86	66.8	66.86	1160.0
2010-06-03 19:00:00	IWM	ETF	66.86	66.9	66.84	66.84	5600.0
2010-06-03 04:00:00	DIA	ETF	103.0	103.07	103.0	103.07	2400.0
2010-06-03 05:00:00	DIA	ETF	103.07	103.09	103.07	103.09	500.0

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

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