PREVIEW / etf_1hour / 2010-03-16

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-03-16.parquet
  size:    154 KB
  rows:    4,749

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-03-16 04:00:00	SPY	ETF	115.48	115.55	115.48	115.55	765.0
2010-03-16 05:00:00	SPY	ETF	115.64	115.74	115.64	115.68	1200.0
2010-03-16 06:00:00	SPY	ETF	115.74	115.74	115.65	115.71	6625.0
2010-03-16 07:00:00	SPY	ETF	115.76	115.8	115.69	115.7	185195.0
2010-03-16 08:00:00	SPY	ETF	115.71	115.83	115.64	115.73	1595599.0
2010-03-16 09:00:00	SPY	ETF	115.72	115.88	115.49	115.72	17566751.0
2010-03-16 10:00:00	SPY	ETF	115.71	116.12	115.58	116.07	23417942.0
2010-03-16 11:00:00	SPY	ETF	116.08	116.23	116.0	116.11	21716117.0
2010-03-16 12:00:00	SPY	ETF	116.12	116.15	115.96	116.02	11233402.0
2010-03-16 13:00:00	SPY	ETF	116.01	116.05	115.87	115.97	7359202.0
2010-03-16 14:00:00	SPY	ETF	115.96	116.34	115.8	116.17	40497964.0
2010-03-16 15:00:00	SPY	ETF	116.18	116.52	116.09	116.41	37550361.0
2010-03-16 16:00:00	SPY	ETF	116.41	116.44	115.5231	116.39	5248438.0
2010-03-16 17:00:00	SPY	ETF	116.4	116.45	116.35	116.4	151963.0
2010-03-16 18:00:00	SPY	ETF	116.41	116.42	116.39	116.41	28618.0
2010-03-16 19:00:00	SPY	ETF	116.41	116.44	116.38	116.43	89451.0
2010-03-16 05:00:00	QQQ	ETF	47.31	47.31	47.31	47.31	2400.0
2010-03-16 07:00:00	QQQ	ETF	47.35	47.35	47.33	47.33	15546.0
2010-03-16 08:00:00	QQQ	ETF	47.33	47.39	47.3	47.32	245545.0
2010-03-16 09:00:00	QQQ	ETF	47.32	47.4	47.24	47.33	7158203.0
2010-03-16 10:00:00	QQQ	ETF	47.32	47.51	47.23	47.5	13732107.0
2010-03-16 11:00:00	QQQ	ETF	47.4937	47.54	47.2599	47.49	8239536.0
2010-03-16 12:00:00	QQQ	ETF	47.49	47.52	47.45	47.46	2916235.0
2010-03-16 13:00:00	QQQ	ETF	47.455	47.48	47.41	47.44	2249297.0
2010-03-16 14:00:00	QQQ	ETF	47.435	47.61	47.32	47.475	18091311.0
2010-03-16 15:00:00	QQQ	ETF	47.47	47.59	47.42	47.54	13664326.0
2010-03-16 16:00:00	QQQ	ETF	47.55	47.5897	47.2599	47.51	6272848.0
2010-03-16 17:00:00	QQQ	ETF	47.51	47.54	47.51	47.53	36854.0
2010-03-16 18:00:00	QQQ	ETF	47.53	47.53	47.5	47.51	168481.0
2010-03-16 19:00:00	QQQ	ETF	47.51	47.53	47.5	47.52	34900.0
2010-03-16 06:00:00	IWM	ETF	67.71	67.71	67.71	67.71	2000.0
2010-03-16 07:00:00	IWM	ETF	67.71	67.71	67.67	67.68	31700.0
2010-03-16 08:00:00	IWM	ETF	67.67	67.74	67.66	67.69	181181.0
2010-03-16 09:00:00	IWM	ETF	67.68	67.85	67.34	67.5501	5697380.0
2010-03-16 10:00:00	IWM	ETF	67.56	67.81	67.38	67.78	8246457.0
2010-03-16 11:00:00	IWM	ETF	67.78	67.84	67.669	67.79	3750659.0
2010-03-16 12:00:00	IWM	ETF	67.79	67.81	67.66	67.69	2515443.0
2010-03-16 13:00:00	IWM	ETF	67.69	67.72	67.65	67.7	2274077.0
2010-03-16 14:00:00	IWM	ETF	67.705	67.88	67.51	67.67	10957535.0
2010-03-16 15:00:00	IWM	ETF	67.68	68.08	67.6	68.07	11645111.0
2010-03-16 16:00:00	IWM	ETF	68.08	68.1	67.5	68.03	4662952.0
2010-03-16 17:00:00	IWM	ETF	68.1	68.1	68.1	68.1	150.0
2010-03-16 18:00:00	IWM	ETF	68.1	68.18	68.1	68.1	6563.0
2010-03-16 19:00:00	IWM	ETF	68.1	68.11	68.04	68.11	1700.0
2010-03-16 08:00:00	DIA	ETF	106.68	106.74	106.68	106.68	4169.0
2010-03-16 09:00:00	DIA	ETF	106.74	106.79	106.41	106.63	525197.0
2010-03-16 10:00:00	DIA	ETF	106.63	106.94	106.51	106.9	906936.0
2010-03-16 11:00:00	DIA	ETF	106.9	107.0101	106.8399	106.88	1165768.0
2010-03-16 12:00:00	DIA	ETF	106.87	106.9	106.76	106.79	291265.0
2010-03-16 13:00:00	DIA	ETF	106.79	106.82	106.63	106.69	396981.0

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

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