PREVIEW / etf_1hour / 2010-04-05

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-04-05.parquet
  size:    156 KB
  rows:    4,855

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-04-05 04:00:00	SPY	ETF	118.0	118.0	118.0	118.0	100.0
2010-04-05 05:00:00	SPY	ETF	118.13	118.15	118.11	118.11	400.0
2010-04-05 06:00:00	SPY	ETF	118.15	118.16	118.08	118.08	13300.0
2010-04-05 07:00:00	SPY	ETF	118.1	118.36	118.1	118.32	324229.0
2010-04-05 08:00:00	SPY	ETF	118.3	118.35	117.67	118.21	1067271.0
2010-04-05 09:00:00	SPY	ETF	118.22	118.42	117.92	118.4	16156807.0
2010-04-05 10:00:00	SPY	ETF	118.38	118.84	117.97	118.74	26516857.0
2010-04-05 11:00:00	SPY	ETF	118.74	118.82	118.64	118.78	9819438.0
2010-04-05 12:00:00	SPY	ETF	118.78	118.82	118.69	118.7101	6063906.0
2010-04-05 13:00:00	SPY	ETF	118.71	118.8	118.56	118.63	7957878.0
2010-04-05 14:00:00	SPY	ETF	118.63	118.84	118.59	118.6799	9312963.0
2010-04-05 15:00:00	SPY	ETF	118.67	118.8	118.57	118.78	20551624.0
2010-04-05 16:00:00	SPY	ETF	118.79	118.82	117.8617	118.8	4066715.0
2010-04-05 17:00:00	SPY	ETF	118.8	118.83	118.79	118.82	107005.0
2010-04-05 18:00:00	SPY	ETF	118.82	118.82	118.76	118.78	46899.0
2010-04-05 19:00:00	SPY	ETF	118.8	118.84	118.76	118.76	179310.0
2010-04-05 05:00:00	QQQ	ETF	48.24	48.24	48.24	48.24	236.0
2010-04-05 06:00:00	QQQ	ETF	48.29	48.29	48.29	48.29	1000.0
2010-04-05 07:00:00	QQQ	ETF	48.27	48.32	48.25	48.3	90800.0
2010-04-05 08:00:00	QQQ	ETF	48.3	48.33	48.08	48.28	633974.0
2010-04-05 09:00:00	QQQ	ETF	48.28	48.54	48.14	48.46	11778463.0
2010-04-05 10:00:00	QQQ	ETF	48.46	48.72	48.41	48.67	11115271.0
2010-04-05 11:00:00	QQQ	ETF	48.67	48.685	48.59	48.615	6522630.0
2010-04-05 12:00:00	QQQ	ETF	48.62	48.66	48.58	48.63	3157337.0
2010-04-05 13:00:00	QQQ	ETF	48.62	48.65	48.55	48.57	2672320.0
2010-04-05 14:00:00	QQQ	ETF	48.57	48.67	48.55	48.59	3969285.0
2010-04-05 15:00:00	QQQ	ETF	48.6	48.64	48.55	48.62	8725407.0
2010-04-05 16:00:00	QQQ	ETF	48.62	48.6338	48.187	48.62	5000638.0
2010-04-05 17:00:00	QQQ	ETF	48.6	48.63	48.6	48.62	54850.0
2010-04-05 18:00:00	QQQ	ETF	48.63	48.63	48.6	48.63	13400.0
2010-04-05 19:00:00	QQQ	ETF	48.63	48.63	48.61	48.61	14540.0
2010-04-05 04:00:00	IWM	ETF	68.51	68.51	68.51	68.51	200.0
2010-04-05 07:00:00	IWM	ETF	68.65	68.7	68.64	68.64	25975.0
2010-04-05 08:00:00	IWM	ETF	68.3	68.68	68.3	68.59	195012.0
2010-04-05 09:00:00	IWM	ETF	68.59	69.15	68.44	69.05	6230859.0
2010-04-05 10:00:00	IWM	ETF	69.07	69.45	69.01	69.38	7128048.0
2010-04-05 11:00:00	IWM	ETF	69.38	69.46	69.31	69.37	3513612.0
2010-04-05 12:00:00	IWM	ETF	69.3699	69.46	69.3	69.39	2208944.0
2010-04-05 13:00:00	IWM	ETF	69.38	69.49	69.31	69.36	2552684.0
2010-04-05 14:00:00	IWM	ETF	69.37	69.55	69.33	69.4194	3871509.0
2010-04-05 15:00:00	IWM	ETF	69.42	69.75	69.34	69.74	11918782.0
2010-04-05 16:00:00	IWM	ETF	69.75	69.76	68.3797	69.68	11284741.0
2010-04-05 17:00:00	IWM	ETF	69.71	69.7425	69.68	69.74	168219.0
2010-04-05 18:00:00	IWM	ETF	69.7	69.76	69.69	69.75	4731.0
2010-04-05 19:00:00	IWM	ETF	69.64	69.75	69.6	69.64	3298.0
2010-04-05 07:00:00	DIA	ETF	109.59	109.61	109.59	109.61	1150.0
2010-04-05 08:00:00	DIA	ETF	109.63	109.65	109.49	109.54	13120.0
2010-04-05 09:00:00	DIA	ETF	109.53	109.64	109.25	109.58	776176.0
2010-04-05 10:00:00	DIA	ETF	109.6	109.88	109.53	109.81	1128758.0
2010-04-05 11:00:00	DIA	ETF	109.8158	109.85	109.7	109.79	443549.0

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

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