PREVIEW / stock_1hour / 2009-06-26

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-06-26.parquet
  size:    957 KB
  rows:    44,530
  symbols: 3,328

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
2009-06-26 07:00:00	AAPL	Stock	4.9907	4.9907	4.9789	4.9821	80080.0
2009-06-26 08:00:00	AAPL	Stock	4.9861	5.0071	4.9821	4.9932	1199828.0
2009-06-26 09:00:00	AAPL	Stock	4.9975	5.0782	4.9857	5.0604	96315240.0
2009-06-26 10:00:00	AAPL	Stock	5.0589	5.0732	5.0421	5.0596	65800336.0
2009-06-26 11:00:00	AAPL	Stock	5.0596	5.0768	5.0504	5.0714	38925376.0
2009-06-26 12:00:00	AAPL	Stock	5.0714	5.0825	5.0625	5.0721	38558324.0
2009-06-26 13:00:00	AAPL	Stock	5.0721	5.0804	5.0657	5.0764	29499596.0
2009-06-26 14:00:00	AAPL	Stock	5.0768	5.0893	5.075	5.0886	33539380.0
2009-06-26 15:00:00	AAPL	Stock	5.0886	5.1271	5.0729	5.0893	76010844.0
2009-06-26 16:00:00	AAPL	Stock	5.0843	5.1071	5.0641	5.0827	36490356.0
2009-06-26 17:00:00	AAPL	Stock	5.0832	5.0964	5.0832	5.0964	3569188.0
2009-06-26 18:00:00	AAPL	Stock	5.0871	5.0914	5.0871	5.0893	974064.0
2009-06-26 19:00:00	AAPL	Stock	5.0964	5.0964	5.0911	5.0929	57400.0
2009-06-26 08:00:00	MSFT	Stock	23.75	23.86	23.71	23.75	17452.0
2009-06-26 09:00:00	MSFT	Stock	23.71	23.71	23.44	23.52	5260831.0
2009-06-26 10:00:00	MSFT	Stock	23.52	23.63	23.48	23.55	7652212.0
2009-06-26 11:00:00	MSFT	Stock	23.54	23.56	23.45	23.53	4846480.0
2009-06-26 12:00:00	MSFT	Stock	23.52	23.6	23.52	23.548	3429647.0
2009-06-26 13:00:00	MSFT	Stock	23.548	23.55	23.41	23.45	7456654.0
2009-06-26 14:00:00	MSFT	Stock	23.44	23.45	23.39	23.44	4353024.0
2009-06-26 15:00:00	MSFT	Stock	23.435	23.46	23.32	23.35	13156021.0
2009-06-26 16:00:00	MSFT	Stock	23.35	23.97	23.34	23.48	14481392.0
2009-06-26 17:00:00	MSFT	Stock	23.382	23.55	23.368	23.45	1687680.0
2009-06-26 18:00:00	MSFT	Stock	23.35	23.45	23.35	23.45	14420.0
2009-06-26 19:00:00	MSFT	Stock	23.45	23.45	23.4	23.45	12336.0
2009-06-26 08:00:00	NVDA	Stock	0.287	0.2875	0.287	0.2875	116000.0
2009-06-26 09:00:00	NVDA	Stock	0.2838	0.2898	0.2818	0.2842	69226360.0
2009-06-26 10:00:00	NVDA	Stock	0.2842	0.2865	0.2832	0.286	76282920.0
2009-06-26 11:00:00	NVDA	Stock	0.286	0.2862	0.284	0.2858	36694280.0
2009-06-26 12:00:00	NVDA	Stock	0.2858	0.2872	0.2855	0.2865	21718520.0
2009-06-26 13:00:00	NVDA	Stock	0.2865	0.2888	0.2865	0.2882	65740720.0
2009-06-26 14:00:00	NVDA	Stock	0.2885	0.29	0.288	0.2899	78757920.0
2009-06-26 15:00:00	NVDA	Stock	0.29	0.2902	0.2875	0.2891	118316800.0
2009-06-26 16:00:00	NVDA	Stock	0.2892	0.2912	0.2856	0.2884	40479640.0
2009-06-26 17:00:00	NVDA	Stock	0.2894	0.2894	0.2888	0.2888	3502160.0
2009-06-26 18:00:00	NVDA	Stock	0.2888	0.2888	0.2888	0.2888	12000.0
2009-06-26 08:00:00	AMZN	Stock	4.1115	4.1115	4.1075	4.1075	14000.0
2009-06-26 09:00:00	AMZN	Stock	4.1095	4.15	4.0565	4.1118	18170300.0
2009-06-26 10:00:00	AMZN	Stock	4.11	4.165	4.101	4.157	20691820.0
2009-06-26 11:00:00	AMZN	Stock	4.156	4.184	4.14	4.181	15425720.0
2009-06-26 12:00:00	AMZN	Stock	4.1815	4.207	4.1765	4.1871	25060720.0
2009-06-26 13:00:00	AMZN	Stock	4.1855	4.1875	4.158	4.173	23089560.0
2009-06-26 14:00:00	AMZN	Stock	4.1725	4.1957	4.1585	4.192	11179260.0
2009-06-26 15:00:00	AMZN	Stock	4.193	4.199	4.174	4.186	27900720.0
2009-06-26 16:00:00	AMZN	Stock	4.2	4.2	4.1548	4.1915	10355960.0
2009-06-26 17:00:00	AMZN	Stock	4.1919	4.195	4.189	4.195	3393880.0
2009-06-26 18:00:00	AMZN	Stock	4.195	4.195	4.195	4.195	18000.0
2009-06-26 19:00:00	AMZN	Stock	4.196	4.196	4.195	4.1955	10000.0
2009-06-26 08:00:00	TLT	Stock	94.19	94.57	94.19	94.52	19800.0
2009-06-26 09:00:00	TLT	Stock	94.69	94.69	94.21	94.48	791389.0

> showing 50 of 44,530 rows — these rows as CSV

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