PREVIEW / stock_1hour / 2011-01-31

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-01-31.parquet
  size:    951 KB
  rows:    44,844
  symbols: 3,539

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-01-31 04:00:00	AAPL	Stock	11.9654	11.9929	11.9654	11.9929	19320.0
2011-01-31 05:00:00	AAPL	Stock	11.9893	11.9971	11.9836	11.9836	14000.0
2011-01-31 06:00:00	AAPL	Stock	12.0082	12.0289	12.0082	12.0096	31360.0
2011-01-31 07:00:00	AAPL	Stock	12.0214	12.0571	12.0	12.0525	450968.0
2011-01-31 08:00:00	AAPL	Stock	12.0386	12.0732	12.0021	12.0607	2028544.0
2011-01-31 09:00:00	AAPL	Stock	12.0554	12.0636	11.9586	11.9789	68412008.0
2011-01-31 10:00:00	AAPL	Stock	11.9786	12.075	11.9393	12.0525	66138268.0
2011-01-31 11:00:00	AAPL	Stock	12.0543	12.1036	12.0464	12.0925	39850692.0
2011-01-31 12:00:00	AAPL	Stock	12.0924	12.1443	12.09	12.1068	44262736.0
2011-01-31 13:00:00	AAPL	Stock	12.1071	12.1246	12.0786	12.1021	27300308.0
2011-01-31 14:00:00	AAPL	Stock	12.1025	12.1125	12.0321	12.0604	35819700.0
2011-01-31 15:00:00	AAPL	Stock	12.0589	12.1179	12.0475	12.1179	51731288.0
2011-01-31 16:00:00	AAPL	Stock	12.1186	12.1214	12.0116	12.1071	26438552.0
2011-01-31 17:00:00	AAPL	Stock	12.1075	12.1186	12.1	12.1018	217112.0
2011-01-31 18:00:00	AAPL	Stock	12.1018	12.1186	12.1018	12.1071	65940.0
2011-01-31 19:00:00	AAPL	Stock	12.1071	12.1279	12.1071	12.1279	274176.0
2011-01-31 04:00:00	MSFT	Stock	27.7	27.8	27.61	27.61	25165.0
2011-01-31 05:00:00	MSFT	Stock	27.79	27.79	27.71	27.71	200.0
2011-01-31 06:00:00	MSFT	Stock	27.79	27.79	27.79	27.79	100.0
2011-01-31 07:00:00	MSFT	Stock	27.79	27.79	27.76	27.79	7950.0
2011-01-31 08:00:00	MSFT	Stock	27.76	27.9	27.71	27.8	57867.0
2011-01-31 09:00:00	MSFT	Stock	27.79	27.9	27.46	27.5	10765712.0
2011-01-31 10:00:00	MSFT	Stock	27.492	27.76	27.46	27.675	11764649.0
2011-01-31 11:00:00	MSFT	Stock	27.68	27.69	27.42	27.492	8871402.0
2011-01-31 12:00:00	MSFT	Stock	27.49	27.7	27.49	27.6	5756974.0
2011-01-31 13:00:00	MSFT	Stock	27.61	27.66	27.59	27.59	3867005.0
2011-01-31 14:00:00	MSFT	Stock	27.6	27.66	27.52	27.632	5656012.0
2011-01-31 15:00:00	MSFT	Stock	27.63	27.74	27.61	27.725	8708357.0
2011-01-31 16:00:00	MSFT	Stock	27.73	27.78	27.597	27.74	8754149.0
2011-01-31 17:00:00	MSFT	Stock	27.72	27.74	27.65	27.69	19188.0
2011-01-31 18:00:00	MSFT	Stock	27.68	27.73	27.65	27.67	7671.0
2011-01-31 19:00:00	MSFT	Stock	27.7	27.73	27.7	27.72	4270.0
2011-01-31 08:00:00	NVDA	Stock	0.5945	0.6045	0.5945	0.5998	606920.0
2011-01-31 09:00:00	NVDA	Stock	0.5998	0.6013	0.5853	0.5885	93662800.0
2011-01-31 10:00:00	NVDA	Stock	0.5883	0.6063	0.5875	0.5938	237127760.0
2011-01-31 11:00:00	NVDA	Stock	0.5938	0.5959	0.5915	0.5933	74147360.0
2011-01-31 12:00:00	NVDA	Stock	0.5933	0.6008	0.5933	0.5978	70024120.0
2011-01-31 13:00:00	NVDA	Stock	0.5978	0.6005	0.5968	0.6	44523920.0
2011-01-31 14:00:00	NVDA	Stock	0.6	0.601	0.5965	0.5979	62218120.0
2011-01-31 15:00:00	NVDA	Stock	0.5978	0.6005	0.5968	0.598	125283440.0
2011-01-31 16:00:00	NVDA	Stock	0.597	0.5992	0.5943	0.5975	6395960.0
2011-01-31 17:00:00	NVDA	Stock	0.5975	0.5995	0.5948	0.5995	317760.0
2011-01-31 18:00:00	NVDA	Stock	0.5995	0.6008	0.597	0.6	104800.0
2011-01-31 19:00:00	NVDA	Stock	0.6	0.6	0.593	0.5968	437080.0
2011-01-31 04:00:00	AMZN	Stock	8.5255	8.5255	8.5255	8.5255	2000.0
2011-01-31 07:00:00	AMZN	Stock	8.55	8.55	8.55	8.55	18100.0
2011-01-31 08:00:00	AMZN	Stock	8.55	8.588	8.5305	8.5575	418600.0
2011-01-31 09:00:00	AMZN	Stock	8.5575	8.5575	8.3705	8.3855	31190340.0
2011-01-31 10:00:00	AMZN	Stock	8.384	8.4555	8.384	8.445	23557840.0
2011-01-31 11:00:00	AMZN	Stock	8.445	8.489	8.4275	8.4755	12206980.0

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

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