PREVIEW / etf_1hour / 2007-04-09

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-04-09.parquet
  size:    68 KB
  rows:    2,186

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
2007-04-09 05:00:00	SPY	ETF	144.45	144.5	144.45	144.5	200.0
2007-04-09 06:00:00	SPY	ETF	144.81	144.89	144.81	144.89	6000.0
2007-04-09 07:00:00	SPY	ETF	144.86	144.86	144.71	144.82	172800.0
2007-04-09 08:00:00	SPY	ETF	144.78	144.84	144.24	144.77	1576700.0
2007-04-09 09:00:00	SPY	ETF	144.78	144.78	144.15	144.58	8339100.0
2007-04-09 10:00:00	SPY	ETF	144.58	144.6	144.25	144.45	10137400.0
2007-04-09 11:00:00	SPY	ETF	144.46	144.62	144.43	144.47	4695406.0
2007-04-09 12:00:00	SPY	ETF	144.47	144.78	144.36	144.67	4344600.0
2007-04-09 13:00:00	SPY	ETF	144.67	144.8	144.48	144.48	4337612.0
2007-04-09 14:00:00	SPY	ETF	144.47	144.52	144.31	144.48	7146884.0
2007-04-09 15:00:00	SPY	ETF	144.48	144.58	144.35	144.43	6224938.0
2007-04-09 16:00:00	SPY	ETF	144.43	144.48	144.38	144.42	1011500.0
2007-04-09 17:00:00	SPY	ETF	144.43	144.43	144.41	144.41	34900.0
2007-04-09 18:00:00	SPY	ETF	144.4	144.43	144.39	144.43	162400.0
2007-04-09 19:00:00	SPY	ETF	144.42	144.45	144.42	144.42	15400.0
2007-04-09 05:00:00	QQQ	ETF	44.78	44.78	44.78	44.78	200.0
2007-04-09 06:00:00	QQQ	ETF	44.77	44.77	44.77	44.77	15000.0
2007-04-09 07:00:00	QQQ	ETF	44.78	44.79	44.72	44.79	217388.0
2007-04-09 08:00:00	QQQ	ETF	44.77	44.81	44.58	44.78	363374.0
2007-04-09 09:00:00	QQQ	ETF	44.78	44.78	44.52	44.58	9798450.0
2007-04-09 10:00:00	QQQ	ETF	44.58	46.47	44.38	44.51	13841100.0
2007-04-09 11:00:00	QQQ	ETF	44.52	44.6	44.51	44.57	5477700.0
2007-04-09 12:00:00	QQQ	ETF	44.57	44.7	44.56	44.65	5038400.0
2007-04-09 13:00:00	QQQ	ETF	44.65	44.66	44.54	44.54	4634200.0
2007-04-09 14:00:00	QQQ	ETF	44.54	44.58	44.48	44.57	7215000.0
2007-04-09 15:00:00	QQQ	ETF	44.57	44.63	44.44	44.44	10628400.0
2007-04-09 16:00:00	QQQ	ETF	44.45	44.5	44.43	44.5	2643486.0
2007-04-09 17:00:00	QQQ	ETF	44.5	44.5	44.47	44.48	94216.0
2007-04-09 18:00:00	QQQ	ETF	44.48	44.49	44.48	44.48	4237.0
2007-04-09 19:00:00	QQQ	ETF	44.48	44.49	44.48	44.48	10013.0
2007-04-09 06:00:00	IWM	ETF	80.4	80.4	80.4	80.4	300.0
2007-04-09 07:00:00	IWM	ETF	80.77	80.85	80.77	80.85	600.0
2007-04-09 08:00:00	IWM	ETF	80.88	80.88	80.44	80.87	55800.0
2007-04-09 09:00:00	IWM	ETF	80.86	80.87	80.54	80.6	5118100.0
2007-04-09 10:00:00	IWM	ETF	80.6	80.606	80.32	80.49	7081226.0
2007-04-09 11:00:00	IWM	ETF	80.5	80.71	80.49	80.63	4087847.0
2007-04-09 12:00:00	IWM	ETF	80.62	80.73	80.56	80.69	3291500.0
2007-04-09 13:00:00	IWM	ETF	80.69	80.77	80.61	80.61	3633300.0
2007-04-09 14:00:00	IWM	ETF	80.6	80.6	80.43	80.54	4759650.0
2007-04-09 15:00:00	IWM	ETF	80.54	80.69	80.5	80.51	3517994.0
2007-04-09 16:00:00	IWM	ETF	80.51	80.6	80.5	80.57	445400.0
2007-04-09 17:00:00	IWM	ETF	80.61	80.64	80.61	80.64	10000.0
2007-04-09 19:00:00	IWM	ETF	80.57	80.57	80.57	80.57	100.0
2007-04-09 07:00:00	DIA	ETF	125.92	125.92	125.86	125.86	2100.0
2007-04-09 08:00:00	DIA	ETF	125.89	125.95	125.82	125.84	9500.0
2007-04-09 09:00:00	DIA	ETF	125.82	125.83	125.62	125.74	622000.0
2007-04-09 10:00:00	DIA	ETF	125.75	125.75	125.53	125.66	473900.0
2007-04-09 11:00:00	DIA	ETF	125.66	125.7922	125.64	125.68	507200.0
2007-04-09 12:00:00	DIA	ETF	125.68	125.9	125.66	125.84	359300.0
2007-04-09 13:00:00	DIA	ETF	125.84	125.9	125.72	125.72	315900.0

> showing 50 of 2,186 rows — these rows as CSV

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