PREVIEW / stock_1hour / 2011-10-07

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-10-07.parquet
  size:    910 KB
  rows:    43,595
  symbols: 3,477

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
2011-10-07 04:00:00	AAPL	Stock	13.4996	13.4996	13.4925	13.4925	8400.0
2011-10-07 05:00:00	AAPL	Stock	13.4607	13.4607	13.4493	13.4493	11200.0
2011-10-07 06:00:00	AAPL	Stock	13.4461	13.4461	13.4236	13.4236	5600.0
2011-10-07 07:00:00	AAPL	Stock	13.4521	13.4521	13.4107	13.425	147448.0
2011-10-07 08:00:00	AAPL	Stock	13.4286	13.545	13.4221	13.5036	6400436.0
2011-10-07 09:00:00	AAPL	Stock	13.5036	13.5104	13.3521	13.4525	73141180.0
2011-10-07 10:00:00	AAPL	Stock	13.4568	13.4718	13.3175	13.3218	80027136.0
2011-10-07 11:00:00	AAPL	Stock	13.3271	13.3364	13.1603	13.2089	125093836.0
2011-10-07 12:00:00	AAPL	Stock	13.2111	13.2764	13.17	13.2221	61055848.0
2011-10-07 13:00:00	AAPL	Stock	13.2196	13.2946	13.1964	13.281	35107128.0
2011-10-07 14:00:00	AAPL	Stock	13.2832	13.3179	13.2325	13.2696	47217128.0
2011-10-07 15:00:00	AAPL	Stock	13.2668	13.3461	13.1896	13.2075	83610100.0
2011-10-07 16:00:00	AAPL	Stock	13.199	13.3342	13.1964	13.2125	16624692.0
2011-10-07 17:00:00	AAPL	Stock	13.4775	13.4775	13.2107	13.2132	245700.0
2011-10-07 18:00:00	AAPL	Stock	13.2139	13.2143	13.2071	13.2107	89320.0
2011-10-07 19:00:00	AAPL	Stock	13.2125	13.2225	13.2111	13.2225	106540.0
2011-10-07 07:00:00	MSFT	Stock	26.26	26.26	26.2	26.22	1250.0
2011-10-07 08:00:00	MSFT	Stock	26.2	26.47	26.15	26.44	48682.0
2011-10-07 09:00:00	MSFT	Stock	26.4	26.45	26.25	26.39	4560842.0
2011-10-07 10:00:00	MSFT	Stock	26.39	26.5	26.34	26.355	6614964.0
2011-10-07 11:00:00	MSFT	Stock	26.36	26.495	26.2	26.495	5804893.0
2011-10-07 12:00:00	MSFT	Stock	26.5	26.5	26.25	26.291	7655482.0
2011-10-07 13:00:00	MSFT	Stock	26.3	26.41	26.23	26.36	3964267.0
2011-10-07 14:00:00	MSFT	Stock	26.355	26.47	26.34	26.375	4762097.0
2011-10-07 15:00:00	MSFT	Stock	26.37	26.51	26.2	26.24	15231345.0
2011-10-07 16:00:00	MSFT	Stock	26.24	26.49	26.2	26.38	3252262.0
2011-10-07 17:00:00	MSFT	Stock	26.32	26.34	26.32	26.33	3622.0
2011-10-07 18:00:00	MSFT	Stock	26.25	26.35	26.25	26.33	9898.0
2011-10-07 19:00:00	MSFT	Stock	26.33	26.33	26.33	26.33	2712.0
2011-10-07 07:00:00	NVDA	Stock	0.345	0.345	0.345	0.345	36000.0
2011-10-07 08:00:00	NVDA	Stock	0.345	0.3513	0.3433	0.3498	2289400.0
2011-10-07 09:00:00	NVDA	Stock	0.3495	0.351	0.3415	0.3477	60727320.0
2011-10-07 10:00:00	NVDA	Stock	0.3478	0.3545	0.345	0.3486	121963560.0
2011-10-07 11:00:00	NVDA	Stock	0.3488	0.3493	0.3442	0.3482	67213400.0
2011-10-07 12:00:00	NVDA	Stock	0.3485	0.3508	0.3459	0.348	135172200.0
2011-10-07 13:00:00	NVDA	Stock	0.3478	0.3522	0.3462	0.352	64798600.0
2011-10-07 14:00:00	NVDA	Stock	0.352	0.356	0.3513	0.3542	125720840.0
2011-10-07 15:00:00	NVDA	Stock	0.3542	0.359	0.353	0.3535	212751160.0
2011-10-07 16:00:00	NVDA	Stock	0.3535	0.3578	0.3514	0.3578	2730320.0
2011-10-07 17:00:00	NVDA	Stock	0.355	0.355	0.3538	0.3538	56000.0
2011-10-07 18:00:00	NVDA	Stock	0.3538	0.3548	0.3525	0.3548	116000.0
2011-10-07 19:00:00	NVDA	Stock	0.3548	0.3548	0.3538	0.3538	45600.0
2011-10-07 04:00:00	AMZN	Stock	11.088	11.088	11.0625	11.0625	8000.0
2011-10-07 07:00:00	AMZN	Stock	11.0125	11.0125	11.0125	11.0125	2000.0
2011-10-07 08:00:00	AMZN	Stock	11.0165	11.2505	11.0145	11.2	791380.0
2011-10-07 09:00:00	AMZN	Stock	11.208	11.2125	10.96	11.044	18626740.0
2011-10-07 10:00:00	AMZN	Stock	11.0425	11.0875	10.9815	11.062	15024340.0
2011-10-07 11:00:00	AMZN	Stock	11.062	11.0875	10.9205	11.086	16126860.0
2011-10-07 12:00:00	AMZN	Stock	11.087	11.15	11.0275	11.1125	16947600.0
2011-10-07 13:00:00	AMZN	Stock	11.112	11.1775	11.0855	11.1645	12224140.0

> showing 50 of 43,595 rows — these rows as CSV

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