PREVIEW / etf_1hour / 2010-02-23

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-02-23.parquet
  size:    155 KB
  rows:    4,820

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-02-23 04:00:00	SPY	ETF	111.48	111.48	111.44	111.47	514.0
2010-02-23 05:00:00	SPY	ETF	111.44	111.44	110.99	111.02	3100.0
2010-02-23 06:00:00	SPY	ETF	110.94	110.94	110.73	110.77	57425.0
2010-02-23 07:00:00	SPY	ETF	110.85	111.0	110.74	110.91	1527590.0
2010-02-23 08:00:00	SPY	ETF	110.97	111.03	110.68	110.84	3190352.0
2010-02-23 09:00:00	SPY	ETF	110.84	111.2	110.74	110.99	20998369.0
2010-02-23 10:00:00	SPY	ETF	110.99	111.1254	109.84	110.16	50852175.0
2010-02-23 11:00:00	SPY	ETF	110.16	110.27	109.96	110.04	19063811.0
2010-02-23 12:00:00	SPY	ETF	110.04	110.06	109.58	109.82	24075800.0
2010-02-23 13:00:00	SPY	ETF	109.83	111.1171	109.6	109.68	18682172.0
2010-02-23 14:00:00	SPY	ETF	109.68	110.1	109.52	110.0	23833179.0
2010-02-23 15:00:00	SPY	ETF	110.0	111.1171	109.7	109.79	30625156.0
2010-02-23 16:00:00	SPY	ETF	109.79	111.117	109.65	110.16	9114337.0
2010-02-23 17:00:00	SPY	ETF	110.14	111.1171	110.09	110.16	1250243.0
2010-02-23 18:00:00	SPY	ETF	110.16	110.16	109.81	110.08	465400.0
2010-02-23 19:00:00	SPY	ETF	110.06	110.1	110.03	110.1	108564.0
2010-02-23 04:00:00	QQQ	ETF	44.92	44.93	44.92	44.93	900.0
2010-02-23 05:00:00	QQQ	ETF	44.88	44.89	44.73	44.73	8100.0
2010-02-23 06:00:00	QQQ	ETF	44.64	44.64	44.56	44.59	58655.0
2010-02-23 07:00:00	QQQ	ETF	44.65	44.69	44.61	44.65	552314.0
2010-02-23 08:00:00	QQQ	ETF	44.65	44.7	44.6	44.7	1430524.0
2010-02-23 09:00:00	QQQ	ETF	44.67	44.74	44.55	44.66	9869060.0
2010-02-23 10:00:00	QQQ	ETF	44.66	44.71	44.13	44.26	23892349.0
2010-02-23 11:00:00	QQQ	ETF	44.25	44.3	44.11	44.16	7232422.0
2010-02-23 12:00:00	QQQ	ETF	44.16	44.16	43.95	44.0701	11736535.0
2010-02-23 13:00:00	QQQ	ETF	44.075	44.14	44.01	44.07	10024106.0
2010-02-23 14:00:00	QQQ	ETF	44.08	44.27	44.01	44.23	9195723.0
2010-02-23 15:00:00	QQQ	ETF	44.22	44.28	44.13	44.15	10503255.0
2010-02-23 16:00:00	QQQ	ETF	44.15	44.34	43.96	44.32	3874046.0
2010-02-23 17:00:00	QQQ	ETF	44.3	44.33	44.15	44.3	662029.0
2010-02-23 18:00:00	QQQ	ETF	44.31	44.31	44.27	44.29	12274.0
2010-02-23 19:00:00	QQQ	ETF	44.29	44.3	44.27	44.3	25106.0
2010-02-23 04:00:00	IWM	ETF	63.35	63.55	63.35	63.55	400.0
2010-02-23 05:00:00	IWM	ETF	63.35	63.35	63.35	63.35	200.0
2010-02-23 06:00:00	IWM	ETF	63.19	63.21	63.1	63.17	12100.0
2010-02-23 07:00:00	IWM	ETF	63.16	63.26	63.12	63.23	157599.0
2010-02-23 08:00:00	IWM	ETF	63.2	63.26	63.05	63.17	251493.0
2010-02-23 09:00:00	IWM	ETF	63.18	63.25	63.01	63.02	10052302.0
2010-02-23 10:00:00	IWM	ETF	63.03	63.035	62.34	62.55	14263893.0
2010-02-23 11:00:00	IWM	ETF	62.55	62.62	62.35	62.39	4671916.0
2010-02-23 12:00:00	IWM	ETF	62.38	62.54	62.33	62.44	5973740.0
2010-02-23 13:00:00	IWM	ETF	62.445	62.6	62.38	62.44	4587050.0
2010-02-23 14:00:00	IWM	ETF	62.44	62.76	62.35	62.705	4709548.0
2010-02-23 15:00:00	IWM	ETF	62.7	62.83	62.45	62.51	11031765.0
2010-02-23 16:00:00	IWM	ETF	62.5	63.2532	62.48	62.7	2627053.0
2010-02-23 17:00:00	IWM	ETF	62.66	62.66	62.64	62.66	3850.0
2010-02-23 18:00:00	IWM	ETF	62.66	62.68	62.64	62.68	3300.0
2010-02-23 04:00:00	DIA	ETF	104.05	104.05	104.05	104.05	500.0
2010-02-23 05:00:00	DIA	ETF	103.84	103.84	103.84	103.84	100.0
2010-02-23 07:00:00	DIA	ETF	103.65	103.65	103.65	103.65	500.0

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

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