PREVIEW / etf_1hour / 2010-01-21

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-01-21.parquet
  size:    159 KB
  rows:    4,875

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-21 04:00:00	SPY	ETF	113.91	113.91	113.84	113.84	700.0
2010-01-21 05:00:00	SPY	ETF	113.82	113.87	113.6	113.61	8278.0
2010-01-21 06:00:00	SPY	ETF	113.69	113.9	113.6	113.87	4200.0
2010-01-21 07:00:00	SPY	ETF	113.99	114.19	113.93	114.02	348185.0
2010-01-21 08:00:00	SPY	ETF	114.04	114.27	113.55	113.7	6837227.0
2010-01-21 09:00:00	SPY	ETF	113.7	114.27	113.67	113.84	29220894.0
2010-01-21 10:00:00	SPY	ETF	113.85	114.14	112.38	112.61	66161251.0
2010-01-21 11:00:00	SPY	ETF	112.62	112.66	111.62	111.88	59750015.0
2010-01-21 12:00:00	SPY	ETF	111.88	112.31	111.65	111.75	39672095.0
2010-01-21 13:00:00	SPY	ETF	111.75	112.14	111.56	112.05	30053648.0
2010-01-21 14:00:00	SPY	ETF	112.05	112.42	111.77	112.092	36198814.0
2010-01-21 15:00:00	SPY	ETF	112.09	112.24	111.66	111.68	56232154.0
2010-01-21 16:00:00	SPY	ETF	111.67	113.8976	111.3	111.45	13028598.0
2010-01-21 17:00:00	SPY	ETF	111.44	113.8976	111.34	111.34	5959833.0
2010-01-21 18:00:00	SPY	ETF	111.33	111.51	111.33	111.51	53927.0
2010-01-21 19:00:00	SPY	ETF	111.45	111.58	111.45	111.53	58551.0
2010-01-21 05:00:00	QQQ	ETF	45.84	45.84	45.84	45.84	400.0
2010-01-21 06:00:00	QQQ	ETF	45.85	45.92	45.83	45.92	35100.0
2010-01-21 07:00:00	QQQ	ETF	45.95	46.04	45.93	46.0	85901.0
2010-01-21 08:00:00	QQQ	ETF	45.99	46.06	45.84	45.92	3658858.0
2010-01-21 09:00:00	QQQ	ETF	45.93	46.29	45.92	46.13	16953178.0
2010-01-21 10:00:00	QQQ	ETF	46.14	46.35	45.48	45.6104	49186085.0
2010-01-21 11:00:00	QQQ	ETF	45.62	45.68	45.3	45.42	28861953.0
2010-01-21 12:00:00	QQQ	ETF	45.43	45.6423	45.32	45.38	19409677.0
2010-01-21 13:00:00	QQQ	ETF	45.39	45.6	45.3	45.57	16773551.0
2010-01-21 14:00:00	QQQ	ETF	45.5732	45.72	45.46	45.6	17524866.0
2010-01-21 15:00:00	QQQ	ETF	45.6	45.618	45.425	45.49	18839012.0
2010-01-21 16:00:00	QQQ	ETF	45.48	46.206	45.21	45.26	17396754.0
2010-01-21 17:00:00	QQQ	ETF	45.25	45.27	45.22	45.22	130243.0
2010-01-21 18:00:00	QQQ	ETF	45.22	45.29	45.21	45.28	80231.0
2010-01-21 19:00:00	QQQ	ETF	45.26	45.31	45.25	45.3	52116.0
2010-01-21 05:00:00	IWM	ETF	64.47	64.47	64.06	64.06	2000.0
2010-01-21 07:00:00	IWM	ETF	64.02	64.07	63.98	64.01	5846.0
2010-01-21 08:00:00	IWM	ETF	64.08	64.13	63.71	63.78	1007630.0
2010-01-21 09:00:00	IWM	ETF	63.8	64.48	63.79	64.05	8194204.0
2010-01-21 10:00:00	IWM	ETF	64.05	64.33	62.91	63.205	17825874.0
2010-01-21 11:00:00	IWM	ETF	63.21	63.29	62.64	62.82	15900996.0
2010-01-21 12:00:00	IWM	ETF	62.8101	63.27	62.76	63.0	8795716.0
2010-01-21 13:00:00	IWM	ETF	63.01	63.22	62.851	63.212	7877985.0
2010-01-21 14:00:00	IWM	ETF	63.2101	63.5	63.08	63.321	7393831.0
2010-01-21 15:00:00	IWM	ETF	63.33	63.35	62.8	62.81	16103932.0
2010-01-21 16:00:00	IWM	ETF	62.82	63.9395	60.0653	62.72	6126145.0
2010-01-21 17:00:00	IWM	ETF	62.71	62.71	62.62	62.66	12116.0
2010-01-21 18:00:00	IWM	ETF	62.68	62.73	62.68	62.71	2380.0
2010-01-21 19:00:00	IWM	ETF	62.71	62.75	62.64	62.69	5140.0
2010-01-21 05:00:00	DIA	ETF	105.9	105.9	105.9	105.9	200.0
2010-01-21 07:00:00	DIA	ETF	106.14	106.14	106.14	106.14	2600.0
2010-01-21 08:00:00	DIA	ETF	106.1	106.21	105.7	105.78	24510.0
2010-01-21 09:00:00	DIA	ETF	105.76	106.11	105.59	105.69	1731690.0
2010-01-21 10:00:00	DIA	ETF	105.7	105.9	104.45	104.638	5477795.0

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

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