PREVIEW / stock_1hour / 2009-05-18

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-05-18.parquet
  size:    850 KB
  rows:    41,563
  symbols: 3,330

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-05-18 08:00:00	AAPL	Stock	4.3929	4.4232	4.39	4.4189	895412.0
2009-05-18 09:00:00	AAPL	Stock	4.4186	4.4286	4.3418	4.3714	64859648.0
2009-05-18 10:00:00	AAPL	Stock	4.3714	4.4246	4.3543	4.4218	63010696.0
2009-05-18 11:00:00	AAPL	Stock	4.4229	4.4271	4.4068	4.4157	30907688.0
2009-05-18 12:00:00	AAPL	Stock	4.4157	4.4921	4.4129	4.4757	95311412.0
2009-05-18 13:00:00	AAPL	Stock	4.4757	4.4936	4.4646	4.48	44143708.0
2009-05-18 14:00:00	AAPL	Stock	4.4813	4.525	4.4793	4.5193	63524664.0
2009-05-18 15:00:00	AAPL	Stock	4.5193	4.525	4.4954	4.5236	77513968.0
2009-05-18 16:00:00	AAPL	Stock	4.525	4.5254	4.4207	4.5182	14962948.0
2009-05-18 17:00:00	AAPL	Stock	4.5239	4.5239	4.4224	4.5179	1698648.0
2009-05-18 18:00:00	AAPL	Stock	4.5239	4.5239	4.5157	4.5193	1483776.0
2009-05-18 19:00:00	AAPL	Stock	4.5196	4.5232	4.5164	4.5179	117068.0
2009-05-18 07:00:00	MSFT	Stock	20.3	20.3	20.3	20.3	1300.0
2009-05-18 08:00:00	MSFT	Stock	20.29	20.37	19.48	20.37	31941.0
2009-05-18 09:00:00	MSFT	Stock	20.38	20.48	20.3	20.38	5232506.0
2009-05-18 10:00:00	MSFT	Stock	20.38	20.41	20.24	20.38	7967159.0
2009-05-18 11:00:00	MSFT	Stock	20.39	20.5	20.32	20.43	4789938.0
2009-05-18 12:00:00	MSFT	Stock	20.43	20.55	20.42	20.5	3790859.0
2009-05-18 13:00:00	MSFT	Stock	20.49	20.51	20.4	20.43	4168305.0
2009-05-18 14:00:00	MSFT	Stock	20.42	20.5	20.32	20.482	4955814.0
2009-05-18 15:00:00	MSFT	Stock	20.49	20.59	20.43	20.59	10096386.0
2009-05-18 16:00:00	MSFT	Stock	20.59	20.6	20.421	20.6	3580423.0
2009-05-18 17:00:00	MSFT	Stock	20.6	20.6	20.55	20.55	455021.0
2009-05-18 18:00:00	MSFT	Stock	20.6	20.6	20.58	20.58	69621.0
2009-05-18 19:00:00	MSFT	Stock	20.56	20.6	20.56	20.6	3796.0
2009-05-18 08:00:00	NVDA	Stock	0.2275	0.2275	0.2218	0.2218	413440.0
2009-05-18 09:00:00	NVDA	Stock	0.2225	0.2318	0.2215	0.2288	174389400.0
2009-05-18 10:00:00	NVDA	Stock	0.2288	0.2312	0.225	0.2303	192517000.0
2009-05-18 11:00:00	NVDA	Stock	0.2301	0.2308	0.2275	0.2293	94906280.0
2009-05-18 12:00:00	NVDA	Stock	0.2292	0.2312	0.228	0.2295	82771000.0
2009-05-18 13:00:00	NVDA	Stock	0.2298	0.2308	0.2288	0.2303	58200640.0
2009-05-18 14:00:00	NVDA	Stock	0.2303	0.2332	0.2295	0.2332	140577440.0
2009-05-18 15:00:00	NVDA	Stock	0.233	0.2332	0.2312	0.232	157358440.0
2009-05-18 16:00:00	NVDA	Stock	0.2318	0.2328	0.2296	0.2318	29575920.0
2009-05-18 17:00:00	NVDA	Stock	0.2318	0.2332	0.2318	0.233	1486720.0
2009-05-18 18:00:00	NVDA	Stock	0.2312	0.2312	0.2312	0.2312	10000.0
2009-05-18 19:00:00	NVDA	Stock	0.233	0.2332	0.2322	0.2322	272400.0
2009-05-18 07:00:00	AMZN	Stock	3.71	3.71	3.695	3.6985	12000.0
2009-05-18 08:00:00	AMZN	Stock	3.6905	3.7115	3.69	3.711	468820.0
2009-05-18 09:00:00	AMZN	Stock	3.712	3.7305	3.6755	3.68	17103480.0
2009-05-18 10:00:00	AMZN	Stock	3.681	3.7125	3.655	3.71	23666320.0
2009-05-18 11:00:00	AMZN	Stock	3.7095	3.725	3.6855	3.7125	10068580.0
2009-05-18 12:00:00	AMZN	Stock	3.7135	3.77	3.713	3.7615	13641260.0
2009-05-18 13:00:00	AMZN	Stock	3.7605	3.7625	3.737	3.7525	8489140.0
2009-05-18 14:00:00	AMZN	Stock	3.753	3.7845	3.7475	3.7794	11429020.0
2009-05-18 15:00:00	AMZN	Stock	3.778	3.7975	3.767	3.7975	27478520.0
2009-05-18 16:00:00	AMZN	Stock	3.7975	3.8	3.7347	3.7945	14769900.0
2009-05-18 17:00:00	AMZN	Stock	3.7975	3.7975	3.7895	3.7895	392300.0
2009-05-18 18:00:00	AMZN	Stock	3.7895	3.792	3.7895	3.792	6400.0
2009-05-18 08:00:00	TLT	Stock	98.15	98.99	98.04	98.2	72412.0

> showing 50 of 41,563 rows — these rows as CSV

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