PREVIEW / stock_1hour / 2012-01-23

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-01-23.parquet
  size:    921 KB
  rows:    43,759
  symbols: 3,538

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
2012-01-23 04:00:00	AAPL	Stock	15.0786	15.0786	15.0714	15.0714	16800.0
2012-01-23 05:00:00	AAPL	Stock	15.0714	15.1214	15.0714	15.1214	19600.0
2012-01-23 06:00:00	AAPL	Stock	15.1429	15.1736	15.1429	15.1464	98868.0
2012-01-23 07:00:00	AAPL	Stock	15.1411	15.1582	15.0893	15.1107	464380.0
2012-01-23 08:00:00	AAPL	Stock	15.1186	15.1621	15.095	15.095	1794268.0
2012-01-23 09:00:00	AAPL	Stock	15.0964	15.2732	15.0107	15.2368	70444612.0
2012-01-23 10:00:00	AAPL	Stock	15.2368	15.3018	15.2286	15.2704	52154984.0
2012-01-23 11:00:00	AAPL	Stock	15.2714	15.2796	15.1936	15.1957	39764228.0
2012-01-23 12:00:00	AAPL	Stock	15.195	15.2054	15.1654	15.1982	28387604.0
2012-01-23 13:00:00	AAPL	Stock	15.1991	15.2675	15.1979	15.2639	23540916.0
2012-01-23 14:00:00	AAPL	Stock	15.2636	15.2657	15.2075	15.2154	27838860.0
2012-01-23 15:00:00	AAPL	Stock	15.215	15.2711	15.21	15.2629	46063304.0
2012-01-23 16:00:00	AAPL	Stock	15.265	15.2711	15.2257	15.265	9471924.0
2012-01-23 17:00:00	AAPL	Stock	15.2675	15.2829	15.2636	15.2729	253652.0
2012-01-23 18:00:00	AAPL	Stock	15.2729	15.275	15.1968	15.2264	883344.0
2012-01-23 19:00:00	AAPL	Stock	15.2236	15.2268	15.2146	15.2214	411768.0
2012-01-23 04:00:00	MSFT	Stock	29.64	29.64	29.6	29.6	3600.0
2012-01-23 05:00:00	MSFT	Stock	29.59	29.65	29.59	29.65	1900.0
2012-01-23 06:00:00	MSFT	Stock	29.68	29.68	29.68	29.68	1500.0
2012-01-23 07:00:00	MSFT	Stock	29.65	29.7	29.63	29.7	8600.0
2012-01-23 08:00:00	MSFT	Stock	29.7	29.73	29.58	29.7	99308.0
2012-01-23 09:00:00	MSFT	Stock	29.7	29.93	29.49	29.92	16694036.0
2012-01-23 10:00:00	MSFT	Stock	29.93	29.95	29.66	29.73	17067684.0
2012-01-23 11:00:00	MSFT	Stock	29.74	29.75	29.54	29.61	10775813.0
2012-01-23 12:00:00	MSFT	Stock	29.6	29.615	29.35	29.431	6351768.0
2012-01-23 13:00:00	MSFT	Stock	29.437	29.635	29.43	29.629	5066785.0
2012-01-23 14:00:00	MSFT	Stock	29.63	29.7	29.59	29.67	4823736.0
2012-01-23 15:00:00	MSFT	Stock	29.68	29.785	29.65	29.73	9330578.0
2012-01-23 16:00:00	MSFT	Stock	29.73	29.779	29.5	29.73	2875285.0
2012-01-23 17:00:00	MSFT	Stock	29.74	29.74	29.71	29.72	2741.0
2012-01-23 18:00:00	MSFT	Stock	29.72	29.72	29.72	29.72	2046.0
2012-01-23 19:00:00	MSFT	Stock	29.72	29.73	29.68	29.72	3655.0
2012-01-23 08:00:00	NVDA	Stock	0.3555	0.3555	0.3555	0.3555	23600.0
2012-01-23 09:00:00	NVDA	Stock	0.357	0.3572	0.3513	0.356	48360120.0
2012-01-23 10:00:00	NVDA	Stock	0.3562	0.3608	0.356	0.359	85469880.0
2012-01-23 11:00:00	NVDA	Stock	0.3592	0.3602	0.3572	0.359	58175760.0
2012-01-23 12:00:00	NVDA	Stock	0.3588	0.3615	0.357	0.3602	69876200.0
2012-01-23 13:00:00	NVDA	Stock	0.3602	0.3638	0.36	0.363	67724440.0
2012-01-23 14:00:00	NVDA	Stock	0.3632	0.3655	0.3622	0.3642	92652680.0
2012-01-23 15:00:00	NVDA	Stock	0.3641	0.3652	0.3638	0.365	106825760.0
2012-01-23 16:00:00	NVDA	Stock	0.3652	0.367	0.354	0.363	10931440.0
2012-01-23 17:00:00	NVDA	Stock	0.3648	0.3652	0.3602	0.3652	235440.0
2012-01-23 18:00:00	NVDA	Stock	0.3658	0.3662	0.365	0.3658	314440.0
2012-01-23 19:00:00	NVDA	Stock	0.366	0.367	0.365	0.3662	142080.0
2012-01-23 07:00:00	AMZN	Stock	9.527	9.527	9.493	9.493	17000.0
2012-01-23 08:00:00	AMZN	Stock	9.523	9.523	9.478	9.485	72240.0
2012-01-23 09:00:00	AMZN	Stock	9.485	9.5865	9.4105	9.44	14600080.0
2012-01-23 10:00:00	AMZN	Stock	9.435	9.506	9.4015	9.4099	14457700.0
2012-01-23 11:00:00	AMZN	Stock	9.41	9.416	9.2815	9.2865	18836520.0
2012-01-23 12:00:00	AMZN	Stock	9.2865	9.3375	9.2615	9.3225	9122980.0

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

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