PREVIEW / etf_1hour / 2010-01-05

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-01-05.parquet
  size:    148 KB
  rows:    4,690

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-01-05 04:00:00	SPY	ETF	113.29	113.29	113.27	113.27	900.0
2010-01-05 05:00:00	SPY	ETF	113.33	113.37	113.33	113.37	15100.0
2010-01-05 06:00:00	SPY	ETF	113.29	113.37	113.22	113.3	11125.0
2010-01-05 07:00:00	SPY	ETF	113.3	113.48	113.29	113.46	97232.0
2010-01-05 08:00:00	SPY	ETF	113.45	113.47	113.25	113.29	1213928.0
2010-01-05 09:00:00	SPY	ETF	113.29	113.36	112.9	112.98	18930790.0
2010-01-05 10:00:00	SPY	ETF	112.985	113.68	112.85	113.56	19785878.0
2010-01-05 11:00:00	SPY	ETF	113.57	113.61	113.24	113.35	14411140.0
2010-01-05 12:00:00	SPY	ETF	113.36	113.5	113.27	113.35	7576278.0
2010-01-05 13:00:00	SPY	ETF	113.35	113.38	113.15	113.25	9495079.0
2010-01-05 14:00:00	SPY	ETF	113.2599	113.37	113.04	113.349	11243954.0
2010-01-05 15:00:00	SPY	ETF	113.35	113.67	113.34	113.63	20196534.0
2010-01-05 16:00:00	SPY	ETF	113.63	113.72	113.04	113.6	8276371.0
2010-01-05 17:00:00	SPY	ETF	113.6	113.64	113.57	113.6	85180.0
2010-01-05 18:00:00	SPY	ETF	113.58	113.61	113.55	113.55	37736.0
2010-01-05 19:00:00	SPY	ETF	113.56	113.6	113.51	113.6	22900.0
2010-01-05 04:00:00	QQQ	ETF	46.36	46.36	46.36	46.36	300.0
2010-01-05 05:00:00	QQQ	ETF	46.41	46.43	46.4	46.4	26000.0
2010-01-05 06:00:00	QQQ	ETF	46.37	46.44	46.36	46.44	77500.0
2010-01-05 07:00:00	QQQ	ETF	46.44	46.47	46.41	46.45	244924.0
2010-01-05 08:00:00	QQQ	ETF	46.45	46.5	46.27	46.37	645821.0
2010-01-05 09:00:00	QQQ	ETF	46.37	46.44	46.26	46.29	8804420.0
2010-01-05 10:00:00	QQQ	ETF	46.32	46.5	46.26	46.47	10330700.0
2010-01-05 11:00:00	QQQ	ETF	46.46	46.49	46.33	46.37	6792748.0
2010-01-05 12:00:00	QQQ	ETF	46.38	46.42	46.31	46.36	5546260.0
2010-01-05 13:00:00	QQQ	ETF	46.3599	46.37	46.27	46.3	5157170.0
2010-01-05 14:00:00	QQQ	ETF	46.3	46.35	46.16	46.34	9605881.0
2010-01-05 15:00:00	QQQ	ETF	46.35	46.43	46.325	46.42	9179332.0
2010-01-05 16:00:00	QQQ	ETF	46.41	46.46	46.37	46.38	5320470.0
2010-01-05 17:00:00	QQQ	ETF	46.42	46.42	46.37	46.4	9032.0
2010-01-05 18:00:00	QQQ	ETF	46.38	46.38	46.36	46.37	18768.0
2010-01-05 19:00:00	QQQ	ETF	46.35	46.37	46.34	46.35	16903.0
2010-01-05 07:00:00	IWM	ETF	63.92	64.0	63.92	64.0	2596.0
2010-01-05 08:00:00	IWM	ETF	63.98	64.0	63.63	63.9	109036.0
2010-01-05 09:00:00	IWM	ETF	63.89	63.96	63.5	63.58	5696711.0
2010-01-05 10:00:00	IWM	ETF	63.59	64.18	63.49	64.12	9682138.0
2010-01-05 11:00:00	IWM	ETF	64.12	64.12	63.76	63.83	4528384.0
2010-01-05 12:00:00	IWM	ETF	63.8402	64.05	63.78	63.85	5684594.0
2010-01-05 13:00:00	IWM	ETF	63.85	63.86	63.58	63.71	6312293.0
2010-01-05 14:00:00	IWM	ETF	63.7	63.77	63.49	63.73	6207396.0
2010-01-05 15:00:00	IWM	ETF	63.73	63.95	63.715	63.75	10014668.0
2010-01-05 16:00:00	IWM	ETF	63.75	63.975	63.71	63.77	1974479.0
2010-01-05 17:00:00	IWM	ETF	63.75	63.79	63.74	63.79	30609.0
2010-01-05 18:00:00	IWM	ETF	63.73	63.78	63.72	63.72	800.0
2010-01-05 19:00:00	IWM	ETF	63.72	63.72	63.72	63.72	200.0
2010-01-05 08:00:00	DIA	ETF	105.74	105.74	105.57	105.6	7833.0
2010-01-05 09:00:00	DIA	ETF	105.59	105.67	104.97	105.06	1036914.0
2010-01-05 10:00:00	DIA	ETF	105.06	105.635	104.97	105.55	1420253.0
2010-01-05 11:00:00	DIA	ETF	105.55	105.5881	105.23	105.31	756414.0
2010-01-05 12:00:00	DIA	ETF	105.3135	105.45	105.27	105.335	411800.0

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

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