PREVIEW / etf_1hour / 2010-01-20

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-01-20.parquet
  size:    155 KB
  rows:    4,812

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-20 04:00:00	SPY	ETF	114.63	114.79	114.56	114.58	6948.0
2010-01-20 05:00:00	SPY	ETF	114.51	114.68	114.51	114.68	1000.0
2010-01-20 06:00:00	SPY	ETF	114.65	114.65	114.38	114.38	27858.0
2010-01-20 07:00:00	SPY	ETF	114.39	114.54	114.29	114.54	426071.0
2010-01-20 08:00:00	SPY	ETF	114.55	114.74	114.22	114.26	5072936.0
2010-01-20 09:00:00	SPY	ETF	114.26	114.45	113.76	113.97	32872281.0
2010-01-20 10:00:00	SPY	ETF	113.96	114.2	113.27	113.3199	36056528.0
2010-01-20 11:00:00	SPY	ETF	113.318	113.37	112.98	113.22	29987294.0
2010-01-20 12:00:00	SPY	ETF	113.22	113.44	113.11	113.259	22780788.0
2010-01-20 13:00:00	SPY	ETF	113.2528	113.55	113.04	113.46	17156225.0
2010-01-20 14:00:00	SPY	ETF	113.45	113.74	113.38	113.7	21158446.0
2010-01-20 15:00:00	SPY	ETF	113.7	114.0	113.61	113.89	32960376.0
2010-01-20 16:00:00	SPY	ETF	113.89	115.1136	113.25	113.3478	16753880.0
2010-01-20 17:00:00	SPY	ETF	113.94	114.06	113.92	114.04	121989.0
2010-01-20 18:00:00	SPY	ETF	114.0	114.06	113.9	114.02	102126.0
2010-01-20 19:00:00	SPY	ETF	114.03	114.15	114.0	114.08	57350.0
2010-01-20 04:00:00	QQQ	ETF	46.4	46.4	46.3	46.33	3833.0
2010-01-20 05:00:00	QQQ	ETF	46.32	46.35	46.31	46.33	5500.0
2010-01-20 06:00:00	QQQ	ETF	46.35	46.35	46.25	46.25	13354.0
2010-01-20 07:00:00	QQQ	ETF	46.22	46.34	46.19	46.33	358222.0
2010-01-20 08:00:00	QQQ	ETF	46.28	46.41	46.25	46.28	1749176.0
2010-01-20 09:00:00	QQQ	ETF	46.28	46.29	46.03	46.06	16757162.0
2010-01-20 10:00:00	QQQ	ETF	46.05	46.1	45.58	45.61	36735955.0
2010-01-20 11:00:00	QQQ	ETF	45.62	45.68	45.43	45.6301	17022077.0
2010-01-20 12:00:00	QQQ	ETF	45.6399	45.73	45.56	45.6	8153200.0
2010-01-20 13:00:00	QQQ	ETF	45.6	45.78	45.5195	45.7201	10146130.0
2010-01-20 14:00:00	QQQ	ETF	45.72	45.81	45.66	45.7701	9846692.0
2010-01-20 15:00:00	QQQ	ETF	45.78	45.9501	45.74	45.92	22901856.0
2010-01-20 16:00:00	QQQ	ETF	45.93	46.604	45.5999	46.0	15667051.0
2010-01-20 17:00:00	QQQ	ETF	45.99	46.06	45.99	46.03	195107.0
2010-01-20 18:00:00	QQQ	ETF	46.03	46.05	46.01	46.02	56409.0
2010-01-20 19:00:00	QQQ	ETF	46.02	46.09	46.02	46.06	105422.0
2010-01-20 07:00:00	IWM	ETF	64.42	64.47	64.35	64.46	42500.0
2010-01-20 08:00:00	IWM	ETF	64.51	64.6	64.34	64.39	497918.0
2010-01-20 09:00:00	IWM	ETF	64.38	64.42	64.04	64.1375	7689266.0
2010-01-20 10:00:00	IWM	ETF	64.13	64.19	63.49	63.56	12789305.0
2010-01-20 11:00:00	IWM	ETF	63.56	63.61	63.19	63.44	7735397.0
2010-01-20 12:00:00	IWM	ETF	63.43	63.59	63.38	63.45	4749638.0
2010-01-20 13:00:00	IWM	ETF	63.46	63.66	63.31	63.59	4869901.0
2010-01-20 14:00:00	IWM	ETF	63.58	63.9	63.55	63.87	4321110.0
2010-01-20 15:00:00	IWM	ETF	63.87	64.1	63.761	63.95	8003004.0
2010-01-20 16:00:00	IWM	ETF	63.95	64.8897	63.4673	63.93	4615850.0
2010-01-20 17:00:00	IWM	ETF	63.97	64.05	63.96	64.02	17629.0
2010-01-20 07:00:00	DIA	ETF	106.76	106.76	106.59	106.67	19000.0
2010-01-20 08:00:00	DIA	ETF	106.75	106.83	106.5	106.56	53400.0
2010-01-20 09:00:00	DIA	ETF	106.56	106.56	105.81	105.98	2339170.0
2010-01-20 10:00:00	DIA	ETF	105.97	106.01	105.4	105.42	2683839.0
2010-01-20 11:00:00	DIA	ETF	105.42	105.46	105.13	105.28	1853252.0
2010-01-20 12:00:00	DIA	ETF	105.27	105.49	105.19	105.34	997180.0
2010-01-20 13:00:00	DIA	ETF	105.295	105.6	105.13	105.55	1032540.0

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

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